Data Engineer I

About Inroads:

Inroads applies 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, 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:

We’re hiring an entry-level Data Engineer to join our Data Engineering team. You’ll take ownership of building reliable ELT/ETL pipelines and strong analytical data models using dbt. You don’t need to know everything on day one, but you must be eager to learn, experiment, and grow quickly. Experience with Airflow and Snowflake is a plus, but not required.

In this position you will:

• Build, test, and document dbt models (staging, intermediate, marts) aligned to Kimball dimensional modeling best practices.
• Implement data quality checks (dbt tests, sources, freshness) and contribute to monitoring data reliability.
• Collaborate with analytics, product, and domain stakeholders to translate business needs into well-modeled datasets.
• Proactively audit, define, and standardize key business metrics in collaboration with stakeholders to ensure consistency and trust across reporting platforms.
• Support source onboarding and ingestion from APIs, files, or databases into the warehouse.
• Maintain clear documentation for datasets, lineage, and transformation logic.
• Assist with CI/CD for analytics code (Git workflows, PR reviews, environments).
• Optimize model performance (incremental strategies, partitions/clustering, query tuning).
• Troubleshoot pipeline/data issues and contribute to root-cause analyses.
• Proactively identify improvement opportunities and drive them to completion with high ownership.

What we are seeking:

• 2 years of experience in data engineering, analytics engineering, or related field (internships, coursework, and projects encouraged) OR an undergraduate degree or higher in a related field
• Proficiency in SQL; able to write clean, performant queries.
• Practical experience with dbt (models, tests, documentation, sources; familiarity with Jinja/macros is a plus).
• Solid grasp of Kimball dimensional modeling (star/snowflake schemas, facts and dimensions, SCDs).
• Demonstrated ability to translate complex business logic into efficient, technical data structures.
• Understanding of data warehousing and ELT/ETL patterns.
• Familiarity with Git and collaborative development workflows.
• Strong problem-solving and communication skills; attention to detail.
• Demonstrated willingness to learn quickly and take ownership of outcomes.

Nice to have:

• Workflow orchestration experience (Airflow, Dagster, Prefect).
• Cloud data warehouse exposure (Snowflake preferred).
• Basic Python skills for data tasks (ETL scripts, API integrations).
• Experience with data testing/observability tools and lineage documentation.
• Experience designing and implementing data models specifically for consumption by internal technical teams (Data Analysts, Data Scientists).
• Exposure to CI/CD for analytics (dbt Cloud/Jobs, GitHub Actions).
• Domain knowledge of the U.S. healthcare insurance marketplace (Healthcare.gov) data and metrics.

Culture & ownership in the role:

• Bias for action: you establish clear goals, participate in problem-solving efforts, and take ownership of the outcomes
• Growth mindset: you learn new tools and concepts rapidly and share learnings with the team.
• Craftsmanship: you care about clean code, tests, documentation, and reproducibility.
• Collaboration: you give and receive constructive feedback and help raise the bar.

Success indicators:

• Delivers well-tested, documented dbt models that meet stakeholder needs.
• Improves data reliability through effective testing and monitoring.
• Demonstrates ownership by driving initiatives from problem definition to solution.
• Learns and applies new concepts (tools, modeling patterns, domain context) quickly.

What we offer:

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

• Salary: $85,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 Senior Director, People Operations. Inroads participates in E-verify. EEO is the Law.

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.