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

Location3 Media Data Analyst Interview Guide

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


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

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

Overview

What Location3 Media Looks for in a Data Analyst

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.

Location3 Media Data Analyst Interview Process

Interview Tips

Let’s say your team at Spotify wants to determine if a recently launched feature, curated playlists, has increased user engagement. However Spotify launched the feature without an A/B test.

How would you measure the effect of curated playlists on user engagement?

How would you establish causal inference to measure the effect of curated playlists on engagement without A/B?

Causal Inference Without A/B

A/B Testing & Experimentation

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 we’ve just delivered a product recommendation algorithm to a retail client, and it’s performing well on their current data.

How would you make sure this algorithm remains reliable and effective as the client’s customer preferences and product catalog evolve over the next year?

How would you ensure a delivered recommendation algorithm stays reliable as business data and preferences change?

Algorithm Reliability

ML Ops & Training Pipelines

Location3 Media Data Analyst Interview Questions

Excelsior University is seeking a Senior Data Analyst to leverage data to drive strategic initiatives, improve operational efficiency, and achieve institutional goals. Reporting to the Head of Data Science Center of Excellence , the analyst will collaborate closely with business partners in Academic Affairs, Strategic Partnerships and Alliances, and Fiscal Services. The role will be responsible for using data modeling and analytical techniques to inform financial decisions, determine ROI, and identify opportunities for efficiency and growth. This position is based out of the university's home office in Albany, NY with the option of considering remote candidates. Remote employees will have mandatory occasional travel for meetings, conferences, and professional development opportunities. Remote employees are expected to be available during work hours 8:30 am - 5:00 pm Eastern time. The University will supply necessary equipment to perform the essential functions of this job (e.g., Laptop, docking station). Employees are responsible for having a workspace where they can participate in virtual meetings without multiple interruptions and noise. Duties and Responsibilities: <li> Use predictive and prescriptive analytical techniques to enable leadership to make informed decisions.</li><li> Apply demonstrated knowledge of business modeling and business analysis to develop and maintain cost allocation and return on investment (ROI) models.</li><li> Uses various data analytics tools to clean, manipulate, and transform data for analysis.</li><li>Lead projects and work with business and academic leaders to identify deliverables and assumptions for analytical tools and models.</li><li> Communicate with data through written and oral reports, using data visualization techniques to present findings in a manner that can be easily understood by nontechnical audiences.</li><li>Promote data stewardship and data quality. Qualifications: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.<ul> <li>A bachelor's degree is required, master's degree preferred, from an accredited institution in business analytics, statistics, finance, or related empirical research field.</li> <li>Master's degree and higher education experience is preferred. Experience with financial analysis, business development, sales, B2B, or academic partnership data is a plus.</li> <li>Demonstrated knowledge and application of cost analysis related to business modeling, including ROI and direct and overhead cost allocation activities.</li> <li>Demonstrated ability to cogently summarize project findings and their implications, both orally and in written reports.</li> <li>Five or more years of relevant experience</li> <li> Analytical mindset and comfort with explaining quantitative analysis</li> <li>Strong attention to detail, thoroughness, and follow through</li> <li>Skill and experience with data analysis and large data sets</li> <li>Strong interpersonal and communication skills to convey project goals, requirements, and results effectively and positively</li> <li>Comfortable working with college leadership on a frequent basis</li> <li>Ability to design, analyze and model business opportunities and processes</li> <li>Ability to work independently and meet deadlines</li> <li> Ability to prioritize and manage multiple tasks</li></ul> The hiring salary range for this position is $73,000.00 - $85,000.00. The hiring salary range above represents the University's good faith estimate at the time of posting.</li> Application Information If you have problems with online submission, please call <a href="tel:5186088238" rel="nofollow">518-608-8238</a>. Excelsior University offers competitive compensation and a generous benefits package that includes paid time off, retirement, and excellent health insurance. Interested candidates should submit a letter of application, resume, and the names of three professional references. Please submit requested information by clicking the Apply Now button on this page. Excelsior University is an equal opportunity employer committed to ensuring all qualified applicants receive consideration for employment without regard to any legally protected characteristic. AA/EOE/ADA Excelsior University is an equal opportunity employer committed to ensuring all qualified applicants receive consideration for employment without regard to any legally protected characteristic.

