Esg Data Analyst - Re Tech Advisors

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.

RE Tech is seeing a highly motivated ESG Data Analyst to support our real estate client sustainability programs. The position serves as analytical, technical, and project support for RE Tech’s growing data management, analytics, and business intelligence platform and services. Our data services team helps real estate professionals, institutional investors, and an array of other stakeholders to better monitor and manage costs, make informed investment and operational decisions, mitigate risk, and progress toward energy and sustainability goals. Our data platform includes, but is not limited to, the following technologies: SQL Server, Power BI, Tableau, Python, and Alteryx.

The positoin is based out of our Tysons Corner, Virginia (13 miles west of Washington, D.C.) or our Dallas, Texas Office. After a successful onboarding period, the positoin is open to a hybrid work model that includes a mix of in office and work from home, and open to flex work scheduling. We may consider remote work for a highly qualified candidate with experience working remotely on a consistent basis.

Essential Job Functions / Job Duties And Responsibilities

• Intermediate level of proficiency in collaborating with cross-functional teams to understand business needs and develop data driven solutions.
• Design and implement accurate, meaningful analysis using sound techniques and approaches.
• High level of proficiency in coaching and mentoring junior analysts to improve their skills and performance.
• Publish reports, dashboard, and applications to internal and external audiences, with guidance as needed.
• Identify and apply appropriate formulas and statistical techniques.
• Intermediate level of proficiency in identifying opportunities for process improvements for recommendation to the data team technical lead.
• Perform all other duties as needed and assigned.
• Intermediate level of proficiency in performing data management activities:
• Build interactive, multifaceted reports and dashboards that utilize filters and relationships between metrics and visuals, based on an approved design.
• Design an effective data model for a project task with guidance from the Data Analytics Manager.
• Intermediate to High level of proficiency in creating data visualization and dashboards with Tableau or PowerBIas follows:
• Effectively communicate dashboard/visual content to an internal audience, including development of verbiage and/or scripts to present products.
• Develop intermediate to advanced SQL code, such as nested queries, merge statements, and different functions in SQL.
• High level of proficiency in ensuring that data analysis and reporting is accurate, timely, and meets business requirements.
• Work with data sources or equivalent in Alteryx or other workflow tools such as Python or SQL.
• Support ESG Programs team as needed.
• Properly and accurately track all your time worked and expenses. Input on time in the expense and time keeping system, billing to the correct codes, and using the correct labor categories.
• Intermediate level of proficiency in supporting and developing internal data centric tools required for client deliverables:
• High level of proficiency in creating and maintaining documents associated with any development and support activities.
• Intermediate level of proficiency in estimating the level of effort to complete tasks.

Essential Knowledge, Skills, And Abilities

• Intermediate to high level of proficiency in analytical, problem-solving, and decision-making capabilities. Strong attention to detail in your work and work produced by more junior team members.
• Intermediate level of proficiency and knowledge with SQL.
• 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.
• Intermediate level of proficiency in determining which visuals (such as data layouts, graphics, dashboards, etc.) are more effective than others for communicating results and data – have a design with audience and UX in mind mindset.
• High level of proficiency with online collaboration and file sharing tools, such as SharePoint and the Microsoft Office Suite (MS Word, Excel, PowerPoint, Outlook, Teams).
• 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
• Entry to Intermediate level of proficiency in Python or Alteryx
• Intermediate to high level of proficiencyto effectively develop measures, calculated columns, and data sets. Be able to communicate the difference between measures and calculated columns, and where to use them (or Tableau equivalent)
• 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.
• Possesses good 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.
• Possesses excellent interpersonal skills including courtesy, professionalism, and a cooperative attitude. Ability to manage challenging interpersonal situations, including employee and client relationships.
• Intermediate level of proficiency in the ability to collaborate internally and externally to co-create successful outcomes.
• Possess sound business ethics, including the protection of proprietary and confidential information.
• Intermediate level of proficiency in determining the rationale for selecting specific approaches used in queries, stored procedures, and views (e.g., update vs. insert vs. merge, join types).

Required Education And/or Experience

• Demonstrated experience with generating insights through visualizations utilizing Tableau or PowerBI.
• Demonstrated experience with data collection, data wrangling, and ETL.
• 1 - 2 years of work experience in data analytics

Additional Preferred Experience

• 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.
• Experience with ESG data collection and benchmarking with ENERGY STAR Portfolio Manager.
• Experience supporting sustainability, ESG, energy and/or decarbonization programs

Work Environment

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 may be required for the role. Travel may include travel to RE Tech offices, if remote, or between RE Tech offices (Tysons Corner, VA and Dallas, Texas) for meetings (estimate of four times per year), as well as for Legence and/or client business needs.

Health And Welfare Benefits

• Health and Welfare
• Vision
• Employee assistance program
• Prescription drug
• Medical
• Maternity and parental leave
• Dental

Personal Benefits

• Company-paid holidays
• Voting leave
• Volunteer time off
• Flexible/hybrid work schedule
• Jury duty
• Paid vacation
• Annual professional development fund
• Bereavement leave

Financial Benefits

• Company-paid long-term and short-term disability insurance
• AD&D insurance
• Life insurance
• One-time home office bonus
• 401(k) retirement savings plan

Office perks

• Free on-site parking
• Metro accessible office (Tysons Corner, Virginia office, Silver Line)
• Snacks, coffee and Bevi drink machine
• Dog friendly office (Dallas, Texas office)
• Free on-site gym (Tysons Corner, Virginia office)
• Regular social activities

About Legence

Legence, a Blackstone portfolio company, is an Energy Transition Accelerator™ that provides advisory services and implementation focused on financing, designing, building, and servicing complex systems in mission-critical and high performance facilities. With five decades of expertise in the built environment, Legence has a proven track record of reducing carbon emissions, implementing renewables, lowering utility costs through efficiency consumption, and making systems run better at unmatched speed and scale. To learn more about Legence and its services, visit https://www.wearelegence.com/ .

Contingent Employment Statement

Offers of employment for this role may be contingent upon successfully passing a background check and/or drug screen. Execution of screens will vary based on role requirements and Company policy. All background checks and drug screens will be done in accordance with applicable federal, state, or local law.

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), parental 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

Reasonable Accommodations

If you require assistance applying online, email [email protected] . Please include a description of the specific accommodations you are requesting as well as the job title and requisition number of the position for which you are applying. If you are selected for an interview, please notify your recruiter of your accommodation needs. All efforts to provide reasonable accommodations will be made.

To all recruitment agencies

Legence and its affiliate companies do not accept unsolicited agency resumes. Do not forward resumes to our career’s alias or employees of Legence and/or its affiliate companies. Legence and/or its affiliate companies are not responsible for any fees related to unsolicited resumes. Any third-party recruiting agreements for Legence and its affiliate companies may only be executed by Legence Holdings LLC’s CHRO or Director of Talent Acquisition, without exception. All others are done without proper authorization and will not be honored. We will not be responsible for any fees under any third-party recruiting agreement not executed by said authority.

Apply Now