Data Warehouse Business Systems Analyst Job at IntePros, Philadelphia, PA

Q3ZMQVc1d1B3cDVwc2JKcnY2ekducEhQeEE9PQ==
  • IntePros
  • Philadelphia, PA

Job Description

Business Systems Analyst – Data Warehouse

Location: Philadelphia, PA (Onsite 3 days/week – must be local to PA, NJ, or DE prior to start)

Employment Type: Contract-to-Hire

About the Role

We are seeking a Business Systems Analyst (BSA) to join our Data Warehouse team. This role is critical in bridging business needs with technical solutions by documenting requirements, designing data mapping specifications, and supporting the development of ETL applications.

The ideal candidate will be highly skilled in SQL, data profiling, and requirements documentation, with the ability to translate complex business requirements into clear, actionable deliverables for technical teams. This position is well-suited for a detail-oriented analyst who thrives in a collaborative environment and is comfortable working with both business stakeholders and technical data teams.

Key Responsibilities

  • Gather, analyze, and document business requirements; create BRDs, FRDs, and mapping documents for ETL development.
  • Write and execute complex SQL queries across multiple tables for data analysis, profiling, and validation.
  • Collaborate with data modelers to define table designs and source-to-target mappings.
  • Support testing, production readiness checks, and post-deployment validation to ensure accuracy and integrity of data solutions.
  • Provide weekend/off-hours support when necessary for production releases.
  • Communicate effectively with stakeholders, ensuring requirements are well understood and technical deliverables meet business needs.

Required Skills & Experience

  • Strong data profiling and analysis expertise.
  • Advanced SQL skills (complex queries, multi-table joins, performance tuning).
  • Proven experience creating functional requirements, data mappings, and documentation.
  • Excellent verbal, written, and active listening skills for stakeholder engagement.

Preferred Skills & Experience

  • Hands-on experience in data warehousing environments.
  • Background in healthcare or health insurance industries.

Why Join

This is a high-impact role within a mission-driven team where your work directly contributes to data-driven decision-making. You’ll have the opportunity to work with advanced data warehouse technologies, collaborate with experienced professionals, and play a key role in shaping ETL and reporting solutions.

Job Tags

Contract work, Local area, 3 days per week,

Similar Jobs

CRH

Underground Utility Foreperson Job at CRH

 ...Job ID: 512852 Reynolds Excavation, Demolition & Utilities is a CRH Company.Our purpose, commitment to the future, and formula...  ...a skilled position requiring: 5-10 years experience with underground utility experience with at least three years as a crew leader... 

Catholic Health Services

Registered Dietitian Job at Catholic Health Services

 ...Summary & Objective The Dietitian is responsible for the nutritional care and education of all patients/residents in accordance with current applicable federal, state, and local standards, guidelines and regulations, our established policies and procedures, through physician... 

365 Health Services

Program Specialist Job at 365 Health Services

 ...A. BASIC PURPOSE The Program Specialist position focuses on two main tasks ensuring quality services are being provided as well as pairing new DSPs with referrals that we have obtained. The Program Specialist develops relationships with clients, individuals,... 

Planet Smile Partners

Pediatric Dentist Job at Planet Smile Partners

 ...Now Hiring: Pediatric Dentist Full-Time Join Our Growing Pediatric Dental Practice Our thriving Pediatric Dental office is expanding, and we're excited to welcome a new Full-Time or Temporary Pediatric Dentist to our dedicated team! Whether you're a seasoned provider... 

Toshiba America Energy Systems

Generator Field Service Repair Technician Job at Toshiba America Energy Systems

 ...maintenance, outage planning and more for current and future power generation needs in the Americas, including thermal, hydro and nuclear...  ...Position Summary We are seeking a Field Service Repair Technician to work out of our Milwaukee Service Center. The FS Repair...