We are currently seeking an SQL Server Developer with
SSIS/SSRS
expertise. 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 Key Responsibilities:
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
Benefits:
401(k) 401(k) matching Dental insurance Health insurance Paid time off Professional development assistance Tuition reimbursement Vision insurance
Experience:
SQL:
6 years (Required)
SSIS/SSRS
4 years (Required)
License/Certification:
IAT Level II (Required) Security clearance: Secret (Required)