Data Engineer (Tableau & GCP Experience REQUIRED) - Raleigh, NC OR Scotts Valley, CA

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

We are seeking a Data Engineer (BI-focused) to join our lean Data and Intelligence team and help build a cloud-based data platform that serves as a single source of truth for business operations. In this role, you’ll have end-to-end ownership of the data lifecycle—from ingestion and transformation to modeling and visualization—helping unify data across systems and deliver reliable, timely insights that drive business decisions.

Key Responsibilities

• Design, build, and maintain scalable, secure, and high-quality ELT data pipelines
• Implement data validation and quality assurance processes to ensure data integrity
• Perform exploratory data analysis and leverage built-in ML tools (e.g., BigQuery ML, Vertex AI) for forecasting and anomaly detection
• Develop and maintain BI dashboards and reporting solutions to support data-driven decision-making
• Collaborate with cross-functional teams to deliver impactful, data-driven solutions

Technical Qualifications

Education:

• Bachelor’s degree in Computer Science, Engineering, or a related quantitative field

Experience:

• 5+ years in data engineering
• 5+ years working with relational databases and SQL
• 3+ years working with cloud-based data platforms (GCP preferred)

Core Technologies:

• Cloud: GCP; AWS (nice to have)
• Data Warehousing: BigQuery (primary); SQL Server, Snowflake
• Databases: MSSQL, MySQL
• Programming: Python, SQL
• BI Tools: Tableau (required); Looker or Power BI (nice to have)
• Other: Airflow, dbt, real-time data streaming, ELT tools (e.g., Fivetran, Airbyte, Stitch), GitHub, CI/CD pipelines, APIs

Core Competencies

• Problem-solving: Strong analytical, debugging, and research skills to resolve process issues or data inconsistencies
• Ownership: End-to-end ownership of data initiatives
• Collaboration: Ability to work effectively with both technical and non-technical stakeholders
• Accountability: Commitment to delivering accurate, reliable, and timely data products
• Team velocity: Focus on improving development efficiency and accelerating deployment of data models