Senior Developer Business Intelligence

Atlantic Packaging Products; Toronto; Hybrid; CAD 80,000 - 120,000; Full time

Job summary

A leading company is seeking a Senior Developer to join its Technical Services Group. The successful candidate will leverage expertise in the Power platform to develop and manage BI tools, transforming raw data into insights and creating visually appealing dashboards. This role demands collaboration across teams, requiring a strong background in data visualization and analytics. Candidates should possess excellent knowledge of SQL, DAX, and data modeling techniques.

Qualifications

• 5 years experience using Power BI tools and BI systems.
• Expert level skills to use Power Automate and Power BI tools to build robust reporting.
• Experience in data governance and cloud platforms like Azure.

Responsibilities

• Developing and managing BI tools as well as transforming raw data into valuable insights.
• Design intuitive user interfaces for web applications.
• Analyze business requirements in context to business intelligence.

Skills

Power BI

Data Modeling

DAX

SQL

Data Analysis

Data Warehousing

Education

University Degree in Computer Science or Statistics

Tools

SQL Server

Power Automate

Azure

Job description

The Senior Developer plays a vital role in Atlantics Technical Services Group bringing expertise in the Power platform (Power BI Power Automate SharePoint etc. and its tools. The successful candidate will be tasked with developing and managing BI tools as well as transforming raw data into valuable insights presented through engaging dashboards and reports. This role will require frequent collaboration with the various teams across the company.

The incumbent will collaborate with various business users to comprehend their requirements develop a data warehouse and create reporting solutions tailored to their needs. The User needs to follow best practices in data visualization aligning with the norms set within the larger IT team.

This role will involve liaising with the Core analytics team to grasp the data warehouse structure and replicate the approach in building our own solution for the US incumbent needs Agility collaborative spirit and an ability to create structure from unstructured sources of information.

Location : Scarborough Ontario (hybrid 3 days in office)

RESPONSIBILITIES :

• Study analyze and understand business requirements in context to business intelligence and be able to convert requirements into technical specifications and decide the timeline to accomplish tasks.
• Design intuitive and visually appealing user interfaces for web and mobile applications right the first time.
• Design and map data models to shift raw data into meaningful insights.
• To design develop and deploy Power BI scripts and perform efficient detailed analysis.
• Utilize Power BI to build interactive and visually appealing dashboards and reports.
• To create charts and document data with algorithms parameters models and relations explanations
• Train new team members
• Demonstrated ability to prioritize tasks manage deadlines and work efficiently in a fastpaced environment while maintaining a high level of attention to detail and quality in deliverables.
• Represent US businesses need to ensure they are incorporated in overall data strategy.
• To identify KPIs with clear objectives and monitor them consistently.
• Analyze previous and present data through reports for better decision making.
• To conduct and maintain data warehouse development.
• Develop strong data documentation about algorithms parameters models and conduct knowledge sharing sessions as required within the Atlantics analytics team.
• Perform detailed analysis on tested and deployed Power BI scripts.
• Run DAX queries and functions in Power BI
• To perform SQL querying for best results
• To define and design new systems by analyzing current ETL processes.
• Make essential technical and strategic changes to improve present business intelligence systems and enhance their functioning.
• Identify the requirements and develop custom charts accordingly.

ROLE REQUIREMENTS :

University Degree in Computer Science or Statistics or related major.

5 years experience using Power BI tools and BI systems.

Expert level skills to use Power Automate and other Power BI tools to build robust reporting.

Skilled in building rich dashboards writing DAX expressions and implementing security.

Ability to analyze existing tools and databases and provide software solution recommendations.

Experience with big data architectures and data modeling to efficiently process large volumes of data.

Comprehensive knowledge of data platform architecture data modeling database optimization data management practices and processes.

Experience in data governance data governance tools ingestion and extraction frameworks data security etc.

Data warehousing experience with cloud platforms like Azure AWS

Expertise in building ELT and ETL data processing on SQL Server and Azure

Indepth knowledge of Microsoft Business Intelligence stack like Power Platform (BI Automate) SSRS SSIS and SSAS.

Well versed in programming languages like SAS R Python VBA and Excel.

Proficient in database management of SQL and NoSQL.

Ability to work with stakeholders and to assess potential risks.

Ability to communicate fluently in French would be an asset.

Frequent travel to various US operations may be required.

COMPETENCIES :

Customer Focus Personally demonstrates that external and internal customers are a high priority. Identifies customer needs and expectations and responds to them in a timely and effective manner. Anticipates and prevents delays or other things that can adversely affect the customer. Keeps customers informed about the status of pending actions and audits customer satisfaction with products or services.

Decision Quality Gathers enough information to allow a pragmatic assessment of risks and benefits of alternative approaches in any decision. Stays focused on objectives and considers both the shortterm and longerterm impact of decisions and keeps objectives in mind throughout the process. Communicates the impact and implications of decisions. Completes the appropriate level of due diligence required to make a quick accurate decision.

Drive for Results Achieves results within established timelines. Understands and demonstrates that intentions activities and results are not the same. Pursues everything with energy drive and a need to finish; does not give up before finishing even in the face of resistance or setbacks; consistently challenges self and others for results.

Leadership The expectation of leadership is not reserved solely for only those who are in positions of authority but from all employees. They demonstrate high integrity and are motivated by wanting to make a real difference to people by delivering a highquality service for their customer and the organization. In positions of authority they : invest in development for the right people and identify and develop future leaders and coach and provide candid feedback to others. They are visible and they model behaviors competencies and values expected and inspire others to undertake challenging tasks and projects.

Teamwork Is an effective team player who adds complementary skills and contributes valuable ideas opinions and feedback. Communicates in an open and candid manner and can be counted upon to fulfill any commitments made to others on the team. Ensures the right stakeholders are informed and involved where necessary. Is ready to roll up their sleeves as necessary.

Think and Act like an owner Thinks and cares about the organization like an owner. Commits to and upholds organizational values and core behaviors even under difficult circumstances. Demonstrates a strong sense of responsibility and dedication to the success of the organization. Takes appropriate risks holds self and others accountable for measurable highquality timely and costeffective results and openly raises a challenge even if others dont.

Required Experience :

Senior IC

Key Skills

Business Intelligence,Cognos,SQL,Power BI,QlikView,Microsoft SQL Server,ssrs,Tableau,SSIS,T Sql,Data Modeling,Data Warehouse

Employment Type : Full-Time

Experience : years

Vacancy : 1

Create a job alert for this search