Technical Business Analyst

EXL

. Review and interpret complex Impala SQL queries written by business stakeholders and translate them into clear business requirements and agile user stories for the Spark development team .

Posted 9/28/2026full-timePittsburgh • Pennsylvania • United StatesMid-LevelSenior💰 $100,000 - $120,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Proficient in translating complex Impala SQL queries into actionable business requirements and user stories, with a strong understanding of Apache Spark architecture and data integration principles. Experienced in leading analytics processes and consulting on BI tool strategies to enhance data quality and reporting.

Highest-signal resume keywords

Impala SQL ProficiencyApache Spark KnowledgeUser Story CreationAgile Tooling (Jira)Business Intelligence Tools (Tableau, Power BI)

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Impala SQLApache SparkUser Story DocumentationData Integration PrinciplesPySparkSpark SQLStatistical ModelingData Quality Best PracticesAgile MethodologiesAnalytics

Soft Skills

FacilitationConsultingCollaborationCommunicationProblem-Solving

Tools & Technologies

JiraTableauPower BIHadoopDelta LakeIceberg

Industry Keywords

Business IntelligenceData ModernizationFinancial ServicesAnalyticsClient-Facing Experience

Tech Stack

Tools & technologies

ApacheHadoopPySparkSparkSQLTableau

About the role

Key responsibilities & impact

Review and interpret complex Impala SQL queries written by business stakeholders and translate them into clear business requirements and agile user stories for the 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

Requirements

What you’ll need

Bachelor's Degree
Proficiency in reading and decomposing complex Impala SQL queries into business requirements and user stories
Working knowledge of Apache Spark architecture and processing model sufficient to write development-ready stories for a Spark engineering team
Strong experience in user story creation and business requirements documentation
Solid understanding of data integration principles and data quality best practices
Ability to translate business stakeholder needs into precise technical requirements for engineering teams
Proficiency with agile tooling such as Jira for sprint and backlog management
5+ years of experience in analytics, business intelligence, or a related data-focused role
Hands-on experience writing PySpark or Spark SQL is good to have
Hands-on experience with BI tools such as Tableau, Power BI, or equivalent is good to have
Familiarity with Hadoop, data lake, or lakehouse platforms such as Delta Lake or Iceberg is good to have
Experience with statistical modeling or advanced analytical techniques is good to have
Background in data modernization or platform migration programs is good to have
Prior consulting or client-facing professional services experience is good to have
Domain experience in banking or financial services is good to have

Benefits

Comp & perks

Annual bonus
Benefits information provided via US Careers and Benefit