Data Intelligence, Senior Data Analyst

RE Tech Advisors, a Legence company

RE Tech Advisors is a growing, woman-led consulting firm of over 125 ESG professionals. We deliver results at the intersection of engineering, technology, and sustainability. RE Tech has a progressive and ambitious client base that includes numerous commercial real estate portfolios, private equity investors, federal agencies, industry associations, and manufacturing companies. By joining the RE Tech Advisors team, you will work closely with recognized industry leaders who are driving national and global sustainability initiatives providing you the opportunity to realize your own professional growth objectives in the ESG arena.

Summary Description

RE Tech Advisors is seeking a highly motivated, experienced, and passionate Senior Data Analyst to bring their knowledge and experience in design & implementation to help our business evolve into a data-driven organization in which data and analytics drive differentiation for RE Tech services. RE Tech’s industry-leading platform provides our clients with the ability to monitor and improve building performance to achieve their sustainability goals. The Senior Data Analyst will wrangle, model, and analyze data with an understanding of data flow from different applications to and from the data management system with the objective of improving data quality and driving improved decision-making. The Senior Data Analyst will demonstrate leadership through mentoring analysts, helping the team achieve goals together, and serving as a role model for technical and interpersonal skills. With your expertise, creativity, and commitment, you will contribute directly to creating a sustainable future for our planet by providing our clients with a product to monitor and improve the performance of their commercial real estate portfolios.  This is an exciting opportunity to join a rapidly growing firm working to accelerate the transition to a low-carbon future. 

Essential Job Functions / Job Duties and Responsibilities

• Maintain and update data in Azure environment which involves running existing or new queries in Test and Prod environments.
• Analyze data housed within RE Tech data management system to identify trends and publish actionable findings. Ensure all policies are met and procedures are current.
• Schedule reviews on predetermined cadence. Coordinate audit activities for client portfolio/ building and meter level data by tracking, scheduling, and communicating needs.
• Create analytical process workflows in tools such as Alteryx to clean, manipulate, and analyze various data points.
• Build advanced analytical models for predictive analytics.
• Develop data centric tools required for client deliverables or process automation using Python, Shell scripts, or other approved methods.
• Develop visualizations in PowerBI and Tableau to gain insights from data.
  • Design wireframes that are appealing to the user with RE Tech standards.
  • Build interactive, multifaceted reports and dashboards that utilize filters and relationships between metrics and visuals, based on an approved design.
  • Effectively communicate dashboard/visual content to an internal audience, including development of verbiage and/or scripts to present products.
  • Publish reports, dashboards, and applications to internal and external audiences, with minimal guidance.
• Generate timely deliverables with high data quality by validating data & metrics calculations, surfacing quality issues, documenting metadata, and remediating data quality issues.
• Ensure work always aligns with team priorities as determined by supervisor.
• Timely and accurate work and project status reporting as requested.
• Demonstrate Quality Assurance process expertise and adherence to process. Continuously monitor and evaluate data quality to ensure accuracy and completeness.
• Create new documentation and proofread existing documentation with the goal of improving when needed.
• Tracks and contributes to SOPs including review process and updates.
• Guide/ mentor junior analysts on standards, best practices, and advanced analytics techniques. Assist in managing the training requirements and administers training as needed. Providing follow-up to ensure all training is completed 100%.
• Work closely with Web development team supporting web app development activities, ETL processes, and other data and analytics needs.
• Work closely with ESG teams to support client deliverables and timelines.
• Collaborate with other teams to develop and implement data-driven solutions.
• Submit timesheets and expenses accurately and on time.
• Possess a growth mindset seeking continuous improvement and supporting a culture of learning, growing, and improving as an individual, our team members, our business, and our client work.
• Possess sound business ethics, including the protection of proprietary and confidential information. 

Essential Knowledge, Skills and Abilities

• Demonstrated experience and proficiency with data collection, data wrangling, visualizations, and ETL.
• Strong capabilities in generating and facilitating insights through visualizations utilizing Tableau or PowerBI.
• Demonstrated experience and proficiency in creating and maintaining analytics automation processes and workflows using Alteryx. Strong experience and advanced skills in Excel and advanced SQL. Strong programming skills at an advanced level (Python, Shell scripts, etc.).
• Very strong problem-solving skills
• Strong analytical modeling (prescriptive, diagnostic, and predictive) skills.
• Proficiency in SharePoint and other Microsoft Office suite of products. Understanding of fundamentals and experience with cloud (Azure, Snowflake, etc.) technologies and databases (RDBMS).
• Demonstrated expertise in estimating level of effort and setting realistic and reasonable timelines.
• Demonstrated leadership skills and capabilities, both technical and interpersonal.
• Demonstrated ability to coordinate, multitask and prioritize to align with and achieve team goals.
• Demonstrated propensity to take ownership of complex items (questions, issues, processes, etc.) and work towards collaborative solutions and closure.
• Must be well-organized, attentive to detail and efficient.
• Experience successfully training others with processes and standard practices.
• Demonstrated strength in ability to be flexible and adapt to a changing landscape and client needs, handle multiple time-sensitive priorities, excel in a fast-paced environment, and ability to pivot and adjust priorities and approaches.
• Strong communication skills; communicate complex data findings in a clear and concise manner.
• Possesses excellent interpersonal skills including courtesy, professionalism, and a cooperative attitude.
• Ability to manage and handle challenging interpersonal situations, including employee and client relationships.
• Possesses good written communication skills with a propensity to write in a clear, concise manner to convey points effectively, creatively, and with the appropriate tone and professionalism.
• Possesses strong verbal communication skills to effectively interact with and build confidence with internal and external contacts, including public speaking.
• Possesses initiative, proactiveness, drive, enthusiasm, energy, and follow through.

Required Education and/or Experience 

• Undergraduate degree in data analytics, mathematics, statistics, engineering or equivalent field, or equivalent experience. Master’s degree is a plus.
• 3 – 4 years of work experience in data analytics.

Preferred Eligibility Qualifications

• Experience supporting sustainability, ESG, energy and/or decarbonization programs
• Experience with ESG data collection and benchmarking with ENERGY STAR Portfolio Manager.
• Experience in a client facing consulting role, delivering professional services, and building relationships across clients and internal teams.
• Demonstrated experience with ENERGY STAR Portfolio Manager a plus, but not required.
• Relevant certifications.

Physical Demands

While performing the duties of this job, the employee is regularly required to sit; use hands to finger, handle, or feel; reach with hands and arms; and talk or hear. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Travel Requirements 

Periodic travel is required for the role. Travel may include travel to RE Tech offices, if remote, or between RE Tech offices (Fairfax, VA and Dallas, Texas) for meetings (estimate of four times per year), as well as for Legence and/or client business needs.

Additional Requirements

In compliance with Federal law and the Federal Acquisition Regulation (FAR) 22.1800, the selected candidate will be required to provide documentation that will verify their identity and eligibility to work in the United States.

#LI-AC1 #LI-Hybrid

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.

Benefits Overview
Health & Welfare: Company Paid medical, dental, vision, prescription drug, accident & sickness benefit, basic group life and AD&D, and Employee Assistance Program
Time Off Benefits: Paid vacation, company-paid holidays, and paid sick leave
Financial Benefits: 401(k) retirement savings plan

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.

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