Job Title -Business Systems Analyst (EDW)
Location - Hybrid- Toronto
We are seeking a Business Systems Analyst (BSA) with strong experience in Enterprise Data Warehousing (EDW) initiatives within the Auto Insurance domain. The role focuses on translating business needs into data requirements, supporting EDW design and delivery, and ensuring data accuracy across policy, claims, billing, and underwriting subject areas.
Key Responsibilities
- Act as a liaison between Auto Insurance business stakeholders and data engineering / QA teams
- Gather, analyze, and document business requirements for EDW and downstream reporting
- Translate business needs into:
- Source‑to‑Target mappings (STTM)
- Data transformation rules
- Business logic and calculation rules
- Support data warehouse design discussions
- Facts, dimensions, grain, and conformed dimensions
- Define and validate Slowly Changing Dimension (SCD Type 1 & 2) rules
- Perform data analysis using SQL to support requirement validation and issue triage
- Support data quality, reconciliation, and UAT activities
- Collaborate with QA teams to ensure:
- Business rule coverage
- Auto insurance scenarios are correctly validated
- Assist with impact analysis for changes across EDW, reporting, and regulatory outputs
- Participate in Agile ceremonies (backlog grooming, sprint planning, demos)
Required Skills & Experience
Data & EDW
- Strong understanding of Data Warehousing concepts
- EDW architecture, fact & dimension modeling
- Star / Snowflake schemas
- Experience working with SCDs, especially:
- Type 1, Type 2
- Effective date handling, current flags, history preservation
- Proficiency in SQL
- Data validation, analysis, reconciliation
- Ability to write and interpret complex queries
Business Analysis
- 6+ years of experience as a BSA / Data Analyst in large data programs
- Strong experience in:
- BRDs, FRDs, user stories
- STTM and data mapping documentation
- Excellent stakeholder management and communication skills
Domain – Auto Insurance (Must Have)
Hands‑on experience with Auto Insurance data domains, such as:
- Policy (Quotes, Endorsements, Renewals, Cancellations)
- Claims (FNOL, Loss details, Payments, Recoveries)
- Billing / Premiums
- Coverages, Vehicles, Drivers
- Reference & Master data (LOB, State, Coverage codes)
Exempt Roles (up to AD Level)
Note: Compensation range should extend from the minimum to P75, consistent with the job family and level.
For all remote positions and those based in pay transparency locations, include this text in the External Description:
Salary and Other Compensation
The annual salary for this position is between $ 90K- 107K depending on experience and other qualifications of the successful candidate.
This position is also eligible for Cognizant’s discretionary annual incentive program, based on performance and subject to the terms of Cognizant’s applicable plans.
Benefits: Cognizant offers the following benefits for this position, subject to applicable eligibility requirements:
· Medical/Dental/Vision/Life Insurance
· Paid holidays plus Paid Time Off
· 401(k) plan and contributions
· Long-term/Short-term Disability
· Paid Parental Leave
· Employee Stock Purchase Plan
Disclaimer: The salary, other compensation, and benefits information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable law.
What we offer
- The chance to work with impact. Here, you’re empowered to bring your biggest thinking to help our company and clients improve everyday life.
- Ownership over your career. Stay at the top of your game through our award-winning learning and development ecosystem. And when your ambitions change or we offer new opportunities, we help you pivot by providing reskilling, on-the-job learning and guidance to find new roles that might be a better fit.
- The opportunity to thrive on a high caliber team with heart. We celebrate each other’s experiences and perspectives and promote a sense of belonging through our affinity groups and diversity and inclusion initiatives.
- A comprehensive total rewards package, including a competitive salary and a pension plan with matching contributions.
- Flexible health and financial benefits to support you and your eligible dependents—from day one.
- True work-life balance. Be at your best through paid time off, flexible work arrangements, volunteering opportunities, social events, and so much more.
About us
Cognizant (Nasdaq: CTSH) is an AI Builder and technology services provider, building the bridge between AI investment and enterprise value by building full-stack AI solutions for our clients. Our deep industry, process and engineering expertise enables us to build an organization’s unique context into technology systems that amplify human potential, realize tangible returns and keep global enterprises ahead in a fast-changing world. See how at www.cognizant.com or @cognizant.
Other employment-related information
Cognizant is an equal opportunity employer. Your application and candidacy will not be considered based on race, color, sex, religion, creed, sexual orientation, gender identity, national origin, disability, genetic information, pregnancy, veteran status or any other characteristic protected by federal, provincial or local laws.
If you have a disability that requires reasonable accommodation to search for a job opening or submit an application, please email [email protected] with your request and contact information.
Language requirements vary depending on roles, but we ask that all candidates have basic English proficiency for company-wide communications purposes. For roles based in Quebec, professional English proficiency is required, as you’ll deliver services to and collaborate with stakeholders outside the province who may not speak French.
