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

Wellpath Data Analyst Interview Guide

Getting ready for an Data Analyst interview at Wellpath? The Wellpath Data Analyst interview span across 10 to 12 different question topics. In preparing for the interview:
<ul>
<li>Know what skills are necessary for Wellpath Data Analyst roles.</li>
<li>Gain insights into the Data Analyst interview process at Wellpath.</li>
<li>Practice real Wellpath 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 Wellpath Data Analyst interview.


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

- Know what skills are necessary for Wellpath Data Analyst roles.
- Gain insights into the Data Analyst interview process at Wellpath.
- Practice real Wellpath 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 Wellpath Data Analyst interview.
        

Overview

Wellpath 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.

Wellpath 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

Let’s say that you’re a data scientist at Robinhood. 

How do we measure the launch of Robinhood’s fractional shares program?

Let’s say you are a data scientist at Robinhood.

Robinhood is introducing a program to allow users to buy fractional shares of publically listed companies.

Focusing in on the activity of new users, which of the following metrics would be the LEAST important to keep track of in determining if the program added value to Robinhood’s platform for new users?

Let's say you are a data scientist at Robinhood. 



Robinhood is introducing a program to allow users to buy fractional shares of publically listed companies.



Focusing in on the activity of new users, which of the following metrics would be the LEAST important to keep track of in determining if the program added value to Robinhood's platform for new users?

Fractional Shares Metrics

Fractional Shares

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

Wellpath Data Analyst Interview Questions

Compensation Range: $74,954.88 - $91,611.52 / year You Matter: Make a difference every day in the lives of the underserved Join a mission driven organization with a people first culture Excellent career growth opportunities Join us and find a career that supports: Caring for overlooked, underserved, and vulnerable patients Diversity, equity, inclusion, and belonging Autonomy in a warm team environment Growth and training Perks and Benefits In addition to comprehensive benefits including medical, dental, vision, paid time off, and 401k, we foster a work, life balance for team members and their family to support physical, mental, and financial wellbeing including: DailyPay, receive your money as you earn it! Tuition Assistance and dependent Scholarships Employee Assistance Program (EAP) including free counseling and health coaching Company paid life insurance Tax free Health Spending Accounts (HSA) Wellness program featuring fitness memberships and product discounts Preferred banking partnership and discounted rates for home and auto loans *Eligibility for perks and benefits varies based on employee type and length of service. Why Us: Now is your moment to make a difference in the lives of the underserved. If there is one unifying characteristic of everyone on our team, it is the deep desire to make a difference by helping society's most vulnerable and often overlooked individuals. Every day we have the distinct honor and responsibility to show up with non-judgmental compassion to provide hope and healing to those who need it most. For those whose calling it is to serve others, now is your moment to join our mission to provide quality care to every patient with compassion, collaboration, and innovation, to live our mantra to Always Do The Right Thing!, and to collectively do our part to heal the world, one patient at a time. Wellpath sees hundreds of thousands of unique individuals in their facilities month over month and a very large percent of those individuals receive direct clinical care, which includes lives saved by Narcan. We offer ongoing training and development opportunities for licensed and unlicensed healthcare team members, and have best in class clinical resources for training, education, and point of care support. How you make a difference: The Business Analyst will be responsible for evaluating and analyzing the current state of the business, gathering requirements for new solutions, and performing gap analysis to identify areas for improvement and increased efficiencies. They will provide recommendations based on their analysis to help the organization achieve its business goals and objectives. The Business Analyst will work closely with stakeholders from various departments to ensure that their recommendations align with the overall strategy of the organization. Key Responsibilities: Manage and report on various contractually required reports, including monthly facility visit summaries, compliance reports, staffing vacancies/reimbursements, and internal operating reviews. Conduct trend and root cause analysis using financial and utilization data, and research/report on claims and A/P systems. Develop and prepare reports for business planning, contract analysis, and operational feedback. Assist in developing project plans, including detailed work plans and timelines, using project management tools. Oversee projects from initiation to completion, including tracking, monitoring, reporting, and maintaining documentation of processes and implementations. Qualifications & Requirements: Education College degree in Finance or related degree. Experience Minimum 2-3 years of experience in a role demonstrating business system and financial analysis. Strong written communication skills & ability to clearly articulate analysis and recommendations to both financial & operations teams. Strong MS Office, including Excel, skills. Additional Details : This role reports onsite to our Arkansas DOC Regional Office located in Pine Bluff, AR. This role focuses on both Business Analyst duties and Administrative duties. The ideal candidate possesses experience in an administrative assistant type role. We are an Equal Employment Opportunity / Affirmative Action Employer: We celebrate diversity and are committed to creating an inclusive environment for all employees. We encourage you to apply! If you are excited about a role but your experience doesnt seem to align perfectly with every element of the job description, we encourage you to apply. You may be just the right candidate for this, or one of our many other roles. Deadline to apply to this position is contingent upon applicant volume. Those positions located in Colorado will have a specific deadline posted in the job description. by Jobble

