Data Analytics Engineer

The Timberline Group; St. Louis (MO); On-site; USD 90,000 - 130,000; Full time

Job summary

The Timberline Group is seeking a Data Analytics Engineer to join the Data Engineering team in St. Louis. You will build trusted data ingestion pipelines from SaaS and in-house databases to a data warehouse, enabling reporting, analytics, and AI initiatives.

Responsibilities include implementing pipelines, data mapping and validation, collaborating with cross-functional teams, maintaining uptime, and contributing to Agile delivery.

Qualifications

• BS in Engineering, Business Administration, Statistics, or equivalent.
• 3+ years SDLC experience in ETL/ELT environments.
• On-site at least two days a week in St. Louis, MO.
• 2+ years building data schemas for analytics.
• 1+ years AWS Cloud with AWS Glue, Lambda, Python.
• Experience with CRM/ERP (Salesforce, NetSuite, HubSpot, Eloqua).
• Strong development background with modern SDLC best practices.
• Proven track record delivering data initiatives.
• Excellent communication and stakeholder management.
• Experience in fast-paced, Agile environments.
• Ability to manage multiple projects simultaneously.

Responsibilities

• Implement data ingestion pipelines following defined guidelines and best practices.
• Implement data mapping, transformation, automated testing and data validation.
• Contribute and implement standards and best practices within the Data Engineering Team.
• Write detailed stories and groom Agile sprints; participate in SDLC life cycle.
• Ensure 100% uptime of environments and delivery accountability.
• Collaborate with cross-functional teams (engineering, sales, marketing, data insights).
• Partner with scrum master daily for updates and with Data Insights to align priorities.
• Stay up to date with industry trends to identify opportunities for innovation.
• Establish and maintain effective communication with stakeholders.

Skills

SDLC experience

Agile / Scrum

Strong communication

Problem solving

Data-driven decisions

Education

Bachelor's degree in Engineering, Business, Statistics, or related field

Tools

Fivetran

dbt

SQL

AWS Redshift

Boomi

PowerBI

Git

AWS Glue

AWS Lambda

Job description

*** Must be a US Citizen or Green Card only Applicant ****

The Data Analytics Engineer will be a part of the Data Engineering team whose primary mission is to build trusted Data Ingestion Pipelines to seamlessly move and transform data from SaaS and in house transactional databases to a Data Warehouse to enable actionable business insights. The data in the Warehouse will serve as a foundation for Reporting, Machine Learning Analysis and Generative AI. The ideal candidate will be a strong technical resource with effective communication and leadership skills to be a member of data engineering team. The role requires collaboration with cross functional teams and ability to play multiple roles depending upon the situation. The ideal candidate should have strong bias for action, able to dig into details when requirements are fuzzy and have a passion to push forward to progress.

What You'll Do

• Implementation of data ingestion pipelines following the guidelines and best practices defined.
• Implement data mapping, data transformation, automated testing and data validation.
• Contribute and implement standards and best practices within the Data Engineering Team.
• Write detailed stories, sprint grooming and actively contribute in the Agile software development life cycle.
• Accountable for Delivery and 100% uptime of the Environments.
• Collaborate with cross-functional teams, including ecosystem leadership and data insights teams, engineering, sales, and marketing to ensure all stakeholders are aligned.
• Partner with scrum master daily to provide updates.
• Partner with Data Insights team on a daily basis to stay aligned on priorities.
• Stay up to date with the latest industry trends and emerging technologies to identify opportunities for innovation and growth.
• Establish and maintain effective communication channels with internal and external stakeholders.

What You'll Need to Succeed

• BS in Engineering, Business Administration, Statistics, Business Analytics, or applicable experience in related field
• Minimum of (3) three years of SDLC experience in ETL/ELT environments with tools/technologies such as Fivetran, dbt, SQL, AWS Redshift, Boomi, PowerBI , Git.
• Ability to work on-site at least two days a week in St. Louis, MO.
• Minimum of (2) years of experience in building out schemas for Analytical purposes.
• Minimum (1) years of hands on experience AWS Cloud and Services such as AWS Glue, AWS Lambda, Python.
• Familiar with ERP, CRM products such as Salesforce, NetSuite, Hubspot and Eloqua.
• Strong development background and expert level skillswith modern SDLC best practices.
• Proven track record of delivering successful data initiatives.
• Excellent communication and interpersonal skills, with the ability to build strong relationships with internal and external stakeholders.
• Strong analytical and problem-solving skills, with the ability to make data-driven decisions.
• Experience working in a fast-paced, agile environment.
• Ability to prioritize and manage multiple projects simultaneously.