SR Business Intelligence Specialist with BI tools and data warehousing experience with a focus

3 days ago


Edmonton, Canada S I Systems Full time
SR Business Intelligence Specialist with BI tools and data warehousing experience with a focus on transforming data into meaningful insights for the business.

Our utilities client is seeking a SR Business Intelligence Specialist with BI tools and data warehousing experience with a focus on transforming data into meaningful insights for the business.

Overview:

The Business Intelligence Specialist will leverage data to provide actionable insights that drive strategic decisions and improve business outcomes. The role focuses on transforming data into meaningful insights through meticulous data management, statistical analysis, and data visualization for data-driven decision-making. This position combines business acumen with technical skills in BI tools and data warehousing. The Business Intelligence Specialist will be integral to a collaborative team, working closely with cross-functional teams, including front-end developers, designers, and other key members. Together, they will produce impactful solutions that align with client requirements. The role involves transforming raw data into compelling insights through intuitive and visually appealing reports and dashboards, requiring the team's collective effort.

Responsibilities:

  • Integrating data from multiple sources such as databases, spreadsheets, and cloud services into Power BI datasets and ensuring accurate, timely, and reliable data.
  • Data cleaning and preprocessing to remove inaccuracies, inconsistencies, and duplicates. Transforming raw data into a structured format suitable for analysis and appropriately handling missing data and outliers.
  • Collaborating with business stakeholders to gather, understand, and analyze business requirements to design data models and visualizations that meet stakeholders' needs.
  • Developing detailed reports and dashboards to present data insights, helping stakeholders understand the data and make informed decisions.
  • Analyzing data to identify trends, patterns, and insights using statistical methods and techniques.
  • Conducting statistical analyses to validate hypotheses, developing predictive models to forecast trends and outcomes using Python and R, and evaluating the performance and accuracy of statistical models.
  • Supporting business decision-making by communicating findings and insights effectively to technical and non-technical stakeholders. Providing data-driven recommendations to empower informed decisions.
  • Creating and optimizing data queries, transformations, and calculations using Power Query M and DAX (Data Analysis Expressions).
  • Documenting data sources, methodologies, and analysis processes, maintaining clear and comprehensive documentation for reproducibility and transparency.
  • Collaborating with data engineers to ensure data quality, integrity, and performance.
  • Implementing security measures to control access to sensitive data within Power BI reports and dashboards, reflecting our dedication to data security.
  • Monitoring and optimizing Power BI performance, troubleshooting issues, and implementing enhancements as needed.

Must Haves:

  • 8+ years as a Business Intelligence Specialist
  • Designing and managing business intelligence, analytics, and data visualization solutions in an Agile setting.
  • Python and SQL experience
  • Statistical methods and techniques for data analysis, including hypothesis testing, regression analysis, and machine learning algorithms.
  • Power BI Desktop for building reports, dashboards, and data models.

Nice to Have:

  • Certifications such as Microsoft Certified: Data Analyst Associate or Microsoft Certified: Power BI Developer Associate.
  • Microsoft PL-300 certification or equivalent.
  • Ability to work with large datasets and perform complex data analysis.
  • Data integration techniques and ETL (Extract, Transform, Load) processes.
  • Experience with other Microsoft Power Platform services.
  • Experience modeling AI and ML algorithms in R/Python and other technologies.
  • A bachelor's or master's degree in business, economics, statistics, computer science, mathematics, information systems, or a related field.
