FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates expertise in Analytics Engineering, focusing on data modeling standards, dbt best practices, and optimizing data pipelines in cloud environments. Proven ability to lead teams, mentor junior staff, and ensure data quality and reliability in compliance with federal healthcare regulations.
Highest-signal resume keywords
Analytics Engineering LeadershipDbt DevelopmentSQL OptimizationAirflow Pipeline ManagementFederal Healthcare Knowledge
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
Data ModelingSQLDbtAirflowSnowflakeRedshiftDatabricksData Quality ChecksVersion ControlData Transformation
Soft Skills
MentoringIndependent Problem SolvingCollaborationAttention to DetailTime Management
Certifications & Qualifications
Federal Public Trust Security Clearance
Industry Keywords
Healthcare ProgramsACA Policy MandatesRegulatory FrameworksData AnalyticsData Infrastructure
Tech Stack
Tools & technologiesAirflowAmazon RedshiftCloudSQLVault
About the role
Key responsibilities & impact- Direct and develop a small Analytics Engineering team partnering with Analysts and Data Engineers
- Define data modeling standards and dbt best practices across the healthcare.gov outreach team
- Oversee migration, refactoring, and optimization of complex SQL logic into scalable dbt pipelines
- Build dimensional models and semantic layers to answer business questions and track KPIs
- Develop and manage complex Airflow DAGs to orchestrate data movement
- Implement data quality checks and monitor data reliability
- Maintain documentation for datasets, lineage, and transformation logic
- Drive query performance and data model efficiency; optimize Snowflake usage
- Develop understanding of federal healthcare programs, ACA policy mandates, and regulatory frameworks
- Resolve challenges independently and deliver accurate products on short deadlines
- Complete other reasonable tasks assigned by management
Requirements
What you’ll need- 5+ years of applied experience working in data analytics/infrastructure, analytics engineering with 1+ years leading, managing, or mentoring technical team members
- Proven track record working with dbt and developing downstream data models (Kimball/Vault) in cloud environments like Snowflake, Redshift, or Databricks along with pipeline management in Airflow or similar tools
- Experience optimizing data models for query efficiency
- Strong desire or experience mentoring junior Analytics Engineering staff and developing best practices within a team
- Ability to understand business logic of ingested data and translate it into derivative data products
- Comfort working independently to drive portions of larger projects
- Experience providing detailed review of others’ work and a strong grasp of version control (i.e., Git)
- Ability to successfully attain and maintain a Federal Public Trust security clearance
- U.S. Citizenship, or U.S. residency for three of the past five years (36 of the past 60 months)
- An undergraduate degree or higher
Benefits
Comp & perks- Premier health, dental, and vision insurance plans
- 401K matching
- Unlimited paid time off
- Paid personal and volunteer leave
- 13 paid holidays
- 15 weeks paid parental leave
- Professional development stipend & tuition reimbursement
- Macbook Pro laptop & tech accessories
- Bring Your Own Device (BYOD) stipend for mobile device
- Employee Assistance Program (EAP)
- Supportive & collaborative culture
- Flexible working hours
- Pre-tax transportation options for commuting to our office in Washington, DC
- Lunches and snacks