Data Engineer II

• Platform Delivery

• Collaborate with Lead Data Engineers and domain Architect to design, build, optimize the data architecture and extract, transform, load (ETL) pipelines to make them accessible for the data users

• Own and support data engineering platform tools using technologies like Snowflake, AWS, HVR, KNIME, etc.

• Design robust ETL pipelines of medium complexity adhering to existing patterns while keeping performance, uptime, reduced technical debt, scalability, and extensibility

• Develop and perform unit tests, and maintain up to date code in source control

• Collaborate with other Data Engineers for code review and participate in pair programming when needed

• Independently troubleshoot issues reported by users and errors from ETL jobs with minimal guidance; participate in on-call rotation and perform root cause analysis

• Deliver quality code and follow best practices and standards keeping performance & Scalability in mind to keep cost in check in Cloud environment

• Partner with Platform Product Manager to prioritize and deliver high quality data products, working in agile team

• Live the culture of sharing, re-use, design for scale and stability, and operational efficiency of data and analytical solutions. Demonstrate the passion for innovation and continuous improvement

• Maintain awareness of advancements, and changes in technologies relating to data engineering and cloud data platforms

• Overall

• Bring a positive Run Happy energy and work with the team to deliver the best possible solutions

• Learn the business, learn the data that supports the business; be a partner - don't just implement technology

• Live Brooks' values

• Other responsibilities as required

Qualifications:

• Bachelor's degree or equivalent work experience in Computer Science, Engineering, Math, Information Systems, or related disciplines

• 5+ years of professional experience in data warehouse ETL or Data Engineering development

• 3 - 5 years of hands-on experience with Python and solid understanding of Object-Oriented Programming Language concepts

• Proficient in SQL and experience in working complex transformations

• 2-3 years of experience working in Cloud data platforms (Snowflake, Microsoft Fabric preferred)

• Experience working with source control tools (Git/Bitbucket)

• 3+ years of current professional experience in cloud based ETL data engineering development (AWS preferred). Certification is a plus.

• Solid understanding of data modeling and data architecture concepts

• Experience working in data orchestration and transformation tools (Airflow and dbt preferred)

• Experience with analyzing data, unit testing & data quality validation

• Excellent verbal and written communication skills, demonstrating effective listening through concise, clear verbal and written communication.

• Good interpersonal skills and demonstrated problem solving skills

• Embraces and lives the Brooks values!

Compensation:

Our compensation reflects the cost of labor across US geographic markets. The base pay for this position ranges from $100,829 per year in our lowest geographic market up to $172,469 per year in our highest geographic market. Base pay offered will consider the specific geographic market and will vary depending on job-related knowledge, skills, and experience.

Other:

Brooks is proud to offer a robust benefits package to our employees and their families!

Benefits- including medical, dental, vision, life and AD&D insurance, disability insurance, HSA and employer contribution, FSA, family & fertility assistance, 401K Savings Plan and match, employee assistance program, and transportation assistance.

Paid Time Off- Brooks offers generous time off including three to five weeks of paid time off, eleven paid holidays, paid sick and parental leave.

Bonus- in addition to base pay, Brooks employees may also be offered an annual bonus based on company performance.

Perks- including product discounts, employee recognition, fitness discounts, volunteer and donation benefits.

At Brooks, we celebrate diversity & equity. We are committed to creating an inclusive environment, and encourage people of all backgrounds, perspectives, experiences, and skills to apply. Brooks is proud to be an equal employment opportunity employer. All employment decisions are made without regard to race, religion, creed, color, national origin, age, sex, gender, gender identity or expression, two-spirit identity, sexual orientation, genetic information, sensory, physical, or mental disability, marital status, pregnancy (including childbirth and related conditions), honorable discharge or military status, protected citizen status, actual or perceived victims of domestic violence, sexual assault or stalking, HIV or Hepatitis C infection, political ideology, use of a trained guide dog by a person with a disability, or on any other basis protected by federal, state or local law, or any other non-merit based factors.