About EMCO: 

Emco is one of Canada's largest national distributors of building products for the residential, commercial, and industrial construction markets, with over 250 Profit Centre (PC) locations across Canada. Emco has leading positions in each of its businesses, with opportunities for tremendous growth, and is continually developing new methods to efficiently serve its growing customer base. Emco’s National Support Centre (NSC) is a high-performing team of professionals focused on providing value-added services to enable Profit Centre success. Learn more about us at emco.ca

About the Opportunity:

EMCO Corporation is seeking a skilled and passionate Business Intelligence (BI) Developer to join our team and help us transform data into actionable insights. You will participate in designing, developing, and maintaining BI solutions that empower informed decision-making across the organization, while also ensuring optimal performance and security of our BI database environments. The ideal candidate will be able to leverage their strong technical skills to enhance business decision making capabilities with tailored BI & analytics solutions.

Key Responsibilities:

• Data Acquisition and Integration

• Develop & maintain data pipelines
• Extract, transform, and load (ETL) data from various sources
• Monitor and optimize end-to-end data flow for efficiency & performance

• Data Modeling and Storage

• Design & implement dimensional BI data models
• Configure & manage BI databases
• Apply best practices for indexing, partitioning, and other techniques to optimize BI database performance

• BI DB Maintenance, Performance Tuning and Troubleshooting

• Observe and troubleshoot data-related issues within the BI environment
• Monitor database performance  and implement performance tuning strategies, including index optimization, query optimization, and scaling adjustments

• BI Development and Reporting

• Partner with stakeholders to understand business requirements and transform them into the required data warehouse architecture
• Maintain & develop interactive dashboards, reports and other analytics assets using BI and analytical tools such as Python, Power BI and Birst

Effectively communicate complex data analysis findings to both technical and non-technical audiences

Qualifications:

• Completion of University Degree in Computer Science, Information Technology, or a related field

• 3+ years of experience as a BI Developer or similar role and 2+ years of experience with database administration tasks

• Experience with BI data warehousing concepts, data modelling principles and a solid understanding of ETL processes & tools

• Strong proficiency in SQL and relational databases

• Intermediate knowledge of programming languages, such as python or R, for data integration and custom analytics solutions

• Experience with Azure data platform services (Azure SQL Database, Azure Postgres DB, Azure Data Factory, etc.)

• Excellent analytical and problem-solving skills

• Strong organizational skills with the ability to multi-task in a fast-paced, dynamic environment

• Strong communication and interpersonal skills

Bonus points for:

•  Knowledge of data mining and machine learning techniques

•  Experience with general programming languages like Java or C#

•  Proven track record of delivering successful BI projects on the Azure platform

• Experience with BI data visualization tools (Birst, Power BI, Tableau, etc.)

Why Join Our Team?

EMCO Corporation is one of Canada’s largest integrated wholesale distributors of plumbing, HVAC, waterworks, and industrial products for the construction industry. We have endless opportunities for you to grow and develop in your career and a culture that prides itself in supporting you every step of the way!

In addition, we will offer you:

•             Growth potential with competitive salary, benefits, and profit sharing

•             A career with a solid, stable company with strong core values

•             Participation in our pension plan with employer contributions

•             Work-life balance and flex time

EMCO is an equal opportunity employer and is committed to maintaining a discrimination, harassment, and barrier free workplace where all employees can contribute to their fullest potential. EMCO is committed to diversity, equity, and inclusion in our workplaces. All employment decisions are based on business needs, job requirements and individual qualifications, without regard to race, colour, creed, place of origin, sex, sexual orientation, gender, gender identity, gender expression, religion, family or parental status, or any other characteristic protected by the law. We welcome applications from all minority group members, women, Aboriginal persons, persons with disabilities, members of sexual minority groups, neurodiversity, and others who may contribute to the further diversification of ideas

EMCO is an equal opportunity employer and is committed to maintaining a discrimination, harassment, and barrier free workplace where all employees can contribute to their fullest potential. EMCO is committed to diversity, equity, and inclusion in our workplaces. All employment decisions are based on business needs, job requirements and individual qualifications, without regard to race, colour, creed, place of origin, sex, sexual orientation, gender, gender identity, gender expression, religion, family or parental status, or any other characteristic protected by the law. We welcome applications from all minority group members, women, Aboriginal persons, persons with disabilities, members of sexual minority groups, neurodiversity, and others who may contribute to the further diversification of ideas.