About Legence Legence (Nasdaq: LGN) is a leading provider of engineering, consulting, installation, and maintenance services for mission-critical systems in buildings. The company specializes in designing, fabricating, and installing complex HVAC, process piping, and other mechanical, electrical, and plumbing (MEP) systems—enhancing energy efficiency, reliability, and sustainability in new and existing facilities. Legence also delivers long-term performance through strategic upgrades and holistic solutions. Serving some of the world’s most technically demanding sectors, Legence counts over 60% of the Nasdaq-100 Index among its clients. Position Overview: We are seeking a highly skilled Power BI Data Engineer who combines deep technical expertise in data engineering with exceptional data visualization abilities. This hands-on role requires someone who can architect robust data solutions while creating compelling, insight-driven dashboards that transform complex data into clear, actionable intelligence. This role is expected to interact directly with end users regarding requirements, testing, and implementation. This position is remote with preference to align to one of Legence’ s office locations. Key Responsibilities Power BI Development & Visualization - Create sophisticated, visually stunning Power BI dashboards and reports that drive business decisions - Develop advanced DAX calculations, measures, and calculated columns to support complex analytical requirements - Design intuitive, user-friendly interfaces with custom visuals, drill-through capabilities, and interactive features - Implement dynamic report features including bookmarks, parameters, field parameters, and dynamic formatting - Build composite models and leverage advanced features like aggregations, incremental refresh, and query folding Data Engineering & Architecture - Design, build, and maintain scalable data pipelines and ETL/ELT processes using Power Query, Dataflows, and Azure Data Factory - Develop and optimize data models using star schema, snowflake schema, and other dimensional modeling techniques - Implement and manage data warehouses and data lakes using Azure Synapse Analytics, SQL Server, or similar platforms - Write and optimize complex SQL queries, stored procedures, and database functions for performance and efficiency - Establish data governance frameworks, including data quality checks, validation rules, and documentation standards Technical Implementation - Configure and manage Power BI/Fabric workspaces, deployment pipelines, and version control - Implement row-level security (RLS) and object-level security (OLS) for data protection - Optimize report performance through query optimization, data model refinement, and DAX tuning - Integrate Power BI with various data sources including SQL databases, APIs, SharePoint, Excel, and cloud platforms - Automate data refresh schedules and monitor gateway configurations Required Qualifications Technical Skills - 3+ years of hands-on experience with Power BI development (Desktop, Service, and Report Server) - Expert-level proficiency in DAX (Data Analysis Expressions) and Power Query (M language) - Strong SQL skills with experience in database design, query optimization, and performance tuning - Solid understanding of data warehousing concepts, dimensional modeling, and ETL principles - Experience with data visualization best practices and UI/UX design principles - Proficiency in Azure data services (Azure SQL Database, Synapse Analytics, Data Factory, or Fabric) Data & Analytical Expertise - Deep understanding of data modeling techniques and relationships (one-to-many, many-to-many, bi-directional) - Strong grasp of statistical concepts and analytical methodologies - Ability to translate complex business requirements into technical data solutions - Experience with data quality assessment and data profiling Professional Competencies - Proven ability to create visually compelling, executive-level dashboards and reports - Strong problem-solving skills with a hands-on, solution-oriented approach - Excellent communication skills to explain technical concepts to non-technical stakeholders - Detail-oriented with commitment to code quality and documentation - Demonstrated ability to use AI and automation in software engineering Preferred Qualifications - CS or CIS bachelor 's degree - Microsoft certifications: PL-300 (Power BI Data Analyst), DP-203 (Data Engineer), or DP-500 (Enterprise Data Analyst) - Experience with Python or R for advanced analytics integration - Familiarity with Git/Azure DevOps for version control and CI/CD pipelines - Knowledge of DAX Studio, and other Power BI development tools - Experience with Power BI Embedded or custom API development - Understanding of data science concepts and predictive analytics Technical Environment - Power BI Desktop, Power BI Service, Power BI Premium/Fabric - SQL Server, Azure SQL Database, Azure Synapse Analytics - Azure Data Factory, Azure Data Lake Storage - DAX Studio, Tabular Editor, Power Query - Git/Azure DevOps for version control What Makes You Stand Out - Portfolio of impressive Power BI dashboards demonstrating design excellence and technical complexity - Track record of optimizing poorly performing reports and data models - Experience mentoring others in Power BI development and best practices - Contributions to the Power BI community (blog posts, speaking engagements, open-source projects) This is a hands-on technical role requiring daily interaction with data, code, and visualization design. The ideal candidate thrives in environments where they can build solutions from the ground up and take ownership of the entire BI development lifecycle. Base salary: $105,000–$120,000 per year. This role may be eligible for participation in discretionary bonus plan based on company and individual performance. Notes: Actual compensation will be based on skills, experience, and work location, and may vary from the posted range. Hiring bonuses (and any guaranteed year-end bonuses) are administered under Company policy and are not earned until all stated conditions are met (e.g., active employment on the payment date). This posting reflects compensation at the time of posting and may be updated. Unable to provide sponsorship for this position. #LI-JS1 #LI-Remote Benefits Overview 401(k) Plan with Company Match: Currently match contributions dollar-for-dollar up to 4% of eligible pay; immediate vesting. Health & Welfare Benefits: Employer provided medical, dental, vision, prescription drug, Employee Assistance Program and accident & illness coverage. Life and Disability Insurance: Employer provided basic life insurance and AD&D valued at 50K coverage amount with the option for voluntary buy up for additional coverage. Time Off: Flexible non-accrual vacation; company holidays per policy. (For California employees, this is separate from California paid sick leave, if applicable.) Expenses: Business travel and related expenses reimbursed per company policy. Reasonable Accommodations If you need assistance or accommodations during the application or interview process, please contact us at ta@wearelegence.com or your dedicated recruiter with the job title and requisition number. Employment Eligibility Candidates must have current work authorization in the U.S.; visa sponsorship is not available for this position. Third-Party Recruiting Disclaimer Legence and its affiliates do not accept unsolicited resumes from agencies; any such submissions without a prior signed agreement authorized by Legence Holdings LLC's CHRO or Director of Talent Acquisition will not incur fees and are considered property of Legence. Pay Disclosure & Considerations Where pay ranges are indicated, please note that a successful candidate’s exact pay will be determined based relevant job-related factors, including any of the following: candidate’s experience, skills, and qualifications, as well as geographic and market considerations. We are committed to ensuring fair and competitive compensation for all employees and comply with all applicable salary transparency laws. Equal Employment Opportunity Employer Legence and its affiliate companies are proud to be an equal opportunity workplace. We are committed to equal employment opportunity regardless of race, color, religion, sex (including pregnancy, gender identity, and sexual orientation), marital or familial status, national origin, age, disability, genetic information (including family medical history), political affiliation, military service, other non-merit-based factors, and any other characteristic protected under applicable local, state or federal laws and regulations. EEO is the Law

