Analytics Data Engineer II
$70k/y-$111k/y
Butler/Till2 days ago
Highlight
OnsiteFull-timeMid
Summary
Butler/Till is seeking an Analytics Data Engineer II to join their team in Rochester, NY. The role involves designing, building, and maintaining scalable data solutions that power reporting and advanced analytics.
About the Role
As an Analytics Data Engineer II, you will be responsible for delivering reliable, well-structured data that improves efficiency and automates workflows. You will partner with various teams to capture requirements, design data marts, and ensure data integrity through quality assurance processes. Additionally, you will enforce data security and governance practices while mentoring junior engineers.
About You
Required:
- Bachelor’s degree in Computer Science, Information Technology, Statistics, Mathematics, Finance, or Economics.
- 2-5+ years of data engineering experience.
- Advanced proficiency in SQL with strong understanding of database schemas and analytics data marts.
- Experience designing and maintaining ETL/ELT pipelines and data workflows.
- Experience with data discovery, analytics, and BI tools (e.g., Power BI, Tableau, Qlik).
- Proficiency with Git and version control platforms (e.g., GitHub, GitLab, Bitbucket).
- 2+ years of experience or intermediate proficiency in Python or similar languages.
- Experience working with normalized and denormalized data structures.
- Detail-oriented with strong organizational, communication, and technical skills.
- Strong analytical and reasoning skills with the ability to visualize processes and outcomes.
- Experience implementing data validation and quality assurance practices.
- Ability to anticipate risks and dependencies across deliverables.
- Ability to translate business requirements into scalable technical solutions.
Preferred:
- Experience working with Snowflake, including administrative permissions.
- Experience in agile environments and project management tools (e.g., Jira, Wrike, Asana, Confluence).
- Familiarity with SaaS analytics platforms and cloud environments (Azure, AWS).
- Familiarity with data security, access controls, and governance practices.
- Experience optimizing performance and cost in cloud data platforms.
Benefits
- Competitive salary range of $70k–$111k.
- Employee stock ownership plan (ESOP).
- Annual bonus eligibility.
- Comprehensive benefits package including medical, dental, and vision coverage.
- Paid time off benefits, including 100% paid parental leave.
Butler/Till
As an independent, women-owned/led, 100% employee-owned, B Corporation, we create award-winning campaigns that deliver measurable business impact. Free from holding company constraints, our agile and accountable approach genuinely serves our clients' best interests. With 25+ years of experience, we specialize in media, campaign analytics, marketing science, creative services, and healthcare marketing, connecting brands with audiences in meaningful ways. Looking for localized marketing solutions? We have that covered too. Endless spreadsheets, logins, tabs open, and emails. We know how complex local marketing can be, so we built the technology to make it easier, BetterLocal.
Rochester, New York Metropolitan Area