Title: Database Analyst Duration: 6 months, Potential to convert to FTE Hybrid 3 days/week (candidate's choice) Location: New York, NY
Resource's typical working day:
Managing the data flow from buildings into online platforms and analyzing the data to find energy savings
Analyzing invoices
Regulatory invoices
Years of Experience needed:
2-3 years
Systems/Software proficiencies:
Excel, air table, Tableau
Top Must have Skills:
Data management
Data organization
Top Nice to have Skills:
Tableau
Understand building engineering data
Interview Process:
2 round, both virtual
JOB SUMMARY:
The purpose of this position is the primary data, analytics & reporting of energy and sustainability initiatives on a global basis for a region or account or within a client’s enterprise client account. This role delivers actionable insights from environmental & utility data and assists in the deployment & management of a comprehensive E&S Program.
ESSENTIAL DUTIES AND RESPONSIBILITIES:
Work closely with Energy and Sustainability Team and on-site staff in all levels of organization to meet goals set by the client.
Work and coordinate with client’s Energy and Sustainability platform to enhance current service offerings.
Collect and analyze monthly utility data, i.e., electricity, water, sewer, natural gas, oil and waste data with commentary on actual usage versus expected usage, coordinate with appropriate stakeholders to explain meaningful variances. Ensure detailed investigation of significant variances are undertaken to ensure root cause is well understood and communicated. Review utility bills for accuracy and verify that they comply with the associated rates and tariffs.
Prepare and analyze monthly utility data and review with Energy Manager to validate normalized savings, develop exception reports for senior management, explanation of potential variances and year-over-year trends. Monitor and track, carbon, water use and waste diversion rates, spending trends.
Assist in the annual disclosure process, including timely and accurate initial preparation of monthly, quarterly, annual GHG inventory, and regional regulatory filings, catalogues supporting data for audit, and solicits commentary as necessary.
Develop dashboard to coordinate energy and sustainability initiatives, monitor compliance, analyze, and communicate externally facing reporting as required.
Review consumption data and validate energy, cost, or carbon savings resulting from operational programs which curtail energy consumption.
Support the client’s leadership with status reports as required outlining progress against carbon, energy, water and waste goals.
Compare collected data against industry benchmarks and prepare reports of findings.
Review all data inputs to ensure the accuracy and timely submission of required reports. Ensure that errors are corrected within the appropriate time frame and are escalated properly.
Assist in the development, implementation and subsequent monitoring of systems and processes to ensure data accuracy.
Develop, recommend, and implement continuous improvement strategies to improve data ingestion, quality, timelessness, required data transformations and more such that client environmental, consumption and financial data is comparable, accurate and timely. Transformations would include, units, time periods, carbon factors and more to provide a common basis of analysis. Provide feedback on process improvements needed for quality in service delivery.
Identify skills required to ensure that tasks are completed, and proper training is provided.
Other duties as assigned. SUPERVISORY RESPONSIBILITIES:
No formal supervisory responsibilities in this position. Provides informal assistance such as technical guidance, and/or training to coworkers. May lead project teams and/or plan, and supervise assignments of lower-level employees.
QUALIFICATIONS:
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Knowledge of the corporate real estate outsourcing industry, knowledge of operational sustainability including industry trends and major public ESG initiatives.
Data science, computer science experience preferred.
A successful applicant must have strong skills in the following areas/categories: advanced project management, strong client-facing communications, experience in data modeling and relational databases, Tableau expertise.
EDUCATION and EXPERIENCE:
Bachelor's degree highly preferred
Bachelor’s degree (BA/BS) from four-year college or university.
Minimum of three years of related experience and/or training
CERTIFICATES and/or LICENSES:
Energy and Sustainability related certifications and/or licenses a plus
Training and accreditation may be part of development and performance management requirements.
COMMUNICATION SKILLS:
Excellent written and verbal communication skills
Strong organizational and analytical skills
Ability to provide efficient, timely, reliable, and courteous service to customers.
Ability to effectively present information.
Ability to respond effectively to sensitive issues
FINANCIAL KNOWLEDGE:
Accounting, accruals, budget/reforecast, and variance analysis
Requires knowledge of financial terms and principles. Conducts intermediate financial analysis. Ability to calculate intermediate figures such as percentages, discounts, and averages.
REASONING ABILITY:
Ability to comprehend, analyze, and interpret complex business documents. Possess excellent writing skills for reports, manuals, speeches, articles, and communications using distinctive styles and various delivery methods.
Ability to respond effectively to complex inquiries or complaints from clients, co-workers, supervisor, and/or management.
Ability to make effective presentations on complex topics to an internal department, large group of employees, clients, and/or management. Ability to motivate and negotiate effectively with client groups to take desired action.
OTHER SKILLS and ABILITIES:
Carbon footprint reporting experience or training preferred. Advanced skills in Microsoft Excel, Intermediate skills with remainder of MS Office Suite. Ability to learn and utilize applications such as Capturis, ENEL X, Energy Star Portfolio Manager, and Tableau.
SCOPE OF RESPONSIBILITY:
Decisions made with understanding of procedures, company policies, and business practices to achieve general results and deadlines.
Errors in judgment may cause long-term impact to coworkers, supervisor, department and/or line of business.
About Us: SPECTRAFORCE is one of the fastest-growing workforce solutions firms in the United States. As a diversity-owned business, we place human connection at the heart of everything we do, building strong relationships with both clients and candidates to fill roles successfully. Our teams in North and Central America and India serve more than 150 Fortune clients globally, leveraging custom AI technology to provide direct hire, executive search, nearshoring, offshoring, and project staffing solutions.
Benefits: SPECTRAFORCE offers ACA compliant health benefits as well as dental, vision, accident, critical illness, voluntary life, and hospital indemnity insurances to eligible employees. Additional benefits offered to eligible employees include commuter benefits, 401K plan with matching, and a referral bonus program. SPECTRAFORCE provides unpaid leave as well as paid sick leave when required by law.
Equal Opportunity Employer: SPECTRAFORCE is an equal opportunity employer and does not discriminate against any employee or applicant for employment because of race, religion, color, sex, national origin, age, sexual orientation, gender identity, genetic information, disability or veteran status, or any other category protected by applicable federal, state, or local laws. Please contact Human Resources at LOA@spectraforce.com if you require reasonable accommodation.
California Applicant Notice: SPECTRAFORCE is committed to complying with the California Privacy Rights Act (“CPRA”) effective January 1, 2023; and all data privacy laws in the jurisdictions in which it recruits and hires employees. A Notice to California Job Applicants Regarding the Collection of Personal Information can be located on our website. Applicants with disabilities may access this notice in an alternative format by contacting NAHR@spectraforce.com.
LA County, CA Applicant Notice: If you are selected for this position with SPECTRAFORCE, your offer is contingent upon the satisfactory completion of several requirements, including but not limited to, a criminal background check. We consider qualified applicants with arrest or conviction records for employment in accordance with all local ordinances and state laws, including the Los Angeles County Fair Chance Ordinance for Employers (FCO) and the California Fair Chance Act (FCA). The background check assessment will consider whether a criminal history could reasonably have a direct, adverse impact on the job-related safety, security, trust, regulatory compliance, or suitability for this role. Such findings may result in withdrawal of a conditional job offer.
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $30.00/hr.
