Data Engineer

Venteon; United States; On-site; USD 100,000 - 130,000; Full time

Job summary

A data solutions company is seeking a data engineer to design and maintain scalable ETL/ELT pipelines, manage an enterprise data warehouse, and create dashboards using Power BI. The ideal candidate will have over 5 years of experience in data engineering, strong skills in SQL, Python, and ETL tools, and familiarity with modern data warehouses. This role is critical for enabling data-driven decision-making across business units.

Qualifications

• 5–8+ years of experience in BI, data engineering, or analytics engineering.
• Strong experience building data pipelines using SQL, Python, or ETL tools.
• Hands-on experience with data modeling tools.

Responsibilities

• Design, build, and maintain scalable ETL/ELT pipelines.
• Design and deliver dashboards and self-service reporting solutions.
• Define and standardize KPIs and build data models.

Skills

Building data pipelines

SQL

Python

Data modeling

Power BI

Tools

Power BI

Tableau

Snowflake

Azure Synapse

BigQuery

Job description

Design, build, and maintain scalable ETL/ELT pipelines to ingest, transform, and load data from Azure SQL, ERP systems (SAP, Sage), marketing platforms, web analytics, and other sources. Own and evolve the enterprise data model to support changing business needs, continuously modeling and integrating new data sources. Manage and optimize the enterprise data warehouse (Snowflake or equivalent), ensuring performance, scalability, and reliability. Develop reusable data transformation logic using SQL and Python while enforcing strong data quality standards. Lead integration of newly acquired business data into the enterprise data environment.

Business Intelligence & Reporting

Design and deliver dashboards and self-service reporting solutions (Power BI preferred). Partner cross-functionally with finance, operations, marketing, customer service, and e-commerce teams to translate business needs into scalable data solutions. Define and standardize KPIs (margin, CAC, customer metrics, manufacturing metrics, etc.) and build data models that enable fast, accurate analysis. Train and support business users on reporting tools and best practices.

Required Qualifications

• 5–8+ years of experience in BI, data engineering, or analytics engineering.
• Strong experience building data pipelines using SQL, Python, or ETL tools.
• Hands‑on experience with data modeling tools (dbt, SQLMesh, Coalesce).
• Proficiency in Power BI, Tableau, or similar BI tools.
• Experience with modern data warehouses (Snowflake, Azure Synapse, BigQuery) and dimensional modeling concepts (facts, dimensions, star schema).
• Familiarity with cloud platforms (Azure preferred) and modern data stack tools (Fivetran, Stitch).
• Experience working with complex, disparate, or unstructured data sources.