You Matter: Make a difference every day in the lives of the underserved Join a mission driven organization with a people first culture Excellent career growth opportunities Join us and find a career that supports: Caring for overlooked, underserved, and vulnerable patients Diversity, equity, inclusion, and belonging Autonomy in a warm team environment Growth and training Perks and Benefits In addition to comprehensive benefits including medical, dental, vision, paid time off, and 401k, we foster a work, life balance for team members and their family to support physical, mental, and financial wellbeing including: DailyPay, receive your money as you earn it! Tuition Assistance and dependent Scholarships Employee Assistance Program (EAP) including free counseling and health coaching Company paid life insurance Tax free Health Spending Accounts (HSA) Wellness program featuring fitness memberships and product discounts Preferred banking partnership and discounted rates for home and auto loans *Eligibility for perks and benefits varies based on employee type and length of service. Why Us: Now is your moment to make a difference in the lives of the underserved. If there is one unifying characteristic of everyone on our team, it is the deep desire to make a difference by helping society's most vulnerable and often overlooked individuals. Every day we have the distinct honor and responsibility to show up with non-judgmental compassion to provide hope and healing to those who need it most. For those whose calling it is to serve others, now is your moment to join our mission to provide quality care to every patient with compassion, collaboration, and innovation, to live our mantra to Always Do The Right Thing!, and to collectively do our part to heal the world, one patient at a time. Wellpath sees hundreds of thousands of unique individuals in their facilities month over month and a very large percent of those individuals receive direct clinical care, which includes lives saved by Narcan. We offer ongoing training and development opportunities for licensed and unlicensed healthcare team members, and have best in class clinical resources for training, education, and point of care support. How you make a difference: The Business Analyst will be responsible for evaluating and analyzing the current state of the business, gathering requirements for new solutions, and performing gap analysis to identify areas for improvement and increased efficiencies. They will provide recommendations based on their analysis to help the organization achieve its business goals and objectives. The Business Analyst will work closely with stakeholders from various departments to ensure that their recommendations align with the overall strategy of the organization. Key Responsibilities: <ul> <li>Manage and report on various contractually required reports, including monthly facility visit summaries, compliance reports, staffing vacancies/reimbursements, and internal operating reviews. </li><li>Conduct trend and root cause analysis using financial and utilization data, and research/report on claims and A/P systems. </li><li>Develop and prepare reports for business planning, contract analysis, and operational feedback. </li><li>Assist in developing project plans, including detailed work plans and timelines, using project management tools. </li><li>Oversee projects from initiation to completion, including tracking, monitoring, reporting, and maintaining documentation of processes and implementations. </li></ul> Qualifications & Requirements: Education <ul> <li>College degree in Finance or related degree. </li> </ul>Experience <ul> <li>Minimum 2-3 years of experience in a role demonstrating business system and financial analysis. Strong written communication skills & ability to clearly articulate analysis and recommendations to both financial & operations teams. Strong MS Office, including Excel, skills. </li></ul> Additional Details : This role reports onsite to our Arkansas DOC Regional Office located in Pine Bluff, AR. We are an Equal Employment Opportunity / Affirmative Action Employer: We celebrate diversity and are committed to creating an inclusive environment for all employees. We encourage you to apply! If you are excited about a role but your experience doesnt seem to align perfectly with every element of the job description, we encourage you to apply. You may be just the right candidate for this, or one of our many other roles. Deadline to apply to this position is contingent upon applicant volume. Those positions located in Colorado will have a specific deadline posted in the job description.