<h3>Job Description</h3><div>Job Description<div><div>Wilson Elser is a leading defense litigation law firm with more than 1300 attorneys in 43 offices throughout the United States. Founded in 1978, we rank among the top 100 law firms identified by The American Lawyer and 36 in the National Law Journal's survey of the nation's largest law firms. We're also Mansfield Certified Plus.</div>Our firm is committed to attracting and retaining professionals who value each other and the service we provide by embracing Teamwork, Collaboration, Client Service, and Innovation. If you are a motivated professional looking for a long-term fit where you can grow in a role, and will be valued and empowered, then we invite you to apply to our HR Reporting Data Analyst position in our White Plains Office. This position is part of the HR Operations team.This position offers a flexible, hybrid working arrangement.The PositionThe HR Reporting Data Analyst will support the firm's HR Operations team by collecting, analyzing, and maintaining data to ensure accurate reporting and informed decision-making. This role is responsible for managing ad hoc and recurring reports, identifying data discrepancies, and supporting key HR initiatives through data-drive insight. This is an excellent opportunity for someone who enjoys working with data and systems and is eager to make a meaningful impact through reporting, analysis, and process improvement. Key Responsibilities<ul><li>Assist in data collection, tracking, analysis and reporting to support business needs</li><li>Ensure data quality by identifying and correcting errors or inconsistencies</li><li>Create and deliver ad hoc and recurring reports, dashboards, and visualizations</li><li>Manage all diversity-related reporting and data requests</li><li>Gather, organize, and input data into HR systems and databases with precision</li><li>Promptly identify and resolve discrepancies in employee information</li><li>Format reports and visualizations to enhance readability and clarity</li><li>Assist in automating reports and streamlining processes</li><li>Troubleshoot and resolve data-related challenges with a problem-solving mindset</li><li>Track service level agreements (SLAs) in the Jira HR ticketing system</li><li>Protect and maintain personal information with a high level of confidentiality abiding by Wilson Elser procedures</li><li>Collaborate with HR team members and other departments to ensure data accuracy and support key HR initiatives</li></ul>QualificationsEducation and Experience<ul><li>Bachelor's degree in Human Resources, Data Science, Business, Statistics or a related field preferred</li><li>Proficiency with data analysis tools, particularly Microsoft Excel</li><li>1-2 years of experience in a data-focused support or analytical role</li><li>Hands-on experience with HRIS systems (UKG preferred)</li></ul>Skills and Abilities<ul><li>Exceptional organizational skills and attention to detail</li><li>Strong analytical and problem-solving abilities</li><li>High level of proficiency in Microsoft Office Suite (particularly Microsoft Excel)</li><li>Understanding of data structures, reporting principals, and data integrity best practices</li><li>Effective written and verbal communication skills</li><li>Ability to handle confidential information with discretion and professionalism</li><li>Team player with collaborative, proactive mindset.</li><li>Willingness to learn and adapt to new tools, processes, and technologies</li></ul><div><div>A variety of factors are considered in making compensation decisions, including but not limited to experience, education, licensure and/or certifications, geographic location, market demands, other business and organizational needs, and other factors permitted by law. Final salary wages offered may be outside of this range based on other reasons and individual circumstances. This position is considered full-time and therefore qualifies for benefits including 401(k) retirement savings plan, medical, dental, vision, disability, and life insurance. Details of participation in these benefit plans will be provided if an employee receives an offer of employment. </div><div>Salary Range: </div><div>$55,000—$70,000 USD</div></div><div>Why Should You Apply? <ul><li>Benefits: Outstanding benefits package, including 401k match and generous PTO plan</li><li>Career Growth: Ample opportunities for professional development and advancement</li><li>Employee Perks: Access to corporate discount plans and other benefits</li></ul>Wilson Elser welcomes submissions of candidates for our open positions exclusively from recruitment agencies with an active, signed fee agreement who have been granted access to a position through our dedicated Recruitment Agency Portal. We are unable to consider submissions from recruitment agencies without a current (dated as of 7/1/2024) agreement in place. We appreciate your understanding. For collaboration inquiries or to establish an agreement, please contact us at talentacquisition@wilsonelser.com.Wilson Elser is committed to a collegial work environment in which all individuals are treated with respect and dignity. It is the Firm's policy that employment will be based on merit, qualifications, and competence. Further, employment decisions will be made without regard to an applicants race, color, age, sex, religion, creed, national origin, ancestry, citizenship, marital status, sexual orientation or preference, gender identity, physical or mental disability, status as a victim of domestic violence, sex offenses, or stalking, past or present service in the uniformed services or application or obligation to serve in the uniformed services, or any other characteristic protected by law. Wilson Elser endeavors to make the Wilson Elser website accessible to any and all users. You may review our Accessibility Policy here.California Residents may review our CCPA notice for applicants and employees here.#ZR</div></div></div>