*Starting from $175,000.00 - $200,000.00 annually plus additional incentives* - The total compensation package for this position may also include other elements, including a performance bonus and discretionary awards in addition to a full range of medical, financial, and/or other benefits (including 401(k) eligibility and various paid time off benefits, such as vacation, sick time, and parental leave), dependent on the position offered. Pay is based on location, experience, and qualifications etc. Peregrine Hospitality is seeking a Senior Director of Business Intelligence to lead the company’s analytics and reporting capabilities across its hotel and resort portfolio. This role is responsible for transforming operational and financial data into clear, actionable insights that support decision-making at the executive, property, and portfolio levels. The ideal candidate brings deep hospitality experience and understands how data supports revenue performance, labor efficiency, guest experience, and overall profitability. This is a business-focused leadership role that partners closely with Finance, Operations, Revenue Management, and Technology teams. Key Responsibilities - Lead Peregrine Hospitality’s business intelligence strategy and execution. - Define and maintain the BI roadmap aligned to business priorities and operational needs. - Establish reporting standards, metric definitions, and consistent dashboards across properties and brands. - Deliver trusted insights across revenue, labor, guest experience, and financial performance. - Oversee the BI technology ecosystem, including DataVision, Power BI, ProfitSword, and Opera PMS. - Lead vendor collaboration and integration efforts to ensure data from PMS, POS, labor, and financial systems is accurately and consistently delivered into DataVision and other data warehouse platforms. - Ensure data accuracy, consistency, and governance across all reporting. - Partner with executive leadership to support strategic planning, performance reviews, and board-level reporting. - Drive adoption of BI tools and reporting across the organization through enablement and change management. - Fully train business users and leaders to ensure analytics are understood, trusted, and actively used. Team Structure & Scope This role will initially operate as a highly hands-on individual contributor, responsible for building the Business Intelligence function from the ground up. The Senior Director will define the BI roadmap and strategy, project manage initiatives, execute and build reporting solutions, and establish foundational processes and standards. The role will also lead adoption across the organization through direct engagement, training, and embedding analytics into daily decision-making. As the program matures, this role will help inform future team structure and resourcing needs. Qualifications - 10+ years of experience in business intelligence, analytics, or data leadership. - Demonstrated ability to adjust level of detail, language, and framing from GM-level operational reporting to executive and board-level materials. - Required hospitality experience within hotels, resorts, or hospitality management companies. - Hands-on experience with DataVision, ProfitSword, Opera PMS, and Power BI. - Strong understanding of hotel operations, revenue management, and financial reporting. - Proven ability to operate independently while building scalable programs. - Strong communication skills with the ability to translate data into clear business insight. Preferred Experience - Multi-property or portfolio-level hospitality experience. - Experience supporting executive, board, or investor reporting. - Background in finance, revenue management, or operations analytics. - Experience standing up or modernizing BI and reporting programs. Why Join Peregrine Hospitality This role offers the opportunity to shape how data is used across a growing hospitality portfolio. The Senior Director of Business Intelligence will play a key role in improving operational efficiency, driving financial performance, and enhancing the guest experience through better insight and decision-making.

