Data-Driven Business Systems Analyst: SQL & Analytics
Compunnel Inc.
The Business System Analyst (BSA) plays a key role in bridging business requirements and technical solutions within data-driven environments.
This position involves gathering and analyzing business needs, translating them into system and data requirements, and supporting data warehousing, modeling, and analytics initiatives through close collaboration with business and technical stakeholders.
Key Responsibilities
- Gather, analyze, and document business and system requirements, including preparation of SRS and data mapping documents.
- Collaborate with stakeholders to understand data needs and translate them into technical specifications.
- Perform data analysis using complex SQL queries, including window functions, to support reporting and analytical use cases.
- Support data profiling and data warehousing activities.
- Work with data engineering teams to validate data models and ensure accurate data flow.
- Participate in requirement validation, solution design discussions, and data verification activities.
- Communicate effectively with cross-functional teams to support project delivery.
- Strong proficiency in SQL, including advanced queries and window functions.
- Experience with data profiling and data warehousing concepts, including Slowly Changing Dimensions (SCD) and various data loading strategies.
- Hands-on experience with data modeling, including different schema types.
- Proven Business System Analyst skills, including requirement gathering, SRS creation, and data mapping.
- Working knowledge of Azure Databricks (ADB) and PySpark.
- Strong analytical, documentation, and communication skills.
- Experience working in large-scale data or analytics platforms.
- Prior exposure to cloud-based data environments.
Vacancy posted 5 hours ago
Similar jobs that could be interesting for youBased on the Data-Driven Business Systems Analyst: SQL & Analytics in Toronto, ON vacancy
$70 per hour
Our client is a major Asset Manager undergoing a project to improve middle office reporting. They are looking for an Business Systems Analyst / Data Analyst for an initial term of 2-3 months [until the end of 2026]. There is expectation of extensions as they work through...DataSqlContract workWork at office$80k - $130k per year
...Your future duties and responsibilities: Lead business systems analysis activities for enterprise Payments and data transformation initiatives within the Banking domain... ..., developers, and data engineers. 9. Strong analytical, problem solving, and stakeholder management skills...DataFull timeWork at office- ...organizations unlock the value of technology and build a more sustainable, more inclusive world. Job Description The Data Business Systems Analyst (Data BSA) will support the design, development, and delivery of data capabilities within the SYF and Zeta Marketing...DataSqlPermanent employmentFull timeFor contractorsManual laborLocal area
$86.1k - $136.1k per year
...technologies to provide customers and business partners with more secure,... ...working with legacy systems and motivated to find creative... ...highly motivated Business Systems Analyst, you will help guide updates... ...with strong technical, analytical, conceptual, diagnostic and problem...DataLong term contractTemporary workLocal areaFlexible hours$89.34k - $132.88k per year
...: Public Health, Operations & Business Services Work Location: 61... ...city. Reporting to the Senior Systems Integrator, Portfolio... ...Health, the Business Systems Analyst provides senior level business... ...and output levels, and conducts data flow analysis and business process...DataFull timeTemporary workFor contractorsInternshipMonday to fridayShift work$81.6k - $115.2k per year
...Sr. Business Systems Analyst Work Location: Toronto, Ontario, Canada Hours: 37.5 Line of Business: Technology Solutions Pay Details: $81,600 -... ...contracts, JSON/XML payloads, request and response structures, data mappings, business rules, error handling, and system...DataSqlFull timeWork from home$81.6k - $115.2k per year
...Ontario, Canada Hours: 37.5 Line of Business: Technology Solutions Pay Details:... .... Job Description: Sr.Business Systems Analyst - L09 Department Overview: Enterprise... ...Marketing solutions and deliver data-driven insights that fuel the growth of...DataWork from home$4108 - $5183 per month
...specifically targeting students who have a Computer Science or Business background. Candidates must be enrolled in a Canadian post-... ...applicable. This position reports to the Senior Business Systems Analyst within the Toronto SAP Marketing and Logistics team. The incumbent...Full timeTemporary workManual laborWork at officeRelocation$143.1k - $166.95k per year
...Together, let's build a brighter, healthier future for all. Sr. Business Analytics Manager Role Summary As a Business Analytics Manager on... ...as a key analytics translator and technical leader driving data-driven strategies across the Hill’s Canada sales, marketing, and...DataSqlWork at officeRelocation$84.56k per year
...scheduling, administration of tests and exams, enrolment data analysis and business intelligence. It is the vision of the Office of... ...: Working under the direction of Manager, Systems and Data Analytics, you will be responsible for creating and running queries...DataSqlFull timeWork at office$100k - $150k per year
...requirement is subject to change based on business needs. Your future duties and... ...Assess impacts across business processes, systems, data, operations, technology, and downstream... ...of experience as a Functional Business Analyst in financial services, banking, payments...DataFull timeWork at office2 days per week$105k - $155k per year
...for a global financial leader? CGI is seeking an elite Senior Business Systems Analyst- Payments Modernization to drive the future of our enterprise... ...needs to conduct comprehensive business analysis, prepare data mapping, analyze detailed functional requirements, and develop...DataSqlFull timeWork at office$70k - $120k per year
...week subject to change at any time. We are seeking a Technical Business Systems Analyst to join our Anti Money Laundering (AML) team. The ideal... ...background within the banking or financial services domain, strong data analytical skills, and experience supporting regulatory...DataSqlFull timeWork at office$81.6k - $115.2k per year
...Ontario, Canada Hours: 37.5 Line of Business: Technology Solutions Pay Details:... ...Job Description: Senior Business Systems Analyst Level 9 | Procurement, Contracting and... ...integrated solutions: Define end-to-end process, data and integration needs across RFx, CLM,...DataContract workWork at officeWork from home- ...Description Job Description Manager, Campaign Analytics - SQL, Pega/ TSYS CDH Location: Downtown,... ...: May be, based on performance and business needs Conversion to FTE: May be, based... ...with Campaign Design and Execution, Data Science, Marketing, Product, and channel...DataSqlContract workWork at office
FINTECH PROFESSIONALS CORP
Toronto, ON7 days ago - ...sustainable, more inclusive world. Role Summary: Seeking a Business Systems Analyst with strong experience in API-led integrations and... ...analyze, and document business and system requirements for API-driven solutions. Define API integration requirements, interface...DataSqlPermanent employmentFull timeLocal area
$81.6k - $115.2k per year
...Toronto, Ontario, Canada Hours: 37.5 Line of Business: Business Management, Strategy & Support... ...: Role Summary: Deliver business-led analytics, data science, and AI-powered solutions that... ...complex data from multiple sources using SQL, Python, Databricks, and related analytics...DataSqlLong term contractFull timeWork from home$72 - $82 per hour
...Technical Business Analyst – APIs & Systems Integration Turn complex ideas into solutions teams can build. Join the insurance sector for our client... ...interact end to end, including services, APIs, integrations, data handoffs, and related business processes. • Draft sequence...DataSqlHourly payContract work$81.6k - $115.2k per year
...Ontario, Canada Hours: 37.5 Line of Business: Technology Solutions Pay Details:... ...Job Description: The Senior Business Systems Analyst will plan, manage, and lead system requirements... ..., responses, payloads, validations, data mappings, integrations, and error scenarios...DataSqlFull timeWork from home$81.6k - $115.2k per year
...Ontario, Canada Hours: 37.5 Line of Business: Technology Solutions Pay Details:... ...We are looking for a Senior Business Systems Analyst to support the delivery and evolution of... ...will translate complex business, risk, data, and technology needs into clear solution...DataSqlInternshipWork from home$50k - $90k per year
...opportunity. It builds consumer and business confidence, empowers... ...Developer at the Business Technology Analyst level. The ideal candidate has... ..., databases, and enterprise systems. Write clean, testable, and... ...object-oriented programming, data structures, debugging, and software...DataSqlPermanent employmentInternshipFlexible hours- ...look for a better way forward. If you're driven to help reshape how banking works for Canadians and the businesses that power our economy, this could be your... ...in Canada. The Senior Financial Analyst will use his or her data analytics skill to maintain key financial...DataFull time
- ...the communities where we live and work. We have a variety of business units with exciting and meaningful work waiting for you,... ...our success story! Who we're looking for: The Digital Data Analytics Senior Analyst plays a key role in analyzing customer behaviour across...DataSqlFull timeContract workFlexible hoursShift work
- ...Business Data Analyst – NoSQL | Microsoft SQL Server | Data Analysis Job Description: Data Analyst w NOSQL~Microsoft SQL Server 2019 Experience Required: 8-10 Toronto, ON - Hybrid (4 Days WFO) Client is looking for someone who has 8+ years of experience in...DataSqlPermanent employment
$56k - $67k per year
...brands to create unified Go-to-Market® systems that connect strategy, AI, creativity,... ...For Marketbridge is seeking an Analyst, Marketing Analytics to support the reporting, measurement,... ...role for someone who enjoys working with data and wants to build practical experience...DataSqlLong term contractFull timeSummer workInternshipManual laborRemote workWorldwideFlexible hours$68k - $75k per year
...The Business Analyst, Real Estate and Construction Data is responsible for translating complex construction and financial forecasting data into clear, actionable... ...improvement of Lucernex and related business systems. This role bridges data, finance, operations, and technology...DataSqlTemporary work- ...where we live and work. We have a variety of business units with exciting and meaningful work... ...Who we're looking for: The Digital Data Analytics Manager will play a key role in driving data... ...& Querying Skills: Knowledge of SQL and Python, particularly for data manipulation...DataSqlFull timeContract workFlexible hoursShift work
- ...where we live and work. We have a variety of business units with exciting and meaningful work... ...opportunity exists to join as a Senior Data Analyst in the Wireless Service & Equipment Finance... ...reporting data layers using Databricks, SQL and Python, including data extraction,...DataSqlFull timeContract workShift work
- ...to facilitate the functions, business, and entities with their service... ...TREATS (TREAsury Trading System) BOS (Back Office System) on IBM... ...with the Team Lead/ Business Analyst/ Project Manager, assisting with... ...connectivity knowledge: DDM (Distributed Data Management), MQ (Message Queue...DataLong term contractLocal areaWorldwideFlexible hours
- ...We are seeking a highly accomplished Functional Systems Specialist/IT Business Analyst for an enterprise-level contract opportunity based in Toronto. In... ...Architect, advanced routing strategies, queue management, data integrations, and contact centre operational metrics who...DataContract work
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Data-Driven Business Systems Analyst: SQL & Analytics. Be the first to apply!
Related searches
- data analyst remote working Toronto, ON
- remote data analyst part time Toronto, ON
- data analyst part time Toronto, ON
- work from home data analyst Toronto, ON
- data analyst volunteer Toronto, ON
- clinical data analyst Toronto, ON
- data governance analyst Toronto, ON
- business data analyst Toronto, ON
- entry level data analyst no experience Toronto, ON
- senior data analyst Toronto, ON