Data Engineer

Burtch Works; United States; Remote; USD 120,000 - 170,000; Full time

Job summary

Burtch Works is seeking a hands-on Data Engineer for a remote role in the United States. The candidate will optimize data pipelines using Databricks, Python, and SQL, and support Power BI reporting across enterprise analytics.

The role spans data integration, transformation, and BI modernization, collaborating with stakeholders to deliver scalable data solutions and reliable dashboards for business insights.

Qualifications

• Hands-on experience building and optimizing data pipelines in Databricks.
• Strong Python for data processing, transformation, automation, and integration.
• Advanced SQL skills for large enterprise datasets and complex joins.
• Experience with Snowflake in an enterprise data environment.
• Experience building Power BI dashboards and reports.
• Understanding of ETL/ELT, data integration, and production data workflows.
• Ability to troubleshoot data quality issues and improve reporting solutions.
• Collaborative, analytical, and able to translate business requirements into technical solutions.

Responsibilities

• Develop, maintain, and optimize data pipelines and transformation workflows using Databricks, Python, and SQL to support enterprise analytics and reporting.
• SQL Development & Optimization: write, troubleshoot, and enhance complex queries with multi-table joins and large-scale transformations.
• Data Integration: transform data across enterprise platforms, using Snowflake as a primary source and Databricks for processing.
• Business Intelligence & Reporting: develop and maintain Power BI dashboards and reporting for subscriber activity, revenue, billing, and streaming ops.
• Reporting Modernization: support a major initiative to consolidate ~90 reports and modernize legacy SQL.
• Data Quality & Validation: investigate discrepancies and ensure reporting accuracy across systems.
• Performance Optimization: identify inefficiencies and improve reliability, scalability, and maintainability.
• Cross-Functional Collaboration: partner with stakeholders to translate reporting requirements into technical solutions.
• Documentation & Knowledge Transfer: document transformations and workflows for long-term maintainability.

Skills

Python

ETL/ELT

Data pipelines

Data quality

Data integration

Reporting

Collaboration

Problem solving

Tools

Databricks

Snowflake

Power BI

Delta Lake

PySpark

SQL

Job description

About The Company

Our client is a leading media and entertainment organization delivering innovative television, streaming, and digital experiences to millions of customers nationwide. With a continued focus on data-driven decision-making, the organization is investing in modern data platforms, business intelligence, and analytics capabilities to improve operational efficiency and deliver actionable insights across the enterprise.

Location: Remote - U.S

About The Company

Our client is a leading media and entertainment organization delivering innovative television, streaming, and digital experiences to millions of customers nationwide. With a continued focus on data-driven decision-making, the organization is investing in modern data platforms, business intelligence, and analytics capabilities to improve operational efficiency and deliver actionable insights across the enterprise.

Job Summary

We are seeking a hands‑on Data Engineer with strong experience in Databricks, Python, SQL, Snowflake, and Power BI to support a growing Business Analytics organization. This role sits at the intersection of data engineering and business intelligence, combining the development and optimization of enterprise data pipelines with the modernization of business-critical reporting solutions.

Working alongside senior technical leadership, the Data Engineer will improve existing data workflows, troubleshoot complex data challenges, and help streamline a broad portfolio of Power BI reports and dashboards. The position offers an opportunity to work across the full data lifecycle, from data integration and transformation to reporting and visualization.

The ideal candidate is a technically strong, resourceful problem‑solver who enjoys working with complex datasets, improving existing processes, and translating business requirements into reliable, scalable data solutions.

Key Responsibilities

• Data Engineering & Pipeline Development: Develop, maintain, and optimize data pipelines and transformation workflows using Databricks, Python, and SQL to support enterprise analytics and reporting.
• SQL Development & Optimization: Write, troubleshoot, and enhance complex SQL queries, including multi‑table joins, large‑scale transformations, and performance optimization.
• Data Integration: Integrate and transform data across enterprise platforms, leveraging Snowflake as a primary data source and Databricks for data processing and manipulation.
• Business Intelligence & Reporting: Develop, enhance, and maintain Power BI dashboards and reporting solutions supporting subscriber activity, revenue, billing, customer accounts, and streaming operations.
• Reporting Modernization: Support a significant reporting optimization initiative involving approximately 90 existing reports, identifying opportunities to consolidate redundant dashboards, modernize legacy SQL, and improve reporting efficiency.
• Data Quality & Validation: Investigate data discrepancies, reconcile information across multiple systems, and implement improvements to ensure reporting accuracy and consistency.
• Performance Optimization: Identify and resolve inefficiencies in existing data pipelines, queries, and reporting processes to improve reliability, scalability, and maintainability.
• Cross‑Functional Collaboration: Partner with business stakeholders, analytics teams, and enterprise data engineering resources to translate reporting requirements into practical technical solutions.
• Documentation & Knowledge Transfer: Document data transformations, reporting logic, and technical workflows to support long‑term maintainability and the transition of repeatable processes to enterprise technology teams.

What You'll Bring

• Hands‑on experience developing, maintaining, and optimizing data pipelines within Databricks.
• Strong proficiency in Python for data processing, transformation, automation, and integration.
• Advanced SQL skills, including complex joins, query optimization, and working with large enterprise datasets.
• Experience working with Snowflake in an enterprise data environment.
• Demonstrated experience building, modifying, and maintaining Power BI dashboards and reports.
• Solid understanding of ETL/ELT processes, data integration, and production data workflows.
• Experience troubleshooting data quality issues, reconciling datasets, and improving existing reporting solutions.
• Ability to evaluate existing technical processes, identify inefficiencies, and implement practical improvements.
• Strong analytical, troubleshooting, and problem‑solving skills, with the ability to communicate effectively with both technical and business stakeholders.
• A collaborative, self‑directed approach with the ability to assume increasing ownership of technical deliverables.

Preferred Qualifications

• Experience developing and optimizing data transformations using PySpark within Databricks.
• Familiarity with Databricks Serverless Compute and modern cloud‑based data processing environments.
• Experience with Delta Lake, including incremental data processing and upsert operations.
• Previous involvement in reporting modernization, dashboard consolidation, or legacy SQL optimization initiatives.
• Experience supporting enterprise business intelligence, financial analytics, or operational reporting environments.
• Familiarity with data governance, reporting automation, and data validation best practices.
• Experience working with subscriber, billing, revenue, or customer account datasets.
• Prior experience in media, entertainment, telecommunications, or subscription‑based businesses.

Why Join Us?

This opportunity offers the chance to make a meaningful impact within a large‑scale, data‑driven organization undergoing continued modernization of its analytics and reporting capabilities. You'll work with modern data technologies, collaborate directly with experienced technical leadership, and contribute to initiatives that improve the accuracy, efficiency, and scalability of business‑critical reporting.

For a Data Engineer who enjoys solving complex problems, working across data engineering and business intelligence, and seeing the direct business impact of their work, this role offers a compelling combination of technical challenge, ownership, and professional growth.