<div><h2>Senior Healthcare Data Analyst</h2>Your Quest: Help make a big difference in healthcare accessAt Quest Analytics our team members can fulfill their quest to work in an innovative, collaborative, challenging and flexible environment supportive of personal growth every day. The team is driven to make healthcare more accessible for all Americans.We are looking for a Senior Data Analyst specializing in health plan network analytics to join our team. As a Senior Data Analyst, you will play a key role in advancing the intelligence and precision of health plan network analytics. This position focuses on working directly with large-scale healthcare datasetsincluding claims data, provider directory files, and provider network filesto uncover trends, measure network performance, and support the development of data-driven strategies for provider network optimization and improve network performance.You will be responsible for identifying and quantifying network challenges, conducting deep analytical investigations, and applying structured data exploration to generate meaningful, context-rich insights. This role requires a strong command of data tools, rigorous attention to data quality, and a passion for using data and analytics to solve complex problems in healthcare delivery.Ideal candidates are curious, methodical, and driven by a desire to understand the "why" behind the data. Success in this role depends on your ability to work independently with complex data inputs, apply critical thinking, and continually refine methods for extracting value from provider network-related datasets.<h3>In this role you will:</h3><ul><li>Data Ingestion and Cleansing:</li><li>Acquire and ingest relevant data sets, including claims data and provider network files.</li><li>Implement robust data cleansing procedures to ensure data accuracy and consistency.</li><li>Data Enrichment and Analysis:</li><li>Enhance datasets by integrating additional relevant information.</li><li>Analyze complex datasets using a variety of tools, with a particular emphasis on SQL, Excel, and Databricks.</li><li>Apply critical thinking and analytical curiosity to investigate data patterns, ask thoughtful and logical questions, explore root causes, and deliver context-driven insights that enhance understanding of business and can inform strategic decisions related to network design.</li><li>Results Dissemination:</li><li>Develop insightful and visually compelling reports using Power BI.</li><li>Effectively communicate findings to internal teams and external stakeholders.</li><li>Collaborate with cross-functional teams to ensure alignment of data analysis with business objectives.</li><li>Continuous Learning and Innovation:</li><li>Stay abreast of industry trends, regulations, and technological advancements.</li><li>Continuously explore novel approaches and methodologies to address healthcare network challenges.</li><li>Contribute to the development of cutting-edge solutions that differentiate our company in the market.</li></ul><h3>This role requires:</h3><ul><li>Required Qualifications:</li><li>Minimum of 5 years of experience in data analysis, with a strong preference for healthcare-related work</li><li>Demonstrated experience working with large datasets, including healthcare claims data</li><li>Proficiency in Excel</li><li>Proficiency in programming using SQL or Python</li><li>Strong understanding of technology, data manipulation tools, and data governance best practices</li><li>Ability to ask thoughtful, logical questions, pursue root cause analysis, and apply critical thinking</li><li>Strong analytical curiosity and a desire to understand the "why" behind the data</li><li>Proven ability to translate technical findings into clear, actionable business insights</li><li>Excellent problem-solving, listening, troubleshooting, and communication skills (both written and verbal)</li><li>Ability to work both independently and as part of a cross-functional team</li><li>Passion for contributing in a fast-paced, growth-oriented, and deadline-driven environment</li><li>Strong understanding of healthcare data and industry regulations</li><li>Preferred Qualifications:</li><li>Experience with Databricks and Spark</li><li>Understanding of provider networks, health plan operations, or network adequacy standards</li><li>Experience with Power BI, data visualization best practices, and dashboard optimization</li></ul>What you'll appreciate:<ul><li>Workplace flexibility you choose between remote, hybrid or in-office.</li><li>Company paid employee medical, dental and vision</li><li>Competitive salary and success sharing bonus</li><li>Flexible vacation with no cap, plus sick time and holidays</li><li>An entrepreneurial culture that won't limit you to a job description</li><li>Being listened to, valued, appreciated -- and having your contributions rewarded</li><li>Enjoying your work each day with a great group of people</li></ul>Apply TODAY!careers.questanalytics.comAbout Quest AnalyticsFor more than 30 years, we've been improving provider network management one groundbreaking innovation at a time. 95% of America's health plans use our tools, including the eight largest in the nation. Achieve your personal quest to build a great career here.Visa sponsorship is not available at this time. Preferred work locations are within one of the following states: Alabama, Arizona, Arkansas, Colorado, Connecticut, Delaware, Florida, Georgia, Idaho, Illinois (outside of Chicago proper), Indiana, Iowa, Kansas, Kentucky, Louisiana, Maine, Maryland, Massachusetts, Michigan, Minnesota, Mississippi, Missouri, Montana, Nebraska, Nevada, New Hampshire, New Mexico, North Carolina, North Dakota, Ohio, Oklahoma, Oregon, South Carolina, South Dakota, Tennessee, Texas, Utah, Vermont, Virginia, West Virginia, Wisconsin, or Wyoming.Quest Analytics provides equal employment opportunities to all people without regard to race, color, religion, sex, national origin, ancestry, marital status, veteran status, age, disability, sexual orientation or gender identity or expression or any other legally protected category. We are committed to creating and maintaining a workforce environment that is free from any form of discriminations or harassment. Applicants must be legally authorized to work in the United States. Verification of employment eligibility will be required at the time of hire. Persons with disabilities who anticipate needing accommodations for any part of the application process may contact, in confidence hr@questanalytics.comNOTE: Staffing agencies, headhunters, recruiters, and/or placement agencies, please do not contact our hiring managers directly. We are not currently working with additional outside agencies at this time.</div>

