Data Analytics Engineer — ETL/BI Pipelines

US132 Guidehouse Digital, LLC; San Antonio (TX); On-site; USD 110,000 - 140,000; Full time

Benefits offered by this job

Medical, Rx, Dental & Vision Insurance

401(k) Retirement Plan

Parental Leave

Health Savings Account

Job summary

Guidehouse seeks a data engineering professional to support analytics across data lakes, warehouses, and BI platforms. You will design ETL/ELT pipelines and ensure data quality while enabling scalable reporting with BI tools.

You will work with Databricks, ODI, SQL, and Python to integrate and validate large datasets, and collaborate with stakeholders to deliver robust data solutions in a federal/public trust environment.

Qualifications

• Bachelor’s degree in a technical field and 3+ years of relevant experience.
• Experience supporting data analytics, reporting, data engineering, or BI initiatives.
• Hands-on experience with enterprise data lakes and data warehouses.

Responsibilities

• Support data analytics, reporting, and data engineering across data lakes, warehouses, and BI platforms.
• Design, develop, and maintain ETL/ELT pipelines for reporting needs.
• Integrate, transform, and validate large datasets using SQL, Python, ODI, and Databricks.
• Perform data quality assessments and govern metadata documentation and lineage.
• Develop and maintain BI semantic layers for accurate reporting.
• Create dashboards/reports using Power BI, OAS, Tableau, and similar tools.
• Monitor production pipelines, troubleshoot performance, and support operations.
• Collaborate with stakeholders to deliver scalable data solutions.

Skills

Databricks

ODI

SQL

Python

Data integration

Data transformation

Data quality

Metadata management

BI semantic layer

Power BI

Tableau

Oracle Analytics Server

Education

Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Engineering, Mathematics, or related field

Tools

ODI

Databricks

Power BI

Tableau

Oracle Analytics Server

Job description

Guidehouse seeks a data engineering professional to support analytics across data lakes, warehouses, and BI platforms. You will design ETL/ELT pipelines and ensure data quality while enabling scalable reporting with BI tools.

You will work with Databricks, ODI, SQL, and Python to integrate and validate large datasets, and collaborate with stakeholders to deliver robust data solutions in a federal/public trust environment.