xelys jobs xelys jobs

Senior Business Intelligence Analyst

Fractal

full-remoteseniorpermanentdataproduct-management United States 129 days ago via LinkedIn

See how well this job matches your profile

Sign up to get an AI match score and generate a tailored application in seconds.

Get your match score

Tags

Business IntelligenceSnowflakeSQL ServerSSISSSASData MigrationData ValidationUser StoriesUATAlteryx

About the role

Role Overview

The Senior Business Intelligence Analyst will support end-to-end activities across the CRDM (Credit Risk Data Mart) migration lifecycle, migrating from on-prem SQL Server to Snowflake. This is a lift-and-shift migration that bridges business stakeholders, analytics/data consumers, and technical delivery teams to ensure BI and data assets are correctly identified, validated, transitioned, and tracked.

Responsibilities

  • Identify opportunities to improve Data & Business Intelligence solutions.
  • Provide data subject-matter expertise and collaborate with the right data SMEs.
  • Lead complex work independently and mentor other analysts.
  • Create user stories and acceptance criteria.
  • Maintain inventories of data and BI assets, including:
    • Database tables, views, attributes, stored procedures
    • Code, SSIS packages, SSAS cubes
    • Dimensions/measures, reports, reporting dependencies
    • Downstream consumers (e.g., SAS, Moody’s, internal applications)
  • Partner with business users to identify actively used assets/reports/queries and retire unused assets.
  • Develop and maintain:
    • Data dictionaries
    • Source-to-Target mappings (STTM)
    • Data lineage and dependency documentation
  • Serve as a lead for Data Q&A:
    • Functional testing and data validation
    • Coordinate UAT planning/execution, defect tracking, business signoff, report validation
    • Support consumer system migration readiness
  • Track throughout the migration lifecycle: inventories, dependencies, risks, issues, decisions, and status.
  • Support EDP (Enterprise Data Platform) adoption by repointing CRDM-sourced EDW objects to EDP objects.
  • Establish processes and automation for the enterprise Data & BI platform.
  • Ensure guidance and protocols for security, governance, and enterprise architecture are followed.
  • Communicate progress, risks, and issues to the project team.

Deliverables / Outcomes

  • Functional requirement documents (BRD) including business requirements, dashboards/views, calculated measures, algorithmic inputs, SLAs.
  • Source-to-Target mapping documents.
  • Technical specifications documents (TSD) including architecture, data dictionary definitions, data model specifications, wireframes, and calculated-measure computations/formulae.
  • Test strategy, test plan, and test cases for data validation.
  • Data testing/validation scripts and Alteryx workflows.
  • Operational support documentation (e.g., runbooks with dev help) and release notes/documentation.
  • Documentation for change control and end-user adoption support.

Requirements / Qualifications

  • Experience across BI/data migration lifecycle activities, including ETL, semantic models, reporting, and downstream consumer migrations.
  • Ability to independently lead complex projects and mentor other analysts.
  • Proven ability to work with business and technical teams to validate data assets and coordinate UAT/signoff.

Nice to Have / Implied Domain Context

  • Familiarity with CRDM/credit risk data mart concepts and enterprise data platform repointing (EDP adoption).
  • Experience with enterprise-grade data governance, security, and architecture protocols.
  • Hands-on familiarity with legacy SQL Server BI components (SSIS/SSAS) and downstream tools (e.g., SAS, third-party reporting like Moody’s).

About Fractal

Fractal is a strategic AI partner to Fortune 500 companies, focused on powering decision-making across the enterprise. The company positions itself around intelligence applied to human imagination and has received recognition such as Great Place to Work and Gartner awards.

Scraped 7/17/2026