Job Requirements
Fairfax, VA
Secret Polygraph not specified
Mid Level Career (5+ yrs experience)
Salary not specified
Join Premium to unlock estimated salaries 
Job Description
SQL/ETL Developer
Location - Fairfax, VA
Clearance - Secret
M-F Days
(Onsite)
Direct Hire
Top 3 Skill Sets:
- 8+ years of experience in the design, development and implementation of SQL Server databases creating and maintaining T-SQL Procedures, functions, and triggers.
- 5+ years of experience with SSIS packages for data manipulation and loading in an enterprise data warehouse environment.
- 5+ years of experience with the SQL Server 2016, 2019, & 2022 environment
Job Summary:
Seeking a Sr. SQL Developer / Enterprise Data Warehouse with Data Warehousing and cloud environment experience
Responsibilities:
- To assist the Team and provide data warehouse information and facilitate the transition to a cloud environment.
- Create and maintain database integrity and performance using scripts and/or Visual Studio Database Projects;
- 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: Data Base 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) of data.
- Support the ongoing effort to establish a Data Engineering environment supported by Python and other languages to perform ETL and ELT (Extract, Load, and Transform) operations.
- Supports the review of database systems from non-Concorde applications in other DEA offices for ingestion into the EDW
Desired Qualifications:
Knowledge of, and experience within, an Agile development environment.
Knowledge of, and prior experience with Git and PowerShell
Knowledge of, and ability to use, Azure DevOps Server.
Ability to write efficient SQL queries as well as demonstrated ability to interpret preexisting scripts.
Knowledge of, and prior experience with multi-dimensional data models.
Demonstrated prior experience with SSIS.
Demonstrated ability and desire to learn new technologies.
Ability to reverse engineer existing logic of all kinds (queries, stored procedures, functions, Python, and C#)
Ability to write test plans and cases
Experience with data modeling.
Quality Assurance Experience is a plus.
Previous experience with Business Intelligence, Kimball Modeling / Kimball data warehouse methodology and/or elastic search is desired.
Location - Fairfax, VA
Clearance - Secret
M-F Days
(Onsite)
Direct Hire
Top 3 Skill Sets:
- 8+ years of experience in the design, development and implementation of SQL Server databases creating and maintaining T-SQL Procedures, functions, and triggers.
- 5+ years of experience with SSIS packages for data manipulation and loading in an enterprise data warehouse environment.
- 5+ years of experience with the SQL Server 2016, 2019, & 2022 environment
Job Summary:
Seeking a Sr. SQL Developer / Enterprise Data Warehouse with Data Warehousing and cloud environment experience
Responsibilities:
- To assist the Team and provide data warehouse information and facilitate the transition to a cloud environment.
- Create and maintain database integrity and performance using scripts and/or Visual Studio Database Projects;
- 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: Data Base 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) of data.
- Support the ongoing effort to establish a Data Engineering environment supported by Python and other languages to perform ETL and ELT (Extract, Load, and Transform) operations.
- Supports the review of database systems from non-Concorde applications in other DEA offices for ingestion into the EDW
Desired Qualifications:
Knowledge of, and experience within, an Agile development environment.
Knowledge of, and prior experience with Git and PowerShell
Knowledge of, and ability to use, Azure DevOps Server.
Ability to write efficient SQL queries as well as demonstrated ability to interpret preexisting scripts.
Knowledge of, and prior experience with multi-dimensional data models.
Demonstrated prior experience with SSIS.
Demonstrated ability and desire to learn new technologies.
Ability to reverse engineer existing logic of all kinds (queries, stored procedures, functions, Python, and C#)
Ability to write test plans and cases
Experience with data modeling.
Quality Assurance Experience is a plus.
Previous experience with Business Intelligence, Kimball Modeling / Kimball data warehouse methodology and/or elastic search is desired.
group id: 10508920