<h3>Job Description</h3><div>Job Description<div>Must pass required background check, drug test, and all pre-hire checks. POSITION OVERVIEW The Data Analyst will lead data collection, analysis, and visualization efforts across all agency programs. This role includes creating data visualizations and infographics that help inform program decisions, program data utilization, continuous quality improvement efforts and the community assessment process. The Data Analyst will stay informed about the latest research and best practices in data collection, evaluation, and data systems. This role is essential to ensuring data integrity across multiple systems and translating complex data into actionable insights for internal and external use. All employees and volunteers are expected to reflect Sunbeam Family Services’ core values and to perform at Sunbeam’s standards of excellence at all times.ESSENTIAL FUNCTIONS Demonstrate capacity for supporting developmentally sensitive, evidence-based, culturally sensitive, hope-centered, and trauma-informed programs. Design and implement data collection systems and tools across all programs, including aggregate and maintenance of data bases. Ensure data integrity, consistency, accuracy, and timely entry across platforms. Develop and maintain dashboards and reporting systems for internal and external stakeholders. Analyze quantitative and qualitative data to identify and discuss trends, gaps, and opportunities with program leadership and staff. Create and deliver compelling data visualizations, infographics, and reports tailored to diverse audiences and funding sources that Excommunicate findings, strategies, and recommendations. Translate complex data sets into clear, actionable insights for program leaders and community partners. Collaborate with program teams to support the data utilization cycle and continuous quality improvement efforts. Support compliance monitoring efforts by preparing reports and summaries for the Continuous Quality Improvement Committee. Contribute to the design and execution of program evaluations and outcome measurement strategies. Support the community assessment process and design with relevant data and analysis. Recommend and implement innovative and streamlined approaches to data collection and analysis across agency program areas. Provide training and support to staff on data tools and procedures. Serve as a data liaison across programs, fostering a culture of data informed decision making. Present findings to leadership, funders, and stakeholders in a clear and engaging manner. Stay current on best practices in data analytics, early childhood education, human services, and nonprofit evaluation. Represent Sunbeam in a professional manner, which may include community interactions, consultation and education to staff and community partners, and presentations (including media and in person), etc. Knowledgeable of agency policies and procedures and compliance with agency accrediting and oversight bodies, including but not limited to Head Start and COA. Adhere to the Sunbeam Code of Ethics, HIPAA, and other confidentiality policies/practices while maintaining professional standards at all time. Travel locally as required in the performance of responsibilities. Perform other appropriate and related responsibilities as assigned by supervisor, Senior Program Director, or Executive Team member.JOB QUALIFICATIONSEducation Minimum Requirement-Bachelor’s Degree in Data Science, Public Health, Education, Social Work, or related field Preferred-Masters Degree in Data Science, Public Health, Education, Social Work, or related fieldExperienceTwo (2) years of experience in data systems, data collection, and high level data analysis, preferably in a nonprofit, early childhood, and/or human services setting.SkillsProficiency in Excel, SQL, and data visualization tools (e.g. Power BI, Crystal Reports) Intermediate to advanced knowledge of computer operations and applications, including Microsoft, and the ability to master other computer technology / software programs as required. Ability to adapt to evolving needs and respond to urgent priorities.Strong organizational, communication, and problem-solving skills. Understanding and ability to maintain high standards for data accuracy and confidentiality. Process, protect, and exercise discretion in handling confidential information and materials Ability to use inclusive data practices in collection and interpretation. Strong collaboration skills to build relationships across diverse teams. Accepting interpersonal approach that reflects cultural sensitivity to the unique and diverse experiences of families served. Able to effectively and respectfully communicate in a manner that consistently demonstrates respect and cultural humility. Caring and compassionate attitude when interacting with all individuals. Excellent command of English language and grammar, both verbal and written. Able to work autonomously without constant supervision. Valid Oklahoma driver’s license and state required vehicle insurance for any vehicle used in performance of job duties.</div>Company Description<div>Established in 1907, Sunbeam Family Services is Oklahoma’s longest-serving social service agency. Sunbeam’s programs and services address the physical, mental and emotional health of our clients. We shine a light on the needs of our community and empower families and individuals. Sunbeam is an employee-first organization to serve the community best. Employees are valued, respected, and encouraged to grow. We believe when employees are inspired, motivated, and treated well, they provide great service to our clients. Join us in building brighter futures with all children and families!</div></div><h3>Company Description</h3><div>Established in 1907, Sunbeam Family Services is Oklahoma’s longest-serving social service agency. Sunbeam’s programs and services address the physical, mental and emotional health of our clients. We shine a light on the needs of our community and empower families and individuals. \r\n\r\nSunbeam is an employee-first organization to serve the community best. Employees are valued, respected, and encouraged to grow. We believe when employees are inspired, motivated, and treated well, they provide great service to our clients.\r\n\r\nJoin us in building brighter futures with all children and families!</div>

