Business Systems Analyst -Data Warehouse

CrossTech is seeking a highly skilled Business Systems Analyst with strong expertise in SQL and Google BigQuery. The ideal candidate will be business-facing and responsible for understanding requirements, analyzing data, and providing developers with detailed mapping documents and solutions. This role requires the ability to write complex queries, validate requirements against actual data, and troubleshoot performance issues in collaboration with developers. While this is not a coding or ETL development role, it is highly technical and requires strong hands-on SQL / BigQuery skills.

Key Responsibilities

• Partner with business stakeholders to gather and document requirements, translating them into detailed mapping documents and solution designs
• Write and optimize complex SQL and BigQuery queries to analyze data, validate requirements, and support solution design
• Provide developers with clear, accurate mapping documents and collaborate closely to resolve issues with rules, logic, or data discrepancies
• Troubleshoot and tweak queries when developers encounter issues, ensuring solutions remain accurate and aligned with business needs
• Support performance tuning and query optimization efforts, creating solutions that consider efficiency and scalability from the start
• Work alongside data engineers and developers to validate data flows and ensure solutions are properly implemented
• Collaborate with stakeholders and technical teams to ensure requirements and solutions align with business objectives

Required Qualifications

Preferred Qualifications

Compensation

Comprehensive benefits offered

Location

Philadelphia, PA