Role Description Als Business / Data Analyst bist du die Schnittstelle zwischen Fachbereich und Daten: - Analyse fachlicher Fragestellungen und Übersetzung von Business-Anforderungen in aussagekräftige Datenmodelle und Reports - Konzeption, Entwicklung und Weiterentwicklung von Power BI Reports mit klarem Fokus auf Business-Mehrwert - Mitarbeit an modernen Data- & Analytics-Architekturen auf Basis von Microsoft Fabric (z. B. Lakehouse, Warehouse, Semantic Models) - Analyse, Aufbereitung und Modellierung von Daten aus unterschiedlichen Quellen (u. a. SAP S/4HANA, CRM, ERP, externe Datenquellen) - Entwicklung von KPIs, Kennzahlensystemen und Storylines für Management und Fachabteilungen - Enge Zusammenarbeit mit Kunden, Consultants, Data Engineers und Entwicklern - Durchführung von Workshops, Anforderungsaufnahmen und Enablement-Sessions für Fachanwender - Unterstützung bei Governance-, Self-Service- und Data-Literacy-Konzepten - Aktives Vordenken in Richtung Data Products, Advanced Analytics und AI-ready Data auf Fabric-Basis Deine fachliche und persönliche Entwicklung ist uns wichtig. Gemeinsam gestalten wir einen Job, der zu deinen Stärken, Interessen und Zielen passt. Qualifications - Abgeschlossenes Studium in Wirtschaftsinformatik, Informatik, Data Science, Betriebswirtschaft oder eine vergleichbare Qualifikation - Mindestens 3 Jahre Erfahrung als Business Analyst, Data Analyst oder Power BI Consultant - Sehr gute Kenntnisse in Microsoft Power BI, insbesondere Datenmodellierung, DAX und Power Query - Gutes Verständnis für betriebswirtschaftliche Zusammenhänge und Kennzahlen - Analytisches Denkvermögen und strukturierte Arbeitsweise - Fähigkeit, komplexe Sachverhalte klar und adressatengerecht zu kommunizieren Requirements - Erste Erfahrung mit Microsoft Fabric oder vergleichbaren modernen Data-Plattformen (Lakehouse, Data Warehouse, Data Pipelines) - Kenntnisse in SQL sowie Grundverständnis von Datenarchitekturen und ETL/ELT-Prozessen - Erfahrung in der Anbindung von SAP S/4HANA, SAP BW oder CDS Views sind von Vorteil - Interesse an Themen wie Data Governance, Self-Service BI, AI & Advanced Analytics - Erfahrung in Kundenprojekten, Workshops oder Beratungsumfeld Benefits - Teamorientierte, familiäre und offene Arbeitskultur mit vielen Gestaltungsmöglichkeiten und kurzen Entscheidungswegen - Respektvoller und lockerer Umgang mit einer Du-Kultur über alle Ebenen hinweg – und das bereits ab dem ersten Kennenlernen - Fachliche und persönliche Weiterentwicklung durch abwechslungsreiche und innovative Projekte sowie Teilnahme an Schulungen, Konferenzen etc. - Zahlreiche Benefits, wie z.B. tolle Altersvorsorge, flexible Arbeitszeiten, Kita-Zuschuss, 30 Tage Urlaub, attraktives Fahrradleasing über JobRad uvm. - Gemeinsame Mittagspausen, Teamevents und „Bier um Vier“ am Freitag - Die Chance, Dich persönlich und fachlich weiterzuentwickeln – mit Perspektive