<h3>Job Description</h3><div>Job Description<div>OverviewCTG is seeking to fill a Data Analyst III position for our client in Anchorage, AK.Location: Anchorage, AK Duration: 12 monthsDuties:<ul><li>Provide quality data to businesses and functions to support critical decision-making.</li><li>Support, promote, and document all Data Management processes and procedures.</li><li>Develop workflows and tools to automate data loading processes, ensuring data quality and integrity.</li><li>Ensure the quality, consistency, and integrity of data in a timely, effective, and reliable manner.</li><li>Receive, archive, distribute, load, and dispose of technical data according to established policies, standards, and procedures.</li></ul>Skills:<ul><li>Strong analytical and problem-solving skills.</li><li>Proficiency in data management tools and software.</li><li>Ability to communicate complex information clearly and concisely.</li><li>Strong attention to detail and organizational skills.</li><li>Ability to work independently and collaboratively within a team.</li></ul>Experience:<ul><li>Typically 5-7 years of experience in data management or a related field.</li><li>Demonstrated understanding of data management principles and best practices.</li><li>Experience in developing and implementing data workflows and automation tools.</li></ul>Education:<ul><li>Bachelor’s degree in a related field preferred.</li></ul>Excellent verbal and written English communication skills and the ability to interact professionally with a diverse group are required.CTG does not accept unsolicited resumes from headhunters, recruitment agencies, or fee-based recruitment services for this role.To Apply: To be considered, please apply directly to this requisition using the link provided. For additional information, please contact Recruiter Rebecca Olan at rebecca.olan@ctg.com. Kindly forward this to any other interested parties. Thank you!</div></div>

Research Data Analyst University of California Los Angeles Requisition Number: 37178 Salary: $29.12 - $64.27 hourly Position Description: The UCLA Law Center for Reproductive Health, Law and Policy Data Analyst will conduct and support social science, public health, and public policy research to advance the mission of the center in close collaboration with the center's other scholars. The UCLA Law Center on Reproductive Health, Law and Policy is dedicated to training the next generation of researchers, lawyers, and leaders dedicated to advancing reproductive rights and producing research-informed strategies to transform current debates. As a national interdisciplinary academic center, the center will amplify UCLA Law's current work on reproductive health, law and policy and build capacity by attracting new leaders, scholars and students. Primary responsibilities include managing project timelines, research materials, and data, developing research protocols, study materials, preparation of human subjects applications, data collection and analysis, and preparing written products (literature reviews, reports, manuscripts, grant proposals, fact sheets, graphics, presentations, and so forth.) Participation in center meetings, seminars, educational events, and other meetings, as determined by the research supervisor, is required. For full application instructions and position description, please visit: <a href="https://apptrkr.com/3398026" rel="nofollow">https://hr.mycareer.ucla.edu/applicants/Central?quickFind=85167</a> The University of California is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age or protected veteran status. For the complete University of California nondiscrimination and affirmative action policy, see: UC Nondiscrimination & Affirmative Action Policy, <a href="https://policy.ucop.edu/doc/4000376/DiscHarassAffirmAction" rel="nofollow">https://policy.ucop.edu/doc/4000376/DiscHarassAffirmAction</a> <img src="https://www.jobelephant.com/img.php?id=3398026&image=pixel" rel="nofollow" /> Copyright ©2022 Jobelephant.com Inc. All rights reserved. <a href="https://www.jobelephant.com/" rel="nofollow">Posted by the FREE value-added recruitment advertising agency</a> jeid-99424cdb1ddd5a4cb63b8533ae6d21e7

