SEM Data Analyst
CLEAResult · Rhode Island, United States · 1 mo ago
$52k–$74k/yrFull-time
We need to output HTML fragment with sections using for headings: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. Only include sections that have real specific content. We need to parse the job posting.
First, identify content:
- Intro about CLEAResult mission, culture, benefits: "At CLEAResult, we lead the transition... Additionally, You Will Enjoy Medical, Dental, and Vision Insurance; we also offer a company-paid health care concierge service... 401(k) with company match Paid vacation, sick, personal and parental leave time Paid Volunteer Time... Employee Recognition Program – convert your recognition points into gift cards Employee Assistance Program – offers benefits to help you manage daily responsibilities Access to on-demand training courses to advance further in your career". That's benefits.
- Job Description: "We are looking for a talented individual… To join our team! CLEAResult's Strategic Energy Management (SEM) team is expanding, and we have a new opportunity for a Data Analyst to help power the work of our SEM experts across the US and Canada. If you love digging into data, spotting patterns others miss, and building the tools and templates that make a whole program run smoother, this is a great place to make an impact. As a Data Analyst, you'll be the engine behind the scenes for our Statistical Analysts and SEM program teams across North America, supporting energy modeling, standardizing processes, and keeping our data clean, consistent, and ready to drive real decisions. This role is primarily internally facing and centered on data analysis, with occasional interaction with clients and end-use customers to gather data or answer questions. You'll play a central role in bringing consistency and efficiency to how our SEM teams work internationally, directly supporting the accuracy and quality of the models and reports our program depends on. Here at CLEAResult, you will fit right in with our energetic team if you are resourceful, resilient, and kind."
That's about the role.
- Then "In this role, you will…" list of duties: bullet list (but they are separated by periods). We need to extract list items.
List:
- Perform pre- and post-modeling data review and manipulation to support our Statistical Analysts.
- Manipulate and format production data with precision and consistency.
- Analyze large data sets to catch errors and ensure accuracy before it moves downstream.
- Integrate data into statistical software templates.
- Collaborate with internal and external teams to build and maintain database files.
- Partner with program teams across the organization to create and maintain standardized templates for energy modeling and program data.
- Write clear work instructions for newly developed templates, so others can pick them up with ease.
- Track, draft, edit, and quality-control final models and reports.
- Help automate data processing to save time and reduce manual error.
- Troubleshoot, modify, and build tools using Visual Basic and Excel formulas.
- Manage and manipulate data in Smartsheet.
- Support benchmarking reporting and contribute to the development of our digital infrastructure.
- Then "For this exciting career opportunity, you're a great fit if you have…" list of qualifications/requirements:
List:
- Strong data manipulation and formatting skills, with an eye for consistency and detail
- Experience analyzing large, complex data sets
- Comfort working with statistical software and templates
- Proficiency in Visual Basic and advanced Excel formulas
- Experience with Smartsheet
- SharePoint experience
- A collaborative mindset, comfortable working across internal teams and occasionally with external clients and customers
- Energy industry experience preferred, but not required
- Then note about sponsorship not available.
- Then note to candidates about encouraging applications.
- Then DOT Requirements: "If applicable, meet all DOT qualification requirements and comply with all applicable federal, state, and local transportation regulations."
- Compensation Range: "$52,000.00 - $74,400.00 Currency USD Type Salary Any offered salary is determined based on internal equity, internal salary ranges, market data/ranges, applicant’s skills and prior relevant experience, certain degrees and certifications (e.g. JD/technology), for example. CLEAResult will not provide sponsorship or support for immigration status or work authorization including for international students. Applicants must be authorized to work in the country where the position is located without the need for employer sponsorship or support. Successful hires must pass pre-employment checks."
- Equal Opportunity Employer boilerplate (should be removed as per instructions: remove EEO/equal-opportunity boilerplate). So we should not include that.
- Also "The above job description and job requirements are not intended to be all inclusive. CLEAResult retains the right to make changes or adjustments to job descriptions and/or requirements at any time without notice." That's boilerplate; remove.
We need sections: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule.
We need to decide what goes where.
- About the role: could be the introductory paragraph describing role purpose, team, etc. Use the paragraph(s) before "In this role, you will…" maybe.
- Responsibilities: the list of duties ("In this role, you will…").
- Requirements: maybe the DOT requirements? Or maybe "Requirements" could be the mandatory items like sponsorship not available, DOT, work authorization, pre-employment checks. But we need to see if there is specific content for Requirements. The posting includes "Please note: sponsorship is not available for this position at this time." and "DOT Requirements If applicable, meet all DOT qualification requirements and comply with all applicable federal, state, and local transportation regulations." Also "Applicants must be authorized to work in the country where the position is located without the need for employer sponsorship or support. Successful hires must pass pre-employment checks." Those could be considered requirements.
- Qualifications: maybe the list of qualifications/experience (strong data manipulation, etc.)? Or we could treat that as Qualifications.
- Skills: maybe the specific technical skills: Visual Basic, Excel formulas, Smartsheet, SharePoint, statistical software, etc.
- Benefits: the benefits paragraph.
- Pay: compensation range.
- Schedule: not mentioned; we should not include Schedule section if no specific content.
We must not create sections with filler like "not specified". So omit Schedule.
We also need to avoid repeating job title as heading; we won't.
We need to output only HTML fragment, no /, no markdown.
We need to use
for headings: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. Only include sections that have real specific content. We need to parse the job posting.
First, identify content:
- Intro about CLEAResult mission, culture, benefits: "At CLEAResult, we lead the transition... Additionally, You Will Enjoy Medical, Dental, and Vision Insurance; we also offer a company-paid health care concierge service... 401(k) with company match Paid vacation, sick, personal and parental leave time Paid Volunteer Time... Employee Recognition Program – convert your recognition points into gift cards Employee Assistance Program – offers benefits to help you manage daily responsibilities Access to on-demand training courses to advance further in your career". That's benefits.
- Job Description: "We are looking for a talented individual… To join our team! CLEAResult's Strategic Energy Management (SEM) team is expanding, and we have a new opportunity for a Data Analyst to help power the work of our SEM experts across the US and Canada. If you love digging into data, spotting patterns others miss, and building the tools and templates that make a whole program run smoother, this is a great place to make an impact. As a Data Analyst, you'll be the engine behind the scenes for our Statistical Analysts and SEM program teams across North America, supporting energy modeling, standardizing processes, and keeping our data clean, consistent, and ready to drive real decisions. This role is primarily internally facing and centered on data analysis, with occasional interaction with clients and end-use customers to gather data or answer questions. You'll play a central role in bringing consistency and efficiency to how our SEM teams work internationally, directly supporting the accuracy and quality of the models and reports our program depends on. Here at CLEAResult, you will fit right in with our energetic team if you are resourceful, resilient, and kind."
That's about the role.
- Then "In this role, you will…" list of duties: bullet list (but they are separated by periods). We need to extract list items.
List:
- Perform pre- and post-modeling data review and manipulation to support our Statistical Analysts.
- Manipulate and format production data with precision and consistency.
- Analyze large data sets to catch errors and ensure accuracy before it moves downstream.
- Integrate data into statistical software templates.
- Collaborate with internal and external teams to build and maintain database files.
- Partner with program teams across the organization to create and maintain standardized templates for energy modeling and program data.
- Write clear work instructions for newly developed templates, so others can pick them up with ease.
- Track, draft, edit, and quality-control final models and reports.
- Help automate data processing to save time and reduce manual error.
- Troubleshoot, modify, and build tools using Visual Basic and Excel formulas.
- Manage and manipulate data in Smartsheet.
- Support benchmarking reporting and contribute to the development of our digital infrastructure.
- Then "For this exciting career opportunity, you're a great fit if you have…" list of qualifications/requirements:
List:
- Strong data manipulation and formatting skills, with an eye for consistency and detail
- Experience analyzing large, complex data sets
- Comfort working with statistical software and templates
- Proficiency in Visual Basic and advanced Excel formulas
- Experience with Smartsheet
- SharePoint experience
- A collaborative mindset, comfortable working across internal teams and occasionally with external clients and customers
- Energy industry experience preferred, but not required
- Then note about sponsorship not available.
- Then note to candidates about encouraging applications.
- Then DOT Requirements: "If applicable, meet all DOT qualification requirements and comply with all applicable federal, state, and local transportation regulations."
- Compensation Range: "$52,000.00 - $74,400.00 Currency USD Type Salary Any offered salary is determined based on internal equity, internal salary ranges, market data/ranges, applicant’s skills and prior relevant experience, certain degrees and certifications (e.g. JD/technology), for example. CLEAResult will not provide sponsorship or support for immigration status or work authorization including for international students. Applicants must be authorized to work in the country where the position is located without the need for employer sponsorship or support. Successful hires must pass pre-employment checks."
- Equal Opportunity Employer boilerplate (should be removed as per instructions: remove EEO/equal-opportunity boilerplate). So we should not include that.
- Also "The above job description and job requirements are not intended to be all inclusive. CLEAResult retains the right to make changes or adjustments to job descriptions and/or requirements at any time without notice." That's boilerplate; remove.
We need sections: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule.
We need to decide what goes where.
- About the role: could be the introductory paragraph describing role purpose, team, etc. Use the paragraph(s) before "In this role, you will…" maybe.
- Responsibilities: the list of duties ("In this role, you will…").
- Requirements: maybe the DOT requirements? Or maybe "Requirements" could be the mandatory items like sponsorship not available, DOT, work authorization, pre-employment checks. But we need to see if there is specific content for Requirements. The posting includes "Please note: sponsorship is not available for this position at this time." and "DOT Requirements If applicable, meet all DOT qualification requirements and comply with all applicable federal, state, and local transportation regulations." Also "Applicants must be authorized to work in the country where the position is located without the need for employer sponsorship or support. Successful hires must pass pre-employment checks." Those could be considered requirements.
- Qualifications: maybe the list of qualifications/experience (strong data manipulation, etc.)? Or we could treat that as Qualifications.
- Skills: maybe the specific technical skills: Visual Basic, Excel formulas, Smartsheet, SharePoint, statistical software, etc.
- Benefits: the benefits paragraph.
- Pay: compensation range.
- Schedule: not mentioned; we should not include Schedule section if no specific content.
We must not create sections with filler like "not specified". So omit Schedule.
We also need to avoid repeating job title as heading; we won't.
We need to output only HTML fragment, no /, no markdown.
We need to use for section headings, - for lists,
for prose.
We need to preserve all substantive information; do not invent or summarize away detail.
We need to remove boilerplate: cookie/navigation/legal/EEO/equal-opportunity/scam-warning, duplicated lines, application instructions. Also remove the Equal Opportunity Employer paragraph and the "The above job description..." paragraph.
Also remove the note about sponsorship not available? That is not boilerplate; it's a specific requirement. Keep it.
Also remove the "Note To Candidates" encouraging applications? That's not boilerplate but could be considered encouraging; it's substantive? It's a note to candidates about diversity. Might be considered EEO-related but it's encouraging applications; not exactly boilerplate but could be considered part of EEO. The instruction says remove EEO/equal-opportunity/... boilerplate. The note about encouraging applications is related to EEO; might be considered boilerplate. Safer to remove it? The instruction: "Remove cookie/navigation/legal/EEO/equal-opportunity/scam-warning boilerplate, duplicated lines, and application instructions." The note to candidates is not exactly EEO boilerplate but it's encouraging applications; it's not an application instruction. It's a note about encouraging underrepresented groups. Might be considered EEO-related. I'd remove it to be safe.
Also remove "Please note: sponsorship is not available for this position at this time." That's not EEO; it's a requirement. Keep.
Also remove "CLEAResult will not provide sponsorship or support for immigration status or work authorization including for international students." That's in compensation paragraph; it's a requirement; keep.
Now structure:
About the role
... (prose)
Responsibilities
- ... each duty
Requirements
... maybe combine sponsorship not available, DOT, work authorization, pre-employment checks.
Qualifications
- ... list of qualifications/experience
Skills
- ... list of technical skills
Benefits
... benefits paragraph
Pay
... compensation range and details
We must not include Schedule.
Now we need to extract precise prose for About the role.
From the text: "At CLEAResult, we lead the transition to a sustainable, equitable, and carbon-neutral energy-efficient future for our communities and our planet. We do that by creating a people-first culture built on trust, accountability, and transparency; where every employee – regardless of position, role, or identity is treated with respect and given an equal chance to thrive." That's about company mission/culture.
Then after that: "Additionally, You Will Enjoy Medical, Dental, and Vision Insurance; we also offer a company-paid health care concierge service to help navigate our health plan to make the best decisions for you and yours 401(k) with company match Paid vacation, sick, personal and parental leave time Paid Volunteer Time: giving back to our communities is important to us Employee Recognition Program – convert your recognition points into gift cards Employee Assistance Program – offers benefits to help you manage daily responsibilities Access to on-demand training courses to advance further in your career". That's benefits; we will put under Benefits.
Then "Job Description We are looking for a talented individual… To join our team! CLEAResult's Strategic Energy Management (SEM) team is expanding, and we have a new opportunity for a Data Analyst to help power the work of our SEM experts across the US and Canada. If you love digging into data, spotting patterns others miss, and building the tools and templates that make a whole program run smoother, this is a great place to make an impact. As a Data Analyst, you'll be the engine behind the scenes for our Statistical Analysts and SEM program teams across North America, supporting energy modeling, standardizing processes, and keeping our data clean, consistent, and ready to drive real decisions. This role is primarily internally facing and centered on data analysis, with occasional interaction with clients and end-use customers to gather data or answer questions. You'll play a central role in bringing consistency and efficiency to how our SEM teams work internationally, directly supporting the accuracy and quality of the models and reports our program depends on. Here at CLEAResult, you will fit right in with our energetic team if you are resourceful, resilient, and kind."
That's about the role. We'll put that as About the role.
Now Responsibilities: list as above.
Now Requirements: combine:
- "Please note: sponsorship is not available for this position at this time."
- "DOT Requirements If applicable, meet all DOT qualification requirements and comply with all applicable federal, state, and local transportation regulations."
- "Applicants must be authorized to work in the country where the position is located without the need for employer sponsorship or support."
- "Successful hires must pass pre-employment checks."
- Also "CLEAResult will not provide sponsorship or support for immigration status or work authorization including for international students." (from compensation paragraph)
We could combine into a paragraph.
Now Qualifications: list of qualifications/experience:
- Strong data manipulation and formatting skills, with an eye for consistency and detail
- Experience analyzing large, complex data sets
- Comfort working with statistical software and templates
- Proficiency in Visual Basic and advanced Excel formulas
- Experience with Smartsheet
- SharePoint experience
- A collaborative mindset, comfortable working across internal teams and occasionally with external clients and customers
- Energy industry experience preferred, but not required
Now Skills: maybe we separate technical skills: Visual Basic
- for lists,
for prose. We need to preserve all substantive information; do not invent or summarize away detail. We need to remove boilerplate: cookie/navigation/legal/EEO/equal-opportunity/scam-warning, duplicated lines, application instructions. Also remove the Equal Opportunity Employer paragraph and the "The above job description..." paragraph. Also remove the note about sponsorship not available? That is not boilerplate; it's a specific requirement. Keep it. Also remove the "Note To Candidates" encouraging applications? That's not boilerplate but could be considered encouraging; it's substantive? It's a note to candidates about diversity. Might be considered EEO-related but it's encouraging applications; not exactly boilerplate but could be considered part of EEO. The instruction says remove EEO/equal-opportunity/... boilerplate. The note about encouraging applications is related to EEO; might be considered boilerplate. Safer to remove it? The instruction: "Remove cookie/navigation/legal/EEO/equal-opportunity/scam-warning boilerplate, duplicated lines, and application instructions." The note to candidates is not exactly EEO boilerplate but it's encouraging applications; it's not an application instruction. It's a note about encouraging underrepresented groups. Might be considered EEO-related. I'd remove it to be safe. Also remove "Please note: sponsorship is not available for this position at this time." That's not EEO; it's a requirement. Keep. Also remove "CLEAResult will not provide sponsorship or support for immigration status or work authorization including for international students." That's in compensation paragraph; it's a requirement; keep. Now structure:
About the role
... (prose)
Responsibilities
- ... each duty
Requirements
... maybe combine sponsorship not available, DOT, work authorization, pre-employment checks.
Qualifications
- ... list of qualifications/experience
Skills
- ... list of technical skills
Benefits
... benefits paragraph
Pay
... compensation range and details
We must not include Schedule. Now we need to extract precise prose for About the role. From the text: "At CLEAResult, we lead the transition to a sustainable, equitable, and carbon-neutral energy-efficient future for our communities and our planet. We do that by creating a people-first culture built on trust, accountability, and transparency; where every employee – regardless of position, role, or identity is treated with respect and given an equal chance to thrive." That's about company mission/culture. Then after that: "Additionally, You Will Enjoy Medical, Dental, and Vision Insurance; we also offer a company-paid health care concierge service to help navigate our health plan to make the best decisions for you and yours 401(k) with company match Paid vacation, sick, personal and parental leave time Paid Volunteer Time: giving back to our communities is important to us Employee Recognition Program – convert your recognition points into gift cards Employee Assistance Program – offers benefits to help you manage daily responsibilities Access to on-demand training courses to advance further in your career". That's benefits; we will put under Benefits. Then "Job Description We are looking for a talented individual… To join our team! CLEAResult's Strategic Energy Management (SEM) team is expanding, and we have a new opportunity for a Data Analyst to help power the work of our SEM experts across the US and Canada. If you love digging into data, spotting patterns others miss, and building the tools and templates that make a whole program run smoother, this is a great place to make an impact. As a Data Analyst, you'll be the engine behind the scenes for our Statistical Analysts and SEM program teams across North America, supporting energy modeling, standardizing processes, and keeping our data clean, consistent, and ready to drive real decisions. This role is primarily internally facing and centered on data analysis, with occasional interaction with clients and end-use customers to gather data or answer questions. You'll play a central role in bringing consistency and efficiency to how our SEM teams work internationally, directly supporting the accuracy and quality of the models and reports our program depends on. Here at CLEAResult, you will fit right in with our energetic team if you are resourceful, resilient, and kind." That's about the role. We'll put that as About the role. Now Responsibilities: list as above. Now Requirements: combine: - "Please note: sponsorship is not available for this position at this time." - "DOT Requirements If applicable, meet all DOT qualification requirements and comply with all applicable federal, state, and local transportation regulations." - "Applicants must be authorized to work in the country where the position is located without the need for employer sponsorship or support." - "Successful hires must pass pre-employment checks." - Also "CLEAResult will not provide sponsorship or support for immigration status or work authorization including for international students." (from compensation paragraph) We could combine into a paragraph. Now Qualifications: list of qualifications/experience: - Strong data manipulation and formatting skills, with an eye for consistency and detail - Experience analyzing large, complex data sets - Comfort working with statistical software and templates - Proficiency in Visual Basic and advanced Excel formulas - Experience with Smartsheet - SharePoint experience - A collaborative mindset, comfortable working across internal teams and occasionally with external clients and customers - Energy industry experience preferred, but not required Now Skills: maybe we separate technical skills: Visual Basic