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

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

Web-Cote Industries

Operations & Office Coordinator Job at Web-Cote Industries

 ...private label rodent, insect, and fly control glue products for the pest control industry. Our products play a critical role in public health protection, food safety, and property preservation. We are seeking an organized and proactive Operations & Office Coordinator for... 

Compunnel Inc.

Data Entry Assistant Job at Compunnel Inc.

Job Summary: We are looking for a detail-oriented and organized individual to help with data entry and administrative tasks. This role involves entering information into computer systems, organizing documents, and supporting the office with basic clerical duties. ...

Hays Electrical Services

Traveling Superintendent Job at Hays Electrical Services

With over 18 years of experience and hundreds of million-dollar projects completed, Hays Electrical Services provides excellent service to customers in industries hospitality, commercial and solar. Hays Electrical Services approaches each project with a cooperative mindset...

Atlantic Health

Nurse Manager RN Cardiac Cath Lab Full Time Days Morristown Medical Center in Morristown Job at Atlantic Health

The Cardiac Cath Lab at Morristown Medical Center is seeking a dynamic Nurse Manager to join one of the most advanced cardiovascular programs in the nation. This is a rare opportunity to lead operations in New Jerseys highest-volume Cath Lab , featuring: Cutting...

Atlanta Public Schools

Carpentry Teacher ***$3,000 INCENTIVE*** Job at Atlanta Public Schools

 ...Carpentry Teacher Location: Atlanta College & Career Academy The Carpentry teacher will be responsible for teaching the theoretical and practical concepts, strategies, and techniques associated with the construction field within the Career, Technical, and Agriculture...