Senior Business Analyst – Data Warehousing & BI

Senior Business Analyst

Responsibilities

• Collaborate with stakeholders to understand business needs and develop functional requirements
• Assess system changes required for new projects and enhancements to existing applications
• Produce detailed functional analysis and specification documentation
• Specify and design impactful business intelligence and data warehousing solutions from scratch
• Define data transformations and workflows to meet specified business requirements
• Design and outline reports or visualizations tailored to business objectives
• Identify and propose improvements for enhanced solution quality and delivery performance
• Validate implemented solutions to ensure alignment with business needs and expectations
• Conduct data quality and validation checks for consistent, high-quality data
• Serve as the liaison between technical teams and business users, ensuring alignment in goals and progress
• Collaborate with cross-location teams to maintain synchronized and effective delivery efforts
• Actively participate in BI/DW-related forums and discussions to uphold organizational best practices
  

Requirements

• 6-10 years of experience, with 5+ years in Data Warehousing and BI
• Strong foundation in Data Warehousing and BI principles, with knowledge of data governance and management
• Experience with SQL and competency in writing and analyzing complex queries
• Proficiency in Postgres DB
• Background in asset finance, equipment finance, or leasing within the finance or banking industry
• Understanding of Agile Scrum practices including story slicing, grooming, iteration planning, and retrospectives
• Skills in developing BI solutions and pitching proposals or solutions to stakeholders
• Strong written and verbal communication, with the ability to interact with diverse stakeholders
• Capability to identify and escalate risks and factual alerts when necessary
• Flexibility to work with distributed teams and maintain consistent delivery standards
  

Nice to have

• Familiarity with ETL tools such as DataStage, Informatica, MS SSIS, or Talend
• Skills in reporting tools such as Power BI, Tableau, or SAP BO
• Understanding of Shell scripting and scheduling tools