What are the responsibilities and job description for the Senior Business Intelligence Analyst- Remote position at SiteOne Landscape Supply?
SiteOne Landscape Supply is the largest national distributor of landscaping products across the United States and Canada. As a leading supplier of wholesale goods for green industry professionals, we have a long history of serving those who design, build, and maintain outdoor spaces – from lawns and gardens to golf courses, sport fields and more. We pride ourselves on knowing our customers and their business better than anyone else and providing them with a one-stop shop of extensive inventory covering irrigation, lighting, turf and landscape maintenance, hardscapes, nursery, and pest control supplies.
At SiteOne, we are passionate about delivering an outstanding customer experience and will stop at nothing to help our customers win. We know that our associates are the key to this success, and our commitment to the SiteOne DNA and support for our associates through development programs, benefits, and perks align with our vision to "Be a Great Place to Work for Our Associates". We foster a culture of safety, teamwork, and continuous improvement. With over 800 locations and exciting expansion ahead, now is the perfect time to join SiteOne and grow Stronger Together™!
Position Overview
The SiteOne Supply Chain and OpEx organization is searching for a Senior Business Intelligence Analyst to join our team, with a focus on Data Engineering. The ideal candidate will be a key member within the team, capable of identifying meaningful connections in data, transforming and staging data in SQL and developing semantic models in SSAS and PowerBI. They are an expert in BI and data transformation within SQL, able to define and align partners on new KPIs, and drive a project from start to finish while influencing others across the business and IT functions.
What You'll Do:
- Design Data Models that can efficiently support BI Applications and Self-Service use-cases.
- Develop transformations to stage data for modeling across various sources within the data warehouse.
- Evaluate the accuracy, completeness, and reliability of data sources.
- Support data governance and security policies to protect the use of data across the organization.
- Partner with Business Science Analysts, Stakeholders, and other engineers to understand requirements and deliver comprehensive solutions.
- Optimize existing models and transformations for maximum performance.
- Identify and resolve data-related issues, ensuring the stability and reliability of reporting.
Skills We Are Seeking
- Bachelor’s degree in business or data analytics related field
- 4 years of working experience
- Broad understanding of SQL for analytics and data transformation (Microsoft SQL Server)
- Advance Experience with leveraging data visualization tools (e.g., Power BI)
- Experience leveraging DAX in the creation of measures
- Experience developing repeatable processes to streamline engineering capabilities.
- Sense of curiosity with exceptional analytical and problem-solving abilities
- Strong influencing and communication skills
- Polished written and verbal communication
- Self-starter with the ability to prioritize workload and communicate timing and challenges
- Desire to “roll up your sleeves”, disaggregate complex problems and simplify into executable solutions
- A track record of following through on commitments
- Proficient in Microsoft Office Suite, specifically Excel
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.
SiteOne Landscape Supply is strongly committed to providing equal employment opportunities for all associates and all applicants for employment. All employment decisions at SiteOne-including those relating to hiring, promotion, transfers, benefits, compensation, placement, and termination-will be made without regard to race, color, national origin, genetic information, creed, sex, sexual orientation, gender, gender identity, religion, age, veteran status, uniform service, pregnancy, disability, or any other factor protected by applicable law.