BI and Data Analytics Manager

Company Overview Whether you are experienced in the green industry, a professional looking for a career change, or a new graduate or veteran transitioning into the workforce, we are confident you will find opportunity and reward with SiteOne. SiteOne Landscape Supply is the largest and only national wholesale distributor of landscaping products in the United States and Canada. With over 500 branches across the U.S. and Canada, we offer a comprehensive selection of products including: irrigation supplies, fertilizer and control products, nursery goods, hardscapes, landscape lighting, drainage and erosion control products, tools, and other landscaping accessories and supplies. Come grow with our associates who are customer obsessed, always safe, continuously improving, and having fun! Position Overview We have an opportunity for a Manager, BI and Data Analytics to join our IT team in our Roswell, GA location. In this role you will be developing data visualization/self service solutions. You will be creating tabular data models as well as creating complex PowerBI dashboards. IN THIS ROLE YOU WILL: Work with business users to define, implement data solutions based on Microsoft SQL BI Stack Schedule, plan and lead complex data integration and business intelligence initiatives Oversee and design the BI architecture, roadmap, and implementation Manage, guide and mentor a team of BI Developers Create project plans and communicate progress/status to business leaders Build, maintain, and optimize tabular data models using Microsoft SSAS Develop data models and architectural designs to build data warehouse using Kimball methodologies Enhance and support data warehousing and data management projects with ETL development Responsible for query optimizations and performance tuning of various MS BI objects Support and maintain or PowerBI environment Skills We Are Seeking 2+ years of experience in Business Intelligence management 2+ years of experience in project management 2+ years building dashboards using Power BI within an enterprise 5+ years of experience with SSAS and other OLAP technologies 5+ years of experience in developing and maintaining SSIS packages Experience with principles of Data Warehousing, and able to prepare technical documentation Knowledge of Dimensional Design Principles, such as Star and Snowflake Schema Solid understanding of Relational and Dimensional Modeling Exposure to Large Databases (1 TB+) and heavy database loads Advanced knowledge and experience with SQL Server 2016+ Performance tuning stored procedures and ETL processes Ability to work well independently with minimal supervision, manage multiple priorities, and remain flexible in a dynamically changing environment PERKS: Medical, Dental and Vision plans Paid Time Off, Paid Holidays Competitive Compensation 401k with company match Company paid life insurance, Short Term Disability and Long-Term Disability Insurance Product Discounts Tuition Reimbursement Opportunity for Advancement THE INFORMATION CONTAINED HEREIN IS NOT INTENDED TO BE AN EXHAUSTIVE LIST OF ALL RESPONSIBILITIES, DUTIES AND QUALIFICATIONS REQUIRED OF INDIVIDUALS PERFORMING THE JOB. THE QUALIFICATIONS DETAILED IN THIS JOB DESCRIPTION ARE NOT CONSIDERED THE MINIMUM REQUIREMENTS NECESSARY TO PERFORM THE JOB, BUT RATHER AS GUIDELINES. THEY MAY VARY FROM POSITION TO POSITION.