Business Intelligence Developer managing finance processes and data visualization at McCarthy Tétrault. Responsible for developing dashboards and automating reports across multiple platforms.
About the role
- Business Intelligence Analyst at Hamilton involved in designing and maintaining business intelligence solutions. Collaborating with data engineering to support strategic planning and performance monitoring.
Responsibilities
- Involved in designing, developing and maintaining business intelligence solutions (dashboards, reports)
- Gather business requirements from users
- Work closely with the Group technical data engineering team
- Translate business needs into technical specs
- Support building data warehouses
- Optimize queries, ensuring completeness of data
- Collaborate with analysts, data engineers, and stakeholders
- Develop, test, and document complex pipelines
- Design and implement database structures
- Develop, test, and deploy SQL queries and stored procedures
- Optimize and tune SQL queries for performance
- Use data models to represent business processes
- Ensure the security model based on privacy requirements
- Participate in reviews of work to ensure developments are standardised, reliable, and maintainable
- Run / participate in Business Intelligence monthly working group for data users
- Communicate well with stakeholders at all levels
- Efficiently manage workload priorities based on the needs of multiple business units
Requirements
- Experience in SQL, ADF and Azure Analysis Services
- Experience in using all Microsoft applications
- Familiarity with software management tools such as DevOps, Azure, and JIRA for project maintenance and user story documentation
- Experience with three or more of the following: data processing automation, data quality, data warehousing, data governance, business intelligence, data visualization, data privacy
- Experience of full cycle development, designing, coding, testing, and correcting complex SQL models and scripts
- Knowledge of data analysis, data modelling and quality assurance techniques
- Knowledge of version control systems (e.g., Git)
- Certifications in relevant database technologies (e.g., Microsoft Certified: Azure Database Administrator Associate)
- Previous experience of working in an insurance environment
- Strong Power BI experience to create custom dashboards and visualisations
- Strong experience with DAX to develop complex measures
- Strong experience working with Semantic models
- Excellent problem-solving and communication skills.
Benefits
- Health insurance
- Retirement plans
- Paid time off
- Flexible work arrangements
- Professional development
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
BI Analyst responsible for ETL development and management of dashboards in Power BI at Minsait, driving data insights across various sectors.
Business Intelligence Consultant utilizing market - leading technology to address client analysis and reporting needs. Developing solutions for big data, data flow, and advanced analytics models with AI expertise.
Data & BI Specialist transforming raw data into business insights for marketing and commercial areas. Collaborating on data analysis and automating processes in SQL and Google Sheets.
Data Analytics Engineer supporting development and maintenance of Exasol's data infrastructure and reporting solutions. Collaborating across teams to transform data into actionable insights.
Junior PowerBI Developer responsible for creating advanced data solutions. Joining SDG Group, a global leader in Data & Analytics consulting.
Power BI Consultant at a Canadian technology company delivering high - performance BI solutions. Engage stakeholders, design models, and collaborate with data engineering.
Power BI Engineer contributing to the development of reports and dashboards. Supporting testing activities for a global mining client with a focus on data science and AI.
Senior Business Intelligence Analyst supporting client insights and delivering high - impact analysis at Cox Automotive. Collaborating across teams to drive client success through actionable insights.
Senior BI Developer creating data - driven insights and services for sonnen's clean energy solutions. Collaborating with cross - functional teams to enhance product offerings through data visualization.