You Matter: Make a difference every day in the lives of the underserved Join a mission driven organization with a people first culture Excellent career growth opportunities Join us and find a career that supports: Caring for overlooked, underserved, and vulnerable patients Diversity, equity, inclusion, and belonging Autonomy in a warm team environment Growth and training Perks and Benefits In addition to comprehensive benefits including medical, dental, vision, paid time off, and 401k, we foster a work, life balance for team members and their family to support physical, mental, and financial wellbeing including: DailyPay, receive your money as you earn it! Tuition Assistance and dependent Scholarships Employee Assistance Program (EAP) including free counseling and health coaching Company paid life insurance Tax free Health Spending Accounts (HSA) Wellness program featuring fitness memberships and product discounts Preferred banking partnership and discounted rates for home and auto loans *Eligibility for perks and benefits varies based on employee type and length of service. Why Us: Now is your moment to make a difference in the lives of the underserved. If there is one unifying characteristic of everyone on our team, it is the deep desire to make a difference by helping society's most vulnerable and often overlooked individuals. Every day we have the distinct honor and responsibility to show up with non-judgmental compassion to provide hope and healing to those who need it most. For those whose calling it is to serve others, now is your moment to join our mission to provide quality care to every patient with compassion, collaboration, and innovation, to live our mantra to Always Do The Right Thing!, and to collectively do our part to heal the world, one patient at a time. Wellpath sees hundreds of thousands of unique individuals in their facilities month over month and a very large percent of those individuals receive direct clinical care, which includes lives saved by Narcan. We offer ongoing training and development opportunities for licensed and unlicensed healthcare team members, and have best in class clinical resources for training, education, and point of care support. How you make a difference: The Business Analyst will be responsible for evaluating and analyzing the current state of the business, gathering requirements for new solutions, and performing gap analysis to identify areas for improvement and increased efficiencies. They will provide recommendations based on their analysis to help the organization achieve its business goals and objectives. The Business Analyst will work closely with stakeholders from various departments to ensure that their recommendations align with the overall strategy of the organization. Key Responsibilities: <ul> <li>Manage and report on various contractually required reports, including monthly facility visit summaries, compliance reports, staffing vacancies/reimbursements, and internal operating reviews. </li><li>Conduct trend and root cause analysis using financial and utilization data, and research/report on claims and A/P systems. </li><li>Develop and prepare reports for business planning, contract analysis, and operational feedback. </li><li>Assist in developing project plans, including detailed work plans and timelines, using project management tools. </li><li>Oversee projects from initiation to completion, including tracking, monitoring, reporting, and maintaining documentation of processes and implementations. </li></ul> Qualifications & Requirements: Education <ul> <li>College degree in Finance or related degree. </li> </ul>Experience <ul> <li>Minimum 2-3 years of experience in a role demonstrating business system and financial analysis. Strong written communication skills & ability to clearly articulate analysis and recommendations to both financial & operations teams. Strong MS Office, including Excel, skills. </li></ul> We are an Equal Employment Opportunity / Affirmative Action Employer: We celebrate diversity and are committed to creating an inclusive environment for all employees. We encourage you to apply! If you are excited about a role but your experience doesnt seem to align perfectly with every element of the job description, we encourage you to apply. You may be just the right candidate for this, or one of our many other roles. Deadline to apply to this position is contingent upon applicant volume. Those positions located in Colorado will have a specific deadline posted in the job description.

