BI Developer

at  EMCO Corporation

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
Job Description

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.

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

• 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