At Zelis, we Get Stuff Done. So, lets get to it! A Little About Us Zelis is modernizing the healthcare financial experience across payers, providers, and healthcare consumers. We serve more than 750 payers, including the top five national health plans, regional health plans, TPAs and millions of healthcare providers and consumers across our platform of solutions. Zelis sees across the system to identify, optimize, and solve problems holistically with technology built by healthcare experts driving real, measurable results for clients. A Little About You You bring a unique blend of personality and professional expertise to your work, inspiring others with your passion and dedication. Your career is a testament to your diverse experiences, community involvement, and the valuable lessons you've learned along the way. You are more than just your resume; you are a reflection of your achievements, the knowledge you've gained, and the personal interests that shape who you are. Position Overview The Healthcare Data Analyst will be responsible for analyzing and managing healthcare repricing claim data, with a focus on various pricing methodologies including Medicare, Medicaid, and commercial reimbursements. This role involves leveraging data to ensure accurate and efficient claim processing, offer insights into contract performance, and communicate results to both internal and external stakeholders. What You'll Do <ul><li>Analyze and interpret healthcare claim data to support/recommend decision-making processes.</li><li>Analyze and interact with data in SQL tables.</li><li>Utilize Excel for data manipulation, analysis, and reporting.</li><li>Understand claim payment methodologies such as Medicare, Medicaid, and Commercial Reimbursement.</li><li>Create visualizations and dashboards to present data findings (Tableau experience is a plus).</li><li>The ability to multi-task and work on multiple assignments will be required.</li><li>This individual must also demonstrate clear and concise communication both verbally and in writing. Including sales, client facing teams and clients</li><li>Actively contribute innovative ideas and support ad hoc projects, including time-sensitive requests</li><li>Maintains awareness of and ensure adherence to ZELIS standards regarding privacy.</li><li>Keep abreast of issues to identify enhancements and process improvement opportunities </li></ul>What You'll Bring To Zelis <ul><li>2+ years of experience in healthcare data analysis.</li><li>1+ years in claim reimbursement methodologies (Medicare, Medicaid, Commercial)</li><li>Experience with Tableau is a bonus but not required.</li><li>Excellent communication and collaboration abilities.</li><li>Consistently demonstrate ability to act and react swiftly to continuous challenges and changes</li><li>Excellent follow through, attention to detail, and time management skills</li><li>Ability to manage projects simultaneously and achieve goals</li><li>Strong initiative, self-directed and self-motivation</li><li>Strong organization and project / process management skills</li><li>Excellent analytical skills with data and analytics related solutions</li><li>Ability to think and act strategically, and as well as execute tactically with bias toward action</li><li>Demonstrated leadership ability with cross-functional teams, knows how to get things done both through formal channels and the informal network</li><li>Financial modeling and strong analytic skills</li><li>Strong excel skills required</li><li>Demonstrated ability to evaluate and balance team and individual workloads through effective time management, prioritization, and organizational skills</li><li>Creative problem-solving skills, leveraging insights and input from other parts of an organization</li><li>Proficient in SQL (Select, Joins, CTE, Sub Queries)</li><li>Proficiency other Microsoft Office products - Outlook, Word, Excel, PowerPoint, SharePoint, Teams</li><li>Strong analytical skills </li></ul>Please note at this time we are unable to proceed with candidates who require visa sponsorship now or in the future. Location and Workplace Flexibility We have offices in Atlanta GA, Boston MA, Morristown NJ, Plano TX, St. Louis MO, St. Petersburg FL, and Hyderabad, India. We foster a hybrid and remote friendly culture, and all our employee's work locations are based on the needs of the position and determined by the Leadership team. In-office work and activities, if applicable, vary based on the work and team objectives in accordance with Company policies. Base Salary Range $59,000.00 - $79,000.00 At Zelis we are committed to providing fair and equitable compensation packages. The base salary range allows us to make an offer that considers multiple individualized factors, including experience, education, qualifications, as well as job-related and industry-related knowledge and skills, etc. Base pay is just one part of our Total Rewards package, which may also include discretionary bonus plans, commissions, or other incentives depending on the role. Zelis full-time associates are eligible for a highly competitive benefits package as well, which demonstrates our commitment to our employees health, well-being, and financial protection. The US-based benefits include a 401k plan with employer match, flexible paid time off, holidays, parental leaves, life and disability insurance, and health benefits including medical, dental, vision, and prescription drug coverage. Equal Employment Opportunity Zelis is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment 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. We welcome applicants from all backgrounds and encourage you to apply even if you dont meet 100% of the qualifications for the role. We believe in the value of diverse perspectives and experiences and are committed to building an inclusive workplace for all. Accessibility Support We are dedicated to ensuring our application process is accessible to all candidates. If you are a qualified individual with a disability or a disabled veteran and require a reasonable accommodation with any part of the application and/or interview process, please email TalentAcquisition@zelis.com. Disclaimer We are an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender identity, national origin, disability status, protected veteran status, or any other characteristic protected by law. The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities, duties, and skills from time to time. #J-18808-Ljbffr

