Analytics Data Engineer II — ESOP‑Owned Data Pipelines

Butler/Till; City of Rochester (NY); On-site; USD 70,000 - 111,000; Full time

Benefits offered by this job

Employee Stock Ownership Plan (ESOP)

Annual bonus

100% paid parental leave

Job summary

A dynamic marketing agency in Rochester is looking for an experienced Analytics Data Engineer II to design, build, and maintain robust data solutions. This role emphasizes strong SQL and Python skills, focused on delivering quality data for analytics and operational efficiency. The ideal candidate will have experience in data governance, ETL processes, and the ability to work collaboratively across teams. Competitive compensation and benefits are offered, including employee ownership opportunities and paid time off.

Qualifications

• 2-5+ years of data engineering experience.
• Advanced proficiency in SQL and database schemas.
• Experience with ETL/ELT processes and data workflows.

Responsibilities

• Design and automate standardized data marts for reporting.
• Collaborate with teams to improve operational efficiency.
• Execute quality assurance and validation processes.

Skills

SQL

Python

Data analysis

Data governance

Education

Bachelor’s degree in Computer Science, IT, or related field

Tools

Power BI

Tableau

Git

Job description

A dynamic marketing agency in Rochester is looking for an experienced Analytics Data Engineer II to design, build, and maintain robust data solutions. This role emphasizes strong SQL and Python skills, focused on delivering quality data for analytics and operational efficiency. The ideal candidate will have experience in data governance, ETL processes, and the ability to work collaboratively across teams. Competitive compensation and benefits are offered, including employee ownership opportunities and paid time off.