Business Intelligence Developer

Job details

Here’s how the job details align with your profile.

Pay

$95,000–$125,000 a year

Job type

Full-time

Shift and schedule

Overtime

Day shift

Monday to Friday

Location

Total Power Ltd in Ottawa, ON

Benefits

• Company events
• Dental care
• Disability insurance
• Employee assistance program
• Life insurance
• On-site parking

Full job description

Summary
The Business Intelligence (BI) Developer is responsible for the delivery of reporting and dashboard solutions across the enterprise. You will gather requirements and expected outcomes from stakeholders, create design documents, design, build, and deploy reports and dashboards to meet defined requirements. You will also assist with ensuring accuracy of source data, enabling one source of truth across the enterprise.

What You’ll Do – The Role (Responsibilities)

• Create dynamic, visually appealing dashboards in Power BI that are accessible and easy to interpret.
• Work with data from various sources, including Azure Data Warehouse and associated technologies, SQL Server, and Excel.
• Gather business requirements and success metrics from stakeholders.
• Create accurate data models that transform raw data into insightful information by importing, cleansing, and converting data.
• Define relationships between tables and implement calculations and measures.
• Establish role-based access to reports through row-level security and Power BI application security layers.
• Assist the data management team with ETL processes.
• Work with data acquired via M&A activities, cleansing and converting for use in TPGS Power BI reports.
• Create non-BI reports including SSRS or Excel reports, if required.
• Collaborate with the FP&A team on reports containing financial metrics.
• Write and maintain cohesive documentation including a report library, purpose, and definitions.

What You Need (Requirements)

• Bachelor’s degree in a related field, or a combination of skills, certifications, and experience.
• Minimum 3 years’ BI development experience within a midsized organization.
• Prior experience working within a small data team with multiple areas of responsibility is mandatory for this position.
• Experience with the Microsoft BI stack including Power BI, Azure Data Factory, SQL, SSIS and SSRS.
• Demonstrable working knowledge building semantic models, measures, and calculations in Power BI.
• Experience with programming languages to analyze and interpret data, such as SQL, R, and Python.
• Prior experience with TimeXtender is considered a definite asset.
• Knowledge of data warehousing and ETL concepts.
• Knowledge of executing DAX queries on Power BI Desktop.
• Present a professional image to the Company’s customers and suppliers maintaining the highest ethical standard of conduct.
• Follow all Company Health and Safety Policies and Guidelines and Privacy Policies.
• In the case of a power outage or declared State of Emergency by any level of Government in Ontario, be available for work.

Working Conditions

• Travel may be required.
• Ability to attend and conduct presentations and training.
• Manual dexterity is required to use desktop computers and peripherals.
• Overtime as required.
• Lifting or moving up to 30lbs may be required.

SOUNDS LIKE YOU? APPLY NOW

A little bit about Us…

Proudly Canadian and respected throughout the industry, we have built our success through expertise, integrity, and innovation in providing on-site power generating solutions nationwide. For more than 60 years, our unparalleled reputation for delivering the right generator solution and superior customer service has been built by our loyal Customers. Visit us at www.totalpower.ca to learn more about us.

Our growth & Culture: As Canada's 1st Choice for PowerGen, we’ve been growing quickly and aim to keep doing so – if you want to be part of our success story, join our family, and grow with us! Our employees are our biggest asset; their engagement and passion are the key to our success. We EMPOWER them to be ENGAGED!

Selected candidates with disabilities who require support in the selection process will be accommodated to the best of our ability. Please let us know how we can help.

Only those selected for an interview will be contacted.