Data Analytics Engineer

Quick Facts

• Role: Data Analytics Engineer (Enterprise Data & Analytics)
• Focus: Building ingestion pipelines, transformation models, and governed data products for reporting and analytics
• Collaboration: Partners with Sales, Marketing, Finance, Production, and other business units

Description

The Data Analytics Engineer builds and maintains pipelines, models, and data products that power reporting, analytics, and decision-making. Working in a modern cloud data ecosystem (including Fivetran, Coalesce, and Snowflake), the role ensures trusted, scalable, and high-performing data solutions, and may deliver governed enterprise data applications using Streamlit or React plus AI/LLM capabilities.

Responsibilities

• Build and maintain Fivetran ingestion pipelines to land source data into Snowflake reliably and on schedule
• Develop custom Python and API-based integrations for source systems not covered by managed connectors
• Develop and maintain transformation models in Coalesce Transform using dimensional and layered modeling patterns
• Document data assets, definitions, and lineage in Coalesce Catalog
• Design and tune Snowflake objects (warehouses, roles, storage patterns) for performance and cost efficiency
• Gather reporting requirements from business stakeholders and translate them into scalable data models and metric definitions
• Build data applications in Streamlit and React for business users
• Apply AI and large language model capabilities for accelerated development, improved data quality checks, and natural language access to governed data
• Establish data quality testing, monitoring, and alerting across pipelines and models
• Partner with analysts and BI developers to ensure dashboards are built on certified, well-modeled data
• Support data governance, security, and access control practices
• Troubleshoot pipeline and data issues, identify root causes, and implement durable fixes

Requirements

• Bachelor’s degree in Computer Science, Information Systems, Analytics, or a related field (or equivalent practical experience)
• 3–5 years of experience in data engineering, analytics engineering, or a comparable data role
• Strong SQL skills
• Hands-on experience with Snowflake (or a comparable cloud data warehouse)
• Experience building and maintaining ELT pipelines with a managed ingestion tool such as Fivetran
• Experience with a modern transformation framework such as Coalesce Transform or dbt
• Demonstrated ability to gather reporting requirements from business stakeholders and deliver solutions that meet business needs
• Working knowledge of Python for data transformation, automation, and scripting
• Experience working with REST APIs to source and deliver data
• Experience with version control and code review practices in a team setting
• Work in office 3 days per week (additional in-office days may vary)

Benefits

• Comprehensive medical/dental
• 401(k) with company match
• Discounted stock purchase
• Discounts on mortgages and homes