Data Analytics Engineer

Bailey Abbott; Southwestern Ontario; On-site; CAD 80,000 - 100,000; Full time

Job summary

A dynamic IT consultancy in Ontario is looking for an Analytics Engineer to join their Data Intelligence capability. This role involves designing and maintaining interactive dashboards and reports using Power BI, optimizing data models, and ensuring data quality. Candidates should have advanced skills in Power BI, experience with ETL processes in Azure, and effective communication skills. The company offers a supportive environment with professional development opportunities and flexible working options.

Benefits

Paid Birthday Leave

Employee Assistance Program

Flexible Working Options

Professional development opportunities

Qualifications

• Hands-on experience with advanced Microsoft Power BI.
• Experience with ETL tools and data governance concepts.
• Effective communication skills in Agile settings.

Responsibilities

• Work with clients to understand requirements.
• Design, develop, and maintain dashboards and reports.
• Implement data quality assurance processes and validation.
• Assist in developing ETL pipelines in Azure environments.
• Contribute to the design of data models in Azure.

Skills

Advanced Microsoft Power BI

Data extraction, transformation and loading tools

Communication skills in Agile setting

Project delivery and client engagement

Cloud infrastructure concepts

Education

Certifications in Microsoft cloud and data tools

Tools

Microsoft Azure

Azure Data Factory

SQL

NoSQL databases

Job description

Our Company

We exist to bring amazing people together to explore the art of possible.

Bailey Abbott are a progressive and dynamic IT Consultancy business working across both Public and Private sectors. People are at the core of everything we do. We’re all about nurturing and inspiring people – ours and our clients. We bring a positive attitude and mindset to everything we do. We confidently use our knowledge and skills to solve problems, finding a better and easier way forward.

We deliver transformational outcomes to take businesses further, fearlessly. Confidence and trust is fundamental to delivering superior outcomes and we take ownership and responsibility for our commitments.

Our People

Our specialist IT Consultants are creative, collaborative, and passionate. We’re strong advocates for change, challenging the status quo through new thinking, technology, and practices. Always exploring creative ways to simplify complexity.

As a Consultant with Bailey Abbott, you will have the opportunity to build your project portfolio by gaining exposure and experience working across different clients, industries, technologies, and methodologies, all while having the stability and security of a permanent position.

Our Career Opportunity

Bailey Abbott now have an exciting opportunity for an Analytics engineer to join our Data Intelligence capability. Our Data specialists work within an active community of practice, enabling you to benefit from their years of collective experience and wisdom.

Working as an Analytics Engineer you will get the opportunity to:

• Work closely with the client to understand operational, user and technological requirements
• Design, develop and maintain interactive dashboards, reports, and visualisations using Power BI.
• Build and optimise semantic models and datasets to enable self-service analytics and consistent reporting across the organisation.
• Develop and maintain DAX measures, calculated columns and other business logic to support advanced analytics.
• Implement data validation and quality assurance processes to ensure accuracy and reliability of reporting outputs.
• Assist in developing and maintaining ETL (Extract, Transform, Load) pipelines to ingest, process, and transform data within Microsoft Azure-based environments, utilising tools such as Azure Data Factory
• Contribute to the design of data models and schemas in Azure to support data quality and reliability
• Apply working knowledge of SQL and NoSQL databases to support data storage and retrieval requirements

Your skills and experience includes:

• Hands-on experience working with Microsoft Power BI at an advanced level.
• Hands-on experience working with data extraction, transformation and loading tools.
• Familiarity with data governance concepts and best practices.
• Effective communication and collaboration skills in Agile team setting.
• Proven track record in project delivery and client engagement.
• Experience leading small teams or workstreams
• Familiarity with cloud infrastructure and architecture concepts
• Certifications in Microsoft cloud and data tools such as Azure, Fabric and Power BI

REWARDS

• Paid Birthday Leave
• Access to Employee Assistance Program
• Flexible Working Options
• Regular team gatherings including monthly team lunch
• Professional development opportunities and continuous learning
• Financial benefits through Discount Store

Our clients are diverse and so are we. We engage with great talent from all walks of life to bring their extensive and varied experience to help promote innovation. We encourage applications from candidates from all backgrounds to further strengthen Bailey Abbott.

Bailey Abbott. Explore Possible.