Job Description Summary

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.

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

Job Description

We are looking for a talented individual

To join our team! CLEAResult’s Strategic Energy Management (SEM) team is expanding, and has a new opportunity for the position of Data Analyst.

As a Data Analyst, you will help support talented teams of SEM experts across the US and Canada; this position helps facilitate energy modeling and data processing for all SEM teams across North America.

This role is focused on data analysis and is primarily internally facing; there will occasionally be interactions with clients and end use customers to acquire data and answer questions.

The scope of this position will be the primary supporting function for the Statistical Analyst and process standardization for the international SEM program teams.

Data Analysts will perform the pre- and post-modeling data review and manipulation for the Statistical Analysts, benchmarking reporting, and assisting in the development of our digital infrastructures.

Here at CLEAResult, you will fit right in with our energetic team if you are resourceful, resilient, and kind.

For this exciting career opportunity, you’re a great fit if you can

• Production data manipulation and formatting
• Analyzing large data sets for consistency and errors
• Integration of data into statistical software templates
• Collaborate with internal and external teams to maintain database files
• Collaborate with all program teams to create and maintain standardized templates for energy modeling and program data
• Create work instructions for newly created templates
• Final model and report tracking, drafting, editing, and QC
• Data processing automation
• Visual basic and excel formula troubleshooting, modification, and creation
• Smartsheet data manipulation
• SharePoint experience
• Energy experience preferred

Additional Job Description

CLEAResult continues to be committed to the health and safety of all employees, customers, partners and the communities we serve.

As we prioritize hiring of talent for essential positions that meet the critical needs of our customers, we intend to continue supporting the fight to end the pandemic.

Employees’ health and safety while meeting client expectations remains our top priority.

Looking for a way to make an impact and help people?

PacificSource is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to status as a protected veteran or a qualified individual with a disability, or other protected status, such as race, religion, color, national origin, sex, sexual orientation, gender identity or age.

Diversity and Inclusion : PacificSource values the diversity of the people we hire and serve. We are committed to creating a diverse environment and fostering a workplace in which individual differences are appreciated, respected and responded to in ways that fully develop and utilize each person’s talents and strengths.

Position Overview : Provide assistance in administering analytic support related to value based payments, financial modeling for provider contracting, support of large employer RFP, large employer and ASO, state and / or federally mandated reporting and analyses.

The role will also support the provider settlement process for a variety of value based payment arrangements; collaborate with level 2, 3 and 4 analysts and analytics management in coordination of projects with multiple departments in supporting contractually required monthly reporting in a timely, accurate and easy to understand format for external provider audiences.

Additional tasks may include assisting with components of validating data used in the settlement and payment processes; initiating documentation and processes;

and provide support to the VBP team in monthly reporting, annual model building and reconciliation processes.

Essential Responsibilities :

• Assist in providing essential data support and coordination activities for various business critical analysis and reporting needs.
• Perform data extraction to meet project requirements as directed. This would include cleaning, transformation and pre-processing data using software programs such as t-SQL, SAS, etc.
• Support the development of data visualization solutions that allow customer to interact with the data using data visualization software solutions such as Tableau or Microsoft Power BI.
• Complete entry-level calculations and analysis of value based payment terms including development of reports, running of monthly report processes as well as reporting to support financial reconciliation processes.
• Support presentation of complex data, analysis and findings to teams in a way that is clear and understandable.
• Contribute to and initiate development and maintenance of documentation and training materials including job aids.
• Assist in evaluating impact of business changes on risk reports specifications such as plan, benefit, network, provider configuration and payment and other operational changes in partnership with senior, non-associate level analysts and analytics management.
• Prepare assigned ad hoc analyses related to cost and utilization opportunities regarding RFP, employer groups, ASO groups and other Sales / Marketing requests.
• Assists with quality assurance adherence to ensure accuracy, completeness, and reliability of project-related information data resources and reporting initiatives such as participating in data validation projects and providing feedback on development of unit testing, error checks and validation processes.
• Develop general health insurance business content knowledge as well as specific knowledge related to assigned business areas of analytics support.

Supporting Responsibilities :

• Meet department and company performance and attendance expectations.
• Follow the PacificSource privacy policy and HIPAA laws and regulations concerning confidentiality and security of protected health information.
• Perform other duties as assigned.

SUCCESS PROFILE

Work Experience : Prior data analytic work experience in healthcare environment preferred, but not required.

Education, Certificates, Licenses : Bachelor's degree in Mathematics, Computer Science, Statistics, Engineering, Health and Medical Economics, Public Health or similar research related field.

Knowledge : General knowledge of business principles, theories and concepts. Ability to manage workload within a team environment and with direct supervision.

Ability to deal responsibly with confidential information. General knowledge of in at least one statistical / analytical programming tools such as R, SAS, SPSS.

General knowledge of other technical applications such as Tableau, Power BI and web-based database tools. killed in Microsoft Office : Word, Excel, PowerPoint and Outlook.

Competencies

• Building Customer Loyalty
• Building Strategic Work Relationships
• Contributing to Team Success
• Planning and Organizing
• Continuous Improvement
• Adaptability
• Building Trust
• Work Standards

Environment : Work inside in a general office setting with ergonomically configured equipment. Travel is required approximately less than 5% of the time.

Our Values

We live and breathe our values. In fact, our culture is driven by these seven core values which guide us in how we do business :

• We are committed to doing the right thing.
• We are one team working toward a common goal.
• We are each responsible for customer service.
• We practice open communication at all levels of the company to foster individual, team and company growth.
• We actively participate in efforts to improve our many communities-internally and externally.
• We actively work to advance social justice, equity, diversity and inclusion in our workplace, the healthcare system and community.
• We encourage creativity, innovation, and the pursuit of excellence.

