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

Element Care

Latest Jobs

Data Engineer