Data Engineer
ARCHIVED
We can't find an active application page for this role right now. It may reopen or be listed elsewhere. Use Next Steps to search for an active apply link and similar live jobs.
GENERAL SUMMARY:
The Data Engineer will design, build, and maintain scalable data pipelines and infrastructure. The role will collaborate closely with cross-functional teams to ensure the availability, reliability, and performance of our data systems, enabling data-driven decision-making across the organization.
Essential Responsibilities:
- Design, build, and maintain reliable data pipelines using SQL and Python to connect operational systems and third-party APIs and power analytics used daily by Operations, Finance, and Executive Leadership
- Ingest data from SQL databases, third-party APIs, and structured file sources (SFTP, CSV/Excel)
- Help establish and maintain a centralized analytics data model
- Partner with business stakeholders to develop Tableau dashboards
- Implement data quality checks, logging, monitoring, and alerting
- Collaborate with business stakeholders to translate workflows into robust data products
- Contribute to version control, deployment, and data engineering standards (Git, environments)
- Optimize SQL queries, views, and table structures for analytics performance and incremental loads
- Maintain documentation for pipelines, datasets, schemas, and reports/dashboards
- Assist with access control, governance, and data security best practices
- Troubleshoot refresh failures and performance bottlenecks across the data stack
- Perform other duties as assigned
- Job Specification
Education:
Bachelor's in Computer Science, Information Systems, Engineering, or a related field, or 5+ years of professional experience as a Data Engineer or Analytics Engineer Strong SQL skills (complex joins, CTEs, window functions, performance tuning) Understanding of data modeling concepts (star schema, keys, SCD basics) Hands-on Python experience for data processing (pandas, standard libraries) Experience with relational databases (SQL Server, Postgres, or similar) Experience with Snowflake, Databricks Experience building and maintaining production data pipelines Experience with Tableau, Salesforce Knowledge of Massachusetts Senior Care Options (SCO) program a plus Strong attention to detail, problem solving and analytical thinking Effective communication and collaboration Comfortable working directly with business stakeholders Ability to manage multiple priorities
Compensation details: 108000-120000 Yearly SalaryPIea8471f20ed1-31181-40473068