BI Data Engineer: ELT Pipelines & Dashboards

Pivotal Solutions; Raleigh (NC); On-site; USD 120,000 - 180,000; Full time

Job summary

Pivotal Solutions is seeking a Data Engineer (BI-focused) to own end-to-end data lifecycle, from ingestion to modeling and visualization, creating a single source of truth for business operations.

The role emphasizes building scalableELT pipelines, ensuring data quality, and delivering timely insights through BI dashboards using tools like Tableau and Looker/Power BI. Collaboration across teams is essential for data-driven decision making.

Qualifications

• 5+ years in data engineering with end-to-end ELT pipelines.
• 5+ years with relational databases and SQL.
• 3+ years on cloud-based data platforms (GCP preferred).

Responsibilities

• Design, build, and maintain scalable ELT data pipelines.
• Implement data validation and quality assurance processes.
• Perform exploratory data analysis and leverage ML tools for forecasting and anomaly detection.
• Develop and maintain BI dashboards and reporting solutions.
• Collaborate with cross-functional teams to deliver data-driven solutions.

Skills

Problem-solving

Ownership

Collaboration

Accountability

Team velocity

SQL

Python

Data modeling

ELT

Education

Bachelor’s degree in CS/Engineering or quantitative field

Tools

BigQuery

SQL Server

Snowflake

MSSQL

MySQL

Python

Tableau

Looker

Power BI

Airflow

dbt

ELT tools (Fivetran, Airbyte, Stitch)

GitHub

CI/CD

APIs

GCP

AWS

Job description

Pivotal Solutions is seeking a Data Engineer (BI-focused) to own end-to-end data lifecycle, from ingestion to modeling and visualization, creating a single source of truth for business operations.

The role emphasizes building scalableELT pipelines, ensuring data quality, and delivering timely insights through BI dashboards using tools like Tableau and Looker/Power BI. Collaboration across teams is essential for data-driven decision making.