Technical Business Analyst

Work Location: Pittsburgh, PA
Work Mode: Hybrid (2-3 days/week in office)
Salary Range: $100K/Yr - $120K/Yr Base + Annual Bonus

The posted range is the hiring range for this role — a subset of the broader range available to employees over time — and reflects base salary across our national hiring scale. Final offers are based on several factors, including the candidate's skills and experience, internal pay equity, work location, market conditions for the role, and the specific scope and responsibilities of the position. The top of the range is reserved for candidates who notably exceed the requirements; the lower end applies to those with less experience or fewer preferred qualifications. For positions based in higher-cost zones (e.g., California, New York, New Jersey), actual compensation may exceed the posted range; your recruiter will share specifics during the process

For more information on benefits and what we offer please visit us at US Careers and Benefit

• 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.

Must-Have Technical Skills

• 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 stories creation and business requirements documentation.
• Solid understanding of data integration principles and data quality best practices.
• Demonstrated 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.
  

Good to Have

• Hands-on experience writing PySpark or Spark SQL.
• Hands-on experience with Business Intelligence (BI) tools such as Tableau, Power BI, or equivalent.
• Familiarity with Hadoop, data lake, or lakehouse platforms (Delta Lake, Iceberg, or similar).
• Experience with statistical modeling or advanced analytical techniques.
• Background in data modernization or platform migration programs.
• Prior consulting or client-facing professional services experience.
• Domain experience in banking or financial services.