Senior data analyst leading race and social - identity data strategy for Ottawa Police Service. Producing equity analyses, dashboards, and insights to improve policing and community safety.
LP
Business Data Analyst (SQL/Data Reporting)
Posted via LinkedIn Recruiter (not a company profile)
Posted 7 months ago
About the role
- Business Data Analyst role supporting data analysis and reporting functions. Requires advanced SQL skills to extract data, ensure quality, and deliver reporting solutions for financial client.
Responsibilities
- This position involves supporting data analysis and reporting functions within a collaborative data analytics team to drive informed business decisions and develop robust data solutions. Responsibilities include mining and curating data based on diverse business requirements, developing and maintaining detailed data documentation, mappings, and transformation specifications, collaborating with development teams to design and implement data platforms and pipelines, creating, optimizing, and executing advanced SQL queries to extract relevant data sets from relational databases, conducting data profiling to ensure data quality, accuracy, and completeness, supporting testing efforts, tracking issues, and driving remediation for data-related projects, ensuring compliance with data handling standards, including sensitive data masking and data security protocols, anticipating business reporting needs by designing and delivering effective reporting solutions, partnering with cross-functional teams, including technical and non-technical stakeholders, to ensure high-quality data delivery, and maintaining knowledge repositories related to data processes and staying informed on evolving data management best practices.
Requirements
- Desired Skill-Set: Extensive experience querying relational databases with advanced SQL skills. Strong understanding of data mapping, transformation, and data profiling techniques. Ability to translate high-level business concepts into technical data requirements. Experience preparing comprehensive documentation for data platforms and workflows. Critical thinking, analytical curiosity, and problem-solving skills. Effective communication skills for working with diverse team members and stakeholders. Familiarity with data governance frameworks and data quality practices. Nice to Have: Experience with modern data platforms and ETL tools. Knowledge of business intelligence and reporting tools. Exposure to data governance frameworks and best practices.
Job title
Job type
Experience level
Salary
Degree requirement
No Education Requirement
Tech skills
Location requirements
Report this job
Found something wrong with the page? Please let us know by submitting a report below.
Analyste de données développant des tableaux de bord Power BI et des solutions BI pour Michelin, fabricant international de pneumatiques. Soutien à la gouvernance des données et à la performance des processus Design to Manufacturing.
Data Analyst developing Power BI dashboards and data governance solutions for Michelin’s Design - to - Manufacturing teams. Supporting data - driven decisions at the Magog research center.
Senior Manager leading Medline Canada’s Microsoft Fabric data platform and BI strategy. Delivering governed data products and analytics for healthcare operations.
Customer Data Analyst modernizing EDC’s customer data ecosystem at Canada’s export - finance Crown corporation. Building Microsoft Fabric pipelines, Power BI assets, and marketing analytics solutions.
Analyste des données clients chez EDC, société d’État aidant les entreprises canadiennes à réussir à l’étranger. Modernisation des pipelines, tableaux de bord et solutions analytiques marketing.
Senior Data Analyst building trusted financial metrics, dbt models, and Looker dashboards for Jane’s clinic - management SaaS platform. Partnering with Finance and Payments to guide critical decisions.
Digital media specialist improving campaign tracking, reporting and analytics at a Toronto marketing technology lab. Automating insights with AI while maintaining data quality and measurement accuracy.
Data Analytics Intern analyzing new features and updates for Montreal - based mobile gaming studio Ludia. Building data modules, dashboards, and insights to optimize game operations.
Senior Data Analyst transforming Sun Life insurance and financial - services data into actionable marketing insights. Building SQL, Python, AWS, Adobe Analytics, reporting, and dashboard solutions.