Company Overview 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 700 locations and exciting expansion ahead, now is the perfect time to join SiteOne and grow Stronger Together™! Position Overview We are seeking a skilled Acquisition Engineer specializing in data to support the integration of newly acquired stores into our organization. This role focuses on extracting, validating, and importing data from diverse systems to ensure smooth and accurate onboarding. What You'll Do: - Partner with newly acquired companies to understand their legacy systems, data structures, and business processes. - Work directly with acquired company personnel to extract required data from legacy platforms. - Transform extracted data into standard formats for downstream matching and import processes. - Maintain, support, and enhance SSIS packages that automate the import of data into our custom POS. - Troubleshoot data quality, transformation, ETL, and import issues across the acquisition integration lifecycle. - Perform data validation and reconciliation to ensure converted data is complete, accurate, and ready for import into internal POS and related systems. - Use Excel and SQL to review, cleanse, transform, and validate data during conversion activities. - Help identify opportunities to improve conversion quality, reduce manual work, and strengthen the scalability of the integration process as acquisition volume grows. - Design, build, and maintain ETL workflows using TSQL, SSIS, and related data integration tools. - Extract critical data from multiple systems and database platforms during acquisitions. - Collaborate with internal teams to run data matching processes and reconcile discrepancies. - Load validated datasets into internal systems while ensuring data quality, integrity, and auditability. - Partner directly with acquisition teams and internal stakeholders to provide technical data support. - Analyze existing datasets and workflows to optimize data intake and transformation processes. Skills We Are Seeking - Ability to work directly with acquired company teams and internal stakeholders to gather data, clarify business rules, and resolve issues. - Experience in data conversion, data migration, ETL development, system integration, or operational data support. - Strong Excel skills, including the ability to manipulate, cleanse, transform, review, and validate data. - Working knowledge of T-SQL for querying, validation, troubleshooting, and data transformation. - Strong analytical and problem-solving skills with attention to detail. - Ability to review data, identify anomalies, reconcile issues, and support accurate conversion outcomes. - Strong organizational skills and the ability to manage multiple acquisition integrations at the same time. - Strong communication skills and the ability to work effectively with both technical teams and non-technical business users. - Experience with gathering data such as Sales history, purchase order, receipts, Accounts receivable, etc. Customer, suppliers - Strong analytical and troubleshooting skills. - A willingness to learn and adapt in a fast‑paced environment. - Strong understanding of ETL principles, data transformation logic, and workflow dependencies. - Pulling data/reports from foreign ERP systems for import to SiteOne POS system - Proficiency with T‑SQL, stored procedures, and scripting for data manipulation. - Hands‑on experience with SSIS package development, deployment, and debugging. - Familiarity with networks, hardware, and software support. - Basic project management and task‑tracking abilities. - Excellent written and verbal communication skills. - Self‑starter with the ability to work independently and adapt quickly. - Experience with ERP systems like EpiCore, QuickBooks‑type applications (preferred but not required). - Advanced Excel proficiency (VLOOKUP, Pivot Tables, Power Query). Preferred - Familiarity with customer, product, supplier, purchase order, invoice, accounts receivable, and sales history data. - Experience with QuickBooks, Epicor, or similar ERP, or POS systems. - Familiarity with SSIS package support, maintenance, or development. Education & Experience - 4+ years of hands‑on T‑SQL experience (nice to have) - 2+ years of SSIS experience. (nice to have) - Bachelor’s degree or 4+ years of relevant professional experience. Compensation & Benefits: - Competitive Compensation - Medical, Dental and Vision plans - Paid Time Off, Paid Holidays - DailyPay available! - 401k with company match - Tuition Reimbursement - Lucrative Associate Referral Program - Company Apparel and Work Boot Vouchers - Opportunity for Advancement - Paid Training and Business Certifications Available - Free Counseling Services/Employee Assistance Program - Life Insurance and Short- and Long-Term Disability Insurance - Product Discounts - Most Branches never work Sundays! 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. This position requires that candidates be authorized to work in the U.S. We are unable to provide sponsorship. If you are ever unsure whether a message is really from SiteOne, here’s how to protect yourself from recruiting scams: - SiteOne will never ask for payment, sensitive personal info, or documents over email, messaging apps., or interviews - All SiteOne job openings and updates will be posted on our official careers page: https://careers.siteone.com/ - SiteOne job related emails will be sent with a @siteone.com. All other variations are likely fraudulent. - You can always reach our SiteOne team directly at Recruiting@siteone.com to confirm Starting pay will depend on factors such as location and experience, and will always meet or exceed applicable state and local minimum wage laws.

