Data Engineer – BI/ETL for Government Programs (Secret Clearance Eligible)

Analytica; Bethesda (MD); On-site; USD 110,000 - 160,000; Full time

Benefits offered by this job

Bonus potential

Employer-paid health care

Training funds

401k match

Job summary

Analytica is seeking a Data Engineer to support a key, long-term federal government client program and software product. The role involves collaborating with an agile team and engaging directly with the client to design and develop software solutions.

Analytica emphasizes competitive compensation, employer-paid health care, training funds, and a 401k match. The candidate will work on data modeling, ETL, and analytics within a mission-focused environment.

Qualifications

• Bachelor’s degree in Computer Science, Engineering, IT, or other scientific or quantitative fields.
• 5 years’ experience designing conceptual, physical and logical data models using enterprise data modeling tools.
• 5 years’ experience in strategic data planning, governance and standards.
• 5 years’ experience in leveraging enterprise data warehouse modeling constructs and star schema best practices to ensure flexible, scalable and high performing physical databases.
• Previous hands-on experience integrating systems with big data / data lake repositories using ETL tools.
• Experience with technologies such as Microsoft SQL Server, Amazon Redshift, DBeaver, Visual Studio.
• Experience with data mining & data warehousing is a must.
• Excellent communication skills, presentation and interpersonal skills are required. Ability to communicate clearly with both business and technical resources.
• Ability to obtain Secret Clearance; Active Secret Clearance highly preferred

Responsibilities

• Design and implement star schema dimensional models (fact and dimensions tables) in SQL Server to support BI and analytics requirements.
• Write and optimize scripts for data operations including table creation, indexing strategies, appropriate primary and foreign keys, and slowly changing dimensions.
• Provide business analysis and develop ETL code and scripting to meet all technical specifications and business requirements according to the established designs.
• Develop application systems that comply with the standard system development methodology and concepts for design, programming, backup, and recovery to deliver solutions with superior performance and integrity.
• Contribute to determining programming approach, tools, and techniques that best meet the business requirements.
• Provide subject matter expertise in the analysis, preparation of specifications and plans for the development of data processes.
• Deploys application code and analytical models using CI/CD tools and techniques and provides support for deployed data applications and analytical models

Skills

Star schema modeling

Data warehousing

ETL scripting

CI/CD tooling

Communication skills

Education

Bachelor's degree in Computer Science/Engineering/IT

Tools

Microsoft SQL Server

Amazon Redshift

DBeaver

Visual Studio

Job description

Analytica is seeking a Data Engineer to support a key, long-term federal government client program and software product. The role involves collaborating with an agile team and engaging directly with the client to design and develop software solutions.

Analytica emphasizes competitive compensation, employer-paid health care, training funds, and a 401k match. The candidate will work on data modeling, ETL, and analytics within a mission-focused environment.