Database Administrator

Index Analytics LLC; Baltimore (MD); Hybrid; USD 120,000 - 180,000; Full time

Job summary

Index Analytics LLC, based in Baltimore, seeks a Sr. Database Administrator to design, build, and optimize scalable data solutions for federal clients. You will architect Snowflake‑based systems, pipelines, and cloud infrastructure, blending advanced data engineering with cloud delivery.

Ideal candidates bring hands‑on experience with Snowflake, SQL, Python, AWS, and an Agile mindset. Responsibilities include modeling data for analytics, building robust ETL/ELT flows, ensuring data quality, and

Qualifications

• US citizen or permanent resident; must be able to obtain government badge and pass background check.
• Bachelor’s degree or equivalent with 10+ years in Data Systems/Engineering roles.
• Hands-on experience with Snowflake, SQL and Python.
• Strong proficiency in DevSecOps, Snowflake, AWS, Jenkins and GitHub.
• Knowledge of data lake, data modeling, data integration, data warehousing, and modern data architecture.
• Strong analytical and communication skills; ability to present findings to stakeholders.
• Knowledge of Agile/Scrum and related tooling.
• Snowflake Certification is a plus; government agency experience is a plus.

Responsibilities

• Collaborate with stakeholders and cross‑functional teams to gather requirements and define business rules.
• Design schemas and scalable data models (star/snowflake) to support analytics and AI workloads.
• Design secure, scalable, and cost‑optimized data solutions.
• Build and maintain scalable ETL/ELT pipelines using AWS and Snowflake tooling.
• Perform data extraction, transformation, and loading from diverse sources.
• Develop and optimize data models to support analytics, reporting, and ops.
• Implement data quality, validation, and monitoring frameworks.
• Ensure modular, testable, version‑controlled workflows; operate pipelines with monitoring and recovery.

Skills

Snowflake

SQL

Python

DevSecOps

AWS

Jenkins

GitHub

Data modeling

ETL/ELT

Data warehousing

CI/CD

Agile/Scrum

Data pipelines

Education

Bachelor’s degree or equivalent

Tools

Snowflake tools

Jenkins

GitHub

AWS

Job description

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

We are seeking a Sr. Database Administrator to support Government clients to design, build, and optimize scalable data solutions, data pipelines and cloud-based solutions. The Sr. Database Administrator plays a key role in modernizing the organization’s data ecosystem by architecting data solutions using a contemporary infrastructure.

As part of a cross-functional team, the incumbent will support efforts to design and implement a robust environment capable of ingesting diverse data sources to support advanced data analytics and data reporting needs. Core responsibilities include defining structural, interface, and business requirements for data solutions; designing relational and non-relational databases and their associated integration components; and implementing a Snowflake-based system with automated data pipelines.

This role blends advanced data engineering with hands ‑ on cloud solutions engineering, leveraging AWS, Snowflake, and modern DevSecOps practices. The ideal candidate has experience delivering high ‑ quality solutions in an Agile environment.

Key Responsibilities

• Collaborate closely with business stakeholders, cross ‑ functional and internal technical teams to gather requirements, document business rules and develop thorough understanding of the business context and objectives.
• Designing schemas and scalable data models (star/snowflake schemas) that support self-service analytics, product operations, and AI workloads
• Collaborate to design secure, scalable, and cost ‑ optimized data solutions.
• Design, build, and maintain scalable, reliable ETL/ELT data pipelineworkflows to process structured and unstructured data using AWS, Snowflake and Snowflake tools.
• Pe rform extraction, transformation, and loading of data from a wide variety of data sources using various data engineering tools and methods
• 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.
• Developdocumentation to include data models, data dictionaries, and data usage guides.
• Improve end-to-end performance of data workflows.
• Build and maintain CI/CD pipelines using Jenkinsto 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 ten (10) or more years of experience as Data System Architect, Engineer or similar role.
• Hands‑on experience using Snowflake tools, SQL and Python is required.
• Strong proficiency in DevSecOps, Snowflake, AWS services, Jenkins as well as with GitHub for source control, branching strategy and reviews.
• Knowledge of data lake, data modeling, 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.
• Extensive knowledge of the most recent technical developments in Data Engineering.
• Knowledge of Agile framework, Scrum methodologies and tools used to support them.
• Strong written and verbal communication skills are required, ability to collaborate, present, and report to stakeholders on findings.
• Snowflake Certification is a plus.
• Prior experience with government agencies is a plus.

About INDEX ANALYTICS LLC

Why Join Index?

Index offers opportunities to reach your potential and join a community of great minds with national impact. Watch this video for a glimpse at what makes us a top-tier employer!