Business Intelligence and Data Analytics Developer

Olsen Consulting; Calgary; On-site; CAD 80,000 - 110,000; Full time

Job summary

A leading consulting firm in Calgary is seeking a skilled Business Intelligence and Data Analytics Developer. The role requires collaboration with cross-functional teams to drive innovative data solutions. Candidates should have over 5 years of experience with tools like Power BI, SQL, and Python. Benefits include remote flexibility, career growth opportunities, and a supportive work environment.

Benefits

Remote work flexibility

Comprehensive benefits package

Career growth opportunities

Paid sick/personal days

Overtime banking opportunity

Qualifications

• Minimum of 5 years' experience in data analytics and business intelligence.
• Proficient with data analytics tools like Power BI and SQL.
• Experience with ERP systems like SAP is a strong plus.

Responsibilities

• Collaborate to address client challenges with innovative solutions.
• Design and deploy analytics solutions using various tools.
• Conduct data analyses and forecasting to identify insights.

Skills

Data management techniques

SQL optimization

Communication abilities

Project management

Problem-solving skills

Tools

Power BI

SQL

Python

VBA

Excel

DAX

Power Query

HANA

SSMS

Job description

Overview

Business Intelligence and Data Analytics Developer

Olsen Consulting specializes in the implementation and optimization of enterprise resource management systems, particularly Vista ERP, for high-revenue construction companies across North America. As a trailblazer in the industry, our goal is to propel our clients toward digital transformation by automating and enhancing their business processes. We are committed to driving impactful changes through data analytics and technology, harnessing our collective expertise, innovation, and commitment to excellence. To further our mission, we are on the lookout for an exceptionally skilled Business Intelligence and Data Analytics Consultant to join our elite team of professionals.

Key Responsibilities

• Collaborate with cross-functional teams to analyze and address client challenges, and apply innovative solutions for business process improvements.
• Design, implement, and deploy analytics solutions leveraging tools and languages such as Power BI, SQL, VBA, Python, DAX, and Power Query.
• Conduct in-depth data analyses and forecasting to identify patterns, trends, and insights that inform decision-making at multiple levels.
• Develop interactive dashboards for a range of business functions, delivering actionable insights to key stakeholders.
• Lead efforts in problem-solving, investigation, and analyses, providing informed recommendations to clients.
• Create and maintain thorough, timely documentation related to software and analytics tasks.
• Deliver training on data interpretation and analytical techniques to internal and external stakeholders.

Qualifications and Experience

• A minimum of 5 years' experience in the realms of data analytics, automation, and business intelligence.
• Proficiency in a broad range of data analytics tools such as Excel, Python, Power BI, HANA, and SSMS.
• High level of competency in SQL, VBA, Power Query, DAX, Python
• Experience with ERP systems like SAP, Vista Viewpoint, and QAD is a strong plus.
• Strong attention to detail, exceptional problem-solving skills, and a proven track record in a consulting environment.
• Ability to demonstrate skills highly preferred.
• Eligible to work in Canada.

Skills

• Excellent verbal and written communication abilities.
• Mastery of data management techniques and SQL optimization.
• Proven leadership and project management skills.
• High level of integrity and ability to handle the confidentiality of sensitive information.
• Capability to manage multiple projects and deadlines across varied clients.

Benefits of Working at Olsen Consulting

• A team environment that thrives on intellectual curiosity, continuous learning, and high-performance
• Remote work flexibility to maintain work-life balance.
• Defined pathways for career growth and professional development.
• Comprehensive benefits package.
• Paid sick/personal days and competitive salaries.
• Open communication lines for transparent and constructive dialogue.
• A positive, encouraging work environment
• Opportunity for overtime banking to optimize your work hours.

Olsen Consulting is committed to recognizing the dignity and worth of every individual, offering equitable rights and opportunities to all our employees. We foster a culture of understanding and mutual respect.

If you are highly motivated, committed to continual learning, and excited to be a part of a growing firm, we invite you to submit your resume and cover letter. Please articulate why you are a remarkable candidate and what you are seeking from your next career move and employer.

We appreciate the interest of all applicants, but only those shortlisted will be contacted.