ABOUT USOur why Crafty Counsel’s mission is to bring joy, insight, and connection to in-house legal professionals around the world. (Who are “in-house legal professionals”? They’re lawyers working in the legal departments of companies and other organisations, rather than in law firms or barristers’ chambers.)  Our how  Crafty Counsel is where in-house legal can grow their network, nurture their career, and cultivate their resources.  As the UK’s fastest growing community for in-house lawyers, we do this by creating events, community, content, and insights for members.  At the core of our offering is events which include Crafty Fest - the largest event for in-house legal in the UK with approximately 700 attendees, several other smaller conferences and regular virtual meetups. We also run an active online Community Hub and app, our members trade recommendations, career opportunities, and general moral support. An affiliated network of volunteers within the community run ‘Crafty Locals’ - small scale meetups in towns and cities across the UK, and beyond. Law firms, legal tech companies, and others in the legal sector often want to meet with, partner with, and market to in-house lawyers. We work with those organisations to create content, shape their market positioning, generate new business, and understand their clients better.  THE ROLE We are looking for a data analyst with great attention to detail, process-driven mindset, and passion for community-first brands to join our team. As a data enthusiast, you will be able to take complex data sets and work magic that help the business to meaningfully use data. Reporting to the Head of Marketing, this role will be supporting the business as a whole. You will play a key role in driving growth and shaping the future of the business with data-driven insights. WHAT WILL I BE DOING? <ul><li>Act as the custodial guardian of data for the company</li><li>Monitoring, evaluating and creating regular reports on key performance indicators (KPIs) across various platforms relating to marketing, sales, events, and community </li><li>Extracting data sets, transforming and developing visual data reporting, enabling the business to monitor real-time progress on KPIs and highlight trends across various platforms</li><li>Support our Events and Marketing team by producing ticketing forecasts </li><li>Analyse customer and community data to identify patterns, trends and insights which can be used across the business for enhance retention, increase engagement and reduce churn</li><li>Providing data relevant for our commercial partners to support the Commercial team’s sales process and producing wrap-up reports at the end of partnership projects </li><li>Responsible for for day-to-day data governance activities such as resolving duplicates, ensuring data completeness, reporting on data quality, and monitoring data related to compliance with internal policies</li><li>Championing automation within the wider business by making recommendations and supporting teams to achieve their goals</li><li>Contribute to wider business strategy and projects by providing data-driven recommendations, analysing trends and growth opportunities</li><li>Own CRM application and updates, including data to ensure to ensure integrity and optimal performance</li><li>Develop and refine customer segmentation to help us improve experience and bring a higher level of personalisation </li><li>Working with the Head of Marketing to recommend and implement visualisation application, including training of business users</li></ul> WHAT WILL I BRING TO THE ROLE?<ul><li>2-3 years experience in data, analytics or another directly applicable area </li><li>Bachelor's degree in Statistics, Mathematics, or a related field, or equivalent experience</li><li>Demonstrate advanced proficiency in Excel/Google Sheets, Google Analytics 4 (GA4), and HubSpot. </li><li>Knowledge of data sciences, coding/scripting languages and databases</li><li>With a great level of attention to detail, you’ll be able to work with and analyse complex qualitative and quantitative data sets </li><li>Bringing magic to data visualisation by conveying findings in clear, creative and accessible ways </li><li>Confident in contributing new ideas to the business</li><li>Enjoy looking at things in different ways to find trends and opportunities that others might not have noticed</li><li>Able to see the big picture and how your work fits into what we’re trying to achieve as a business</li><li>Enthusiastic self-starter who wants to grow, try new things and can also adapt to change</li><li>We are small team so you must be collegiate and fun</li><li>Legal sector experience is a “nice to have” </li></ul> WORKING CULTURE:Our values We feel strongly about our values and these are: Community First, Creativity, Curiosity, Humility, Integrity, Joy, Long Term Thinking, Security. We can share more on these choices in interview.  We are looking for someone for whom these values resonate, and someone who can add to our strong team culture.  How we work We work in a hybrid work environment where our centre of gravity is central London. What this means is:<ul><li>First business day of the week: the whole team works together in person. </li><li>Rest of the week: each team decides its own pattern, by business need. </li><li>You will be required to attend most of our events in person, which may involve some evening work. </li><li>Think of it as a very flexible and humane model but where you need to be able to (and want to!) get into London frequently. </li><li>Our office is in Holborn / Tottenham Court Road. </li></ul>You can also work fully remotely up to four weeks a year, usually when we are not holding events. Once a year, we travel for an overnight stay in a UK location for a team offsite. So far, we’ve been to York, Oxford, and Brighton. Benefits <ul><li>Salary: up to £37,500 gross, experience dependent   </li><li>Benefits include </li><li>£500 annual budget for learning and development, conferences, memberships, anything that is professionally useful to you</li><li>£250 - annual work from home grant to spend on office equipment (that will be yours to keep) above and beyond the laptop we provide you</li><li>25 days of holiday plus UK public holidays plus your birthdays off </li><li>A top of the market maternity and paternity policy </li><li>Private medical scheme</li></ul>

