Data Analytics Engineer — ETL & BI Pipelines

Guidehouse; San Antonio (TX); On-site; USD 95,000 - 130,000; Full time

Benefits offered by this job

Medical, Rx, Dental & Vision Insurance

401(k) Retirement Plan

Parental Leave

Tuition Reimbursement

Job summary

Guidehouse is seeking a Data Analytics Engineer to support data analytics, reporting, and data engineering across enterprise data lakes, data warehouses, and BI platforms. You will design, develop, and maintain ETL/ELT pipelines using Databricks, ODI, SQL, and Python to transform large datasets and ensure data quality and governance.

You will build BI semantic layers and dashboards with Power BI, OAS, Tableau, and related tools, while monitoring pipelines and collaborating with stakeholders to

Qualifications

• Bachelor’s degree in a technical field as listed.
• Three or more years of professional experience in data analytics, reporting, data engineering, or BI initiatives.
• Hands-on experience with enterprise data lakes and analytics platforms.

Responsibilities

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

Skills

Databricks

ETL/ELT development

ODI

SQL

Python

Data integration

Data quality validation

Metadata management

BI semantic layer

Education

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

Tools

Power BI

Oracle Analytics Server (OAS)

Tableau

Job description

Guidehouse is seeking a Data Analytics Engineer to support data analytics, reporting, and data engineering across enterprise data lakes, data warehouses, and BI platforms. You will design, develop, and maintain ETL/ELT pipelines using Databricks, ODI, SQL, and Python to transform large datasets and ensure data quality and governance.

You will build BI semantic layers and dashboards with Power BI, OAS, Tableau, and related tools, while monitoring pipelines and collaborating with stakeholders to