BI Developer

4 weeks ago

Barrie, Ontario, Canada Napoleon Full time
Napoleon leads the way with innovative engineering, advanced manufacturing techniques, unsurpassed customer service and remarkable product quality. Our award-winning products offer a best-in-class experience for all customers' home comfort needs. While we are proudly Canadian, Napoleon is also fortunate to operate on a world-side scale.

The warmth and experience that a Napoleon product brings to the homes of our customers transcends borders, language, and cultures to enhance everyday living across the globe.

Throughout North America, Europe, South America and Asia, Napoleon crates memorable moments through our stunning designs and innovative technologies.

Title:
Business Intelligence Developer - 12 month contract Reports to: Director BI and

Data Integrity Job Purpose:
The Business Intelligence (BI) Developer (BI Dev) manages in-house BI software and systems to ensure high levels of availability and security of the supported business applications

Key Responsibilities and Accountabilities:

  • Planning, designing, developing, implementing, report development, configuring, maintaining, supporting, and optimizing all BI software and systems.
  • Analyze and resolve end user problems related to databases and data warehouses, and reports in a timely and accurate fashion, and provide end user training where required.
  • Responsible for the technical implementation of current and future data lakes, data warehouse, business intelligence solutions and data migration strategies.
  • Collaborate with BI group and department leads in delivering a working DataMart to meet business requirements.
  • Oversees the data warehouse architecture resulting in the delivery of an efficient BI platform.
  • Driven from business requirements, architects, implements, and builds solutions to assist in the generation of standard or custom reports summarizing business KPI and financials for review by executives, managers, and other stakeholders.
  • Leads the BI group in the creation and maintenance of business intelligence tools, databases, dashboards, systems (on-premise and cloud), cubes (OLAP) and DevOps. Rationalizes new data requirements to avoid data/reports duplication.
  • Provide technical documentation and technical support for existing reports, dashboards, or other tools. Maintain a library of model documents, templates, or other reusable knowledge assets. Creates or reviews technical design documentation to ensure the accurate development of reporting solutions.
  • Provide input into the development of system testing strategies and plans. Validate that developed solutions align with defined business requirements
  • Contribute to the strategic direction of the BI platform, the creation of the BI roadmap, the selection of new tools, and the overall integrity of information delivery. Expand knowledge of broader range of Business Intelligence products and tools.

