Senior Business Intelligence Analyst
Fractal
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 scoreTags
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