sr sql developer - Fairfax, United States - VSolvit LLC

VSolvit LLC Fairfax, United States

2 weeks ago

Description

Sr.

EDW Consultant for the DEA Datawarehouse Project – Location:

DC, MD, Northern VA area (requires 2 to 3 days per week onsite at Merrifield (Fairfax), VA DEA Office.

Job Summary

Seeking an Enterprise Data Warehouse (EDW) Consultant with SQL Developer and cloud environment experience to support to the Office of Information Systems (TC) within the Drug Enforcement Administration (DEA).

The DEA's SQL Server-based EDW is used by a majority of DEA's applications and is a critical component of statistical reporting.

AN ACTIVE SECRET CLEARANCE IS REQUIRED
As with any position, additional expectations exist.

Some of these are, but are not limited to, adhering to normal working hours, meeting deadlines, following company policies as outlined by the Employee Handbook, communicating regularly with assigned supervisor(s), and staying focused on the assigned tasks including company meetings, and completing other tasks as assigned.

Responsibilities

Essential Duties and Responsibilities:
(Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this position)

To assist EDW Team and provide data warehouse information and/or systems transitioning to a cloud environment
Create and maintain database integrity and performance using scripts and/or VS Database Project
Create new and maintain/improve any and all data transformation services: Microsoft SSIS and others using VS data tools
Create SQL Scripts to deploy / enhance / maintain databases
Create and maintain database security, including, but not limited to: DB Roles, Users and Logins
May write reports or facilitate data access by other means as needed, to include SSRS, PowerBI, etc
Conducts performance tuning and database design, dimensional analysis and modeling
Maintain and add to an extensive set of SQL Server Integration Service (SSIS) packages for Extract, Transform, and Load (ETL) data
Supports the review of database systems from non-Concorde applications in other DEA offices
Participates in daily Agile stand-up meetings and monthly planning sessions, sprint reviews, and retrospective sessions
Maintain, enhance, and create enterprise and application level SQL Server Report Service (SSRS) and other Business Intelligence (BI) tools. If requested, the EDW team will leverage SQL Server Analysis Services (SSAS) for performance purposes
Other duties as assigned

Basic Qualifications

2+ years of Cloud environment experience (AWS or Microsoft Azure)
8 years of experience in the design, development and implementation of SQL Server databases creating and maintaining T-SQL Procedures, functions, packages and triggers
2 years of experience with SSIS packages for data manipulation and loading
2 years of experience with the SQL Server 2012 environment
Bachelor's degree in IT, Computer Engineering, or a related discipline
Previous experience with Business Intelligence, Kimball Modeling and/or elastic search is desired
An active secret clearance is required

Knowledge, Skills and Abilities

Knowledge of and experience within, an Agile development environment
Knowledge of and prior experience with Git and Python, and PowerShell
Knowledge of and ability to use, Azure DevOps Server
Ability to write efficient SQL queries as well as demonstrated ability to interpret legacy scripts
Knowledge of and prior experience with multi-dimensional data models
Ability to create reports with a solid understanding of a variety of BI data tools
Knowledge of and prior experience with SSIS
Knowledge of Kimball data warehouse methodology highly desired
Demonstrated ability and desire to learn new technologies
Experience with data modeling programming and software development, including Python, R, or other high-level language used in statistical computing

Company Summary

Join the VSolvit Team Founded in 2006, VSolvit (pronounced 'We Solve It') is a technology services provider that specializes in cybersecurity, cloud computing, geographic information systems (GIS), business intelligence (BI) systems, data warehousing, engineering services, and custom database and application development.

VSolvit is an award winning WOSB, CA CDB, MBE, WBE, and CMMI Level 3 certified company. We offer a customizable health benefits program that best meets the needs of its employees.

Offering may include:

medical, dental, and vision insurance, life insurance, long and short-term disability and other insurance products, Health Savings Account, Flexible Spending Account, 401K Retirement Plan options, Tuition Reimbursement, and assorted voluntary benefits.

Our goal is to grow together and enjoy the work that we do as a team.

VSolvit LLC is an Equal Opportunity/Affirmative Action employer and will consider all qualified applicants for employment without regard to race, color, religion, sex, national origin, protected veteran status, or disability status

Database Engineer

3 weeks ago

Twenty Bridge Staffing Fairfax, United States

Position Summary: · Our client is seeking a Database Engineer to join their team. The Database Engineer is a fully qualified relational database technician who is responsible for creating, configuring, maintaining, and supporting databases utilized in production, development, and ...
Sr. Data Engineer with DataBricks Experience

2 weeks ago

Hudson Data Falls Church, United States

Job Title: Sr. Data Engineer with DataBricks Experience · Location: Remote · Duration: Long Term · Description: · • Work as part of a team to develop Cloud Data and Analytics solutions · • Participate in development of cloud data warehouses, data as a service, business intell ...
MS SQL Database Analyst

3 weeks ago

General Dynamics Information Technology Falls Church, United States

Req ID: RQ166782 · Type of Requisition: Regular · Clearance Level Must Be Able to Obtain: Top Secret · Public Trust/Other Required: SSBI (T5) · Job Family: Database Analysis/Design · Skills: · Microsoft SQL Server,SQL Database Management,SQL Database Queries,SQL Databases · Certi ...
Database Engineer

2 weeks ago

Twenty Bridge LLC Fairfax, United States

Position Summary: · Our client is seeking a · Database Engineer · to join their team. The Database Engineer is a fully qualified relational database technician who is responsible for creating, configuring, maintaining, and supporting databases utilized in production, developmen ...
Sr Database Developer-Remote

2 weeks ago

Shuvel Digital Fairfax, United States

Required Skills · 10+ years of experience as a MS SQL Server Developer or similar role with strong experience in · Database design and development. · BS/MS degree in Computer Science, Engineering, or a related subject · 5-7 years of experience with SQL Server PowerBI · Experienc ...
Database Engineer

1 week ago

Twenty Bridge Staffing Fairfax, United States

Job Description · Job Description · Position Summary: · Twenty Bridge is seeking a · Database Engineer · to join our client's team. The Database Engineer is a fully qualified relational database technician who is responsible for creating, configuring, maintaining, and support ...
Junior/Mid-Level .NET Developer

2 weeks ago

Plateau Software, Inc. Fairfax, United States

Job Type · Full-time · Description · Plateau is seeking Junior and Mid-Level .NET developers to join a growing program - These positions require U.S. Citizenship. · Mid-Level Position · Minimum Required Qualifications: · Bachelor's degree in computer science or a related fi ...
ETL Developer

3 weeks ago

Syms Strategic Group, LLC (SSG) Falls Church, United States

Syms Strategic Group (SSG) is seeking a talented Extract, Transform, and Load (ETL) Developer · Department: Veterans Affairs · Location: On-site, Washington, DC · Type: Full Time · Min. Experience: Experienced · Security Clearance Level: Public Trust (MBI) · Salary Range: $75,995 ...
Senior Windows System Engineer

3 weeks ago

Alta It Services Falls Church, United States

SENIOR SYSTEMS ENGINEER · Direct Hire · Merrifield, VA: First 90 days on-site – 2 days a week onsite hybrid thereafter · Salary up to $117,000 annually plus excellent benefits. · US citizenship is required. Candidates must be eligible for a basic security clearance. · ALTA IT ...
Chief Systems Engineer

3 weeks ago

Gridiron IT Fairfax, United States

Gridiron IT is seeking a Chief Systems Engineer to support an international program in Fairfax, VA · Position Summary: Primarily focused on the development and organization of IT Systems. Leads effort to form a structured development process that facilitates IT Systems operation ...
Senior .NET Developer

4 days ago

General Dynamics Information Technology Falls Church, United States

Background: · General Dynamics Information Technology (GDIT), a market leader and technology innovator, is seeking talented professionals to deliver detailed solutions to our customers. · GDIT has an opening for a senior level .NET Developer to join our team. This position provid ...
Batch Ops

4 days ago

Dunhill Professional Search San Francisco, United States Permanent

Job Description · Responsible for design, development, implementation, and support of business intelligence reports. Gathers requirements, performs analyses, and implements business intelligence solutions. Analyzes management information requirements to develop programs or admini ...
Database Administrator with Security Clearance

1 week ago

Torin Consulting Inc. Fairfax, United States

Torin is looking for a qualified Database Administrator with demonstrated database engineering and administration of systems for complex and high volume data processing. The candidate will use a variety ingest methods and data management techniques. Management includes a variety ...
Senior Java Developer

3 weeks ago

General Dynamics Information Technology Falls Church, United States

Req ID: RQ168139 · Type of Requisition: Regular · Clearance Level Must Be Able to Obtain: None · Public Trust/Other Required: NACI (T1) · Job Family: Software Engineering · Skills: · Java,Java Software Development,Structured Query Language (SQL) · Experience: · 5 + years of relat ...
Sr .NET Architect

2 weeks ago

Shuvel Digital Fairfax, United States

Job Description: · We are seeking Senior Level .NET Software Engineer/ Architect to join our team. In this role, you will have the opportunity to Lead and work on modernization and technology transformation projects. You will be part of an empowered team with the opportunity to ...
Power BI Consultant

2 weeks ago

Gridiron IT Fairfax, United States

Gridiron IT is seeking a Mid-level Power BI Consultant to work based out of Arlington, VA. Must be able to clear for a Public Trust Clearance. · Job Description: · Responsibilities: · Primary focus on business intelligence and reporting technologies/methodologies · Perform da ...
Data Analytics Analyst

3 weeks ago

ASM Research, An Accenture Federal Services Company Fairfax, United States

Delivers insights on potential areas of optimization, improvement, and growth. Partners with cross-functional teams to create coordinate data architecture strategies. Responsible for knowledge sharing of Data Analytics best practices to the broader company. Collaborates with busi ...
Azure Data Engineer

1 day ago

General Dynamics Information Technology Falls Church, United States

General Dynamics Information Technology - Federal Health Strategy & Analytics practice is currently looking for an experienced Azure Data Engineer to join our team in support various clients under the Department of Health and Human Services including Centers for Disease Control a ...
Remote .NET Developer

2 weeks ago

Shuvel Digital Fairfax, United States

Job Description: · We are seeking Mid - Senior Level .NET Developer to join our team. You will be part of an empowered team with the opportunity to innovate and learn continuously. · Develop, modernize, and make enhancements to an existing application or new enterprise applicat ...
Back-End Developer

2 weeks ago

CGI Technologies and Solutions, Inc. Fairfax, United States

Back-End Developer (Junior) · Category: Software Development/ Engineering · Main location: United States, Virginia, Fairfax · Position ID: J · Employment Type: Full Time · Position Description: · CGI is in the top 5 largest global IT companies spread across 40 countries with end ...