Data Engineer

Analytica; Washington (District of Columbia); On-site; USD 75,000 - 90,000; Full time

Benefits offered by this job

Competitive salary

Employer-paid health care

401(k) match

Training and development funds

Job summary

A leading consulting firm is seeking a Data Engineer to support a federal government client in Washington, DC. The role involves designing data models, developing ETL processes, and engaging directly with clients. Candidates should have a Bachelor's degree in Computer Science and over 5 years of relevant experience. Competitive compensation and benefits are offered, including bonuses and health care.

Qualifications

• 5+ years' experience designing data models.
• Hands-on experience with big data integration using ETL tools.
• Ability to secure U.S. Federal Clearance.

Responsibilities

• Design and implement data models in SQL Server.
• Develop ETL code and scripting to meet business requirements.
• Deploy application code using CI/CD tools.

Skills

Data modeling

ETL processes

SQL Server

Communication skills

Education

Bachelor's degree in Computer Science or related field

Tools

Microsoft SQL Server

AWS Glue

Git

Job description

Data Engineer

Analytica is seeking a Data Engineer to support a key, long‑term federal government client program and software product. This role involves working in an agile, multi‑faceted team with direct client engagement to design and develop software products.

Responsibilities

• Design and implement star‑schema dimensional models (fact and dimension tables) in SQL Server to support business intelligence 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 that have 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.
• Deploy application code and analytical models using CI/CD tools and techniques and provide support for deployed data applications and analytical models.

Basic 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 leveraging enterprise data warehouse modeling constructs and star‑schema best practices to ensure flexible, scalable and high‑performing physical databases.
• 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, and Visual Studio.
• Experience with data mining and data warehousing.
• Excellent communication, presentation and interpersonal skills with the ability to communicate clearly with both business and technical resources.
• Ability to secure a U.S. Federal Clearance.

Preferred Qualifications

• Experience with AWS Glue, Lambda, Git and GitHub.
• Certification in SQL Server or data management (e.g., CDMP, MCSA).
• Background in defense healthcare domain.

About Analytica

Analytica is a leading consulting and information technology solutions provider to public sector organizations supporting health, civilian, and national security missions. It is an award‑winning SBA‑certified 8(a) small business and Inc. Magazine’s fastest‑growing 250 company for three consecutive years. The company offers competitive compensation with bonuses, employer‑paid health care, training and development funds, and a 401(k) match.

Seniority level: Mid‑Senior level • Employment type: Full‑time • Location: Washington, DC • Salary: $75,000‑$90,000.