Your opportunity Our client builds North America’s leading clinical practice software for mental healthcare providers. They are a mission-driven innovator rooted in research and building the tools to support the emergent clinical category they are creating. They currently serve >350 healthcare organizations and tens of thousands of clinicians delivering care in clinics, hospitals, campuses and workplaces. The company also serves regional health systems by providing population-level insights and bolsters continuity of care by making patient data on the platform portable to a variety of care providers and program administrators. The mission was inspired by personal experiences with the shortcomings and inconsistencies in mental healthcare practice and the founders are dedicated to improving the quality of care within these systems. The company is ~9 years old and recently closed its first lettered venture round of financing. Despite the capital injection the team is growing in line with revenue, and minimal reliance on outside capital. The current wave of hiring was unlocked by revenue and a large implementation that will roll out to millions of insurance plan members over the coming months. The company is ~80 total team members and as a analytics engineer, you will join an R&D organization of ~29 team members (with a data team of~5, ~7 in product and design, and ~17 in software engineering). The teams are organized into 5 cross-functional pods focusing on platform, core clinical solutions, data and AI platform, integrations, and population health. The data team that you will join works with highly privileged data and produce insights that meaningfully improve people’s health. They are a small, growing, remote-first team and successful data team members tend to be high ownership communicators who take initiative, clarify requirements, and work cross-functionally with a steady eye on high-level business requirements and constraints. Key responsibilities - Data modelling & transformations: Own and evolve the analytics data model in dbt/BigQuery, building maintainable, well-tested transformations that support product analytics, custom use cases, and new feature development - Looker stewardship and analytics technical strategy: Act as a technical steward for Looker and help shape the broader analytics strategy, including explores, views, folder structure, customization patterns, performance, and developer workflows - Customer analytics customizations: Own the technical delivery of complex customer-specific analytics requests, from scoping and prioritization through implementation, testing, documentation, rollout, and customer walkthroughs - Analytics architecture and productization: Default to reusable, productized solutions wherever possible, creating shared models, standard tiles, and scalable patterns to minimize one-off work - Analytics support, debugging, and reliability: Serve as a senior escalation point for analytics issues, investigating metric discrepancies, broken dashboards, performance regressions, and recurring problems while improving SLAs, monitoring, and long-term stability - Cross-functional collaboration: Partner closely with the product, design, success, and support teams to translate requirements into analytics solutions and bring customer insight into roadmap and product decisions - Documentation, enablement, and continuous improvement: Strengthen team effectiveness through clear documentation, internal enablement, and a steady focus on maintainability, backward compatibility, and modern analytics engineering best practices Your know-how - You have 3+ years of experience owning data modelling and BI tooling as a data analyst, analytics engineer, BI engineer or data scientist - You are experienced with SQL, Python and modern data warehousing - You care deeply about clean and efficient models, tests and documentation and are experienced with dbt or a similar transformation framework - You have experience building views, dashboards and self-service data exploration with Looker or a similar BI tool - You have experience gathering requirements directly from customers and other internal and external stakeholders - You are comfortable owning the reliability of analytics systems in production and have experience investigating incidents, shipping fixes and designing solutions that proactively mitigate outages - You think in AI-first terms, actively adopt and integrate AI tools in your own workflow to accelerate your work - You are a pragmatic person with experience making tradeoffs between shipping a solution quickly and investing in more robust solves - You have an excellent command of English and are comfortable adapting your communication style for non-technical audiences - You have a contagious growth mindset and persistently seek opportunities to improve yourself, the team, products and processes in a scaling business It’s a bonus if - You have experience working on enterprise-grade software that handles sensitive data - You have previously served in a business that faces healthcare or other regulated industries - You have experience building or scaling a B2B or B2B2C venture - You have an acute interest in mental healthcare or health technology Interested in learning more? Please apply using the following form or send your resume or LinkedIn profile URL to talent@lutrapartners.com with “Analytics Engineer, Mental Healthcare” as the subject line. One of our talent partners will be in contact shortly.

• As a Senior Analytics Engineer within our team, you will lead initiatives on topics such as data quality, observability and model optimisation. Typical responsibilities could involve; • Design, build and maintain high quality datasets for engineers to build robust customer facing reporting • Collaborate closely with engineers to assess and mitigate the impact of upstream product changes • Apply domain knowledge to develop semantic layers for business intelligence • Develop data models optimized for efficient querying over large datasets, specifically for reports embedded within our main platform

