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