Role Description This is a strategic and hands-on leadership role focused on shaping the future of a modern, cloud-native data and AI platform. You will define the architecture that powers large-scale data processing, advanced analytics, and machine learning capabilities. Working in a fast-growing, globally distributed environment, you will collaborate with cross-functional teams to solve complex data challenges and drive innovation. This role offers the opportunity to influence technical direction, design scalable systems, and enable data-driven decision-making at scale. It is ideal for someone who thrives at the intersection of architecture, engineering, and data science, and is passionate about building high-impact solutions. - Define and drive the technical vision for data architecture, ensuring scalability, performance, and long-term sustainability. - Design and implement large-scale data and machine learning systems capable of processing high volumes of real-time data. - Lead architectural decision-making processes, ensuring solutions are robust, future-proof, and aligned with business goals. - Build and optimize data pipelines, feature engineering workflows, and model deployment frameworks. - Collaborate with DevOps and engineering teams to ensure infrastructure supports efficient training and inference workloads. - Develop and evolve data models supporting analytics, predictive capabilities, and business growth. - Mentor and guide data scientists and engineers, promoting best practices in MLOps, system design, and statistical rigor. Qualifications - Degree in Computer Science, Engineering, Applied Mathematics, or a related STEM field, or equivalent practical experience. - 5+ years of experience across data engineering, data architecture, and data science roles. - Proven experience designing and deploying distributed data systems at scale. - Strong expertise in cloud platforms such as AWS, GCP, or Azure, and modern data tools like Snowflake, Databricks, or BigQuery. - Solid understanding of data modeling techniques, including relational, dimensional, and NoSQL approaches. - Hands-on experience with data pipeline and orchestration tools such as Airflow, dbt, Spark, or Kafka. - Advanced proficiency in Python and SQL, with experience using data science libraries (e.g., pandas, NumPy, scikit-learn). - Experience building, deploying, and maintaining machine learning models in production environments. - Familiarity with MLOps practices, data governance, security, and compliance standards. - Bonus: Experience with AI-driven systems, RAG pipelines, or usage-based billing models. Benefits - Competitive salary aligned with experience and expertise. - Fully remote work environment with flexible working arrangements. - Opportunities for career advancement and continuous professional development. - Exposure to cutting-edge technologies in data, AI, and cloud ecosystems. - Collaborative and inclusive work culture focused on innovation and growth. - Work-life balance support and flexible scheduling.

Role Description This position is a Medicaid Subject Matter (SME) Expert for the Enterprise Data Warehouse supporting the State Medicaid program. This role requires significant expertise of Medicaid Enterprise System modules and data warehousing or decision support systems. The selected SME will provide guidance and direction to support a large data warehouse implementation for both DDI and maintenance & operations. - Provide direction, guidance and recommendations supporting decision making for large Medicaid data warehouse implementation and operations. - Lead and guide internal and external stakeholders to make determinations relating to complex processes involving claims processing/adjudication, recipient eligibility, provider enrollment, and third-party liability. - Proactively identify and understand state Medicaid agency data needs and determine the recommended solution to meet them with credible reason, justification and validated proof of concepts. - Direct technical and business teams on understanding healthcare topics and utilizing healthcare data appropriately. - Proactively suggest and recommend enhancements and improvements throughout the project processes, driven by Medicaid best practices, standards and policies. This is a telecommute position with some (<25%) required travel to Springfield, IL for onsite customer meetings. Qualifications - More than ten (10) years of experience in information technology with five (5) years of experience working directly with/for State Medicaid agencies or equivalent, supporting business initiatives through data analysis, writing business requirements and testing/validation of various systems. - More than 2 years of experience working CMS Federal Reporting MARS, PERM, T-MSIS, Quality of Care CMS Core Measure or similar projects. - Understanding of claims, recipient/eligibility, and provider/enrollment data processes. - Able to create and perform data analysis using SQL, Excel against data warehouses, utilizing large datasets. - Knowledge of the Centers for Medicare and Medicaid Services reporting requirements and the programs covered. - Excellent verbal/written communication and presentation skills, manager/executive/director-level client facing, team collaboration, and mentoring skills. - Ability to travel to Springfield, IL two (3) to three (4) times per year or as needed. Preferred Qualifications - Strong culture fit, demonstrating our culture values in action (Integrity, Compassion, Inclusion, Relationships, Innovation, and Performance). - Experience using JIRA, Rally, DevOps or equivalent. - Previous experience on large implementation or DDI project. - Located within driving distance (3 - 5 Hours) of Springfield, IL.

