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.
コグニザントのコミュニティ：
私たちは、互いを尊重し支え合う優秀な人材の集まりです。社員一人ひとりが成長し、力を発揮できるよう、エネルギッシュで協力的かつインクルーシブな職場環境を大切にしています。
- コグニザントは、世界中に30万人以上のアソシエイトを擁するグローバルコミュニティです。
- 私たちは、より良い方法を夢見るだけでなく、それを実現します。
- 人、クライアント、企業、地域社会、そして環境に対して、常に「正しいこと」を行うことで責任を果たします。
- あなたにとって最適なキャリアパスを築くことができる、革新的な環境を提供します。
私たちについて：
コグニザント（NASDAQ: CTSH）は、AI builderおよびテクノロジーサービスプロバイダとして、AI投資を企業価値へとつなげるフルスタックのAIソリューションを提供しています。業界、業務プロセス、エンジニアリングに関する深い専門性を強みに、各企業固有のコンテキストをテクノロジーシステムに組み込み、人の力を最大限に引き出すとともに、具体的な成果の創出と、急速に変化する世界におけるグローバル企業の競争力維持を支援します。詳しくは、当社ウェブサイト www.cognizant.com をご覧ください。
コグニザントは機会均等を重視する雇用主です。応募者および候補者は、人種、肌の色、性別、宗教、信条、性的指向、性自認、国籍、障がい、遺伝情報、妊娠、退役軍人の地位、または連邦、州、地方の法律で保護されているその他の特性に基づいて差別されることはありません。
免責事項：
応募者は、対面またはビデオ会議による面接への参加を求められる場合があります。また、各面接の際に、現住所または政府発行の身分証明書の提示が必要となる場合があります。