The Calm Data Analyst interview guide, interview questions, salary data, and interview experiences.

Calm Data Analyst Interview Guide

Getting ready for an Data Analyst interview at Calm? The Calm Data Analyst interview span across 10 to 12 different question topics. In preparing for the interview:
<ul>
<li>Know what skills are necessary for Calm Data Analyst roles.</li>
<li>Gain insights into the Data Analyst interview process at Calm.</li>
<li>Practice real Calm Data Analyst interview questions.</li>
</ul>
Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Calm Data Analyst interview.


Getting ready for an Data Analyst interview at Calm? The Calm Data Analyst interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for Calm Data Analyst roles.
- Gain insights into the Data Analyst interview process at Calm.
- Practice real Calm Data Analyst interview questions.

Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Calm Data Analyst interview.
        

Overview

Calm Data Analyst Salary

We've gathered this data from parsing thousands of interview experiences sourced from members.

We've gathered this data from parsing thousands of interview experiences sourced from members.

Calm Data Analyst Interview Process

As part of the financial management in a large corporation, the CFO wants to review the expenses in all departments for the previous financial year (2022).

Write a SQL query to calculate the total expenditure for each department in 2022. Additionally, for comparison purposes, return the average expense across all departments in 2022.

Note: The output should include the department name, the total expense, and the average expense (rounded to 2 decimal places). The data should be sorted in descending order by total expenditure.

<h3>Example:</h3>

Input:

<code>departments</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>name</td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
<code>expenses</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>department_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>amount</td>
<td>FLOAT</td>
</tr>

<tr>
<td>date</td>
<td>DATE</td>
</tr>
</tbody>
</table>
Output:

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>department_name</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>total_expense</td>
<td>FLOAT</td>
</tr>

<tr>
<td>average_expense</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>

Calculate total and average expenses for each department.

Department Expenses

The probability that it will rain tomorrow is dependent on whether or not it is raining today and whether or not it rained yesterday.

If it rained yesterday and today, there is a 20% chance it will rain tomorrow. If it rained one of the days, there is a 60% chance it will rain tomorrow. If it rained neither today nor yesterday, there is a 20% chance it will rain tomorrow.

Given that it is raining today and that it rained yesterday, write a function <code>rain_days</code> to calculate the probability that it will rain on the nth day after today.

Example:

Input:

<pre tabindex="0" class="chroma"><code>n=5
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>def rain_days(n) -&gt; 0.39968
</code></pre>

Given that it is raining today and that it rained yesterday, write a function to calculate the probability that it will rain on the nth day after today.

Rain in N Days

You’re given two dataframes. One contains information about addresses and the other contains relationships between various cities and states:

Example:

<code>df_addresses</code>

<table>
<thead>
<tr>
<th>address</th>
</tr>
</thead>

<tbody>
<tr>
<td>4860 Sunset Boulevard, San Francisco, 94105</td>
</tr>

<tr>
<td>3055 Paradise Lane, Salt Lake City, 84103</td>
</tr>

<tr>
<td>682 Main Street, Detroit, 48204</td>
</tr>

<tr>
<td>9001 Cascade Road, Kansas City, 64102</td>
</tr>

<tr>
<td>5853 Leon Street, Tampa, 33605</td>
</tr>
</tbody>
</table>
<code>df_cities</code>

<table>
<thead>
<tr>
<th>city</th>
<th>state</th>
</tr>
</thead>

<tbody>
<tr>
<td>Salt Lake City</td>
<td>Utah</td>
</tr>

<tr>
<td>Kansas City</td>
<td>Missouri</td>
</tr>

<tr>
<td>Detroit</td>
<td>Michigan</td>
</tr>

<tr>
<td>Tampa</td>
<td>Florida</td>
</tr>

<tr>
<td>San Francisco</td>
<td>California</td>
</tr>
</tbody>
</table>
Write a function <code>complete_address</code> to create a single dataframe with complete addresses in the format of street, city, state, zip code.

Input:

<pre tabindex="0" class="chroma"><code>import pandas as pd

