Data Engineer

Index Analytics LLC; Milford Mill (MD); On-site; USD 122,000 - 164,000; Full time

Job summary

Index Analytics is seeking a Senior Data Engineer to design, build, and optimize scalable data pipelines for government clients. The role focuses on modernizing the data ecosystem using Snowflake, AWS, Python, and SQL.

You will collaborate with stakeholders, deliver reliable data solutions, and implement robust data quality, monitoring, and CI/CD practices in an Agile environment. On-site in Windsor Mill, MD; U.S. citizenship or eligibility required.

Qualifications

• 6+ years of experience as a Data Engineer or similar role.
• Strong proficiency in Snowflake, AWS, SQL, and Python.
• Experience with data warehousing, data modeling, and modern data architectures.
• Experience with government contracting or fraud detection systems is a plus.

Responsibilities

• Collaborate with stakeholders and cross‑functional teams to translate requirements into scalable data solutions.
• Design, build, and optimize ETL/ELT pipelines in AWS and Snowflake.
• Develop data models to support analytics, reporting, and dashboards.
• Implement data quality, validation, and monitoring frameworks.
• Operationalize pipelines with version control, testing, and CI/CD.
• Perform data analysis using Python and SQL to derive insights.
• Document data models, dictionaries, and usage guides.

Skills

SQL

Python

Snowflake

AWS

ETL/ELT

Data Modeling

GitHub

CI/CD

Data Warehousing

Agile

Education

Bachelor's degree or equivalent

Tools

Snowflake tools

AWS services

GitHub

CI/CD tools

Job description

Job DetailsLevel: SeniorJob Location: 7265 WINDSOR BLVD SUITE 106 - Windsor Mill, MD 21244Education Level: 4 Year DegreeSalary Range: $121,600.00 - $163,800.00 Salary/year

Company Overview

Index Analytics, LLC, is a rapidly growing, Baltimore-based small business providing health-related consulting services to the federal government. At the center of our company culture is a commitment to instilling a dynamic and employee-friendly place to work. We place a priority on promoting a supportive and collegial team environment and enhancing staff experience through career development and educational opportunities.

Position Overview

Index Analytics is seeking a Data Engineer to support Government clients to design, build, and optimize scalable data pipelines and cloud-based solutions. The Data Engineer plays a key role in modernizing the organization’s data ecosystem by implementing data solutions using a contemporary infrastructure.

Responsibilities

• Collaborate closely with stakeholders, cross‑functional and internal technical teams to understand requirements and business rules and develop a thorough understanding of the business context and objectives
• Collaborate to implement secure, scalable, and cost‑optimized data solutions
• Build and maintain scalable, reliable ETL/ELT data pipelinesusing AWS, Snowflake and Snowflake tools
• Develop and optimize data models, both conceptual and physical, to support analytics, reporting, dashboards and operational consumption
• Implement data quality, validation, and monitoringframeworks to ensure accuracy and reliability
• Ensure data workflows are modular, testable, and properly version‑controlled
• Operationalize pipelines with monitoring, alerting, and automated recovery mechanisms
• Conduct advanced data analysis usinglanguages such as Python and SQL
• Support the development of documentation to include data models, data dictionaries, and data usage guides
• Improve end-to-end performance of data workflows
• Build and maintain CI/CD pipelines to support automated testing, deployments, and continuous integration
• Meet schedule deadlines and commitments with a high-level of quality of deliverables
• Collaborate with a team of cross‑functional resources in an Agile delivery environment to deliver iterative value

Qualifications

• US citizen or lived in the US for 3 of the last 5 years. Must be able to obtain a U.S. Federal government client badge and pass a government background investigation
• Bachelor’s degree or equivalent with six (6) or more years of experience as a Data Engineer or similar role
• Strong proficiency in Snowflake, AWS services
• Hands‑on experience using Snowflake tools, SQL and Python is required
• Strong proficiency in GitHub for source control, branching strategy and reviews
• Knowledge of data integration patterns, data warehousing, and modern data architecture
• Strong analytical and communication skills, including the ability to analyze data, create meaningful insights, and present information clearly to stakeholders.
• Experience with object‑oriented programming and building with software engineering principles
• DevOps exposure, including CI/CD tools
• Understanding of Data Lake concepts
• Strong written and verbal communication skills are required, ability to collaborate, present, and report on findings
• Knowledge of Agile framework, Scrum methodologies and knowledge of tools used to support them
• Prior experience with government agencies and fraud detection systems is a plus

Attention Candidates

If you are selected for an interview, please be advised that Index Analytics LLC reserves the right to prohibit the use of artificial intelligence (AI) tools, including but not limited to AI-generated responses, real-time transcription, or automated assistance during the interview process. We value authentic interactions and the opportunity to engage directly with candidates. Any unauthorized use of AI may result in disqualification from consideration.

We're dedicated to ensuring a safe and transparent recruitment process for all candidates and have implemented robust measures to protect your personal information. Please be aware that all employment-related communications will originate from a secure portal (@msg.paycomonline.com) or a corporate email address (@index-analytics.com). If you have any concerns, please don't hesitate to reach out to us at [e-mail].

Index Analytics provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

Share job details to