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

dTBqQWVXbkVrR3hrdldhbTJQbHdyNmpVQWc9PQ==
  • 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

Element care

Psychiatric Nurse Practitioner Job at Element care

 ...The Advanced Practice Psychiatric Nurse (APRN) is responsible for providing behavioral health services to clients at assigned sites, including those in nursing home settings. The APRN delivers behavioral health care to a caseload of clients referred by the centers Primary... 

The British Connection Staffing

Personal Assistant - $130-$150k base Job at The British Connection Staffing

 ...work from home. Responsibilities Family & Household Flow ~ Set up a centralized calendar for both Principals ~ Coordinate school calendars, appointments, and extracurricular activities. ~4 children - 17, 14, 12 and 9 years old (and a new puppy for good... 

Summit Technology Services, Inc.

Production Operator Job at Summit Technology Services, Inc.

 ...Summit Technology Services has a long term contract for a Production Operator in Skaneateles, NY Job ID S-BH29824 Description of Assembly duties: Assemble small component parts or sub-assemblies using basic tools such as screwdrivers, clamps, exacto-knives, Allen... 

A.G. Rhodes

Registered Nurse ( RN ) Job at A.G. Rhodes

 ...best experience possible. Please consider applying for our Registered Nurse ( RN ) position. We have positions available at all three...  ...application for Registered Nurse ( RN ). Please note all Full-time and Part-time positions do require Every other weekend (Saturday &... 

Clark Ascend Inc.

Brand Ambassador Job at Clark Ascend Inc.

 ...Clark Ascend Inc. is looking for a dedicated and passionate Brand Ambassador to be the face of branding and marketing as a part of our growing team in Northridge, CA. As a Brand Ambassador , you will be at the forefront of creating positive customer interactions and...