Campus OSU-Stillwater Contact Name & Email Shoko Robinson, shokor@okstate.edu Work Schedule Monday through Friday, 8:00 AM - 5:00 PM. Appointment Length Regular Continuous/Until Further Notice Hiring Range $47,000 - $69,000 Priority Application Date For full consideration, please apply by 2025-09-15. Resumes will be accepted until position is filled. Special Instructions to Applicants For full consideration, please include a resume, cover letter, and contact information for three professional references. About this Position Provides operational support for select functional areas in the Oklahoma State University and A&M Systems utilizing information analysis/delivery tools, SQL, and process improvement methods. Assists with integration efforts of university owned or managed applications. Performs information analysis according to delivered specifications, and ongoing responsibility for maintaining and improving data flows between ERP components. Required Qualifications Bachelor's degree (degree must be conferred on or before agreed upon start date) Two years of increasingly responsible experience in query languages, databases, and process improvement Proficient in relational databases and SQL (PLSQL, Transact-SQL, or other SQL) Proficient in COGNOS, Power BI, or other data extraction/visualization tools. Proficient in Microsoft Excel (PowerQuery) Experience in Python or a similar programming language Excellent interpersonal and communication skills Ability and desire to work in a team environment. Preferred Qualifications Bachelor's degree in IT or business 4 years of experience in understanding the needs of a higher educational institution related to administrative information delivery, including grants (state and federal), external agency reporting, in house data needs, and budgets. Experience in the Ellucian Banner system Experience in Dagster, AirFlow, or similar data orchestrator tool

<div><h2>Risk Data Analyst II - ETL and Warehouse</h2>Location: CityScapeThe Portfolio Credit Risk Management department is a high performing, dynamic team within Western Alliance Bank. Critical to success in this position is an understanding of SQL, SSIS and database concepts, as well as the ability to document and follow procedures. Additionally, the position requires independent problem solving, adaptability to changing priorities, a sense of urgency, on-time delivery and the ability to support diverse projects. This position requires an understanding of banking concepts, and an aptitude for learning new technology. This position interacts with personnel in WAB's Information Technology, Accounting, Loan Servicing and other business groups.<ul><li>Access Analytical Data Store or other data repositories to meet the reporting needs of various customers within the Bank.</li><li>Proposes improvements to existing processes, obtains approval, completes documentation and implements upgrades.</li><li>Completes assigned projects, which may be individual or team projects and include acquiring new data sources (due to new products, new business acquisitions, new system implementations, etc.), defining/documenting transformations required to load, writing load scripts and testing.</li><li>Understand business unit reporting and analytical needs and translate business questions into analytical tasks that help drive strategic decisions. Present analytical findings and recommendations to senior management and key stakeholders.</li><li>Manages a pipeline of data and process related projects, identifying and elevating road blocks and executing within designated time frames.</li><li>Serves as the point of contact to internal customers for ad hoc extracts and support for assigned areas of responsibility.</li><li>Uses excellent communication skills to keep manager, team and customers apprised of project statuses.</li></ul>Bachelor's degree in related field required.<ul><li>Intermediate experience with data analysis tools (e.g., SQL, Excel).</li><li>3+years of related experience in Banking, Data Analytics, Data Management or similar field.</li><li>Experience with project management and managing multiple priorities and deliverables.</li><li>Intermediate experience presenting findings from large datasets in a clear, actionable way.</li></ul>We offer all the important things you'd want like competitive salaries, an ownership stake in the company, medical and dental insurance, time off, a great 401k matching program, tuition assistance program, an employee volunteer program, and a wellness program. In addition, you'll have the opportunity to bolster your business knowledge, learning the ins and outs of how successful companies operate and manage their finances, giving you invaluable hands-on experience to help grow your career!Western Alliance Bank is a wholly owned subsidiary of Western Alliance Bancorporation. Alliance Bank of Arizona, Alliance Association Bank, Bank of Nevada, Bridge Bank, First Independent Bank, and Torrey Pines Bank are divisions of Western Alliance Bank; Member FDIC. AmeriHome Mortgage is a Western Alliance Bank company.</div>

