Data Analytics Engineer: ETL Pipelines & BI Dashboards

Guidehouse; Huntsville (AL); On-site; USD 85,000 - 125,000; Full time

Benefits offered by this job

Medical insurance

401(k) retirement plan

Paid holidays

Parental leave

Transit and parking benefits

Tuition reimbursement

Job summary

Guidehouse in Huntsville, AL is seeking a data analytics engineer to support enterprise data lakes, data warehouses, and BI platforms. You will design, build, and maintain ETL/ELT pipelines using Databricks, ODI, SQL, and Python to enable timely reporting and analytics.

You will validate data quality, support governance, and develop BI semantic layers, dashboards, and reports with Power BI, OAS, Tableau. Collaboration with stakeholders is essential to deliver scalable data solutions.

Qualifications

• Must be able to obtain and maintain a Federal Public Trust.
• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, Mathematics, or related field.
• Three (3) or more years of professional experience supporting data analytics, reporting, data engineering, or business intelligence initiatives.
• Hands-on experience supporting enterprise data lakes, data warehouses, and analytics platforms.
• Strong expertise with Databricks, ODI, SQL, Python, and data governance concepts.
• Experience developing reports, dashboards, and visualizations using Power BI, OAS, Tableau, or similar BI tools.

Responsibilities

• Support data analytics, reporting, and data engineering activities across enterprise data lakes, data warehouses, and business intelligence platforms.
• Design, develop, and maintain ETL/ELT data pipelines to support reporting and analytics requirements.
• Utilize Databricks, Oracle Data Integrator (ODI), SQL, and Python to integrate, transform, and validate large datasets.
• Perform data quality assessments, troubleshoot data issues, and support data governance efforts through metadata documentation and lineage tracking.
• Develop and support BI semantic layers to ensure accurate and scalable reporting solutions.
• Create and maintain dashboards and reports using tools such as Power BI, Oracle Analytics Server (OAS), Tableau, and other enterprise reporting platforms.
• Monitor production data pipelines, troubleshoot query performance issues, validate dashboard data, and support ongoing operations and maintenance activities.
• Collaborate with business stakeholders, analysts, and technical teams to deliver scalable data and reporting solutions.

Skills

ETL/ELT development

Data integration

Data quality

Communication

Education

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

Tools

Databricks

Oracle Data Integrator (ODI)

SQL

Python

Power BI

Tableau

Job description

Guidehouse in Huntsville, AL is seeking a data analytics engineer to support enterprise data lakes, data warehouses, and BI platforms. You will design, build, and maintain ETL/ELT pipelines using Databricks, ODI, SQL, and Python to enable timely reporting and analytics.

You will validate data quality, support governance, and develop BI semantic layers, dashboards, and reports with Power BI, OAS, Tableau. Collaboration with stakeholders is essential to deliver scalable data solutions.