Data Analytics Engineer - ETL Pipelines & Dashboards

Guidehouse; Huntsville (AL); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Medical insurance

401(k) plan

Paid holidays

Tuition reimbursement

Employee assistance program

Job summary

Guidehouse is seeking a data analytics and engineering professional in Huntsville to support enterprise data lakes, data warehouses, and BI platforms. You will design and maintain ETL/ELT pipelines, leverage Databricks, ODI, SQL, and Python to transform large datasets, and ensure data quality and governance through metadata documentation and lineage tracking.

The role involves developing BI semantic layers and dashboards with Power BI, OAS, Tableau, and similar tools, while monitoring production

Qualifications

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

Responsibilities

• Support data analytics, reporting, and data engineering across enterprise data lakes, warehouses, and BI platforms.
• Design, develop, and maintain ETL/ELT pipelines for reporting and analytics needs.
• Utilize Databricks, ODI, SQL, and Python to transform and validate large datasets.
• Perform data quality assessments and support data governance through metadata documentation and lineage tracking.
• Develop and support BI semantic layers and dashboards using Power BI, OAS, Tableau, and other tools.
• Monitor production pipelines, troubleshoot performance, and support ongoing operations.
• Collaborate with stakeholders, analysts, and technical teams to deliver scalable data and reporting solutions.

Skills

Databricks

SQL

Python

Data integration

Data quality

Metadata management

BI reporting

Education

Bachelor's degree in Computer Science / Information Systems / Data Analytics

Tools

ODI

Power BI

Tableau

Oracle Analytics Server (OAS)

Job description

Guidehouse is seeking a data analytics and engineering professional in Huntsville to support enterprise data lakes, data warehouses, and BI platforms. You will design and maintain ETL/ELT pipelines, leverage Databricks, ODI, SQL, and Python to transform large datasets, and ensure data quality and governance through metadata documentation and lineage tracking.

The role involves developing BI semantic layers and dashboards with Power BI, OAS, Tableau, and similar tools, while monitoring production