Data Engineer

Overview In this Data Engineer role, you will design and implement dimensional models and data pipelines to support analytics for a federal government program. You’ll collaborate with an agile, cross-functional team and engage with clients to shape software products. The work focuses on scalable data architectures, ETL development, and compliant deployment of data applications. This position offers growth, impactful public sector work, and opportunities to advance data capabilities. Compensation / Benefitscompetitive compensationbonusesemployer-paid health caretraining and development funds401k match ResponsibilitiesDesign and implement star schema dimensional models (fact and dimensions) in SQL Server to support BI and analyticsWrite and optimize data operation scripts including table creation, indexing, keys, and slowly changing dimensionsDevelop ETL code and scripting to meet technical specifications and business requirementsBuild application systems following standard SDLC concepts for design, programming, backup, and recoveryContribute to selecting programming approaches, tools, and techniques for business needsProvide SME input in data process specifications and development plansDeploy code and analytics models using CI/CD tools and provide support for deployed data applications Key requirementsBachelor’s degree in Computer Science, Engineering, IT, or other scientific/quantitative fields5 years’ experience designing conceptual, physical and logical data models using enterprise data modeling tools5 years’ experience in strategic data planning, governance and standards5 years’ experience leveraging enterprise data warehouse modeling constructs and star schema best practices for scalable databasesHands-on experience integrating systems with big data/data lake repositories using ETL toolsExperience with Microsoft SQL Server, Amazon Redshift, Dbeaver, Visual StudioExperience with data mining & data warehousingExcellent communication, presentation and interpersonal skillsAbility to obtain Secret Clearance; Active Secret Clearance highly preferredPreferred Qualifications: AWS (Glue, Lambda), Git & Github, SQL Server data management certifications (CDMP, MCSA)Background in defense healthcare domaincommunicationpresentationinterpersonal skillsMicrosoft SQL ServerAmazon RedshiftDbeaver