Hybrid Technical Business Analyst: Data Translator

EXL; Pittsburgh (Allegheny County); Hybrid; USD 100,000 - 120,000; Full time

Job summary

EXL is seeking a seasoned Technical Business Analyst to bridge business teams and data engineering. In a hybrid Pittsburgh role, you’ll translate complex stakeholder needs into clear requirements and agile user stories for Spark development.

You will partner with BI, data quality, and analytics teams, review Impala SQL queries, and guide solutions from concept to delivery, ensuring alignment with business goals and KPI targets.

Qualifications

• Must read and decompose complex Impala SQL queries into business requirements.
• Working knowledge of Apache Spark architecture to write development-ready stories.
• Experience creating user stories and documenting business requirements.
• Strong data quality knowledge and data integration principles.
• Translate stakeholder needs into precise engineering requirements.
• Proficient with Jira for sprint and backlog management.
• 5+ years in analytics, BI, or related data roles.
• Hands-on PySpark or Spark SQL experience.
• Experience with Tableau or Power BI.
• Familiarity with Hadoop or lakehouse platforms.
• Experience with statistical modeling or advanced analytics.
• Consulting or client-facing experience.
• Banking/financial services domain experience.

Responsibilities

• Review and interpret complex Impala SQL queries written by stakeholders and translate into clear business requirements and user stories for Spark development team.
• Facilitate requirements-gathering sessions with business clients to surface data needs, KPIs, and reporting goals.
• Partner with Spark Engineers throughout development to ensure delivered solutions match original business intent.
• Lead analytics processes across multiple business units, determining the optimal analytical approach for each problem.
• Consult with clients on BI tool strategy, data quality, and analytical solution development.

Skills

Impala SQL queries

Spark understanding

User stories creation

Business requirements documentation

Data quality best practices

Agile tooling Jira

Analytics experience 5+ years

Tools

Jira

Tableau

Power BI

Hadoop

Delta Lake

Iceberg

Job description

EXL is seeking a seasoned Technical Business Analyst to bridge business teams and data engineering. In a hybrid Pittsburgh role, you’ll translate complex stakeholder needs into clear requirements and agile user stories for Spark development.

You will partner with BI, data quality, and analytics teams, review Impala SQL queries, and guide solutions from concept to delivery, ensuring alignment with business goals and KPI targets.