Manager II, Analytics Engineering

Inroads; United States; Remote; USD 82,000 - 109,000; Full time

Benefits offered by this job

Health insurance

401K matching

Unlimited PTO

Parental leave

Tuition reimbursement

MacBook Pro

BYOD stipend

EAP

Flexible hours

Transit benefits

Lunches and snacks

Job summary

Inroads is seeking a Manager II, Analytics Engineering to lead a team of Analysts, Data Scientists, Engineers and PMs on a federal contract supporting healthcare.gov outreach and analytics. The role sits between Data Engineering and Data Analysis and requires building robust data pipelines and semantic models for KPIs.

You will foster dbt best practices, manage Airflow pipelines, and ensure data quality and documentation while aligning with ACA policy changes and client needs.

Qualifications

• 5+ years of applied experience in data analytics/infrastructure with 1+ year in leadership or mentoring
• Experience with dbt and downstream data models in cloud environments like Snowflake/Redshift/Databricks
• Experience optimizing data models for query efficiency

Responsibilities

• Direct and develop a small Analytics Engineering team
• Oversee migration and optimization of SQL logic into dbt pipelines; build dimensional models
• Develop and manage Airflow DAGs and data quality tests; monitor data reliability
• Maintain clear documentation for datasets, lineage, and transformation logic
• Drive performance improvements for queries and Snowflake usage
• Understand ACA regulatory frameworks to reflect marketplace changes in data models
• Own tasks and resolve challenges to deliver accurate products on deadlines
• Perform additional tasks as assigned by management

Skills

Leadership

Mentoring

SQL

ETL/ELT

Data modeling

Education

Bachelor's degree

Tools

dbt

Snowflake

Redshift

Databricks

Airflow

Job description

About Inroads:

Inroads works with government clients, applying data, analytics, technology, research, and content development to co-create services and programs that are personalized, relevant, and engaging for the communities who rely on them. Our deep understanding of digital services, analytics, policy implementation, and ways communities consume information allows us to seamlessly integrate with organizations and public sector teams to revolutionize the ways they deliver complex services at scale.

About the role:

As Manager II, Analytics Engineering, you will help ensure millions of Americans have access to healthcare by working with a team of Analysts, Data Scientists, Engineers, and Technical Product Managers to deliver on a federal contract that supports healthcare.gov outreach, analytics, and data science. Positioned between Data Engineering and Data Analysis, this leadership role will employ best practices in data modeling, SQL and dbt to design and build robust data pipelines, implement data quality testing, and maintain the foundational data models used for analytics reporting, outreach, and data science. This person will play an instrumental role supporting a team to improve documentation, manage pipeline automation, and transform data into actionable insights. Your track record should reflect domain knowledge in data analysis, data modeling, and ETL/ELT (particularly transformation), including experience adapting to changing technologies, business logic, policy implications, and client priorities.

In this position you will:

• Direct and develop a small Analytics Engineering team that partners with Analysts and Data Engineers to define data modeling standards and dbt best practices across the healthcare.gov outreach team.
• Oversee the migration, refactoring, and optimization of complex SQL logic into maintainable, highly scalable dbt pipelines; build dimensional models and semantic layers to answer critical business questions and track KPIs.
• Develop and manage complex Airflow DAGs to orchestrate movement of data throughout the lifecycle of outreachImplement data quality checks (dbt tests, sources, freshness) and monitor data reliability.
• Develop and maintain clear documentation for datasets, lineage, and transformation logic.
• Drive best practices for query performance and data model efficiency, helping the team troubleshoot slow-running transformations and optimize Snowflake usage.
• Develop a deep understanding of federal healthcare programs, specifically the ACA, policy mandates, and regulatory frameworks to ensure data models accurately reflect marketplace changes and consumer messaging.
• Take ownership of task areas and strive to independently resolve challenges in order to deliver accurate products on short deadlines.
• Complete such other reasonable tasks as may be assigned by management.

What we are seeking:

• 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 work alongside technical and less technical team members to understand the business logic of ingested data, ask the right questions, and translate that logic to build derivative data products that provide value.
• Deep interest in researching and investigating problems, approaching new systems with a lot of curiosity, solving puzzles, and proposing solutions that improve both technical performance and end users' satisfaction.
• Comfort working independently to drive portions of larger projects, using organizational objectives and sound judgment to guide your work.
• Experience providing detailed review of others' work and a strong grasp of version control (i.e., Git).
• Passion for applying your skills to our mission of improving government services and collaborating within a cross-functional team environment.
• The ability to successfully attain and maintain a Federal Public Trust security clearance, as required by our government clients; this includes a background investigation and a requirement that the individual has U.S. Citizenship, or U.S. residency for three of the past five years (36 of the past 60 months). Resumes should specify citizenship or residency information for the past 5 years.
• An undergraduate degree or higher.

You may also have:

• Experience working with Medicare, Medicaid, or HealthCare.gov Marketplace data and systems.
• Experience working with workflow orchestration tools, such as Airflow Workflows.
• Experience navigating cloud data environments like Snowflake or AWS Redshift.
• Familiarity with R for basic data manipulation, automation, or statistical analysis.
• Experience working in an Agile development environment

What We Offer:

Inroads offers a friendly work environment and competitive compensation and benefits package including:

• Salary: $95,000
• 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

The salary range for candidates who meet the minimum posted qualifications reflects the Company's good faith understanding and belief as to the wage range, and is accurate as of the date of this job posting.

At Inroads, we celebrate, support and thrive on differences. Not only do they benefit our services, products, and community, but most importantly, they are to the benefit of our team. Qualified people of all races, ethnicities, ages, sex, genders, sexual orientations, national origins, gender identities, marital status, religions, veterans statuses, disabilities and any other protected classes are strongly encouraged to apply. Inroads endeavors to make reasonable accommodations for qualified applicants with a disability unless the accommodation would impose an undue hardship on the operation of our business. If an applicant believes they require such assistance to complete the application or to participate in an interview, or has any questions or concerns, they should contact the Director, People Operations. Inroads participates in E-verify.

Collection of Personal Information Notice:

As you are likely aware, by submitting your job application, you are submitting personal information to our company. We collect various categories of personal information, including identifiers, protected classifications, professional or employment related information and sensitive personal information. We may retain and use this information for up to three years, in order to come to a decision on whether or not you are a good fit for our company. We may also retain or use some of this information to comply with any requirements under law, or for purposes of defending ourselves in any litigation. We do not use this information for any other purpose, or share it with third parties, unless you become an employee. To learn more, or to see our full Notice to Job Applicants, please click here.