Inroads ยท 3 hours ago
Data Engineer I
United States
Full-time
Remote
Entry Level
$85K/yr - $85K/yr
2+ years expInroads applies data, analytics, technology, research, and content development to enhance community services. They are seeking an entry-level Data Engineer to build reliable ELT/ETL pipelines and analytical data models, collaborating with various stakeholders to meet business needs.
Information Technology & Services
Responsibilities
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
Qualification
Required
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
Preferred
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
Benefits
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
Company
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.
11-50 employees
Funding
Current Stage
Early StageCompany data provided by crunchbase