Note: The job is a remote job and is open to candidates in USA. Fractal is a strategic AI partner to Fortune 500 companies focused on improving enterprise decision-making through intelligence. The Senior Business Intelligence Analyst will support the migration of the Credit Risk Data Mart from on-premises SQL Server to Snowflake by coordinating discovery, documentation, testing, stakeholder engagement, and migration tracking across data, reporting, and downstream consumer systems.
Responsibilities
- Responsible for identifying opportunities for improving Data and Business Intelligence Solutions
- Data subject-matter expertise, or proven ability to identify and collaborate with the appropriate data SMEs. Works on complex projects/teams independently and acts as a mentor and lead to other Analysts
- Create user stories and write acceptance criteria
- Create and maintain inventories of database tables, views, attributes, stored procedures, code, SSIS packages, SSAS cubes, dimensions, measures, reports, reporting dependencies, and downstream consumer systems such as SAS, Moody’s, and internal applications
- Partner with business users to identify actively used data assets, reports, queries, and opportunities to 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 – Perform functional testing and data validation and liaison between business, developers, and other technical teams to coordinate UAT planning, execution, defect tracking, business signoff, report validation, migration readiness, and consumer system migration activities
- Track inventories, dependencies, risks, issues, decisions, and status throughout the migration lifecycle, including EDP (Enterprise Data Platform) adoption work to repoint CRDM-sourced EDW objects to corresponding EDP objects
- Establish processes and automation for the enterprise-grade Data & BI platform
- Ensure the Security, Governance, Enterprise Architecture guidance and protocols are adhered
- Communicate progress, risks, and issues to the project team
Skills
- 5+ years of experience in a related position working with dashboard development along with expertise in transforming the required data tables
- Strong BIA/BSA experience supporting data warehouse, analytics, or cloud migration initiatives
- Strong demonstrated experience acting as a business liaison and delivering both strategic and operational solutions to technical teams required
- Experience owning, supporting and delivering the full data life cycle development and its various phases required
- Advanced level knowledge of SQL and Data Modeling for SQL and NoSQL Repositories required
- Working knowledge of SQL Server, Snowflake, SSIS, Azure Data Factory, SSAS, and Power BI
- Experience with data mapping, lineage, requirements gathering, documentation, and UAT coordination required
- Advanced knowledge of multiple business intelligence and data discovery tool such as Tableau, Alteryx or Power BI required
- Understanding of Cloud Computing is required
- Understanding of data engineering vocabulary and data architecture and experience working with Azure, DataOps, JIRA or other Agile development team tools required
- Strong stakeholder engagement, organizational, and communication skills required
- Ability to plan, organize, schedule, and implement projects in accordance with established project management methodologies required
- Bachelor's degree in Computer Science, Math, IT, Business or equivalent work or educational experience required
- Advanced level knowledge of data manipulation languages and tools such as Python, Alteryx etc. preferred
Benefits
- Eligible to participate in health, dental, vision, life insurance, and disability plans, for full-time employees or hourly employees working more than 30 hours per week.
- Eligible for benefits on the first day of employment with the Company.
- Eligible to participate in the Company 401(k) Plan after 30 days of employment, in accordance with the applicable plan terms.
- 11 paid holidays.
- 12 weeks of Parental Leave.
- “Free time” PTO policy, allowing the flexibility to take the time needed for either sick time or vacation.
- Eligible for a discretionary bonus for the current performance period.
Company Overview