• Design algorithms and query logic to create data sets based on end user requirements • Build disruption lists by comparing datasets and identifying target opportunities for recruiting • Create geographical access reports using Quest to demonstrate coverage adequacy • Present insightful summaries with recommendations that include key themes, trends, and results to internal and external stakeholders • Coordinate, publish and maintain weekly/monthly report schedules • Analyze provider network and utilization by members; responsible for producing reports to ensure enterprise is compliant with ACA and other regulatory agencies, as well as client network adequacy and access requirements • Complete quarterly and annual GEO Access reporting requirements for internal and external clients, as well as ad hoc reporting • Develop network recruiting recommendations for leased network partners in order to maintain optimal network strength • Be source of truth for provider network questions (e.g., annual network size; ad hoc requests for network strength/size; comparison of Dominion network to competitors, etc.) • Coordinator of all network reporting requirements • Design and run quality assurance reports to ensure the integrity of networks within proprietary platform • Ensure that all business deadlines are met according to published Action Plans • Develop visualizations and tracking dashboards that provide real-time insights into provider network performance and growth • Support provider network deliverables across markets by managing and analyzing provider data to support the organization's network operations and strategic objectives • Ensure data integrity, supports provider recruitment and payer requirements, and contributes to cross-functional projects that enhance network processes and performance • Complete other tasks assigned by manager related to reporting/data in the IS Operations framework.

Description About Leo Leo is a portfolio of trusted service companies operating under one brand. Our family includes Academy Locksmith, Firstline Lock & Door, First Choice Facilities, Caliber, CLM, Impact, and others - all Powered by Leo. By operating as one team, we invest in our people, systems, and shared ways of working, while continuing to support the local teams and relationships that define our businesses. The result is consistent, reliable service and more opportunity for our people to grow and make an impact. ABOUT THE ROLE We are looking for a driven detail-oriented Business Intelligence Analyst to become the cornerstone of our data and analytics function. This is a high-impact, ownership-driven role. You will be responsible for supporting the end-to-end lifecycle of our data solutions, from raw ingestion and data quality governance through to polished executive-facing dashboards. You will work directly with leadership, operations, finance, sales, HR, and technology teams, translating complex data into clear, actionable insight. If you thrive on building things that matter, take pride in clean data, and love automating the mundane so you can focus on the meaningful then this role was built for you. Core Technology Stack - Snowflake - SQL - Power BI/Dax - Power Automate - Microsoft 365 - Azure - N8N/RPA - cData/ETL KEY RESPONSIBILITIES Reporting & Visualization • Own the design, development, and maintenance of all Power BI dashboards, reports, and scorecards across the organization • Establish and enforce reporting standards, including naming conventions, data model governance, and version control • Translate business questions from all organizational levels — from frontline staff to the C-suite — into clear, accurate visual analytics • Deliver self-service BI capabilities that reduce ad hoc data requests and empower teams to answer their own questions Data Quality & Governance • Own data quality end-to-end: define standards, build monitoring pipelines, triage anomalies, and communicate findings proactively • Implement and maintain data validation frameworks within Snowflake and downstream reporting layers • Partner with data owners across the business to document data lineage, definitions, and business rules • Develop and maintain a data dictionary and metadata catalog to support organizational data literacy Automation & Integration • Maintain and innovate automated workflows using Power Automate, N8N, or equivalent RPA platforms to reduce manual data handling • Build and maintain data pipelines that connect source systems to Snowflake and BI layers with minimal latency and maximum reliability • Identify repetitive, manual processes across the organization and proactively develop automation solutions • Support integration between Microsoft 365 ecosystem tools (Teams, SharePoint, Excel, Outlook) and core data infrastructure Data Architecture & Solutions • Contribute to the design and evolution of our Snowflake data warehouse — schemas, data models, access patterns, and performance optimization • Advise on and implement best practices for star schema, data vault, or medallion architecture patterns depending on use case • Collaborate with engineering and IT to ensure data solutions are scalable, secure, and aligned with organizational strategy • Support the evaluation and adoption of new data tools, platforms, and emerging technologies Stakeholder Communication • Serve as the primary point of contact for data questions, needs, and escalations across the organization • Present findings, project status, and data insights clearly to both technical and non-technical audiences • Lead regular reporting reviews, data working groups, or analytics office hours to increase data fluency across teams WHAT SUCCESS LOOKS LIKE In your first 90 days, you will have: ? Familiarize yourself with the data landscape of all companies ? Establish yourself as the go-to resource for data questions across the organization ? Delivered at least one meaningful automation that reduces manual effort Within your first year, you will have: ? Implemented a data standardization framework across all departments and companies ? Rebuilt or significantly improved the core reporting suite in Power BI ? Contributed meaningfully to the design of our Snowflake data architecture ? Create a portfolio of workflow automations that have meaningful business impact Requirements 2-4 years of hands-on experience in a Business Intelligence, Data Analyst, or Analytics Engineer role • Advanced SQL proficiency – Schemas, warehouses, stages, tasks, streams, and query optimization • Proven experience with Snowflake or equivalent • Data modeling, DAX, row-level security, deployment pipelines, and gateway management • Advanced Power BI skills • Demonstrated experience owning data quality programs • Workflow automation using Power Automate, N8N, or similar RPA tooling • Hands-on experience with at least one automation through API • SharePoint, Teams integrations • Deep familiarity with the Microsoft 365 / Azure ecosystem • Strong understanding of data warehouse concepts and modern architecture patterns • Exceptional communication skills — proven ability to present complex data to non-technical stakeholders confidently • Self-starter mentality with a track record of owning projects from concept to delivery with minimal supervision • Quick learner who actively stays current with evolving tools, platforms, and industry best practices NICE TO HAVE • Experience with Python or AI Agents for data transformation and pipeline orchestration • Familiarity with CI/CD practices applied to data and BI projects (git, version control, testing frameworks) • Background in building semantic layers or metrics layers (Power BI Tabular models) • Experience with Agile / Scrum methodologies in a data team context • Microsoft certifications — PL-300 (Power BI Data Analyst), DP-900, DP-203, or equivalent • Familiarity with statistical analysis, forecasting models, or machine learning concepts • Experience in a fast-scaling organization where processes and infrastructure were built, not inherited