addresses = {&#34;address&#34;: [&#34;4860 Sunset Boulevard, San Francisco, 94105&#34;, &#34;3055 Paradise Lane, Salt Lake City, 84103&#34;, &#34;682 Main Street, Detroit, 48204&#34;, &#34;9001 Cascade Road, Kansas City, 64102&#34;, &#34;5853 Leon Street, Tampa, 33605&#34;]}

cities = {&#34;city&#34;: [&#34;Salt Lake City&#34;, &#34;Kansas City&#34;, &#34;Detroit&#34;, &#34;Tampa&#34;, &#34;San Francisco&#34;], &#34;state&#34;: [&#34;Utah&#34;, &#34;Missouri&#34;, &#34;Michigan&#34;, &#34;Florida&#34;, &#34;California&#34;]}

df_addresses = pd.DataFrame(addresses)
df_cities = pd.DataFrame(cities)
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>def complete_address(df_addresses,df_cities) -&gt;
</code></pre>

<table>
<thead>
<tr>
<th>address</th>
</tr>
</thead>

<tbody>
<tr>
<td>4860 Sunset Boulevard, San Francisco, California, 94105</td>
</tr>

<tr>
<td>3055 Paradise Lane, Salt Lake City, Utah, 84103</td>
</tr>

<tr>
<td>682 Main Street, Detroit, Michigan, 48204</td>
</tr>

<tr>
<td>9001 Cascade Road, Kansas City, Missouri, 64102</td>
</tr>

<tr>
<td>5853 Leon Street, Tampa, Florida, 33605</td>
</tr>
</tbody>
</table>

Write a function to create a single dataframe with complete addresses in the format of street, city, state, zip code.

Complete Addresses

Calm Data Analyst Interview Questions

About Calm Calm is on a mission to support everyone on every step of their mental health journey. With the #1 app for sleep, meditation and relaxation as well as a growing library of digital, evidence-based mental health programs, Calm offers trusted support for individuals and organizations alike. Our flagship consumer app provides personalized content and activities - featuring a range of experts and beloved celebrity voices - to help users manage stress, improve sleep and live mindfully. Our workplace and healthcare solutions offer a consumer-friendly approach to clinical content and HIPAA-compliant resources in order to drive positive health and business outcomes. Named a TIME100 Most Influential Company, Calm supports more than 150 million people and 3,500 organizations across seven languages and 190 countries. What We Do The Data Science team focuses on helping drive business outcomes across Calm. The business problem comes first (what are we trying to solve?), and the analysis follows (how do we best solve this problem?). Sometimes the solution is straightforward and sometimes it is highly complex-we always rely on data to drive our solutions. What You'll Do As a Product Analyst for Calm's B2B business you will be responsible for data products and analyses to support both external B2B customers as well as internal product and go-to-market teams. You will help drive quality analytics practices end-to-end: From building tracking plans for new product features, to delivering analysis-backed recommendations to B2B business leaders. Your role will be critical to delivering the key data points and insights to decision makers, helping move the company forward. We are hiring remote workers for this role in the San Francisco Bay Area, Los Angeles, New York City, or Minneapolis areas. At this time, only candidates in these locations will be considered. You will: <ul><li>Produce ad-hoc analyses on data across various sources (e.g. event streams, salesforce, application data), translating results into actionable summaries and recommendations</li><li>Build and maintain operational dashboards in BI tools to enable internal partners to answer their most common questions</li><li>Engineer data models for our production pipeline, which feed into high visibility dashboards critical for stakeholder decision-making</li><li>Partner with product managers and engineers to develop tracking plans to ensure high quality data is available for performance measurement and analysis</li><li>Serve as a bridge between Calm's B2B product and go-to-market teams. For example, tying operational initiatives (e.g. marketing campaigns) to product outcomes (e.g. new users) and vice-versa.</li></ul> Some past projects include: <ul><li>Building a customer reporting dashboard to enable our Customer Success team to deliver trustworthy and insightful reports to our customers</li><li>Supporting the end-to-end analytics needs for a new product launch: From ensuring required tracking is in place to presenting success metric readouts to product leadership</li><li>Working closely with sales operations, finance and data engineering teams to build a company KPI dashboard for the B2B leadership team</li><li>Partnering with Customer Success managers and data teams from B2B external customers to deliver high-value reporting products</li></ul> Who You Are <ul><li>Experience working in a product analytics tool such as Amplitude, Mixpanel or Heap</li><li>Prior experience and enthusiasm for building and maintaining data products in a BI tool (e.g. Tableau, Looker, Power BI)</li><li>Experience building data models, preferably using dbt</li><li>Ability to translate non-technical business requirements into technical solutions, and translate technical solutions to business outcomes</li><li>Proven track record of building relationships and influencing others within and across immediate working groups</li><li>Hands-on experience building data documentation and testing practices</li><li>Comfortable being an early team member and navigating ambiguity</li><li>Experience working with cloud based data warehouses like Google BigQuery, Redshift, or Snowflake</li></ul> Nice to Haves <ul><li>Prior experience working with a subscription or B2B SaaS business</li></ul> Minimum Requirements <ul><li>5 years of relevant experience</li><li>4+ years of experience in an Analyst or Data Science role</li><li>Strong proficiency in SQL</li></ul> Calm uses a geographic pay model that determines salaries based on the location where an employee lives. For this position, the base pay ranges across Calm's pay tiers is as follows: $88,560 - $183,700. The base pay range represents the low and high end of Calm's salary range for this position. Not all candidates will be eligible for the upper end of the salary range. Exact salary will ultimately depend on multiple factors, which include the successful candidate's geographic location, skills, experience and other qualifications. Calm uses employee zip code to determine which pay range applies. This role is also eligible for equity + comprehensive benefits + 401k + flexible time off. Please note that Calm may leverage artificial intelligence technology in the application review process. Calm is committed to providing reasonable accommodations for qualified individuals with disabilities, including disabled veterans. Please contact Calm's Recruiting team if you need a reasonable accommodation, assistance completing any forms, or to otherwise participate in the application process. You can reach the Recruiting team at recruitingaccommodations@calm.com We believe that mental health is health, and every person should be considered in the discussion. That's why we're proud to be an equal opportunity workplace, committed to providing equal employment opportunities to all applicants and employees regardless of race, color, religion, national origin, age, sex, marital status, ancestry, physical or mental disability, medical condition, genetic information, military or veteran status, gender identity or expression, sexual orientation, or any other characteristic protected by applicable federal, state or local law. Calm is deeply committed to diversity, equity and inclusion. We strive to create a mindful and respectful environment where everyone can bring their authentic self to work, and experience a culture that is free of harassment, racism, and discrimination. Employment offers are contingent upon the successful completion of a background check. Roles which require access to certain types of information may also require the successful completion of a drug screening. Calm participates in e-verify. E-verify provides the federal government with your Form I-9 information to confirm that you are authorized to work in the U.S. <ul><li>Right to Work</li><li>E-Verify Participation</li></ul> #LI-Remote

About Lumen Lumen connects the world. We are igniting business growth by connecting people, data and applications quickly, securely, and effortlessly. Together, we are building a culture and company from the people up committed to teamwork, trust and transparency. People power progress. Lumens commitment to workplace inclusion and employee support shines bright. Weve made the Newsweek 2024 Greatest Workplaces for Diversity list and achieved a perfect score of 100 on the Human Rights Campaign Corporate Equality Index (CEI) for the fifth consecutive year. Plus, were the top employer in the communications and telecom industry, ranking 12th overall across all industries in The American Opportunity Index. Were looking for top-tier talent and offer the flexibility you need to thrive and deliver lasting impact. Join us as we digitally connect the world and shape the future. The Role If you're a student eager to explore the exciting world of digital innovation, Lumen is the perfect place for you. Lumen offers an excellent opportunity to broaden your knowledge, build a strong network of support, and kickstart your career. Lumen offers a fully immersive, 10-week summer internship program. Our interns demonstrate curiosity, innovation, and a passion for advancing technology. We believe that empowering our people and helping them reach their full potential is essential for the long-term success of both Lumen and our customers. Program dates: May 30 August 8, 2025. The Main Responsibilities Lumens Enterprise Operations organization is looking for a Data Analyst Insights and Intelligence intern on our Access Delivery team. The intern will support our team in enhancing service delivery through data-driven decision-making. Your primary responsibilities will include: Data Analysis and Insights: Assist in analyzing large datasets to uncover trends and patterns. Learn to use analytical tools and techniques to interpret data and provide recommendations. Targeted Analysis: Support the team in performing precise analysis to identify specific issues and opportunities within our service delivery processes. Actionable WIP: Help translate data insights into actionable work-in-progress (WIP) items. Collaborate with cross-functional teams to implement these actions and monitor their impact. Service Delivery Improvement: Participate in assessing and improving service delivery processes by leveraging data intelligence. Contribute to strategies aimed at enhancing efficiency and customer satisfaction. Reporting and Visualization: Assist in creating reports and visualizations to communicate findings and recommendations to stakeholders. Ensure that data insights are easily understandable and actionable. Collaboration: Work closely with various departments, including operations, IT, and customer service, to support data-driven decisions in daily operations. Learning and Development: Stay updated with the latest trends in data analytics and intelligence. Continuously seek opportunities to enhance your skills and knowledge in this field. What We Look For in a Candidate Program eligibility is contingent on the candidates commitment of the entire 10-week program. No exceptions will be made. Required qualifications o Enrolled at a 4-year accredited college or university, rising senior or graduate level education status at the start of the internship o Graduating August 2025 May 2027 o Preferred fields include bur not limited to: Computer Science, Business Analytics, Data Analytics, Data Science, Information Systems or Statistics. o Intern must be able to work 40 hours per week during the 10-week program (May 30 August 8, 2025) Proficiency and understanding of: o MS Office Suite Excel heavy o Data Report and Dashboard like PowerBI o Data Management experience o Data Query experience is nice to have Preferred qualifications o Analytical Skills: Ability to analyze and interpret data to provide actionable insights o Experience with statistical analysis and data visualization tools is a plus. o Attention to detail and a proactive approach to learning and development. o Ability to translate technical information into non-technical terms o Driven by curiosity in problem solving and willing to challenge the norm o Strong problem-solving abilities to identify and resolve issues related to data o Eagerness to learn and adapt to new technologies and methodologies. o Strong organization skills o Ability to multitask while working in fast paced environment o Comfortability interacting and presenting to leadership Compensation Internship compensation ranges depend on each individuals level of education, geographic location, and experience/qualifications aligned to the role. Hourly Based Pay Range: Min: $26.00/hour Max: $43.00/hour What to Expect Next After completion and submission of your application, you will be asked to participate in a virtual video interview. This on demand interview will be a way for Lumen to learn more about you and your experience as it aligns to the internship position. A separate email invitation will be sent to you (check your spam) within 6 hours of application. For continued consideration in the summer internship program, please ensure you complete the video interview within 5 business days of application. Application & Interview Timeline: October First Round Interviews with top, qualified candidates November - Interview panel with work team December - All Summer 2025 offers will be extended by end of month Requisition : 335388 Background Screening If you are selected for a position, there will be a background screen, which may include checks for criminal records and/or motor vehicle reports and/or drug screening, depending on the position requirements. For more information on these checks, please refer to the Post Offer section of our FAQ page (https://jobs.lumen.com/global/en/faq) . Job-related concerns identified during the background screening may disqualify you from the new position or your current role. Background results will be evaluated on a case-by-case basis. Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records. Equal Employment Opportunities We are committed to providing equal employment opportunities to all persons regardless of race, color, ancestry, citizenship, national origin, religion, veteran status, disability, genetic characteristic or information, age, gender, sexual orientation, gender identity, gender expression, marital status, family status, pregnancy, or other legally protected status (collectively, protected statuses). We do not tolerate unlawful discrimination in any employment decisions, including recruiting, hiring, compensation, promotion, benefits, discipline, termination, job assignments or training. Disclaimer The job responsibilities described above indicate the general nature and level of work performed by employees within this classification. It is not intended to include a comprehensive inventory of all duties and responsibilities for this job. Job duties and responsibilities are subject to change based on evolving business needs and conditions. Salary Range Salary Min : 26 Salary Max : 43 This information reflects the anticipated base salary range for this position based on current national data. Minimums and maximums may vary based on location. Individual pay is based on skills, experience and other relevant factors. This position is eligible for either short-term incentives or sales compensation. Director and VP positions also are eligible for long-term incentive. To learn more about our bonus structure, you can view additional information here. (https://jobs.lumen.com/global/en/compensation-information) We're able to answer any additional questions you may have as you move through the selection process. As part of our comprehensive benefits package, Lumen offers a broad range of Health, Life, Voluntary Lifestyle and other benefits and perks that enhance your physical, mental, emotional and financial wellbeing. You can learn more by clicking here. (https://centurylinkbenefits.com) Please be advised that Lumen does not require any form of payment from job applicants during the recruitment process. All legitimate job openings will be posted on our official website or communicated through official company email addresses. If you encounter any job offers that request payment in exchange for employment at Lumen, they are not for employment with us, but may relate to another company with a similar name. Note: For union-represented postings, wage rates and ranges are governed by applicable collective bargaining agreement provisions. Application Deadline 11/02/2024

Company Profile: Newport News Nuclear BWXT Los Alamos (N3B) manages the 10-year, $2.1 billion Los Alamos Legacy Cleanup Contract for the U.S. Department of Energy, Office of Environmental Management, Los Alamos Field Office. N3B is a limited liability company owned by HII Nuclear Inc. and BWX Technologies, joined by our critical subcontractors Longenecker and Associates and Tech2 Solutions. N3B brings operational discipline, proven approaches and predictable results to the Los Alamos Legacy Cleanup Contract. Position Location: This position is located in Los Alamos, New Mexico. Los Alamos is a tight-knit mountain community that consistently ranks as one of Livability.com's Best Small Towns in America. For two years in a row, Los Alamos County has ranked as the healthiest county in the nation according to a U.S. News report. The city is a top spot for outdoor enthusiasts as it has more than 120 hiking and biking trails, and residents enjoy easy access to the Pajarito Mountain Ski Area. Thanks to the University of New Mexico-Los Alamos' presence in the area, Los Alamos also has a college-town vibe that's a major draw for young professionals, families and retirees. Position Summary: The Metric and Data Analyst will work across the organization to collect, manage, summarize, and communicate data as needed for the implementation of N3B's Environmental Management System (EMS). The position will be responsible for developing procedures/processes to ensure data quality. Additional responsibilities may be assigned as needed. The Position reports to the Environmental Programs/Services Director. Essential Duties/Responsibilities (may include, but are not limited to): Build and maintain systems to collect, manage, summarize, and communicate key sustainability and operational metrics Engage with stakeholders across N3B to identify, track, manage, and report on the company's environmental performance Develop, track, and lead data generation and formulation of Key Performance Indicators (KPIs) for the EMS Compile and submit annual Site Sustainability Plan reporting Develop various environmental performance status reports for senior management Minimum Qualifications (Knowledge, Skills, Abilities): Must be a U.S. citizen Possess a valid driver's license High proficiency in MS Office Suite, Power BI Data visualization, storytelling through data, data analytics, dashboard development Scripting using languages such as SQL, Python, R Demonstrated verbal and written communication skills for communicating effectively with staff across disciplines Good time management skills to manage diverse portfolio and multiple project needs Strong problem-solving and analytical skills Flexibility and willingness to learn Work independently with minimal supervision completing assigned roles and responsibilities Desired Qualifications (Knowledge, Skills, and Abilities): Familiarity with DOE Cyber-Security regulations Familiarity with ISO 14001:2015 - Environmental Management Systems Working knowledge of Costpoint, Devonway, ArcGIS, Environmental Information Management (EIM) database, and the Waste Compliance and Tracking System (WCATS) Education and Experience Required: Level 3: Bachelor's degree in Sustainability, Environmental Science, Data Science, Information Systems, Computer Science, or related scientific discipline and at least 6 years' experience Level 4: Bachelor's degree in Sustainability, Environmental Science, Data Science, Information Systems, Computer Science, or related scientific discipline and at least 10 years' experience Employee Referral Eligibility: This position is eligible for N3B's employee referral program. Hard To Fill: Yes ? No ? Business Associations: Level 3: Represents organization as a prime contact on contracts or projects. Interacts with senior internal and external personnel on significant matters often requiring coordination between organizations. Level 4: Serves as consultant to management and special external spokesperson for the organization on major matters pertaining to its policies, plans, and objectives. Impact: Level 3 : Exerts some influence on the overall objectives and long-range goals of the organization. Erroneous decisions or failure to achieve objectives would normally have a serious effect upon the administration of the organization. Level 4: Effects of decisions are long-lasting and heavily influence the future course of the organization. Errors in judgement of failure to achieve results would result in the expenditure of large amounts of company resources. Working Conditions and Physical Requirements: Primarily assigned to perform work in the office. Work may be completed remotely, but on-site coordination is likely necessary. Job performance requires adequate visual acuity and manual dexterity for meeting the requirements of the discipline. Safety, Security, and Quality While working to achieve N3B LLCC objectives, the Metrics and Data Analyst staff will ensure all activities and operations are performed in a safe and deliberate manner to include protecting the confidentiality and integrity of Personally Identifiable Information (PII) and Official Use Only (OUO). This role will maintain required safety, security and operational training; assure procedural and regulatory compliance; and make safety, security and quality an integral part of every task; including taking the necessary steps to stop work if continuing the job is unsafe or compromises security. Diversity & Inclusiveness N3B is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. N3B will ensure no applicant for employment or employee is denied equal opportunity because of race, color, religion, sex, gender identity, sexual orientation, pregnancy, status as a parent, national origin, age, disability (physical or mental), family medical history or genetic information, political affiliation, military service, or other non-merit-based factors. These protections extend to all management practices and decisions, including recruitment and hiring practices, appraisal systems, promotions, training, and career development programs.

<h3>Job Description</h3><div>Job Description<div>Sr. Data AnalystPura, based in Pleasant Grove, UT, has been revolutionizing self-care and iOT (internet of things) connected experiences in homes for the past several years. We obsess over providing world-class experiences for our customers, partners, and vendors. We're looking for candidates who are committed to Human-Centered design & delivery. We pride ourselves on maintaining a team-based culture, quality, innovation, and continuous growth and development! Our teams build and maintain apps, services, fragrances, and devices that power all of the connected experience platforms for Pura customers internal and external. We are currently hiring a Sr. Data Analyst to join our growing Product team. We are looking for an experienced analyst who loves solving problems and telling stories with data analysis and visualization. This person will help enable a data-first product culture and will work closely across multiple product teams to measure user engagement, feature adoption, and product performance.  This person will also help provide insights and opportunities to our Brand Partners for securing and expanding their footprint in our website marketplace.Who you are committed to being:<ul><li>You are focused on making progress every day</li><li>You are comfortable establishing and evangelizing a desired end state, or outcome, and motivating others to come along</li><li>You ask detailed and specific questions, understand nuance, and question conventional wisdom</li><li>You care about the success of your customers, partners, and team members</li><li>You understand that what people say they want and what they actually want may differ</li></ul>What you'll own:<ul><li>Head data-based projects and initiatives to support product team KPIs and brand partnerships</li><li>Define, analyze, and help track new metrics that inform strategy</li><li>Compile, analyze, visualize, and interpret critical product and web analytics data for presenting to teams and brand partner stakeholders</li><li>Provide quantitative balance throughout the entire product life cycle (research, design, implementation, and iteration)</li><li>Make recommendations on how to improve user experience and business performance</li><li>Explore data to find trends and opportunities for our product teams and brand partners</li><li>Develop and maintain data dashboards and reporting, including ad hoc requests and reporting automation</li></ul>Experience you'll need:<ul><li>3-5+ years of experience in a data analysis or analytics insights role</li><li>Advanced experience with Google Analytics, GA4, or equivalent analytics platform</li><li>Proficiency with scripting languages (SQL, Python)</li><li>Experience with a modern data stack (Fivetran, Segment, DBT, GCP)</li><li>Experience in a data visualization tool (ex: Domo, Tableau, Mixpanel, Looker) </li><li>Experience in analytics and statistical techniques, A/B testing, customer segmentation, marketing effectiveness, and revenue/opportunity attribution</li><li>Experience building and automating management-level reporting</li><li>Strong communication skills. Demonstrated ability to speak on a technical level and communicate clearly with engineers, product owners, customer service, marketing, manufacturing, and designers</li><li>Experience facilitating cross-functional teams with a strong sense of accountability</li></ul>We know that each candidate may not meet all the listed requirements, but please apply anyway! <hr />Pura’s StoryPura—a company that married smart-home technology and fragrance diffusers, all controlled by the Pura app. At Pura, our mission is to create a luxury fragrance experience in each home that can change moods and brighten days. We are partnering with the leading premium fragrance brands, celebrities, and lifestyle brands in the industry to bring customers’ favorite scents to their home with the touch of a button. And that is just the beginning.Pura started in 2014 and raised a seed round of 4.4M in February of 2020. Pura thrives on hiring or creating the best talent, known as a young and hungry brand that is rapidly becoming a household name around the world.Check out our Founder’s story and find out more about our perks and benefits offerings on our website. Explore the latest amazing fragrance launches on Instagram @pura. Join the Pura Team!All candidates are subject to a background check. Pura provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.  Powered by JazzHRJnPe9GQYdT</div></div>

Founded in 1993, MedeAnalytics is an innovation-focused company. Over the past three decades, we have worked tirelessly to reimagine healthcare through the power of data-and helped thousands of organizations achieve their potential along the way.Leveraging state-of-the-art analytics and data activation, MedeAnalytics delivers actionable insights that support payers, providers, employers, and public entities as they navigate the complex healthcare landscape.Using artificial intelligence and machine learning alongside the most advanced data orchestration in the industry, we empower organizations to optimize their resource allocation, experience superior patient outcomes, and achieve population health management goals.And that's just the beginning.With a deep understanding of the complex challenges facing the healthcare industry,MedeAnalytics offers a comprehensive suite of solutions to address key areas such as:Population Health Management: Gain insights into patient populations, identify at-risk individuals, and implement targeted interventions to improve health outcomes.Value-Based Care: Optimize care delivery, reduce costs, and enhance patient satisfaction by aligning with value-based care models.Revenue Cycle Management: Streamline revenue cycle processes, improve reimbursement rates, and minimize denials.And more...MedeAnalytics is committed to delivering cutting-edge technology and exceptional customer service. Our team is passionate about transforming healthcare and making a positive impact on the lives of patients.MedeAnalytics is seeking a highly experienced Healthcare Data Analyst. This rolereports to the Sr. Director of Professional Services acting as a liaison, facilitating collaboration between core Mede and Professional Services teamsThis client facing position will guide healthcare payer and provider clients through extracting, analyzing, and interpreting large data sets to build various reports and dashboards. The analyst will provide clients with analytical consultative expertise and guidance to create metrics enabling measurements of progress towards initiative goals and ensuring the proper data is being collected for those metrics. Performing extensive data analysis, creating documentation of data issues, and developing implementation strategies for improving data quality and data standardization is a core function of our role.The ideal candidate is not new to the data realm and has potentially worn multiple hats as an Analytics Engineer, Data Analyst, or Data Architect. Must be proficient in SQL and have experience using a BI tool. This role requires strong data modeling, data mapping & integration skills coupled with current experience in B2B, EAI, ESB, web services, service-oriented architectures, and standardized terminology services. Epic certifications with a focus on analytical capabilities is strongly preferred. Having up-to-date knowledge and understanding of HEDIS & CMS STARs measures' technical specifications is required.Location Requirement: The candidate hired for this position must be based within a commutable distance from Nashville, TN, or Dallas, TX. This role may require periodic in-office attendance, and applicants not located within proximity to these areas may not be considered.Essential Duties and Responsibilities: Lead the design, development, and ongoing support of clinical and financial integrated data models and reports used by provider and payer management in decision-making. This includes but is not limited to determining appropriate data transformations and governance strategies needed to provide trusted data sets for NCQA HEDIS & CMS STARs reporting and analytics.Responsible for designing new data structures, mapping data from client source data to our data models, writing SQL/SQL like scripts to load and transfer the data to databases and performing data analysis with ETL.Leads ideation sessions using lean principles to develop, document and analyze present state process maps and develop future state models.Conduct, assess and profile data mappings to adhere to specific data structures, ensuring data quality is clearly defined to meet requested business use cases.Design, create and maintain accurate and efficient data models.Summarizes testing and validation results and be able to communicate and make recommendations on the best course for remediation.Resourceful in arriving at solutions using existing or available resources.Participate in agile work environment, completing sprint deliverables on time.Contribute to our evolving development and testing standards and best practices.Knowledge and experience in discrete data elements utilized in healthcare analytics.Experience querying data, data interpretation and report generation using modern analytics tools (i.e., Power BI)Work with product owners and business analysts on requirements and design.Create and maintain comprehensive project documentation, using Mede's standard technical templates, methodologies, and standards.Consultative engagement with clients to assess and guide requirements specifications.Conduct meetings, internal and with clients, to review integration progress, upcoming activities and deliverables required to fulfil the Integration project delivery.Create and maintain data integrity by providing quality data profiling ensuring known constraints to operate in the Client's environment.Education, Experience, and Required Qualifications: Bachelor's Degree (Bachelor of Science, Computer Science or equivalent) strongly desired; advanced degree (MS or MBA) preferred.3+ year(s) of experience in working with MEDITECH Expanse, Cerner, Allscripts or Epic health information systems and/or 3 + years of relevant professional work experience with complex analysis background in healthcare data, HL7, C-CDA, HEDIS, CMS & STARSEpic certifications with a focus on analytical capabilities is strongly preferredCAQH certification and/or Certified Health Data Analyst (CHDA®) a plusExpertise with standard healthcare terminologies and vocabularies (ICD, DRG, CPT, SNOMED CT, LOINC, NDC, Medispan, RxNorm, etc.)2+ years of Enterprise Software Packaged/SaaS Integration experience.2+ years of Enterprise Integration Tool (Informatica is preferred) experience.3+ years of database design and construction, ETL, and data modeling with an understanding of relational and dimensional data models3+ years of procedural programming and markup languages such as JAVA, JavaScript, Python, SQL, XML, and JSON2+ years managing big data (Data transfer, import/export, storage, performance, and security) and MS OLAP; additional experience with ETL framework, Linux and open-source technologies preferred.3+ years RDBMS and Cloud data platforms with preferred experience leveraging AWS, Mondrian, Oracle, Databricks, Vertica, Hadoop, Apache Spark, Mondrian & MongoDBFamiliar with data visualization tools, Data Lake, Git, and version controlBenefits Include:Comprehensive Medical, Dental, and Vision Coverage - Effective the first of the month following your start dateCompany-Paid Life & AD&D Insurance, plus Short-Term and Long-Term Disability (STD/LTD)Company-Paid Employee Assistance Program (EAP) premium tier for your wellbeing401(k) Plan with company matchPaid Holidays and Paid Time Off (PTO) AccrualsEmployee Referral Bonus ProgramProfessional Development Opportunities to support your growthAnd More!We are committed to equal employment opportunity regardless of race, color, ethnicity, ancestry, religion, national origin, gender, sex, gender identity or expression, sexual orientation, age, citizenship, marital or parental status, disability, veteran status, or other class protected by applicable law. We are proud to be an equal opportunity workplace.** Currently, we are not able to offer sponsorship or take over sponsorship to candidates who are not eligible to work in the country where the position is locatedAt MedeAnalytics we deeply value each and every one of our committed, inspired and passionate team members. If you're looking to make an impact doing work that matters, you're in the right place. Help us shape the future of healthcare by joining #TeamMede.MedeAnalytics does not utilize any outside vendors/agencies. Please no unsolicited phone calls or invites.

About Lumen Lumen connects the world. We are igniting business growth by connecting people, data and applications quickly, securely, and effortlessly. Together, we are building a culture and company from the people up committed to teamwork, trust and transparency. People power progress. Lumens commitment to workplace inclusion and employee support shines bright. Weve made the Newsweek 2024 Greatest Workplaces for Diversity list and achieved a perfect score of 100 on the Human Rights Campaign Corporate Equality Index (CEI) for the fifth consecutive year. Plus, were the top employer in the communications and telecom industry, ranking 12th overall across all industries in The American Opportunity Index. Were looking for top-tier talent and offer the flexibility you need to thrive and deliver lasting impact. Join us as we digitally connect the world and shape the future. Legal Statement In any materials you submit, you may redact or remove age-identifying information such as age, date of birth, or dates of school attendance or graduation. You will not be penalized for redacting or removing this information. The Role If you're a student eager to explore the exciting world of digital innovation, Lumen is the perfect place for you. Lumen offers an excellent opportunity to broaden your knowledge, build a strong network of support, and kickstart your career. Lumen offers a fully immersive, 10-week summer internship program. Our interns demonstrate curiosity, innovation, and a passion for advancing technology. We believe that empowering our people and helping them reach their full potential is essential for the long-term success of both Lumen and our customers. Program dates: May 30 August 8, 2025. The Main Responsibilities Lumens Enterprise Operations organization is looking for a Business Intelligence Analyst intern on our Carrier Relations Digital Transformation & BI team. The intern will be responsible for developing and maintaining Power BI reports to support business intelligence and data analysis needs. This role involves working closely with various departments to understand their reporting requirements, ensuring data accuracy, and providing actionable insights through visualizations. Additionally, the intern will perform data clean-up tasks to ensure data integrity and consistency across systems. Other responsibilities of intern will include: Creating Power BI Reports: Design and develop interactive Power BI reports and dashboards based on business requirements. This includes connecting to various data sources, transforming data, and creating visualizations that provide meaningful insights. Enhancing Existing Reports: Review and improve existing Power BI reports by adding new features, optimizing performance, and ensuring they meet the evolving needs of stakeholders. Monitoring Report Performance: Regularly monitor the performance of Power BI reports and dashboards to ensure they are running efficiently. Identify and resolve any issues related to data refreshes, loading times, and visualization errors. Data Clean-Up: Perform data clean-up tasks to ensure data accuracy and consistency. This includes identifying and correcting data discrepancies, removing duplicates, and standardizing data formats. Collaborating with Stakeholders: Work closely with various departments to gather reporting requirements, provide training on Power BI usage, and ensure that reports meet their needs. This involves regular communication and collaboration to understand their data needs and provide solutions What We Look For in a Candidate Program eligibility is contingent on the candidates commitment of the entire 10-week program. No exceptions will be made. Required qualifications o Enrolled at a 4-year accredited college or university, rising senior or graduate level education status at the start of the internship o Graduating August 2025 May 2027 o Preferred fields include but not limited to: Computer Science, Business Analytics, Data Science, Information Systems. o Intern must be able to work 40 hours per week during the 10-week program (May 30 August 8, 2025) Proficiency and understanding of: o MS Office Suite Excel heavy o Data Reporting and Dashboard tools like Microsoft Power BI o Familiarity with Data Transformation and Modeling using Power Query and DAX. o Data Management: Strong understanding of data management principles, including data cleaning, data integration, and data validation techniques Preferred qualifications o Analytical Skills: Ability to analyze and interpret data to provide actionable insights o Experience with statistical analysis and data visualization tools is a plus. o Attention to detail and a proactive approach to learning and development. o Ability to translate technical information into non-technical terms o Strong problem-solving abilities to identify and resolve issues related to data accuracy, report performance, and user requirements o Eagerness to learn and adapt to new technologies and methodologies. o Strong organization skills o Ability to multitask while working in fast paced environment Compensation Internship compensation ranges depend on each individuals level of education, geographic location, and experience/qualifications aligned to the role. Hourly Based Pay Range: Min: $26.00/hour Max: $43.00/hour What to Expect Next After completion and submission of your application, you will be asked to participate in a virtual video interview. This on demand interview will be a way for Lumen to learn more about you and your experience as it aligns to the internship position. A separate email invitation will be sent to you (check your spam) within 6 hours of application. For continued consideration in the summer internship program, please ensure you complete the video interview within 5 business days of application. Application & Interview Timeline: October First Round Interviews with top, qualified candidates November - Interview panel with work team December - All Summer 2025 offers will be extended by end of month Requisition : 335206 Background Screening If you are selected for a position, there will be a background screen, which may include checks for criminal records and/or motor vehicle reports and/or drug screening, depending on the position requirements. For more information on these checks, please refer to the Post Offer section of our FAQ page (https://jobs.lumen.com/global/en/faq) . Job-related concerns identified during the background screening may disqualify you from the new position or your current role. Background results will be evaluated on a case-by-case basis. Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records. Equal Employment Opportunities We are committed to providing equal employment opportunities to all persons regardless of race, color, ancestry, citizenship, national origin, religion, veteran status, disability, genetic characteristic or information, age, gender, sexual orientation, gender identity, gender expression, marital status, family status, pregnancy, or other legally protected status (collectively, protected statuses). We do not tolerate unlawful discrimination in any employment decisions, including recruiting, hiring, compensation, promotion, benefits, discipline, termination, job assignments or training. Disclaimer The job responsibilities described above indicate the general nature and level of work performed by employees within this classification. It is not intended to include a comprehensive inventory of all duties and responsibilities for this job. Job duties and responsibilities are subject to change based on evolving business needs and conditions. Salary Range Salary Min : 26 Salary Max : 43 This information reflects the anticipated base salary range for this position based on current national data. Minimums and maximums may vary based on location. Individual pay is based on skills, experience and other relevant factors. This position is eligible for either short-term incentives or sales compensation. Director and VP positions also are eligible for long-term incentive. To learn more about our bonus structure, you can view additional information here. (https://jobs.lumen.com/global/en/compensation-information) We're able to answer any additional questions you may have as you move through the selection process. As part of our comprehensive benefits package, Lumen offers a broad range of Health, Life, Voluntary Lifestyle and other benefits and perks that enhance your physical, mental, emotional and financial wellbeing. You can learn more by clicking here. (https://centurylinkbenefits.com) Please be advised that Lumen does not require any form of payment from job applicants during the recruitment process. All legitimate job openings will be posted on our official website or communicated through official company email addresses. If you encounter any job offers that request payment in exchange for employment at Lumen, they are not for employment with us, but may relate to another company with a similar name. Note: For union-represented postings, wage rates and ranges are governed by applicable collective bargaining agreement provisions. Application Deadline 10/27/2024

Data Analyst Are you a tech enthusiast who loves solving complex problems? Do you have a keen eye for detail and excellent analytical skills? Would your friends describe you as a self-starter who takes pride in your work and enjoys collaborating with others? If so, we have an exciting opportunity for you at The Greentree Group WHO WE ARE The Greentree Group is a dynamic, innovative, and thriving company that specializes in delivering advanced technology solutions to federal, state, and commercial clients. With a team of highly skilled professionals, we provide cutting-edge services and are always pushing the boundaries of whats possible. What sets us apart is our commitment to excellence and our passion for the work we do. At The Greentree Group, we are driven by a shared sense of purpose and a desire to make a difference in the lives of people around us. Whether it's helping our clients achieve their goals, developing innovative solutions to complex problems, or giving back to the community, we are dedicated to making a positive impact. We also believe in investing in our people and providing them with opportunities for growth, development, and advancement. We offer a dynamic and supportive work environment, a culture of continuous learning, and a wide range of benefits and perks that promote work-life balance and personal well-being. Whether you're a seasoned expert or just starting out in your career, if you're passionate about technology, committed to excellence, and eager to take on new challenges, we want to hear from you ABOUT THE OPPORTUNITY As a potential Data Analyst, you will have the opportunity to work with cutting-edge technologies and collaborate with a talented team of professionals in support of a client in the Tallahassee, FL area. This potential role will serve as the principal line of communication for the project team in a state-wide implementation effort. Join us and be part of our mission to make a difference SOME RESPONSIBILITIES INCLUDE BUT ARE NOT LIMITED TO: Implement data modeling and design techniques to build scalable and efficient data structures to meet the Departments accounting and budgeting reporting needs. Design and create data dashboards, visualizations, and reports using Power BI, providing critical insights to stakeholders. Troubleshoot any issues that arise in the data warehouse and implement solutions. Collaborate with other team members, stakeholders, and data users to ensure the new data warehouse meets the needs of the Department. Continuously monitor, refine, and report on the performance and capacity of the data warehouse. Configure and administer data warehouse security settings. Work closely with the Information Security team to ensure the best practices are in place. Stay up to date on new data warehousing technologies and approaches. Train and mentor less experienced team members. Coordinate with other IT teams to ensure smooth data warehouse operations. Handle incident management and problem resolution for data warehouse issues. Developing data mining models to identify trends and patterns within large datasets. Ensuring that data is accurate and clean, using statistical methods such as data profiling and data quality analysis to identify potential problems with data quality before using it in reports or analyses. Developing and thoroughly documenting the processes and procedures for the warehouses day-to-day operations, including creating backup plans for disaster recovery in case of equipment failure or data loss. Designing and implementing data warehouse solutions that meet the Departments needs while ensuring compliance with industry regulations regarding security of sensitive data. Work collaboratively with stakeholders teams to compile audience profiles, insights, and measurement plans. Create simple, easy-to-follow reports and dashboards that key department heads will utilize on a regular basis to make informed business decisions. Work with multiple Project Managers to deliver capabilities/projects/data sets/reports that have been prioritized by the Business Product Owners. Works with the Manager of the Departments Research & Data Team and other stakeholders to accurately integrate collected data into the data warehouse. Using descriptive analytics, researches and performs statistical analysis to identify actionable insights. Ensures that reporting and key institutional metrics are regularly updated, available, and accurate. Provides expertise to the Data Governance team. Create ad-hoc reports as needed. Stays current of technology and best practices. Regularly attends training and proactively conducts research when available. Assist in overseeing the work of several other individuals. Must be able to motivate team members, delegate tasks, perform knowledge transfer and mentor staff. Must be able to handle all duties and information in a confidential manner. Must have the ability to simplify information systems and make sound business decisions. Perform other job-related duties as assigned. MINIMUM QUALIFICATIONS: Masters or Bachelor's Degree, from an accredited college/university, in Computer Science, Information Systems, or other related field, or four (4) years of equivalent work experience. Seven (7) or more years experience in a Business Intelligence (BI), Data Engineer, or Extract, Transform, and Load (ETL) role. Proven experience working with SQL databases and Microsoft Structured Query Language (SQL) Server. Proven track record of successful data warehouse implementations. Proven experience in data warehouse design and development. Proven experience in ETL tools and processes, and in data migration projects. Proficient understanding of data warehousing methodologies. Proven proficiency with Microsoft Power BI for creating dashboards and reports. Proven experience with data modeling, data architecture, and data quality concepts. Proven proficiency in SQL and other data languages. Excellent troubleshooting and problem-solving abilities. Strong communication skills, capable of explaining complex concepts to non-technical stakeholders. Must be able to clearly convey information and ideas in both written and verbal forms to share information and ideas and resolve issues. Strong written and verbal communication skills required. Ability to communicate/interact professionally and tactfully with people of different levels of education, cultural backgrounds, and life experiences, and to exhibit respect to others. Organizational skills with strong attention to detail including the ability to adequately establish time frames and deadlines, to meet deadlines, and to follow through on tasks and assignments. Candidates must successfully complete a Level II Background Check. DESIRED QUALIFICATIONS: Experience working in the corrections or public safety sector. Experience working with financial systems. Previous involvement in public sector IT projects. Experience working with large datasets and data lakes. Experience with other data visualization tools. Familiarity with Databricks SQL. Experience with Big Data technologies. Familiarity with Machine Learning and Artificial Intelligence concepts and their application in data analysis. Experience in implementing ML and AI solutions in data warehouse environments. Experience with security technologies around cloud solutions, preferably Azure. Experience managing projects using Scrum and Kanban. Preferred Licensing or Certifications, such as: ASCM Warehousing Certification Data Warehousing and BI Certification Training Data Warehousing for Business Intelligence Specialization BI Foundations with SQL, ETL and Data Warehousing Specialization Enterprise Data Management We believe in fostering a positive, inclusive culture that values diversity, teamwork, and personal growth. With opportunities for advancement and a supportive community of colleagues, The Greentree Group is the perfect place to build your career. Learn more about us at www.greentreegroup.com. Please note that this role may require a National Agency Check (NAC) and/or background check, and relocation assistance is not available at this time. Greentree is an Equal Opportunity Employer and does not discriminate based on race, color, religion, sex, national origin, age, sexual orientation, gender identity, genetic information, or status as a qualified individual with a disability or protected veteran. Compensation / Salary Range: Greentree adheres to federal, state, and local regulations. This is a Full-Time, Salary, Exempt position. The following salary range is what we reasonably expect to pay but is contingent and subject to a variety of factors, including but not limited to years of experience, education, certification(s), training, specialized skills, responsibilities, etc. Bonuses: Greentree has an employee referral bonus, as well as employee bonuses based on employee contributions and Greentrees yearly performance. Top Benefits Core Benefits 100% paid by Greentree: Employee Medical Premium on the High Deductible Health Plan (HDHP), Basic Life Insurance and AD&D, Short-Term Disability (STD), Long-Term Disability (LTD), Health Reimbursement Account (HRA), 401(k) Match, Job-Related Certifications, and Training Programs Elected Benefits: Medical, Dental, Vision, HSA, FSA, Voluntary Term Life, 401(k) (Roth and Pretax available) Time Off: PTO, Flexible Schedules, Holidays and Paid Parental Leave: Work-life balance is important we all enjoy some time off for rest and relaxation Employees receive a very generous amount of PTO which is granted on start date, plus the ability for quick escalation to the next tier. Flexible/hybrid working schedules and 11 paid holidays, in addition to paid parental leave round out the work-life balance benefits. Paid Training and Development: We encourage and support ongoing employee learning and development, consistent with needs of the company, its clients, and markets. Greentree is committed to paying the cost for job-related certifications and/or training programs. In conjunction with management/employee communication and discussions regarding performance and goals, employees are expected to seek out and pursue development opportunities to meet emerging organizational skill requirements in combination with their own personal growth needs. Greentree also makes job-related tuition reimbursement contributions for those in higher-level education programs.

The Master Data Analyst is responsible for providing key support for timely master data changes among their specific domain. Work integrally with and assist Stakeholders, Sales Administrators, Account Managers, Program Managers, Product Managers, Directors, Senior Leadership and other staff to continuously improve upon our service offerings and delivery to customers. This is a 6 to 8 month Hybrid opportunity. Must be located in the DFW area and able to work onsite 100% for training then Tuesday and Thursday after. Qualifications: <ul> <li>Bachelor's degree required</li> <li>1+ years' related experience</li> <li>Analytical experience strongly preferred.</li> <li>Experience working with data to analyze, research and execute daily process</li> <li>Intermediate proficiency with Microsoft Excel</li> <li>Experience with tools such as SAP and Salesforce preferred</li> <li>Excellent interpersonal problem-solving skills with the ability to multitask and manage multiple priorities</li> <li>Ability to work independently</li> <li>Excellent written and verbal communication skills</li> <li>Excellent organizational skills</li> <li>Highly motivated self-starter</li></ul> salary: $25 - $30 per hour shift: First work hours: 8 AM - 5 PM education: Bachelors Responsibilities <ul> <li>Perform collection, interpretation and recording of data in accordance with documented guidelines and standards.</li> <li>Provide key support for timely master data changes among their specific domain (Material).</li> <li>Work integrally with and assist Stakeholders, Sales Administrators, Account Managers, Program Managers, Product Managers, Directors, Senior Leadership and other staff to continuously improve upon our service offerings and delivery to customers.</li></ul> Skills<li>Data Analysis</li><li>SAP</li><li>SalesForce.com</li><li>Microsoft Excel</li><li>Customer Data Analysis</li><li>Accounting</li> Qualifications<li>Years of experience: 1 year</li><li>Experience level: Experienced</li> Randstad is a world leader in matching great people with great companies. Our experienced agents will listen carefully to your employment needs and then work diligently to match your skills and qualifications to the right job and company. Whether you're looking for temporary, temporary-to-permanent or permanent opportunities, no one works harder for you than Randstad. Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status. At Randstad, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com. Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility). This posting is open for thirty (30) days.

SAS Business Data Analyst <ul> <li> Location: Pomona, California </li> <li> Type: Contract </li> <li> Job #78260 </li> </ul> An electric utility client is looking for a SAS Business Data Analyst who will support the inspection ORG, related to planning and scheduling. Location: Pomona, CA 91768 (HYBRID) Position: SAS Business Data Analyst Pay Rate: $38.60+/hr. on W2 (depending on experience) Duration: 8 months or longer Schedule: M-F, 8-5 ***Hybrid, Mondays and Tuesdays are In-Office days. 1 Innovation Way, Pomona, CA*** RESPONSIBILITIES: Exception Processing <ul> <li>Mapping - Create .kmz and spatial joins in Excel to determine potential access issues related to CROPS, Government Lands, etc. <li>Create work orders for released access issues and send to vendors with notes regarding appointments, gate codes, special instructions, contact info, etc. <li>Tracking and oversight of constrained inspections to actively mitigate the potential for non-compliant inspections and not meeting risk mitigation commitment. <li>Drive down 'double dip' inspection charges for access issues. <li>Assist in development and monitoring of data management tools to provide more timely and accurate status reporting to management. <li>Identify follow-up actions required by various stakeholders in the inspection workflow. <li>An additional resource can take advantage of the data management tools and process improvements being developed, to provide more timely and accurate status reporting to management and to identify follow-up actions required by various stakeholders in the inspection workflow. <li>Contacting customers to arrange appointments for inspections and track to ensure completion. </ul> Requisitions <ul> <li>Create requisitions in Ariba for all scopes, including Commissioning, GO165 Compliance Sweep, and yearly scope. <li>Work closely with internal invoicing resources to ensure validation occurs seamlessly <li>Ensure the accuracy of PREQs and will work closely with procurement and vendors for any issues that may arise. </ul> Planning & Scheduling - Scope Releases <ul> <li>Create work orders taking all the necessary steps to ensure the accuracy of the scope <li>Analyze to ensure inspections have not been released yet <li>Gather planned scope and organize data (by resource, location, the timing of inspection, etc.) into script <li>Rename work orders based on bucket (Commissioning, GO165 Sweep, 2x Per Year, AOC) <li>Run script through SAP to create draft work orders <li>If errors occur, clean data (remove inactive FLOCs, repair structure data, rearrange structures to build larger WO) <li>Rerun script to recheck errors <li>Run script to create actual work orders <li>Organize work orders by resource and submit IT tickets to move work orders to appropriate inspection groups in ClickSchedule <li>Validate with resources that all work orders have been loaded into their ClickSchedule hierarchies </ul> Scope Packages <ul> <li>Organize scope by vendor, type (360 vs ground), bucket (Follow-Up, GO165 Sweep, Commissioning, etc), priority (due date) in Excel <li>Assign Block IDs <li>Share scope files with vendors via email and SharePoint <li>Update source sheets and ensure the dashboard have updated appropriately <li>If not, troubleshoot with Data Science or PADI </ul> Planning & Scheduling - Scope Removals <ul> <li>Remove scope from vendors as needed <li>Remove FLOCs from work orders <li>Update source sheets so dashboards reflect changes </ul> AdHoc Reporting / Data Analysis <ul> <li>Support Planning & Scheduling Advisor/Analyst to run both regular weekly/daily reports, ad hoc reports internally and externally as well as any special analysis needed to resolve issues/process improvements such as 1, 2, skip a few, reports related to finance/cost analysis, supporting any issues that arise from vendors or internally such as data discrepancies. <li>Identify data discrepancies through SAP, InspectApp, EZYViewer research <li>Using systems like SAS Enterprise, SAS VA, SAP, PowerBi, Python, WiSDM to: <li>Report on historical performance (by structure, region, resource, etc.) <li>Find sync issues <li>Understand trends in survey results (by inspector, resource, type of inspection) <li>Validate inspections are populating in dashboards (SAS, Power BI) <li>If not, contact Data Science and PADI and follow through to resolution. <li>Communicate with InspectApp/InspectForce team both internal to Inspections and IT regarding sync issues and tracking resolution </ul> Performance Tracking <ul> <li>Track the completion of various scopes on weekly/daily basis </ul> QUALIFICATIONS: <ul> <li>3-5 years of related experience. <li>Top 5 required skills set: Software proficiency - MS Office Suite, SAS, SAP, PowerBI, SQL, Python <li>Data management (data structure and controls design, data querying, and report development) <li>Time management (manage resolution of work to align with workflow due dates and inspection due dates) <li>Comfortable engaging multiple SMEs across multiple organizations, presenting issues and potential solutions, and securing support and/or buy-in from stakeholders and support partners <li>Project tracking from issue ID, causal analysis, and solutioning, through resolution of issue <li>Data visualization reporting and dashboard development Software proficiency <li>Help individuals frequently in navigating work orders, maintenance plans, mdocs, FLOC/Equipment data) <li>Has prior experience with SAP transformations, especially as it pertains to data cleansing and validation. With S/4HANA transformation, this could be valuable. ArcGIS <li>Join different visual layers/maps (districts, FLOCs, circuits, hexbins, constrained areas) to create tables of data to work with more effectively </ul> About our client: Our client is one of the largest electric utilities and a longtime leader in renewable energy and energy efficiency in the United States providing electricity for much of Southern California. About APR: Since 1980 APR Consulting, Inc. has provided professional recruiting and contingent workforce solutions to a diverse mix of clients, industries, and skill sets nationwide. Qualified applications with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. We are an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, national origin, disability status, genetic information, protected veteran status, or any other characteristic protected by law. Don't miss out on this amazing opportunity! If you feel your experience is the match for this position please apply today and join our team. We look forward to working with you! #SLA

Calm Data Analyst Interview Guide

Overview

Calm Data Analyst Salary

Calm Data Analyst Interview Process

Calm Data Analyst Interview Questions

Calm Data Analyst Jobs