• Develop and prototype cloud‑native analytics solutions using Power BI (Desktop, Service), DAX, Power Query (M), dataflows, deployment pipelines, and Snowflake components including schemas, virtual warehouses, roles, tasks/streams, and performance services. • Lead full‑cycle development (SDLC + agile) of secure, scalable, and cost‑efficient analytics, including design, build, test, documentation, and support. • Implement governance controls including row‑level and object‑level security, data endorsements, versioning, and reliable refresh pipelines. • Perform source‑to‑target mapping and design star/snowflake models optimized for analytics and semantic modeling. • Build semantic layers and governed calculation frameworks (DAX measures, calculation groups). • Optimize model and query performance using aggregations, incremental refresh, model size tuning, and Snowflake performance strategies (clustering, caching). • Write medium to complex SQL queries for data validation, quality checks, and in-depth analysis. • Operationalize production pipelines, schedules, workflows, alerting/monitoring, and SLAs. • Provide Level 3 support (ServiceNow), including triage, root‑cause analysis, and stable release management. • Partner with business and technical stakeholders to define requirements, lead design workshops, and produce actionable prototypes and wireframes. • Design high‑value dashboards, reports, and analytics that provide product insights and operational decision support. • Own end‑to‑end design for visualization, reporting, and dashboard solutions that power product insights and operational decision‑making. • Communicate proactively with teams and stakeholders; escalate risks early to ensure on‑time delivery. • Champion quality, standards, and continuous improvement through architecture/code reviews, operational documentation, and usage/cost awareness across workloads. • Research emerging cloud analytics capabilities and ensure compliance with required training and SOPs (e.g., GCP, 21 CFR Part 11, CAPA). • Explore new opportunities to add value through automation, standardization, and measurement. • Support teammates to achieve shared outcomes; perform other duties as assigned. • Maintain version-controlled BI assets using GitLab (commit, push, merge requests, resolving conflicts) • Use Jira for sprint planning, task updates, story tracking, and collaboration within Agile teams. • Collaborate with data engineering teams to ensure accurate and consistent data flows. • Support root-cause analysis for data discrepancies reported by business users. • Participate in patch releases, including validation, deployment coordination, and documentation • Maintain strong, current knowledge of cloud analytics, Power BI, Snowflake, data engineering patterns (ELT/ETL), data governance, and security.

Facilities Specialist, Data & Analytics - Corporate Real Estate and Facilities Remote time type Full time The Facilities Specialist, Data & Analytics transforms complex facilities data into actionable insights that enhance operational efficiency, reliability, and strategic decision-making across Ferguson’s real estate portfolio! This role designs and maintains enterprise dashboards, data models, and integrations to drive consistency, accuracy, and visibility in facility performance reporting and long-range planning. Location: Remote anywhere in the US or hybrid if you are located in the Newport News, VA HQ area. Job description - Serve as a subject matter expert in a specialized area of Facilities Management, providing strategic insight, advanced analysis and technical expertise to enhance operational efficiency. - Design, build, and maintain advanced dashboards using Power BI or Tableau, transforming complex facilities data into actionable insights for internal partners and executive leadership. - Lead data mapping and integration efforts across disparate facilities management systems, ensuring consistent, accurate, and scalable data pipelines for enterprise reporting. - Develop and manage BI data models, including SQL-based transformations, ETL design, API integrations, data governance, security protocols, and performance optimization for real-time analytics and long-range planning. - Create and administer facility survey tools and reporting frameworks, enabling standardized field data collection and continuous improvement tracking. - Support corporate initiatives through data-driven decision-making, process optimization and vendor performance management. - Monitor and advise on budgets, capital planning, financial reports, vendor contracts, expenditures, and purchase orders related to facility operations, ensuring cost control and alignment with company objectives. - Prepare and deliver consolidated reports, including key performance indicators and periodic reviews of all facility activities, to support strategic decision-making and ensure alignment with company goals. - Act as a trusted advisor to internal partners, including executives and cross-functional teams, by providing strategic recommendations and insight into Facilities Management standard processes. - Support vendor management, including reviewing contracts, ensuring service level agreements (SLAs) are met, and verifying the accuracy of completed work and proposals. - Ensure consistent and high-quality delivery of facility services, including maintenance, operational support, safety, and compliance. - Maintain strict adherence to company compliance standards, as well as Health, Safety, and Environment (HSE) policies and procedures. - Leverage data and analytics to enhance service delivery, equipment reliability, and operational performance. - Identify and implement best practices for cost reduction, operational improvement, and long-term facility planning. - Perform additional duties and responsibilities as assigned by leadership. Preferred Education and experience - 3+ years’ relevant experience preferably within Real Estate and Facilities at a corporate level. - Bachelor’s degree in facilities management, business management, technical facilities, or a similar field preferred. - Experience managing/supporting multi-location industrial or retail portfolios with a focus on operational improvement. - Exceptional ability in Communication, Organizing, Group Problem Solving, Teamwork, Relationship Building, Time Management and Communication both written and verbally. - Ability to engage effectively with partners at all levels, internal and external, including the Executive Leadership Team, and act as a strategic advisor. - Perform with a strong sense of urgency, with high expectations, around driving costs from the company P&L and best preparing Ferguson for future growth. - Ability to travel up to 10% of the time. - Ability to manage multiple priorities and deadlines in a fast-paced environment. At Ferguson, we care for each other. We value our well-being just as much as our hard work. We are committed to a holistic approach towards benefits plans and programs that support the mental, physical and financial well-being of our associates. Our competitive offering not only includes benefits like health, dental, vision, paid time off, life insurance and a 401(k) with a company match, but our associates also enjoy additional meaningful and inclusive enhancements that are adaptable to their diverse situations and needs, including mental health coverage, gender affirming and family building benefits, paid parental leave, associate discounts, community involvement opportunities and more! - Pay Range: $4,500.00 - $11,275.00 monthly