Data Analytics Engineer: ETL & BI Pipeline Expert

Guidehouse; San Antonio (TX); On-site; USD 85,000 - 120,000; Full time

Benefits offered by this job

Medical, Rx, Dental & Vision Insurance

401(k) Retirement Plan

Company Paid Holidays

Parental Leave

Tuition Reimbursement

Learning Opportunities

Job summary

Guidehouse seeks a data analytics and data engineering professional to support analytics across enterprise data lakes and BI platforms. You will design ETL/ELT pipelines with Databricks, ODI, SQL, and Python to integrate and validate large datasets, while ensuring data quality and governance.

Candidate will develop BI semantic layers and dashboards using Power BI, OAS, Tableau, and other enterprise reporting platforms, monitoring pipelines and collaborating with stakeholders.

Qualifications

• Three or more years of professional experience supporting data analytics, reporting, data engineering, or BI initiatives.
• Hands-on experience with enterprise data lakes, data warehouses, and analytics platforms.
• Strong expertise with Databricks, ODI, SQL, Python and data integration/quality.
• Experience developing reports and dashboards with Power BI, OAS, Tableau.

Responsibilities

• Support data analytics, reporting, and data engineering across enterprise data lakes, warehouses, and BI platforms.
• Design, develop, and maintain ETL/ELT data pipelines to support reporting and analytics needs.
• Utilize Databricks, ODI, SQL, and Python to integrate, transform, and validate large datasets.
• Perform data quality assessments, troubleshoot data issues, and document metadata lineage.
• Develop and support BI semantic layers for accurate, scalable reporting.
• Create dashboards and reports using Power BI, OAS, Tableau, and other enterprise tools.
• Monitor production pipelines, troubleshoot performance, and support operations.

Skills

Databricks

ODI

SQL

Python

Data integration

Data quality

Metadata management

BI semantic layer

Education

Bachelor's degree in Computer Science

Information Systems

Data Analytics

Tools

Power BI

Oracle Analytics Server

Tableau

Oracle Data Integrator (ODI)

Job description

Guidehouse seeks a data analytics and data engineering professional to support analytics across enterprise data lakes and BI platforms. You will design ETL/ELT pipelines with Databricks, ODI, SQL, and Python to integrate and validate large datasets, while ensuring data quality and governance.

Candidate will develop BI semantic layers and dashboards using Power BI, OAS, Tableau, and other enterprise reporting platforms, monitoring pipelines and collaborating with stakeholders.