Remote BI Engineer: Modern Data Platform & Pipelines

Sourcepass; United States; Remote; USD 120,000 - 180,000; Full time

Job summary

Sourcepass is seeking a remote Senior Data Engineer to design, build, and maintain data pipelines and models that feed the data lake and SQL layer. You’ll modernize the BI platform, evaluate architectures, plan migrations, and retire legacy pipelines.

You’ll partner with the BI Manager and business leaders to translate analytics needs into data models, ensure data freshness and quality, monitor pipeline health, and support integrations and AI-enabled data services.

Qualifications

• 3+ years of data engineering or BI engineering experience.
• Strong SQL skills: writing, optimizing, validating queries.
• Hands-on ETL/ELT pipeline development for a data warehouse or data lake.
• Experience integrating systems via REST APIs with authentication, pagination, and error handling.
• Proficiency in Python, PowerShell, or similar.
• Ability to explain technical work clearly to engineers and business stakeholders.

Responsibilities

• Designs, builds, and maintains pipelines and data models that move data into the data lake and SQL layer.
• Leads modernization of the Sourcepass BI platform, evaluating architecture options and planning migrations.
• Partners with the BI Manager and business leaders to translate reporting needs into data models, freshness targets, and quality checks.
• Monitors pipeline health and data quality, resolves data issues, and keeps the SQL layer as the source of truth for dashboards.
• Builds and supports back-end integrations, APIs, and data services used by automation workflows and AI agents.
• Supports data migration and system integration for acquired companies, mapping legacy systems and data.
• Documents data sources, models, and pipelines for maintainability and auditability.

Skills

SQL

ETL/ELT pipelines

Data modeling

REST APIs

Python

Communication

Tools

Azure Synapse

Power BI

Azure Data Factory

Power Automate

Job description

Sourcepass is seeking a remote Senior Data Engineer to design, build, and maintain data pipelines and models that feed the data lake and SQL layer. You’ll modernize the BI platform, evaluate architectures, plan migrations, and retire legacy pipelines.

You’ll partner with the BI Manager and business leaders to translate analytics needs into data models, ensure data freshness and quality, monitor pipeline health, and support integrations and AI-enabled data services.