• Leads or co-leads larger projects, technical and advisory, and contributes to project design. • Independently drives work with minimal day-to-day supervision and project oversight. • May manage Associates and Senior Associates in a supervisory capacity, if/as needed. • Manages projects to exemplary client satisfaction; Contributes to and/or leads proposals. • Build dashboards, charts, and interactive views aligned to approved requirements, indicators, and business rules, using Snowflake-curated data as the source of truth. • Develop standardized visualization components and templates (e.g., filter controls, parameters, tooltips, legends, export patterns) to support consistency across products. • Implement indicator and metric logic in the BI layer where appropriate (e.g., calculations, measures, formatting, labeling) consistent with documented methodologies and conventions. • Configure and maintain BI semantic layer/modeling artifacts as applicable (e.g., Tableau data sources/extracts where relevant, Power BI datasets/models), preserving alignment with Snowflake structures. • Improve performance and usability through tuning and optimization (e.g., query efficiency, workbook/model design, visual density, filter strategies). • Support release readiness and visual quality assurance, including filter behavior, crosstab consistency, export validation, and stakeholder review cycles. • Participate in DPH/LPH engagement and refinement sessions and translate feedback into prioritized visualization updates. • Work within a structured delivery environment using Jira, Confluence, SharePoint, Microsoft Teams, and Microsoft Office.

• Solve complex business problems using data from internal and external sources • Lead the strategy, development, and execution of data management and analytic functions • Drive effective governance of insurance benefit data across the full lifecycle • Oversee the development, maintenance, and optimization of analytic processes • Enforce Enterprise data governance policies, standards, and best practices • Support automation and process enhancement efforts • Collaborate with IT, leaders within the Product organization, other business units, and executive leadership • Monitor industry trends and recommend new tools, technologies, or processes • Support organizational change management by advocating for a data-driven culture