Physical Requirements : Stoop and bend. Sit and / or stand for extended periods of time while performing core job functions.

Repetitive motions to include typing, sorting and filing. Light lifting and carrying of files and business materials. Ability to read and comprehend both written and spoken English.

Communicate clearly and effectively.

Disclaimer : This job description indicates the general nature and level of work performed by employees within this position and is subject to change.

It is not designed to contain or be interpreted as a comprehensive list of all duties, responsibilities, and qualifications required of employees assigned to this position.

Employment remains AT-WILL at all times.

The HR Data and Insights Analyst supports P&O and its internal partners by extracting meaningful insights from existing and new P&O data to drive an effective people strategy, applying statistical findings to layered P&O, Financial, and Operational data to support effective human capital planning, enhancing strategic usage of metrics.

What are we looking for?

• Bachelor’s Degree or combination of education and experience required Field of Study : Human Resources, Business Analytics, Finance, or Business Information Systems
• 5 yrs experience in Human Resources Reporting, HR, Business or Finance Analytics
• Solid communicator with experience storytelling through data
• Expert Level Excel
• Knowledge of best practices and standards for designing data visualizations for business users
• Comfort with data cleansing, data modeling, and data mining
• Experience developing metrics, conducting statistical analysis and forecasting

What will be your key responsibilities?

• Derive functional requirements from high-level business needs, understanding the question / problem and identifying the data needs and sources for various P&O effectiveness projects / processes
• Apply data analytics and provide valuable quantitative metrics needed to illustrate organizational challenges, measure efficiencies, and return on investment on key P&O initiatives
• Collaborate effectively and cooperatively with stakeholders, co-workers, vendors, and leadership to create new ideas and Innovations for analytical solutions that solve internal business challenges, ensure data quality, and improve data usage
• Identify and forecast trends from raw data with clear representation of the storytelling through data and workforce measurements to improve people processes

What can you expect from Mars?

• Work with over , diverse and talented Associates, all guided by the Five Principles.
• Join a purpose driven company, where we’re striving to build the world we want tomorrow, today.
• Best-in-class learning and development support from day one, including access to our in-house Mars University.
• An industry competitive salary and benefits package, including company bonus.

LI-KS1

LI-Hybrid

Our client, a global leader in recycling metals, is seeking a talented Data Analyst with expertise in Power BI to join their team.

As the Data Analyst, you will play a crucial role in analyzing and interpreting data sets to provide valuable insights. You will work closely with cross-functional teams and stakeholders to understand their data needs, design, and develop interactive reports and dashboards using Power BI, and deliver data-driven solutions.

If you think you’d be a good fit, we want to hear from you!

This role is fully remote and is a 3-month contract with the possibility of extension.

Key Responsibilities for Senior Data Analyst

• Collaborate with business stakeholders to gather data requirements and understand their analytical needs.
• Design, develop, and maintain interactive reports, visualizations, and dashboards using Power BI.
• Analyze large and complex datasets to identify patterns, trends, and correlations.
• Perform data cleansing, transformation, and manipulation to ensure data accuracy and reliability.
• Develop and implement data models to support business intelligence and reporting requirements.
• Conduct ad-hoc data analysis and provide insights to drive informed decision-making.
• Stay up to date with industry trends and best practices in data analytics and visualization.

Requirements for Senior Data Analyst

• Bachelor's degree in a related field (e.g., Computer Science, Data Analytics, Statistics).
• Proven experience as a Data Analyst, preferably with expertise in Power BI.
• Proficient in SQL and advanced Excel functions.
• Strong analytical skills and the ability to translate complex data into meaningful insights.
• Experience in data visualization and creating interactive dashboards using Power BI.
• Knowledge of data modeling, data warehousing, and ETL processes.
• Excellent communication and collaboration skills to work effectively with cross-functional teams.
• Attention to detail and a commitment to delivering high-quality results.
• Ability to work independently and manage multiple tasks simultaneously.
• Certification in Power BI or other relevant data analytics certifications preferred.
• Familiarity with other data visualization tools such as Tableau or QlikView preferred.
• Knowledge of data governance and data privacy regulations preferred.
• Knowledge of Data Integration tool or ETL experience is a plus.

Senior Healthcare Data Analyst

Remote : Must work and reside from Oregon, Washtington or California ONLY

Permanent with Great Benefits

Salary 80-129K / yr DOE

Be responsible for leading advanced strategic analysis of various data sets for multiple geographic regions and lines of business

Have experience working with and analyzing large complex data sets and systems

Display strong analytical and deductive reasoning skills with a strong attention to detail

Have the ability to complete tasks independently and make decisions

Be responsible for developing and maintaining reports for management and other users

Utilize advanced programming, coding, and scripting skills in VBA, SQL, and Tableau

Required :

Bachelor's Degree in a highly quantitative field of study and 7+ years of experience in data analysis ( Field of Study Examples : Statistics, Mathematics, Actuarial Science, Economics, Engineering / Physics, Accounting or Computer Science) -OR

Minimum of a HS Diploma or GED Equivalency and 9+ years of experience in data analysis

Preferred : Master's Degree

Master's Degree

Healthcare organization / health insurer experience

Extensive SQL experience

Extensive VBA experience

Extensive Tableau experience

Moderate Power BI experience

The following benefits are offered for this position : medical, dental, & vision insurance, short-term disability, life and AD&D insurance, and a 401(k) retirement plan.

Everest Consultants is an equal opportunity employer and does not discriminate on the basis of race, color, religion, sex, national origin, age, disability, or any other characteristic protected by applicable local, state, or federal civil rights laws.