ETL Developer

• Review and reverse-engineer existing SSIS packages to document current system logic.
• Modify, test, and deploy updates to existing ETL workflows and database objects.
• Develop, modify, and maintain enterprise reports using SSRS.
• Collaborate with the database team to ensure data integrity and system stability.

Active Secret Clearance, IAT II Certification IAW DoD (For DoD IAT Level 2, you must have one of the following certifications - CCNA Security, CySA+, GICSP, GSEC, Security+ CE or CND: EC-Council’s Certified Network Defender (CND)) or IAT III.

Pay: $130,000.00 - $145,000.00 per year

• SQL Server Developer with SSIS/SSRS expertise
• SSIS (SQL Server Integration Services) expertise and reporting generation capabilities
• SSIS with C# or visual basic
• 10+ years of experience working with databases, preferably SQL Server.
• 7+ years of experience in developing ETL processes, including the use of SSIS packages in a Microsoft SQL Server database environment.
• 5+ years of experience in developing reports using SSRS/Power BI.
• Extensive experience working with MS SQL Server versions 2016, 2017, 2019 and 2022.
• Technical expertise in relational and dimensional database design.
• Strong understanding of database security principles and data privacy practices/laws.
• Experience in database/metadata analysis and design.
• Very strong SQL Server DB querying skills
• Basic DBA Skills, * SQL: 6 years (Required)
• SSIS/SSRS: 4 years (Required)

License/Certification:

• IAT Level II (Required)

• 401(k)
• 401(k) matching
• Dental insurance
• Health insurance
• Paid time off
• Professional development assistance
• Tuition reimbursement
• Vision insurance