Data Architect

IntePros Consulting; Philadelphia (Philadelphia County); On-site; USD 70,000 - 100,000; Full time

Job summary

An established industry player is seeking a skilled Business System Analyst to join their dynamic team in Philadelphia. This role is pivotal in bridging business needs with technical solutions, especially in data warehousing and ETL applications. You will engage with business clients to gather requirements, analyze data, and ensure effective communication between stakeholders and technical teams. Your expertise in SQL and data analysis will be essential in delivering accurate reporting and documentation. This opportunity promises a collaborative environment where your contributions will significantly impact the organization’s success.

Qualifications

• 5+ years as a Business Systems Analyst with a focus on data warehousing.
• Expertise in writing SQL queries and conducting data analysis.

Responsibilities

• Gather requirements and develop detailed BRDs and FRDs.
• Plan and consult on data reporting needs, providing insights.

Skills

SQL Queries

Data Analysis

Business Requirement Documents (BRDs)

Functional Requirement Documents (FRDs)

ETL Methodologies

Communication Skills

Problem-Solving

Team Collaboration

Education

Bachelor's Degree in a relevant field

Tools

Teradata

DB2

Oracle

Job description

Business System Analyst - Data Warehouse

Location : Philadelphia, PA (Onsite Required)

About the Role : IntePros is seeking a highly skilled Business System Analyst (BSA) for a leading health insurance organization based in Philadelphia. This role is crucial to ensuring the effective delivery of data warehouse solutions, where you will serve as the bridge between business needs and technical implementation.

Key Responsibilities :

• Requirements Gathering & Analysis : Work closely with business clients to determine system requirements, develop detailed Business Requirement Documents (BRDs), Functional Requirement Documents (FRDs), and Mapping documents for ETL applications.
• System Recommendations : Recommend system criteria, project scope, and perform analysis to identify potential problems, system enhancements, and necessary upgrades.
• Data Analysis & Reporting : Plan and consult with business clients on data reporting needs, providing insights through data profiling, complex SQL queries, and trending reports.
• Documentation & Design : Oversee the design and development of user system documentation and ensure all system designs are accurately documented.
• Collaboration & Communication : Serve as the primary contact for defining business and functional system requirements, ensuring clear communication between stakeholders and technical teams.
• Testing & Validation : Perform system testing, assist in User Acceptance Testing (UAT), and ensure production readiness through rigorous verification processes.
• Mentorship : Mentor junior team members, guiding them in best practices and technical processes.

Qualifications :

• Experience : Minimum of 5 years as a Business Systems Analyst, with a strong background in data warehousing and ETL applications.
• Technical Skills : Expertise in writing SQL queries across multiple tables and conducting data analysis / profiling.Proficient in creating BRDs, FRDs, and Source-to-Target mapping documents.Familiarity with one or more database products (Teradata, DB2, Oracle, etc.).Understanding of data integration and ETL methodologies.
• Industry Knowledge : Exposure to at least one health care business area, such as Actuarial, Finance, Underwriting, Claims Processing, Enrollment, or Provider.
• Communication : Exceptional oral and written communication skills, with the ability to facilitate presentations and discussions.
• Problem-Solving : Strong analytical and troubleshooting skills, with the ability to work independently on multiple projects.
• Teamwork : Demonstrated ability to collaborate effectively within a team and across departments.
• Accountability : Commitment to adhering to program and project management standards.