Education and Experience:

  • Preference given to those with a Bachelor's degree in computer science, mathematics, finance, statistics, or related field with equivalent experience. MBA is considered an asset.
  • Minimum 4+ years architecting, implementing, and developing a total business metrics, analytics, and intelligence platform.
  • Experience interacting directly with customers to elicit, document, and implement solutions.
  • Experienced in full business analysis value lifecycle including – planning, analysis, design, implementation, and improvement, following the Agile methodology.
  • Prior experience publishing reports (SSRS, PowerBI, PowerPivot, and/or SharePoint).
  • Experience working in a manufacturing/distribution organization consider an asset.
  • Microsoft Certified Solutions Expert (MCSE), DM&A, DP, BI considered an asset.
  • Microsoft Azure Data Engineering (DP-203) or equivalent considered and asset.
  • Project Management Professional Certification is considered an asset.
  • Certified Business Intelligence Professional (CBIP) designation is considered an asset
  • Knowledge of one or more Data Warehouse design methodologies and implementation (Inmon CIF, Kimball Dimensional, Data Vault 2.0) with preference to Kimball or Data Vault 2.0.
  • Advanced Microsoft SQL server knowledge with server administration (DBA) experience.
  • Advanced SQL language skills (SQL, MDX, DAX, DDL, DML, DQL, DCL, ADX, and/or XML).
  • Has delivered analytics and insight by creating standard and custom cubes/reports using the Microsoft Business Intelligence development stack (SSIS, SSAS, SSRS).
  • Advanced knowledge of Online Analytical Processing, Online Transaction Processing, Extract - Transform Load operations and Data Warehousing.
  • Prior Experience with Microsoft Azure Data Engineering Platforms (Azure SQL, Azure Manage SQL, Azure Data Lake, Azure Synapse Analytics, and/or Azure Databricks).
  • Demonstrated understanding of all key components required to deliver a Business Intelligence solution and their relationship, including data warehousing, data governance, and data modelling.
  • Prior experience with report writing tools (Excel Power Pivot, Excel Power Query, Power BI and/or Reporting Services) considered an asset.
  • Prior experience working with Dynamics 365 Finance and Supply Chain data considered and asset.
  • Knowledge and/or prior experience working with Power Shell, Bash or Azure CLI considered an asset.
  • Intermediate Excel/Access skills, including VBA scripting considered an asset. Intermediate PowerPoint, Word, Visio skills considered an asset.
  • Programming languages such as C#, C++, C, VB, AngularJS, JS will be considered an asset.
  • Oracle experience considered an asset.
  • Proficient with the design of database architectures, data warehouses, data migrations, data marts, decision support systems, business intelligence packages, and implementing user reporting solutions based upon business requirement and content knowledge.
  • Must have management skills to drive projects to completion on schedule with team members and mid-level business professionals.
  • Strong understanding database methodology, data analysis, advanced SQL queries, ETL and business intelligence application required.
  • Manages competing priorities in an effective and positive manner. The Napoleon Group of Companies is committed to fair and accessible employment practices that attract and retain Associates with disabilities. This includes providing accessibility across all stages of the employment cycle. Accommodation is available upon request. We thank you for your interest in The Napoleon Group of Companies and for participating in our competition. Only those candidates selected for consideration will be contacted.

  • Business Intelligence Analyst

    1 week ago

    Barrie, Ontario, Canada SE Health Full time

    We are looking for a _Business Intelligence Analyst_ to join a team of passionate and driven individuals who help equip business with insights and data to make a difference in the community.Position SummaryThis role is classified as hybrid where you would be primarily working remote, but may be asked to come into our head office in Markham as...

  • Business Intelligence Analyst

    1 week ago

    Barrie, Ontario, Canada Home and Community Care Support Services Full time

    Job Description: This position is responsible for collecting, consolidating and analyzing data queried from large data sets and multiple data sources. The Business Intelligence (BI) Analyst will develop, disseminate and present information requiring low to moderate complexity analysis to support operational, management and strategic decision making for...

  • Child Care Provider

    1 month ago

    Barrie, Ontario, Canada CanadianNanny Full time

    Located in Barrie, Ontario, seeking a reliable caregiver to look after our infant and primary school-aged children during the summer months. This will be bi-weekly Saturday. The job is live-out and offers competitive compensation at $200 flat rate. As a member of our household, you will primarily be responsible for engaging our children in fun and...

  • Child Care Provider

    4 weeks ago

    Barrie, Ontario, Canada CanadianNanny Full time

    Located in Barrie, Ontario, seeking a reliable caregiver to look after our infant and primary school-aged children during the summer months. This will be bi-weekly Saturday. The job is live-out and offers competitive compensation at $200 flat rate. As a member of our household, you will primarily be responsible for engaging our children in fun and...

  • Program Financial Consultant

    1 week ago

    Barrie, Ontario, Canada Royal Victoria Regional Health Centre Full time

    Job Description:As a key member of the Financial Planning and Analysis team, the Program Financial Consultant provides in-depth financial analysis, planning, and consultation for various hospital programs. This role acts as a bridge, seamlessly integrating financial and statistical data, ensuring optimal resource allocation and effective decision-making...

  • Programs Process Specialist

    1 week ago

    Barrie, Ontario, Canada Hydro One Networks Inc Full time

    47186 - Barrie - Rotation - Upto 18 MonthsHydro One is proud to be the largest electricity transmission and distribution provider in Ontario, serving nearly 1.4 million customers. We have a long history in the industry with our roots dating back over 110 years to 1906. Since then, we have worked to grow and evolve to meet the changing needs of our customers...

  • Payroll Specialist and Entry Level Bookkeeper

    1 week ago

    Barrie, Ontario, Canada Solutions Plus] Full time

    Job Description:Job Description Data Analyst/Payroll Specialist SUMMARY We are seeking a detail oriented and highly organized Data Analyst/Payroll Specialist to join our team. The ideal candidate will be responsible for accurately inputting client income/expenses and payroll data This role requires exceptional attention to detail, strong computer skills and...

  • Dishwasher

    1 week ago

    Barrie, Ontario, Canada Beertown Public House Barrie Full time

    JOIN THE MOST INSANELY GREAT CULINARY TEAM IN BARRIENow seeking keen individuals to join our stellar culinary team as Dishwashers.Dishwasher Qualifications: You are a positive, funloving person with a growth mindset You are able to work days, nights, weekends & holidays (parttime) You have strong organization & time management skills You are keen to learn &...

  • Music with Children

    1 week ago

    Barrie, Ontario, Canada Collier Street United Church Full time

    Music With ChildrenCollier United Church is a Christian community that values connection, creativity, inclusion, love, diversity, transformation, and hope. Our downtown Church in Barrie, Ontario, seeks a Music With Children Animator to work in a team supporting the development of music with children in the community.We desire that the person has:Knowledge of...

  • Registered Nurse

    4 weeks ago

    Barrie, Ontario, Canada Home Care Assistance of Barrie, Ontario Full time

    Are you looking for a career helping others? Looking for a company that values passion and rewards its employees with great benefits? Your search is over – an RN with Home Care Assistance is the job for youWe are seeking an RN to work in an LTC home in Barrie. Must be available for bi-weekly weekend night shifts. There is possibility of picking up extra...

  • Registered Practical Nurse

    4 weeks ago

    Barrie, Ontario, Canada Home Care Assistance of Barrie, Ontario Full time

    Are you looking for a career helping others? Looking for a company that values passion and rewards its employees with great benefits? Your search is over – an RPN with Home Care Assistance is the job for youWe are seeking an RPN to work in a LTC facility in Barrie. Must be available for bi-weekly weekend night shifts, 10pm-6am. Possibility to pick up extra...

  • Registered Nurse

    4 weeks ago

    Barrie, Ontario, Canada Home Care Assistance of Barrie, Ontario Full time

    Are you looking for a career helping others? Looking for a company that values passion and rewards its employees with great benefits? Your search is over – an RN with Home Care Assistance is the job for youWe are seeking an RN to work in an LTC home in Barrie. Must be available for bi-weekly weekend night shifts. There is possibility of picking up extra...

  • Registered Practical Nurse

    2 months ago

    Barrie, Ontario, Canada Home Care Assistance of Barrie, Ontario Full time

    Are you looking for a career helping others? Looking for a company that values passion and rewards its employees with great benefits? Your search is over – an RPN with Home Care Assistance is the job for youWe are seeking an RPN to work in a LTC facility in Barrie. Must be available for bi-weekly weekend night shifts, 10pm-6am. Possibility to pick up extra...

  • New Positions Available Continental Night Shift Machine Operators Needed

    1 month ago

    Barrie, Ontario, Canada Canplas Industries Ltd. Full time

    Are you an individual who loves to be a part of a productive team? Have you been looking for a career at a company that encourages growth and developing their employees? If the answer is yes to these questions then you are the person we are looking for.Don't let this exciting entry level opportunity as Machine Operator get away from you, apply today This...

  • New Positions Available Continental Night Shift Machine Operators Needed

    4 weeks ago

    Barrie, Ontario, Canada Canplas Industries Ltd. Full time

    Are you an individual who loves to be a part of a productive team? Have you been looking for a career at a company that encourages growth and developing their employees? If the answer is yes to these questions then you are the person we are looking for.Don't let this exciting entry level opportunity as Machine Operator get away from you, apply today This...

  • senior financial analyst and reporting officer

    1 week ago

    Barrie, Ontario, Canada Georgian College Full time

    Job Description - Senior Financial Analyst and Reporting Officer Senior Financial Analyst and Reporting Officer ( Job Number: Department: AccountingCampus: BarrieClassification: Support StaffPosting Date: May 2, 2024 Salary Range: $41.12 (start rate) - $ year rate)Hours Per Week: 40 hours per weekStatus: Full TimeReporting to the Controller, the...

  • Manager of Financial Systems Support and Integration

    1 week ago

    Barrie, Ontario, Canada City of Barrie Full time

    Posted:Tuesday, November 21, 2023Job Number:***PN-23-21Job Type:***Permanent Full-time, Non-UnionPosition Closing Date:Tuesday, December 12, 2023 at 11:59pmChoose BarrieThe City of Barrie is a vibrant, progressive, and growing community with deep connections to our heritage, to nature and to the opportunities surrounding us.Our community values quality of...

  • Activity Aide, Adult Day Program

    4 weeks ago

    Barrie, Ontario, Canada VON Canada Full time

    This position is funded by the Canada Summer Jobs Program. To be eligible to participate in the Canada Summer Jobs program, applicants must;Be between 15 and 30 years of age at the beginning of the employment period*; Be a Canadian citizen, permanent resident, or person to whom refugee protection has been conferred under the Immigration and Refugee...

  • Activity Aide, Adult Day Program

    2 months ago

    Barrie, Ontario, Canada VON Canada Full time

    This position is funded by the Canada Summer Jobs Program. To be eligible to participate in the Canada Summer Jobs program, applicants must;Be between 15 and 30 years of age at the beginning of the employment period*; Be a Canadian citizen, permanent resident, or person to whom refugee protection has been conferred under the Immigration and Refugee...

  • Gay Men's Sexual Health Coordinator

    1 month ago

    Barrie, Ontario, Canada Gilbert Centre Full time

    Salary: $43,000 annualThe Gay Men's Sexual Health Coordinator, reporting to the direct supervisor of the Sexual Healthdepartment, will play a pivotal role in fostering synergy between our Sexual Health program and our2S-LGBTQ+ initiatives. Primary responsibilities will include disseminating vital information, conducting workshops, and offering subject matter...