Position Summary... What you'll do... Principal Data Analyst-Global Travel About the Team: We are diverse team made up with members from around the globe that support both Procurement and Travel Operations. Our goal is to support our Global Enterprise Business, by leveraging discounts and rates to deliver maximum savings and value. About the Position: Walmart's Global Travel organization is looking for a Principal Data Analyst. As a primary steward of our company, you'll engage with multiple global teams while working alongside a global operational forward-thinking team. Reporting to the Director of Sourcing, you will primarily support the Global Travel Procurement team with developing strategies, data, analysis, reporting, technology, visualization and insights. Key responsibilities: <ul> <li>Leverage programing languages and tools used to manipulate, analyze, visualize, and draw insights from big data sets (e.g. SQL, Python, R, MS PowerBI, Tableau, Tableau Prep, Dataiku, Big Query, etc....) </li><li>Develop dynamic dashboards and reports in response to the needs and priorities of designated Internal/External stakeholder(s) </li><li>Collaborate with Global Travel Procurement team to provide analytics to support supplier RFP's </li><li>Provide insights and innovation across functional workstreams </li><li>Effective communication skills (written, verbal, presenting, and visual) to influence stakeholders to implement fact-based recommendations from actionable insights. Demonstrating sound judgment and articulating supporting insights in a compelling way. Understanding how to connect broader sets of analyses and findings into a cohesive storyline. </li><li>Follow competitors, consumer trends, and market dynamics impacting supported categories. </li></ul>You'll sweep us off our feet if... <ul> <li>You have a background supporting travel, finance or corporate compliance teams with analytics, and data governance. </li><li>You have a strong understanding of statistics and advanced analytics </li><li>You have strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy </li><li>You have sound knowledge of managing data for experiments (sampling, labelling, EDA, etc.) </li><li>You have skills in SQL and "Big Data" queries (i.e. Hive or Google Big query) </li><li>You have experience with data visualization and reporting using Walmart's preferred tools: Tableau, Looker or Power BI, Finalytics </li><li>You have strong people and communication skills to connect authentically with internal stakeholders. </li><li>You are curious, proactive and comfortable working in a fast-paced environment </li></ul>Bonus points if you have... <ul> <li>Experience transforming innovative ideas into practical analytics solutions </li></ul> At Walmart, we offer competitive pay as well as performance-based bonus awards and other great benefits for a happier mind, body, and wallet. Health benefits include medical, vision and dental coverage. Financial benefits include 401(k), stock purchase and company-paid life insurance. Paid time off benefits include PTO (including sick leave), parental leave, family care leave, bereavement, jury duty, and voting. Other benefits include short-term and long-term disability, company discounts, Military Leave Pay, adoption and surrogacy expense reimbursement, and more. ? ? ? You will also receive PTO and/or PPTO that can be used for vacation, sick leave, holidays, or other purposes. The amount you receive depends on your job classification and length of employment. It will meet or exceed the requirements of paid sick leave laws, where applicable. ? For information about PTO, see https://one.walmart.com/notices . ? ? Live Better U is a Walmart-paid education benefit program for full-time and part-time associates in Walmart and Sam's Club facilities. Programs range from high school completion to bachelor's degrees, including English Language Learning and short-form certificates. Tuition, books, and fees are completely paid for by Walmart. ? Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to a specific plan or program terms. ? For information about benefits and eligibility, see One.Walmart . ? The annual salary range for this position is $90,000.00-$180,000.00 ? Additional compensation includes annual or quarterly performance bonuses. ? Additional compensation for certain positions may also include: ? ? - Stock ? ? Minimum Qualifications... Outlined below are the required minimum qualifications for this position. If none are listed, there are no minimum qualifications. Option 1: Bachelor's degree in Business, Engineering, Statistics, Economics, Analytics, Mathematics, Arts, Finance or related field and 4 years' experience in data analysis, data science, statistics, or related field. Option 2: Master's degree in Business, Engineering, Statistics, Economics, Analytics, Mathematics, Computer Science, Information Technology or related field and 2 years' experience in data analysis, data science, statistics, or related field. Option 3: 6 years' experience in data analysis, data science, statistics, or related field. Preferred Qualifications... Outlined below are the optional preferred qualifications for this position. If none are listed, there are no preferred qualifications. Data science, data analysis, statistics, or related field, Master's degree in Business, Computer Science, Engineering, Statistics, Economics, Analytics, Mathematics, Computer Science, Information Technology or related field, Related industry experience (for example, retail, merchandising, healthcare, eCommerce), Successful completion of assessments in data analysis and Business Intelligence tools and scripting languages (for example, SQL, Python, Spark, Scala, R, Power BI, or Tableau) Primary Location... 2608 Se J St, Bentonville, AR 72712, United States of America