Our Company BrightSpring Health Services Overview We are seeking a highly skilled Senior Data Modeler to join our Data Engineering & Architecture team. This role will play a critical part not only in designing, developing, and maintaining logical and physical data models, but also in architecting, building, and optimizing the data pipelines and platforms that power our enterprise data warehouse, analytics ecosystem, and business intelligence solutions. This position ensures that data assets are structured, engineered, and delivered in a scalable, high performance, and user-friendly manner across the organization. Responsibilities - Design, implement, and optimize conceptual, logical, and physical data models to support enterprise reporting, analytics, and data science use cases. - Collaborate with data engineers, business analysts, and business stakeholders to translate business requirements into robust data structures. - Define and enforce data modeling standards, best practices, and naming conventions across the organization. - Develop and maintain data dictionaries, ER diagrams, and metadata documentation to ensure clarity and consistency. - Analyze existing data models and workflows to identify opportunities for improvement in performance, scalability, and maintainability. - Contribute to the development of enterprise data architecture patterns and reusable modeling frameworks. - Architect, build, and optimize scalable ETL/ELT pipelines using modern data engineering frameworks and cloud technologies. - Lead the design and development of distributed data processing workflows using Databricks, PySpark, Azure SQL and/or Azure Synapse. - Develop and optimize data ingestion frameworks (batch and streaming) from diverse sources including FHIR, APIs, files, databases, and event streams. - Ensure data pipelines meet enterprise standards for performance, reliability, observability, and recoverability. - Perform advanced SQL, PySpark, or Python optimization to maximize query speed and dataset availability for analytics and downstream applications. - Oversee data lake and data warehouse architecture, including partitioning strategies, delta lake management, schema evolution, and performance tuning. - Troubleshoot, diagnose, and resolve complex data engineering and pipeline issues across cloud environments. - Mentor junior engineers and modelers, influencing engineering patterns, coding standards, and architectural direction. - Collaborate with security teams to implement proper access controls, encryption, secrets management, and compliance processes. Qualifications - Bachelor’s degree in Computer Science, Information Systems, Data Management, or related field (or equivalent experience). - 7–10 years of experience in data modeling, data engineering, dimensional modeling, or data architecture roles. - Strong knowledge of relational, dimensional, and NoSQL data modeling techniques. - Advanced SQL skills and experience designing for cloud data platforms (Databricks, Synapse, Azure SQL Databases, Redshift, BigQuery, or similar). - Expertise in building scalable ETL/ELT processes using modern data engineering tools (Azure Data Factory, Databricks, Synapse Pipelines, SSIS, etc.). - Strong proficiency with Python, PySpark, or Scala for data engineering and scripting. - Hands-on experience with Azure cloud data services: Azure Data Factory, Azure SQL Database, Azure Synapse Analytics, Azure Data Lake Storage Gen2, Databricks. - Experience designing and optimizing data lakes, delta lakehouse architectures, and large-scale distributed data systems. - Experience working with DevOps concepts—CI/CD pipelines, Git branching strategies, automated testing, and deployment. - Ability to orchestrate and influence remote teams, ensuring successful implementation of complex data solutions. - Detail-oriented with excellent organizational skills. - Effective working in a cross-functional, dynamic, and remote environment. - Strategic thinker with the ability to balance short-term deliverables with long-term platform evolution. Preferred - Hands-on experience designing, building, and operationalizing unified data platforms, including semantic layers, ontologies, and knowledge graphs, to enable AI/ML product development. - Experience with enterprise-scale analytics environments and BI tools (Power BI, Qlik, Tableau, Databricks AI/BI Dashboards). - Exposure to data governance, data cataloging, and MDM practices. - Knowledge of data vault modeling, star schema, and snowflake modeling. - Experience designing real-time/streaming data pipelines (Kafka, Event Hubs, Spark Streaming, etc.). - Familiarity with API platforms and tools such as Postman or API gateways. - Experience tuning large-scale Spark workloads and optimizing cloud compute costs. - Strong communication and collaboration skills across both technical and non-technical teams. Key Competencies - Analytical and meticulous mindset with a strong ability to solve complex data design and engineering challenges. - Ability to balance short-term deliverables with long-term enterprise strategy. - Strong documentation and communication skills for presenting technical concepts to non-technical audiences. - Leadership qualities with the ability to mentor and guide junior team members. - Ability to think holistically across data modeling, data engineering, and data architecture disciplines. About our Line of Business BrightSpring Health Services provides complementary home- and community-based pharmacy and provider health solutions for complex populations in need of specialized and/or chronic care. Through the Company’s service lines, including pharmacy, home health care and rehabilitation, we provide comprehensive and more integrated care and clinical solutions in all 50 states to over 450,000 customers, clients and patients daily. BrightSpring has consistently demonstrated strong and industry-leading quality metrics across its services lines, while improving the health and quality of life for high-need individuals and reducing overall healthcare system costs. For more information, please visit www.brightspringhealth.com. Follow us on Facebook, LinkedIn, and X.