Essential Duties and Responsibilities - Create summary reports, data extracts, and other financial analyses for management and external vendors. - Pull underlying data by creating/modifying SQL queries to run in Epic's Clarity database. - Adjust query outputs in Excel, add formulas, charts, and graphs to summarize data and show underlying trends. - Link output data to other workbooks to create more complex data models if required. - Uses Visual Studio to generate appropriate output format. - Uses Excel VBA to automate reports. - Build contract models using Epic contract modeling tools. - Build contract models in Excel by querying Epic's Clarity database. - Refresh underlying claim data in contract models as contract terms change. - Build SQL templates to pull patient, claim, department, or enterprise-wide data. - Maintains and updates the templates after each Epic upgrade. - Thorough understanding of source data systems and their interaction with medical claims. Culture of Excellence Behavior Expectations To perform the job successfully, an individual should demonstrate the following behavior expectations: Quality - Follows policies and procedures; adapts to and manages changes in the environment; Demonstrates accuracy and thoroughness giving attention to details; Looks for ways to improve and promote quality; Applies feedback to improve performance; Manages time and prioritizes effectively to achieve organizational goals. Service - Responds promptly to requests for service and assistance; Follows the Mercyhealth Critical Moments of service; Meets commitments; Abides by MH confidentiality and security agreement; Shows respect and sensitivity for cultural differences; and effectively communicates information to partners; Thinks system wide regarding processes and functions. Partnering - Shows commitment to the Mission of Mercyhealth and Culture of Excellence through all words and actions; Exhibits objectivity and openness to other's views; Demonstrates a high level of participation and engagement in day-to-day work; Gives and welcomes feedback; Generates suggestions for improving work: Embraces teamwork, supports and encourages positive change while giving value to individuals. Cost - Conserves organization resources; Understands fiscal responsibility; Works within approved budget; Develops and implements cost saving measures; contributes to profits and revenue. Education and Experience Associates degree with a major in computer science, business, mathematics, engineering, science and 3 years' experience in Revenue Cycle Reporting required. 5 years of experience in lieu of degree. Certification and Licensure Required to obtain the following Epic certifications within the one year of hire: Cogito Fundamentals (or prior equivalent), Clarity Data Model, Revenue Data Model. Skills and Abilities Knowledge of healthcare reimbursement programs, coding, and billing preferred. Special Physical Demands The Special Physical Demands are considered Essential Job Functions of the position with or without reasonable accommodations. While performing the duties of this job, the employee is frequently required to sit; use hands to handle, finger, feel; reach, talk and hear. The employee is occasionally required to stand and walk. This is light work exerting up to 25 pounds of force occasionally. Specific vision abilities required by this job include constant close vision. Frequent ability to adjust focus. Prolonged sitting. Manual dexterity needed to operate telephone and keyboard. Level of Supervision Supervises N/A PAY RANGE: $29.99 - $44.99 Mercyhealth is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identify, national origin, disability, or protected veteran status. Mercyhealth offers competitive pay and a comprehensive benefits package including: - Medical, Dental, Vision - Life & Disability Insurance - FSA/HSA Options - Generous, accruing paid time off - Paid Parental and caregiver leave - Career advancement and educational opportunities - Tuition and certification reimbursement - Certification Reimbursement - Well-being Programs - Employee Discounts - On-Demand Pay - Financial Education - Annual recognition/awards events - Partner appreciation days - Family entertainment/attractions discount - Community service/improvement opportunities Click here for more details regarding Mercyhealth Careers Benefit Information. At Mercyhealth, we don’t simply hire people, we empower employee-partners who are passionate about making lives better. As an integrated health system, we deliver exceptional, coordinated across seven hospitals, 85 primary and specialty clinics, and a team of over 7,500 professionals serving northern Illinois and southern Wisconsin. Mercyhealth has been nationally recognized for our commitment to our people and culture, including: - #1 in the nation on AARP's Best Employers for Workers Over 50 - One of Working Mother magazine's 100 Best Companies for Working Mothers - A Top 50 Company and Top 10 Nonprofit for Executive Women