SummaryThe Data Analyst’s role is to analyze, specify and validate the business needs of the organizations. In this role, the Data Analyst will play a key part in the design, development, and launch efficient business, financial, and operations systems in support of core organizational functions and business processes. This includes gathering and analyzing data in support of business cases, proposed projects, and systems requirements. The Data Analyst is also responsible for supporting the development process, and ensuring that project deliverables are met according to specifications. This individual will apply proven communication, analytical, and problem-solving skills to help maximize the benefit of IT system investments. Essential Functions<ul><li>Meets with executive leadership, decision makers, business owners, technical owners, and end users to define business, financial, and operations requirements and systems goals</li><li>Collaborates with project managers and project sponsors to determine project scope and vision</li><li>Identifies project stakeholders and establish roles and responsibilities (process owners, change champions, etc.)</li><li>Conducts interviews and data analysis to document requirements via workshops, questionnaires, surveys, site visits, workflow storyboards, use cases, scenarios, and other methods</li><li>Develops and utilizes standard templates to accurately and concisely write requirement specifications</li><li>Analyzes and verifies requirements for completeness, consistency, comprehensibility, feasibility, and conformity to standards</li><li>Identifies and establishes scope and parameters of requirements analysis in order to define impact, outcome criteria, and measure-taking actions</li><li>Collects, interprets, and performs analysis across large data sets and relational databases</li><li>Translates conceptual user requirements into data transformation or reporting requirements in a clear manner that is comprehensible to developers/project team</li><li>Provides quality assurance of imported data, working with developers and DBA’s as needed</li><li>Develops reports to support data integrity and normalization </li><li>Evaluates changes and updates to source system and their impacts to existing data framework</li><li>Identifies and establishes scope and parameters of requirements analysis in order to define impact, outcome criteria, and measure-taking actions</li><li>Works with stakeholders and project team to prioritize collected requirements</li><li>Creates process models, specifications, diagrams, and charts to provide direction to developers and/or the project team</li><li>Develops and conducts peer reviews to ensure that requirement specifications are correctly interpreted</li><li>Manages and tracks the status of requirements throughout the project lifecycle; enforce and redefine as necessary</li><li>Communicates changes, enhancements, and modifications – verbally or through written documentation project managers, sponsors, and other stakeholders so that issues and solutions are understood</li><li>Research, reviews, and analyzes the effectiveness and efficiency of existing requirements-gathering processes and develop strategies for enhancing or further leveraging these processes</li><li>Assists in conducting research on software and hardware products to justify recommendations and to support purchasing efforts</li><li>Establishes practices and procedures that work towards the continuous improvement of the requirements process</li><li>Provides guidance and/or instruction to junior staff members</li></ul> Required Qualifications<ul><li>College diploma or university degree in software engineering, computer science, or business administration or equivalent work experience</li><li>5 or more years as a data analyst (Proven experience with business and technical requirements analysis, elicitation, modeling, verification, and methodology development)</li><li>5 or more years of experience developing reports in Power BI</li><li>Advanced SQL Experience</li><li>Advanced Excel skills</li><li>Advanced Power BI skills (Data modeling, DAX expressions, Gateways, Apps, Data Flows, etc)</li><li>Experience with Data Mapping</li><li>Experience with Data Modeling</li><li>Experience with large scale data migrations</li><li>Familiarity with sourcing data from Data Warehouse and data mining</li><li>Proven data analysis, data verification, and problem-solving abilities</li><li>Familiarity with software and database development and network architecture</li></ul> Desired/Preferred Qualifications<ul><li>Experience with core software applications, including MS CRM, SharePoint, MS GP, SQL Server 2005 and above</li><li>Experience writing and managing QlikView reports</li><li>Experience writing and managing SSRS reports</li><li>Experience importing data for use in report software, spreadsheets, graphs, and flow charts</li><li>Excellent written and oral communication skills</li><li>Ability to communicate ideas in both technical and user-friendly language</li><li>Able to prioritize and execute tasks in a high-pressure environment</li><li>Ability to be self-motivating and work independently</li></ul><li></li>

