Data Engineer

Butler/Till is a results-driven marketing agency offering deeply collaborative client experiences, proprietary technology, and world-class partnerships. At Butler/Till, we take immense pride in our independent, women-owned and led status, our unwavering commitment to a purpose-driven approach, our B-Corp status, and our unique structure as a 100% employee-owned company (ESOP).

SUMMARY

Data Engineer II is a role designed for individuals with a solid understanding and some hands-on experience in data engineering. This role involves taking ownership of larger data engineering tasks, designing solutions for moderately complex problems, and ensuring high-quality data pipelines and integrations. The ideal candidate will have experience with SQL, Python, cloud technologies, and data warehousing, with a strong ability to design, implement, and optimize data solutions. The role will offer opportunities to collaborate with cross-functional teams, contribute to architecture discussions, and mentor junior engineers.

The overall tech stack includes SQL, Python, AWS, Snowflake, and Power BI.

KEY OUTCOMES & RESPONSIBILITIES

Key Outcome: High-quality data solutions

Key Responsibilities:

• Independently design, develop, and maintain data pipelines and ETL processes for moderately complex data flows.
• Write complex, efficient, and maintainable code to integrate data from multiple sources, ensuring scalability and performance.
• Optimize and refactor existing code and pipelines to improve efficiency, reliability, and maintainability.
• Troubleshoot and resolve more complex technical issues with data quality, pipeline performance, or integration challenges.
• Collaborate with cross-functional teams (e.g., Analytics, Product) to understand and define business requirements for data solutions.
• Ensure data quality, integrity, and security through monitoring, validation, and the application of best practices.
• Automate and document data processes to improve efficiency and repeatability.

Key Outcome: Collaborative team environment

Key Responsibilities:

• Actively contribute to team discussions, offering solutions and feedback to improve data engineering practices.
• Assist in mentorship of junior engineers, helping them grow in their technical skills and knowledge of the team’s processes.
• Participate in and sometimes lead code reviews, ensuring adherence to best practices and high code quality.
• Contribute to the development of best practices and technical standards within the data engineering team.
• Participate in sprint planning, retrospectives, and other Agile ceremonies to ensure alignment on priorities and deliverables.
• Use tools like JIRA and Confluence for task tracking, progress reporting, and documentation.

Other Responsibilities:

• Assist with technical documentation for data pipelines, system configurations, and troubleshooting procedures.
• Lead or assist with data integration projects, including the creation of reports, data extracts, and data marts.
• Collaborate on troubleshooting and resolving complex production data issues to ensure system reliability and availability.

REQUIRED QUALIFICATIONS

• Bachelor’s degree in Computer Science, Information Technology, or a related field, or equivalent work experience.
• 2-5 years of experience in data engineering or a related field.
• Proficiency in SQL and experience with relational databases.
• Experience with cloud platforms (e.g., AWS) and data warehousing technologies (e.g., Snowflake).
• Strong understanding of data integration techniques and ETL/ELT processes.
• Ability to write complex code with a focus on optimization and scalability.
• Strong attention to detail and ability to ensure data quality and integrity.
• Ability to work effectively in cross-functional teams and communicate technical concepts to non-technical stakeholders.
• Excellent problem-solving skills with a focus on troubleshooting complex data issues.

PREFERRED QUALIFICATIONS

• Experience with Python, big data technologies, and distributed data processing.
• Familiarity with data visualization tools like Power BI.
• Exposure to Agile development methodologies and tools (e.g., JIRA, Confluence).
• Experience mentoring or coaching junior engineers.

CORE COMPETENCIES

• CUSTOMER FOCUS/CLIENT INTIMACY: seeking to understand client business challenges/needs and delivering continuous value to our clients
• COLLABORATIVE: working with teams and across the organization with ease
• OWNER AGILITY: able to continuously learn and quickly adapt to changing circumstance
• RESULTS DRIVEN: accepts accountability to deliver business outcomes, even under changing circumstances. Delivers on commitments
• DISCIPLINED: Thinks, plans, and prioritizes work on an ongoing basis, plans and aligns with key team members before acting WORK ENVIRONMENT & PHYSICAL DEMANDS

WORK ENVIORNMENT & PHYSICAL DEMANDS

The work environment and physical demands characteristics described here are representative of those an employee encounters while performing the essential functions of this job, typically in an office setting or in a home office. An employee in this role may be in a stationary position, often standing or sitting for prolonged periods and using office equipment and computers. The noise level in the office environment is usually moderate. (I.e., business office with computers and printers, light foot traffic, etc.). Reasonable accommodation may be requested to enable individuals to perform the essential functions.

Commitment to Diversity, Equity, Inclusion and Belonging

Our dedication to Diversity, Equity, Inclusion, and Belonging (DEIB) is a cornerstone of our culture. We believe that the diversity and inclusivity of our workforce are sources of strength. As you become part of our community, you'll discover that we are dedicated to creating a positive impact, not only for our clients but also for the communities where we live and work.

EEO DISCLAIMER

Butler/Till is an Equal Opportunity Employer to all employees and applicants and prohibits discrimination and harassment of any kind without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. This applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.

COMPENSATION

Butler/Till is committed to providing pay transparency of our compensation philosophy and ensuring equitable pay practices for our employee owners. The compensation range for this position is $79,000 - $110,000 and represents the annual salary range in Rochester, NY. Base pay offered may vary depending on multiple individualized factors, including location, skills, and experience.

This is just one component of Butler/Till’s total compensation package for employee owners. The total compensation package for this position may also include other elements, including ESOP (employee stock ownership plan), an annual bonus, in addition to a full benefits package, and paid time off benefits, including 100% paid parental leave. Details of participation in these benefit plans will be provided if an employee receives an offer of employment.