<h3>Job Description</h3><div>Job Description<div>Essential Duties and Responsibilities The Water Utility Support Analyst interfaces with various internal departments and must work exceptionally well with employees of all levels. The person in this position is responsible for embracing and utilizing available technology as communication and data gathering tools in performing routine and complex duties for the Planning and Analysis team. Core responsibilities include the following:<ul><li>Assist in the preparation of annual capital and expense budget-related functions and ensures the integrity of budget information are entered in the system accurately as approved by theBoard</li><li>Coordinates blanket capital projects activities with various Operations Superintendents, Engineers and field staffs.</li><li>Initiates and prepares blanket capital work order package and preliminary cost estimates</li><li>Prepares periodic fluctuation variance analysis report on changes in the capital budgets for Operations groups and perform necessary budget substitutions.</li><li>Reviews completeness and accuracy of job closing package information.</li><li>Performs cost and budget analysis of projects and ensures that all documentation, analysis, authorization, etc. for all phases of projects are complete and proper.</li><li>Analyzes transactions, understands and explains variances, and proactively identifies potential problems and solutions.Ability to recognize unusual transactions, trends, or variations and communicate findings to supervisor.</li><li>Work closely with various Operations groups to obtain engineering As-built details and identifies installed and retired facilities.</li><li>Prepares project status reports and project schedules.</li><li>Develops and produces various Power Plant queries as assigned.</li><li>Assist in the identification of other relevant issues within the department and participate in the creation of innovative solutions and/or the implementation of new procedures.</li><li>Provides support in District Invoicing preparations for property damages and other related claims and reimbursements.</li><li>Ensuring department processes are properly documented and followed, and ensuring policies and procedures are in compliance with regulatory and internal requirements.</li><li>Provides assistance with coordination, development and maintenance of General Rate Case studies, data requests, rate comparisons and other assistance as needed.</li><li>Performs/prepares various other special projects analyses and periodic reports as directed.</li><li>Ensures all related processes are in compliance with Generally Accepted Accounting Principles (GAAP) and Sarbanes Oxley requirements in accordance with the Uniform System of Accounting for water utilities.</li><li>Performs other duties as assigned.</li></ul>MINIMUM POSITION QUALIFICATIONS:<ul><li>Bachelor’s Degree in accounting or business preferred.</li><li>At least three years accounting, project management or closely related experience.</li><li>Experience with JD Edwards and PowerPlan accounting software preferred or any other project management software.</li><li>Ability to read and analyze financial reports and present information and respond to questions from internal/external auditors.</li><li>Demonstrated critical thinking capacity and ability to work with minimum supervision.</li><li>Attention to detail and accuracy is required</li><li>Independently manage multiple tasks, projects, works well under pressure and ability to prioritize</li><li>Proficient in Microsoft Office applications; familiarity with data query/data management tools extremely helpful (Access, SQL, Business Objects)</li><li>Ability to effectively communicate and establish working relationships with other departments and personnel.</li></ul></div>Company Description<div>We're not just a staffing company - we're a people company. At Amtec, we care about helping you reach your unique career goals. Since 1959, we’ve changed the lives of thousands of people for the better - people just like you. It’s our purpose to help you find meaningful work by matching your character, competence, and culture with an organization that truly values what you have to offer.</div></div><h3>Company Description</h3><div>We're not just a staffing company - we're a people company. At Amtec, we care about helping you reach your unique career goals. Since 1959, we’ve changed the lives of thousands of people for the better - people just like you. It’s our purpose to help you find meaningful work by matching your character, competence, and culture with an organization that truly values what you have to offer.</div>

Question	Topic	Difficulty	Ask Chance
Causal Inference Without A/B	A/B Testing & Experimentation	Medium	Very High
Department Expenses	SQL	Medium	Very High
Algorithm Reliability	ML Ops & Training Pipelines	Hard	Very High