<h3>Job Description</h3><div>Job Description<div>Data Engineer or Data Analyst **Remote** **5 year contract** CSEngineering is looking to add a Data Engineer/Data Analyst to our growing team! JOB RESPONSIBILITIES The Candidate shall develop community profiles within the areas of contamination including identification and characterization of: <ul><li>Socioeconomic indicators such as people of color, low-income populations, unemployment rate, limited English speaking/other languages, less than high school education, and age</li><li>Demographics (i.e., statistical data relating to the population and particular groups within it)</li><li>Environmental exposures burdens or cumulative exposures (e.g., populations disproportionately exposed to environmental risks or potential environmental quality issues),</li><li>Subsistence patterns within a community</li><li>Sensitive populations (e.g., low-income, elderly people, pregnant or nursing women, infants and children, and people with chronic illnesses).</li></ul><ul><li>Combination of the environmental and demographic indicators that is greater than usual.</li></ul> REQUIRED QUALIFICATIONS Security Clearance: Public Trust <ul><li>Must have a BS/BA (Technical or Management degree).</li><li>Minimum 5 years of experience as a Data Engineer or Data Analyst.</li><li>Experience with Data analytics and the designing, maintaining, and optimizing data for data collection, management, transformation, and access. Particularly Meta Data and GIS/GeoBase Spatial Data (Mapping).</li><li>Shall use federal and/or state online data tools such as CEJST and EPA's EJScreen to support development of the community profile.</li><li>Ability to interact with senior level government management in coordinating and communicating and managing cross functional teams.</li><li>Demonstrated success in coordinating with other project resources Federal and Contract.</li><li>Demonstrated experience and success in working with data related to Environmental Justice.</li><li>Excellent communication skills, multi-task and lead several projects simultaneously.</li><li>Strong analytical and problem-solving skills.</li><li>Must be a United States Citizen</li></ul> Location: Remote COMPANY OVERVIEW Who we are- CSEngineering, a Service-Disabled Veteran-owned small business established in 2002, is dedicated to becoming the premier engineering and services firm in our industry, all while prioritizing client satisfaction above all else. What we do- With a rich history of excellence, we boast significant expertise in a wide array of areas, including satellite systems, weapons and missile systems, naval architecture, aviation systems, IT and Enterprise Architecture, and more. We offer a comprehensive range of services, including logistics, program management, and IT operations. As a recipient of the Hire Vets Gold Medallion award, we're proud of our commitment to veteran hiring, retention, and professional development. Why should you be a part of CSE- At CSEngineering, our employees are at the heart of everything we do. We foster a culture of passion and growth, where individuals are encouraged to excel build fulfilling careers, and continually strive for excellence. Our dedication to innovation and excellence propels us forward, as we continuously strive to set new standards in our industry. Join us and be part of a team that's redefining what's possible.CSEngineering offers a competitive salary and comprehensive benefits package, including medical, dental, life, disability, 401k, and paid time off.CSEngineering is an equal opportunity employer committed to a culturally diverse workforce. All qualified applicants will receive consideration for employment without regard to race, religion, color, age, sex, national origin, sexual orientation, gender identity, or veteran status. #dice Job Posted by ApplicantPro </div></div>

JOB DESCRIPTIONInsight Global is looking for a Data Analyst to join one of our top banking clients for a 6-month contract with high opportunities of extension. This is a 2-day hybrid role downtown Toronto. The Data Analyst will be joining the risk group responsible for monitoring and helping to define policies and products that address areas of significant risk. This team is accountable for a cross-functional, multi-year data architecture and technology platform development initiative to deliver new data and tech capabilities to support robust and timely insights related to risk appetite and capital management and enable data governance practices that enhance transparency and data integrity. The Data Analyst will be expected to understand and articulate the use case based on the business opportunity and the estimated value being delivered. They will use advanced analytical algorithms and technologies to mine and analyze large sets of structured and unstructured data to obtain insights and discover opportunities through end-to-end analysis of the existing data pipeline. The analysis will help to design and construct new processes for capital reporting, leveraging big data technology to design solutions that deliver smarter business decisions, improve customer experience, and drive productivity. They will collaborate with other data and analytics professionals and teams to optimize, refine, and scale analysis into mature analytics solutions. REQUIRED SKILLS AND EXPERIENCE- 1-2+ years of hands-on experience in performing deep-dive analysis from databases and deciphering technical documentation to understandable rules- 1-2+ years of experience with SQL, Python, AWS SageMaker, and PySpark- Fast learner with keen interest in big-data applications and a self-starter attitude- Ability to build various prototypes independently (including data processes, visualizations, and calculations)- Conducts large-scale analysis of information to discover patterns and trends by combining different modules and algorithms- Ability to translate business needs to technical specifications- Ability to develop tools and deliver training programs for the use of reporting tools and self-serve analytics by non-analytical end users- Ability to document data flow, systems, and processes to improve the design, implementation, and management of business and group processes- Excellent communication, collaboration, and time management skills to manage multiple deliveries simultaneously and work with different teams and stakeholders to enhance usability and aesthetic appeal of data analytics solutions NICE TO HAVE SKILLS AND EXPERIENCE- Knowledge of BASEL Accords and financial products- CFA/FRM or other related certifications

