Senior ETL & Business Intelligence Developer (Toronto)

123Dentist is Canada's oldest and largest dentist-owned network of dental practices with more than 400 locations nationwide and more than 8,000 employees and growing. We provide Canadian dentists and dental practices with an array of non-clinical support and resources, including accounting, HR, marketing, as well as supply & equipment procurement.

By leveraging our unmatched management experience, marketing expertise and state-of-the-art technologies, we allow dentists to take advantage of a practical and effective alternative to practice ownership and focus on what they're best at - being a dentist!

As we continue to grow, we are seeking a Senior ETL & Business Intelligence Developer to join our team. This role is based at Downtown Toronto Head Office (on-site position).

Job Overview:

Reporting to the Director, Business Intelligence, the Senior ETL and Business Intelligence Developer will be a key player on the Business Intelligence team, contributing to the overall success of 123Dentist Operations and Finance. This opportunity will be a perfect fit for an individual with an analytical mindset, a willingness to explore metrics in creative ways, and a keen interest in delivering information in an organized and meaningful way.

Responsibilities and Duties:

• Conceptualize, design, and implement MS Power BI solutions from the existing data warehouse, and other enterprise data sources.
• Designs databases using star, snowflake, normalization techniques required for data modelling.
• Utilize Power BI to build interactive and visually appealing reports and dashboards for deployment in Windows/ Web-based environments in accordance with predefined detailed report specifications.
• Conduct unit & integration tests, assisting in test preparations to ensure data integrity, data quality, and program functional completeness & correctness.
• Designs Power BI analytics solutions using best in class standards taking into account sensitivity of data the need to have necessary security models in place for data segregation.
• Develop ETL process using MS Azure Data Factory, SQL Stored Procedure, Runbook, Logic App, Python to ingest, transform, cleanse and load data into Azure SQL Database.
• Investigate data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutions.
• Collaborate with data analysts and different business stakeholders to design optimal logical and physical data model for fast querying of large volume of data.
• Perform a variety of quality control functions that support data quality in reconciliation processes, test for compliance with department standards, and identify potential risks.

Education, Credentials, Qualifications:

• Bachelor's degree in Computer Science, Computing and Financial Management, Statistics and Actuarial Science, or formal education.
• Minimum 8 years of overall work experience
• 6-8 years experience in ETL, Power BI, or Data Warehouse.
• Certified Microsoft Power BI Data Analyst or Certified Data Engineering on Microsoft Azure would be an asset.

Required Skills & Abilities:

• Profound expertise in analyzing financial statements within the modern BI environment, with a specific emphasis on understanding Balance Sheets, Profit & Loss Statements, Cash Flow, and various other financial statements.
• Ability to independently analyze extensive data, identify discrepancies and inconsistencies and recommend a course of corrective action.
• Ability to create reports with large data sets and visualization tables for Business Intelligence needs.
• Practical knowledge in DAX, Power Query, MS Power BI service architecture design and administration, defining roles and security.
• Proven working experience with SQL Server, Oracle, Azure SQL Databases, API.
• General knowledge in Data warehousing, including data source analysis and profiling, as well as Relational DBMS.
• Expert proficiency with data manipulation languages (T-SQL, PL/SQL), data definition languages, physical database design, data modeling, query performance analysis & tuning.
• Experience with at least one programming language (Python, Java, C#, etc.)
• Experience with Azure Data Factory (ADF), Logic App, and Runbook.
• Familiarity with Azure cloud platform and PowerShell
• Advanced knowledge in MS Office
• Excellent problem-solving and analytical skills
• Strong communication and teamwork skills Excellent interpersonal and communication skills for interacting with various levels of stakeholders.
• Ability to manage multiple projects and adapt to changing priorities.
• Good organizational and time management skills.

Working Conditions:

• Dynamic work environment and an excellent corporate culture.
• Ability to adapt to a changing and growing business environment.

We are an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.

We thank all candidates for their interest; however, only those selected for an interview will be contacted.