Capgemini
Sr Business Systems Analyst with (SQL, DWH ETL & Healthcare)
Capgemini, New York, New York, us, 10261
Business Systems Analyst with (SQL, DWH ETL & Healthcare)
Join to apply for the
Business Systems Analyst with (SQL, DWH ETL & Healthcare)
role at
Capgemini Business Systems Analyst with (SQL, DWH ETL & Healthcare)
Join to apply for the
Business Systems Analyst with (SQL, DWH ETL & Healthcare)
role at
Capgemini Get AI-powered advice on this job and more exclusive features. Job Description
We are seeking a highly skilled and experienced Job Location : Philadelphia, PA
Job Description
We are seeking a highly skilled and experienced
Business Systems Analyst with (SQL, DWH ETL & Healthcare)
to join our team. The ideal candidate will have 510 years of experience in gathering and documenting business and functional requirements, creating data mapping documents, and working closely with ETL developers and data modelers. This role demands strong SQL expertise, a deep understanding of data warehousing concepts, and the ability to manage multiple complex projects in a dynamic environment.
Key Responsibilities
Collaborate with business stakeholders to gather and document Business Requirements Documents (BRDs) and Functional Requirements Documents (FRDs). Develop detailed Data Mapping Documents to support ETL development and data integration. Write and review complex SQL queries across multiple tables for data analysis, validation, and profiling. Work closely with data modelers to design and validate data warehouse schemas and structures. Analyze large datasets to identify trends, anomalies, and data quality issues. Adapt quickly to changing requirements and integrate them into ongoing work. Lead and influence the adoption of best practices, standards, and strategies within the team. Manage and prioritize a diverse portfolio of cross-functional projects. Stay informed on industry trends and provide insights and case studies relevant to the business.
Required Skills And Qualifications
610 years of experience in business systems analysis, preferably in a data warehousing environment. Proven experience in creating BRDs, FRDs, and Data Mapping Documents. SQL (Must have very good knowledge) Advanced skills in writing and optimizing complex queries. DWH ETL (Must have good knowledge) Strong understanding of ETL processes and data warehouse architecture. ETL Reporting (Good to have) Experience with reporting tools and generating insights from ETL data. Prior experience in data warehousing is required. Must have Healthcare industry experience. Demonstrated ability to manage multiple projects and workstreams simultaneously. Excellent communication and stakeholder management skills. Must be local and available to work onsite as required.
Preferred Attributes
Leadership experience in setting standards and best practices. Ability to influence high-impact decisions and strategic initiatives. Theoretical and practical understanding of data architecture and ETL processes.
Life at Capgemini
Capgemini supports all aspects of your well-being throughout the changing stages of your life and career. For eligible employees, we offer:
Flexible work Healthcare including dental, vision, mental health, and well-being programs Financial well-being programs such as 401(k) and Employee Share Ownership Plan Paid time off and paid holidays Paid parental leave Family building benefits like adoption assistance, surrogacy, and cryopreservation Social well-being benefits like subsidized back-up child/elder care and tutoring Mentoring, coaching and learning programs Employee Resource Groups Disaster Relief
Disclaimer
Capgemini is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.
This is a general description of the Duties, Responsibilities and Qualifications required for this position. Physical, mental, sensory or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed. Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodations do not pose an undue hardship.
Capgemini is committed to providing reasonable accommodations during our recruitment process. If you need assistance or accommodation, please reach out to your recruiting contact.
Click the following link for more information on your rights as an Applicant http://www.capgemini.com/resources/equal-employment-opportunity-is-the-law
Salary Transparency
Capgemini discloses salary range information in compliance with state and local pay transparency obligations. The disclosed range represents the lowest to highest salary we, in good faith, believe we would pay for this role at the time of this posting, although we may ultimately pay more or less than the disclosed range, and the range may be modified in the future. The disclosed range takes into account the wide range of factors that are considered in making compensation decisions including, but not limited to, geographic location, relevant education, qualifications, certifications, experience, skills, seniority, performance, sales or revenue-based metrics, and business or organizational needs. At Capgemini, it is not typical for an individual to be hired at or near the top of the range for their role. The base salary range for the tagged location is $80420- $106050/yearly.
This role may be eligible for other compensation including variable compensation, bonus, or commission. Full time regular employees are eligible for paid time off, medical/dental/vision insurance, 401(k), and any other benefits to eligible employees.
Note: No amount of pay is considered to be wages or compensation until such amount is earned, vested, and determinable. The amount and availability of any bonus, commission, or any other form of compensation that are allocable to a particular employee remains in the Company's sole discretion unless and until paid and may be modified at the Companys sole discretion, consistent with the law.
Seniority level
Seniority level
Mid-Senior level Employment type
Employment type
Full-time Job function
Job function
Information Technology Industries
IT Services and IT Consulting Referrals increase your chances of interviewing at Capgemini by 2x Sign in to set job alerts for Business System Analyst roles.
Front Office Support IT Business Analyst
New York, NY $115,000.00-$180,000.00 3 weeks ago Buffalo, NY $55,000.00-$80,000.00 6 days ago Buffalo, NY $55,000.00-$80,000.00 12 hours ago New York, NY $120,000.00-$200,000.00 1 week ago IT Manager - IT Business Advisor and Analyst
Front Office IT Business Analysts -Global Markets & Risks
New York, NY $115,000.00-$180,000.00 1 hour ago New York, NY $101,000.00-$147,000.00 9 hours ago Reference Data Technical Business Analyst
New York, NY $105,000.00-$125,000.00 1 week ago Senior Business Systems Analyst, Quote to Cash
New York, NY $135,300.00-$200,400.00 2 weeks ago GM Post-trade Equity Solutions IT Business Analyst Front Office
New York, United States $145,000.00-$180,000.00 1 week ago Embedded Banking IT Senior Business Analyst
Buffalo, NY $55,000.00-$80,000.00 2 weeks ago New York, NY $79,000.00-$99,000.00 5 days ago Business Analyst - Payments (FEDWIRE, CHIPS, SWIFT)
New York, United States $40.00-$45.00 2 weeks ago Embedded Banking IT Senior Business Analyst
Albany, NY $95,000.00-$105,000.00 1 week ago New York, United States $60,000.00-$80,000.00 14 hours ago New York, NY $90,500.00-$128,600.00 5 days ago Murex Front Office, Business Analyst - Support
New York, NY $120,000.00-$220,000.00 3 weeks ago Business Data Analyst With Banking & Regulatory Expertise
New York, United States $103,330.00-$128,656.00 3 weeks ago New York, NY $90,000.00-$150,000.00 6 days ago business Data Analyst - Pricing & Reporting
New York, United States $70.00-$75.00 1 month ago New York, NY $125,000.00-$150,000.00 2 weeks ago Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr
Join to apply for the
Business Systems Analyst with (SQL, DWH ETL & Healthcare)
role at
Capgemini Business Systems Analyst with (SQL, DWH ETL & Healthcare)
Join to apply for the
Business Systems Analyst with (SQL, DWH ETL & Healthcare)
role at
Capgemini Get AI-powered advice on this job and more exclusive features. Job Description
We are seeking a highly skilled and experienced Job Location : Philadelphia, PA
Job Description
We are seeking a highly skilled and experienced
Business Systems Analyst with (SQL, DWH ETL & Healthcare)
to join our team. The ideal candidate will have 510 years of experience in gathering and documenting business and functional requirements, creating data mapping documents, and working closely with ETL developers and data modelers. This role demands strong SQL expertise, a deep understanding of data warehousing concepts, and the ability to manage multiple complex projects in a dynamic environment.
Key Responsibilities
Collaborate with business stakeholders to gather and document Business Requirements Documents (BRDs) and Functional Requirements Documents (FRDs). Develop detailed Data Mapping Documents to support ETL development and data integration. Write and review complex SQL queries across multiple tables for data analysis, validation, and profiling. Work closely with data modelers to design and validate data warehouse schemas and structures. Analyze large datasets to identify trends, anomalies, and data quality issues. Adapt quickly to changing requirements and integrate them into ongoing work. Lead and influence the adoption of best practices, standards, and strategies within the team. Manage and prioritize a diverse portfolio of cross-functional projects. Stay informed on industry trends and provide insights and case studies relevant to the business.
Required Skills And Qualifications
610 years of experience in business systems analysis, preferably in a data warehousing environment. Proven experience in creating BRDs, FRDs, and Data Mapping Documents. SQL (Must have very good knowledge) Advanced skills in writing and optimizing complex queries. DWH ETL (Must have good knowledge) Strong understanding of ETL processes and data warehouse architecture. ETL Reporting (Good to have) Experience with reporting tools and generating insights from ETL data. Prior experience in data warehousing is required. Must have Healthcare industry experience. Demonstrated ability to manage multiple projects and workstreams simultaneously. Excellent communication and stakeholder management skills. Must be local and available to work onsite as required.
Preferred Attributes
Leadership experience in setting standards and best practices. Ability to influence high-impact decisions and strategic initiatives. Theoretical and practical understanding of data architecture and ETL processes.
Life at Capgemini
Capgemini supports all aspects of your well-being throughout the changing stages of your life and career. For eligible employees, we offer:
Flexible work Healthcare including dental, vision, mental health, and well-being programs Financial well-being programs such as 401(k) and Employee Share Ownership Plan Paid time off and paid holidays Paid parental leave Family building benefits like adoption assistance, surrogacy, and cryopreservation Social well-being benefits like subsidized back-up child/elder care and tutoring Mentoring, coaching and learning programs Employee Resource Groups Disaster Relief
Disclaimer
Capgemini is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.
This is a general description of the Duties, Responsibilities and Qualifications required for this position. Physical, mental, sensory or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed. Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodations do not pose an undue hardship.
Capgemini is committed to providing reasonable accommodations during our recruitment process. If you need assistance or accommodation, please reach out to your recruiting contact.
Click the following link for more information on your rights as an Applicant http://www.capgemini.com/resources/equal-employment-opportunity-is-the-law
Salary Transparency
Capgemini discloses salary range information in compliance with state and local pay transparency obligations. The disclosed range represents the lowest to highest salary we, in good faith, believe we would pay for this role at the time of this posting, although we may ultimately pay more or less than the disclosed range, and the range may be modified in the future. The disclosed range takes into account the wide range of factors that are considered in making compensation decisions including, but not limited to, geographic location, relevant education, qualifications, certifications, experience, skills, seniority, performance, sales or revenue-based metrics, and business or organizational needs. At Capgemini, it is not typical for an individual to be hired at or near the top of the range for their role. The base salary range for the tagged location is $80420- $106050/yearly.
This role may be eligible for other compensation including variable compensation, bonus, or commission. Full time regular employees are eligible for paid time off, medical/dental/vision insurance, 401(k), and any other benefits to eligible employees.
Note: No amount of pay is considered to be wages or compensation until such amount is earned, vested, and determinable. The amount and availability of any bonus, commission, or any other form of compensation that are allocable to a particular employee remains in the Company's sole discretion unless and until paid and may be modified at the Companys sole discretion, consistent with the law.
Seniority level
Seniority level
Mid-Senior level Employment type
Employment type
Full-time Job function
Job function
Information Technology Industries
IT Services and IT Consulting Referrals increase your chances of interviewing at Capgemini by 2x Sign in to set job alerts for Business System Analyst roles.
Front Office Support IT Business Analyst
New York, NY $115,000.00-$180,000.00 3 weeks ago Buffalo, NY $55,000.00-$80,000.00 6 days ago Buffalo, NY $55,000.00-$80,000.00 12 hours ago New York, NY $120,000.00-$200,000.00 1 week ago IT Manager - IT Business Advisor and Analyst
Front Office IT Business Analysts -Global Markets & Risks
New York, NY $115,000.00-$180,000.00 1 hour ago New York, NY $101,000.00-$147,000.00 9 hours ago Reference Data Technical Business Analyst
New York, NY $105,000.00-$125,000.00 1 week ago Senior Business Systems Analyst, Quote to Cash
New York, NY $135,300.00-$200,400.00 2 weeks ago GM Post-trade Equity Solutions IT Business Analyst Front Office
New York, United States $145,000.00-$180,000.00 1 week ago Embedded Banking IT Senior Business Analyst
Buffalo, NY $55,000.00-$80,000.00 2 weeks ago New York, NY $79,000.00-$99,000.00 5 days ago Business Analyst - Payments (FEDWIRE, CHIPS, SWIFT)
New York, United States $40.00-$45.00 2 weeks ago Embedded Banking IT Senior Business Analyst
Albany, NY $95,000.00-$105,000.00 1 week ago New York, United States $60,000.00-$80,000.00 14 hours ago New York, NY $90,500.00-$128,600.00 5 days ago Murex Front Office, Business Analyst - Support
New York, NY $120,000.00-$220,000.00 3 weeks ago Business Data Analyst With Banking & Regulatory Expertise
New York, United States $103,330.00-$128,656.00 3 weeks ago New York, NY $90,000.00-$150,000.00 6 days ago business Data Analyst - Pricing & Reporting
New York, United States $70.00-$75.00 1 month ago New York, NY $125,000.00-$150,000.00 2 weeks ago Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr