Senior Business System Analyst, Data

Position Title: Senior Business Systems Analyst
Reports To: Senior Technology Manager, Data Delivery
Department: IT Data & Analytics
Term: Permanent Full-Time​


Work Arrangements: This is a hybrid role. You will work in our office in Waterloo, ON a minimum of two (2) assigned, consecutive days every other week, plus a fifth (5th) assigned day per month. You are welcome to work from the office more than the minimum requirement and there may be some roles that are required to work in our office more than the minimum requirement.


The Opportunity: Now is an exciting time to join Equitable! We are growing and looking to add a Senior Business Systems Analyst to our Technology team.

We are looking for an experienced and highly motivated Senior Business Systems Analyst to join Equitable's Technology team. This role will support our data warehouse vision by maintaining our on-prem warehouse solution and transitioning to our new Azure data hub platform. 

You will be responsible for analyzing business requirements, designing, and executing test plans, and reporting on test results. You will also work closely with developers, project managers, and stakeholders to ensure that the deliverables meet the business needs and quality standards.

As a mutual-owned company, our focus is completely on our clients. With today's clients, we know to be nimble and responsive to our clients' needs to help us reach our growth targets. Through our adoption of agile values and principles, we are on a journey to continue offering the best service in the industry, as recommended by advisors, and bring on new experiences to help improve the financial health and security of our clients. As a team we'll discover the right solutions and be on a constant journey of learning while bringing our skills, experience, and ideas together.

The Senior Business Systems Analyst will collaborate with the Architects, DevOps Leads and stakeholders to define target state data solutions. We are an organization that values diverse thinking, rewards both behaviors and delivery, and focuses on growth and continuous improvement. This role is a unique opportunity to join a team that is at the beginning of a multi-year growth plan whose work will have direct impact on company direction, our customers, and our industry.

The Senior Business Systems Analyst will be accountable for contributing to the data solution in our on-prem SQL Server world.  Working closely with current Data Delivery team members and business users to address all data and reporting needs for the entire organization.

To be successful in this role, you should have a bachelor’s degree in a related field, and at least three years of experience in business analysis and quality assurance testing using Microsoft technologies. You should also have strong analytical, problem-solving, and communication skills, and a good knowledge of software development methodologies and testing tools. You should be able to work independently and as part of a team and handle multiple tasks and deadlines.


What you will be doing:

• Ensure data quality, accuracy, and consistency across all data sources in the Microsoft SQL Server data space with an outlook to migrate to our Azure EQDataHub
• Analyze business needs and system requirements and translate that into business specification documents
• Evaluate and improve system performance and quality
• Lead and mentor junior business system analysts
• Learn and adapt to new technologies and trends
• Gather and document business requirements from clients and stakeholders
• Translate business requirements into functional and technical specifications
• Develop and maintain test cases, test scripts, and test data using Azure Test Plans
• Execute test cases, both manually and using automated tools such as Azure DevOps
• Identify, report, and track software defects and issues using Azure DevOps
• Perform regression, integration, performance, and user acceptance testing
• Collaborate with developers and project managers to resolve issues and ensure software quality
• Provide feedback and suggestions for software improvement and enhancement
• Prepare and present test reports and metrics to clients and stakeholders
• Stay updated with the latest Azure cloud technologies and best practices with the mindset of migrating on-prem data warehouse solutions to Azure

What you will bring:

• Bachelor’s degree in computer science, information systems, or a related field
• Three years of experience in business analysis and quality assurance testing using Microsoft technologies
• Experience with software development methodologies, such as Agile, Scrum, or Waterfall
• Experience in agile methodologies and DevOps tools.
• Experience with testing tools, such as Selenium, Jira, or TestRail
• Knowledge of SQL, HTML, XML, and other scripting languages
• Excellent ability to record data and plan in Excel/PowerPoint
• Excellent analytical, problem-solving, and communication (verbal and written) skills
• An eye and a passion for detail and accuracy
• Ability to work independently and as part of a team
• Ability to handle multiple tasks and deadlines

What’s in it for you:

• A healthy work-life balance with employee wellness top of mind 
• Annual bonus program, annual vacation allowance, and company-paid benefits program  
• An additional paid volunteer day each year so you can spend time giving back to the community 
• Immediate enrollment in the company’s pension program with employer matching 
• Employee resource groups that support an inclusive work environment 
• Tuition support and specialized program assistance  
• An onsite full-service cafeteria with a variety of daily options 
• Discounts on company products and services, and access to exclusive employee perks  
• Regular EQ Together events focused on company togetherness and collaboration

As part of the recruitment/offer process you will be required to:

• Provide two professional references (minimum one supervisor and above)
• Undergo a criminal background check