Your Role

The Data Analyst team is responsible for performing detailed data analysis, source to target designs, data profiling, and metadata management in support of new development, implementation or enhancement of existing data assets. The Data Analyst, Consultant will report to the Manager of Data Solutions and Asset Management. In this role you will participate in design, development, and implementation of large enterprise data warehouse/BI solutions. In addition, you will support operations and assist with production, incident resolution. This position requires strong collaboration with a cross-functional team consisting of business system analysts, business partners, third-party vendors, solution leads, data modelers, analysts, and development teams. The analysts will be responsible for understanding business requirements, researching/analyzing requirements and understanding datasets that support business functions, conduct data profiling, and provide appropriate source to target transformation rules/logic for the implementation. Data Analysts are expected to be an integral part of the full development lifecycle process from concept, design, development through testing, and implementation.

Your Work

In this role, you will:

Be responsible for performing data analysis which includes inspecting, profiling, transforming with the goal of discovering useful information, suggesting conclusions, and supporting decision-making

Own and manage portfolios and multiple assets within the healthcare portfolio and partner with analytics and business counterparts in providing solutions

Perform data analysis, gap and impact analysis for medium to large sized assignments (with mid/large number of data elements, one-to-multiple sources, business impact, and visibility)

Drive data analysis and profiling for complex data issues with options and recommendations

Develop extensible and flexible data analysis processes based on long-term strategy and promote reuse of existing structures when possible

Work on multiple projects as a project leader or sometimes as a project advisor on projects of varying complexity

Use documented procedures to create source-to-target mapping, capturing business and technical metadata, and complete data lineage.

Partner with Business Subject Matter Experts, Business System Analysts, Solution Technical Leads, Data/Application architects and development teams to analyze data requirements to ensure data design is aligned with business strategy, project and scope

Manipulate and analyze high-volume, high-dimensionality data from various sources using a variety of tools and data analysis techniques

Perform ad hoc, live research to demonstrate/present data issues, patterns, relationships, findings and/or recommendations, risks, and assumptions

Work with cross-functional teams: data stewards, architects, data governance, data modeler, data quality, development, solution leads, and QA team to address data and mapping questions

Work collaboratively with data quality analysts, data stewards, and data governance team to resolve data quality issues

Influence stakeholders to make product improvements that yield business value by effectively making compelling cases through storytelling, visualizations, and other influencing tools

Mentor and provide guidance to peers and junior staff

Your Knowledge and Experience

Requires a bachelor's degree preferably in computer science, statistics, or mathematics or equivalent experience

Requires at least 8 years of experience in data analysis

8+ years of hands-on experience in SQL, including querying large and complex data sets

8+ years of experience in one or more relational or columnar databases or appliances like Snowflake, DB2, Oracle, MS SQL Server, Netezza, Redshift etc.

8+ years acting as team lead or leading individual effort is preferred

Experience in cloud architecture, Azure framework, data vault methodology and data catalog tools like or similar to Collibra

Strong experience in data management, data integration, data warehouse, data virtualization and data quality design patterns and techniques

Preferred working experience in Domain models, Canonical models and API interfaces

Proven track record of full life cycle successes from inception to successful completion and production support

Ability to effectively communicate status, design, and approach to management/business sponsors/product managers

Familiar with standard software development tools, including incident tracking, version control, documentation and testing systems

Self-directed, ability to work with limited management direction and exercises considerable latitude in determining technical objectives of the assignment

Experience with iterative development life cycle methodologies and application of those principles, especially agile development practices

Demonstrated experience working with vendor partners, cross-functional and development teams in terms of end-to-end technical delivery

Strong analytic, process flow, problem-solving, communication, customer service, organization skills, required

Excellent verbal and written communication skills

Capable of delivering on multiple competing priorities with little supervision

Prior Healthcare experience is a plus

Pay Range:

The pay range for this role is: $118800.00 to $178200.00 for California.

Note:

Please note that this range represents the pay range for this and many other positions at Blue Shield that fall into this pay grade. Blue Shield salaries are based on a variety of factors, including the candidate's experience, location (California, Bay area, or outside California), and current employee salaries for similar roles.

#J-18808-Ljbffr

Wellpath Data Analyst Interview Guide

Overview

Wellpath Data Analyst Salary

Wellpath Data Analyst Interview Process

Wellpath Data Analyst Interview Questions

Wellpath Data Analyst Jobs