#J-18808-Ljbffr

  • Edmonton, Canada Workers' Compensation Board- Alberta Full time

    As an equal opportunity employer, we are looking to build a diverse workforce that reflects the diversity of our clients and the customers we serve. Learn more about working for WCB at Careers - WCB Alberta **Job Title**: Business Intelligence Analyst III **Job Type**: Permanent / Full time **Job Location**: Edmonton, Alberta BUSINESS INTELLIGENCE...


  • Edmonton, Canada WCB Alberta Full time

    Careers - WCB Alberta Job Title: Business Intelligence Analyst III **Job Type**: Temporary Long Term (Fixed Term) / Full time Job Location: Edmonton, Alberta BUSINESS INTELLIGENCE ANALYST III Data Warehouse / Business Intelligence Team Edmonton, Alberta Temporary Long Term Full-Time Position (1 year term) RESPONSIBILITIES: - Captures and translates...


  • Edmonton, Alberta, Canada Workers' Compensation Board- Alberta Full time

    As an equal opportunity employer, we are looking to build a diverse workforce that reflects the diversity of our clients and the customers we serve. Learn more about working for WCB at Careers - WCB AlbertaJob Title:Business Intelligence Analyst IIIJob Type:Permanent / Full timeJob Location:Edmonton, AlbertaBUSINESS INTELLIGENCE ANALYST IIIData Warehouse /...


  • Edmonton, Alberta, Canada Workers' Compensation Board- Alberta Full time

    As an equal opportunity employer, we are looking to build a diverse workforce that reflects the diversity of our clients and the customers we serve. Learn more about working for WCB at Careers - WCB AlbertaJob Title:Business Intelligence Analyst IIIJob Type:Permanent / Full timeJob Location:Edmonton, AlbertaBUSINESS INTELLIGENCE ANALYST IIIData Warehouse /...

  • BI Developer

    4 weeks ago


    Edmonton, Canada Intellex Systems Full time

    BI Developer Back to All Jobs Share This Job Posting TwitterFacebookGoogle+LinkedInEmail Our client requires a skilled and experienced BI Developer with experience deploying BI solutions using a variety of different software to join their team to work on one or more projects. Candidates should have advanced experience with different programming...


  • Edmonton, Canada Government of Alberta Full time

    **Job Information**: Job Requisition ID: 53664 Ministry: Seniors, Community and Social Services Location: Edmonton Full or Part-Time: Full Time Hours of Work: 36.25 hours per week Permanent/Temporary: Permanent Scope: Open Competition Closing Date: March 4,2024 Classification: Manager Zone 2 **Salary**: $3,147.32 to $4,235.37 bi-weekly ($82,145-...


  • Edmonton, Canada TF Energy Solutions Full time

    TF Energy Solutions is your trusted logistics company that services customers across Canada and the United States. We have established ourselves as the go-to company for trucking services thanks to our commitment to our clients, our goal of building long-term relationships, and our continued ability to deliver excellent results for our clients. Want to work...

  • Reporting and BI Lead

    2 weeks ago


    Edmonton, Canada EZOPS Full time

    **Join the future of oil & gas!** At EZ Ops, we're not just leading the oil & gas logistics industry - we're redefining it with our cutting-edge, AI-powered solutions. We are seeking a highly skilled, self-motivated **Reporting and BI Lead **to come be part of our innovative journey! As the Reporting and BI Lead, you will orchestrate the transformation of...


  • Edmonton, Canada Booster Juice Full time

    As Canada’s original juice and smoothie bar, Booster Juice remains committed to providing customers with choices they can feel good about. A leader of providing healthy alternatives in the quick-service food industry, we're consistently looking for new and innovative health products to add to our menu! Today, Booster Juice has expanded to over 400...

  • Comet Associate

    2 weeks ago


    Edmonton, Canada 1300-Applied Industrial Technology Full time

    **THE OPPORTUNITY**: Our Career Opportunity and Management Employment Training (COMET) is the exclusive award-winning, fast track training program of Applied Industrial Technologies for May/June 2024 Graduates and Alumni. In this full-time, permanent opportunity, you will learn about the business from the ground up and be part of an organization with a...


  • Edmonton, Canada David Aplin Group Full time

    Are you seeking a career opportunity within a rapidly expanding organization? Our client is a dynamic retail organization that is privately owned and headquartered in Edmonton with top-line sales revenue in the billions primed for substantial growth in the coming years. Over the past couple of years, our client has undergone remarkable expansion, nearly...


  • Edmonton, Canada David Aplin Group Full time

    Are you seeking a career opportunity within a rapidly expanding organization? Our client is a dynamic retail organization that is privately owned and headquartered in Edmonton with top-line sales revenue in the billions primed for substantial growth in the coming years. Over the past couple of years, our client has undergone remarkable expansion, nearly...


  • Edmonton, Alberta, Canada David Aplin Recruiting Full time

    To Apply for this Job Click HereAre you seeking a career opportunity within a rapidly expanding organization? Our client is a dynamic retail organization that is privately owned and headquartered in Edmonton with top-line sales revenue in the billions primed for substantial growth in the coming years. Over the past couple of years, our client has undergone...


  • Edmonton, Alberta, Canada David Aplin Recruiting Full time

    Are you seeking a career opportunity within a rapidly expanding organization? Our client is a dynamic retail organization that is privately owned and headquartered in Edmonton with top-line sales revenue in the billions primed for substantial growth in the coming years. Over the past couple of years, our client has undergone remarkable expansion, nearly...


  • Edmonton, Canada David Aplin Recruiting Full time

    To Apply for this Job Click Here Are you seeking a career opportunity within a rapidly expanding organization? Our client is a dynamic retail organization that is privately owned and headquartered in Edmonton with top-line sales revenue in the billions primed for substantial growth in the coming years. Over the past couple of years, our client has undergone...


  • Edmonton, Canada David Aplin Recruiting Full time

    To Apply for this Job Click Here Are you seeking a career opportunity within a rapidly expanding organization? Our client is a dynamic retail organization that is privately owned and headquartered in Edmonton with top-line sales revenue in the billions primed for substantial growth in the coming years. Over the past couple of years, our client has undergone...


  • Edmonton, Canada David Aplin Group Full time

    Are you seeking a career opportunity within a rapidly expanding organization? Our client is a dynamic retail organization that is privately owned and headquartered in Edmonton with top-line sales revenue in the billions primed for substantial growth in the coming years. Over the past couple of years, our client has undergone remarkable expansion, nearly...


  • Edmonton, Canada David Aplin Group Full time

    Are you seeking a career opportunity within a rapidly expanding organization? Our client is a dynamic retail organization that is privately owned and headquartered in Edmonton with top-line sales revenue in the billions primed for substantial growth in the coming years. Over the past couple of years, our client has undergone remarkable expansion, nearly...

  • Power BI Admin

    4 weeks ago


    Edmonton, Canada Finning International Inc. Full time

    Company: Finning International Inc. Number of Openings: 1 Worker Type: Permanent Position Overview: Reporting to the Data Lead, the Power BI Admin would conduct analysis of business and user needs to determine business and technology requirements and identify Business intelligence, Data Analytics, and Data Warehousing solutions to support business...


  • Edmonton, Canada OpenCircle Association Full time

    What will you do? Job Responsibilities - Collaborate closely with various departments within the organization to work together to understand business requirements, gather data, analyze insights, and provide actionable recommendations to support decision-making. - Communicate findings, present insights, and provide regular updates on key performance...