Job Closed
This listing is no longer active.
Transforming the health of the communities we serve, one person at a time.
Data Analyst III SQL
Location
United States
Posted
73 days ago
Salary
$70.1K - $126K / year
Seniority
Mid Level
Job Description
Data Analyst III SQL
Centene Corporation
You could be the one who changes everything for our 28 million members. Centene is transforming the health of our communities, one person at a time. As a diversified, national organization, you’ll have access to competitive benefits including a fresh perspective on workplace flexibility. Must be authorized to work in the U.S. without the need for employment-based visa sponsorship now or in the future. Sponsorship and future sponsorship are not available for this opportunity, including employment-based visa types H-1B, L-1, O-1, H-1B1, F-1, J-1, OPT, or CPT. Position Purpose: Analyze integrated and extensive datasets to extract value, which directly impacts and influences business decisions. Work collaboratively with key business stakeholders to identify areas of value, develop solutions, and deliver insights to reduce overall cost of care for members and improve their clinical outcomes. - Interpret and analyze data from multiple sources including claims, provider, member, and encounters data. Identify and assess the business impact of trends - Develop, maintain, and troubleshoot complex scripts and reports developed using SQL, Microsoft Excel, or other analytics tools - Contribute to the planning and execution of large-scale projects with limited direction from leadership - Assist in the design, testing, and implementation of process enhancements and identify opportunities for automation - Identify and perform root-cause analysis of data irregularities and present findings and proposed solutions to leadership and/or customers - Manage multiple, variable tasks and data review processes with limited supervision within targeted timelines and thrive in a demanding, quickly changing environment - Demonstrate a sense of ownership over projects and ask probing questions to understand the business value of tasks - Apply expertise in quantitative analysis, data mining, and the presentation of data to see beyond the numbers and understand how customers interact with analytic products - Partner cross-functionally at all levels of the organization and effectively, both verbally and visually, communicate findings and insights to non-technical business partners - Independently engage with customers and business partners to gather requirements and validate results - Communicate and present data-driven insights and recommendations to both internal and external stakeholders, soliciting and incorporating feedback when required - Provide technical guidance to junior analysts Education/Experience: Bachelor’s degree in business, economics, statistics, mathematics, actuarial science, public health, health informatics, healthcare administration, finance or related field or equivalent experience. Healthcare analytics experience preferred. Working knowledge of SQL/querying languages. Preferred knowledge of modern business intelligence and visualization tools including Microsoft Power BI. Appeals or UM background or knowledge a plus. By applying to this requisition, you acknowledge and understand that you may be considered for other job opportunities for which Centene believes you may be qualified. Pay Range: $70,100.00 - $126,200.00 per year Centene offers a comprehensive benefits package including: competitive pay, health insurance, 401K and stock purchase plans, tuition reimbursement, paid time off plus holidays, and a flexible approach to work with remote, hybrid, field or office work schedules. Actual pay will be adjusted based on an individual's skills, experience, education, and other job-related factors permitted by law, including full-time or part-time status. Total compensation may also include additional forms of incentives. Benefits may be subject to program eligibility. Centene is an equal opportunity employer that is committed to diversity, and values the ways in which we are different. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or other characteristic protected by applicable law. Qualified applicants with arrest or conviction records will be considered in accordance with the LA County Ordinance and the California Fair Chance Act
Related Guides
Related Categories
Related Job Pages
More Data Analyst Jobs
CTMS Data Analyst 1
University of WashingtonThe University of Washington is a renowned public research university with a main campus located just minutes from downtown Seattle, and additional locations in
Job Description UW MEDICINE IT SERVICES has an outstanding job opportunity for a CTMS Data Analyst 1 position. (CTMS: OnCore Clinical Trials Management System.) . WORK SCHEDULE - 100% FTE – 40 hours per week - Day Shift – UW MEDICINE ITS SERVICES CORE HOURS ARE 08:00 – 17:00 (PST), Monday-Friday DEPARTMENT DESCRIPTION UW Medicine IT Services (ITS) is a shared services organization that supports all of UW Medicine. UW Medicine is comprised of Harborview Medical Center (HMC), UW Medical Center-Montlake Campus (UWMC-Montlake), UW Medical Center-Northwest Campus (UWMC-NW), UW Medicine Primary Care (UWMPC), UW Physicians (UWP), UW School of Medicine (SOM), and Airlift Northwest (ALNW). ITS is responsible for the ongoing support and maintenance of the infrastructure and applications which support all these institutions, along with the implementation of new services and applications that are used to support and further the UW Medicine mission. POSITION HIGHLIGHTS - 100% remote opportunity - 15 days of vacation your first year – Also, 12 days of sick time, 1 personal holiday, and 11 paid holidays each year - 100% matching, 100% immediately vesting 403(b) PRIMARY JOB RESPONSIBILITIES - Providing immediate response to basic to intermediate level data-related questions, ad-hoc Tableau and SQL reports, and developing and/or updating business logic reports - Maintaining continuity of data, delivery, and connections - Facilitating timely changes on preexisting logic to provide more immediate availability - Investigating basic to intermediate level data connection issues, prioritizing, and resolving via defined service level agreements - Aligning with larger program office process to deliver services and communicating CTMS Program Office priorities to RIT leadership - Performing tier 1 and lower-end tier 2 support tickets - Participating in Program Office process meetings to fully understand context when working under the advisement of and being mentored by senior analysts REQUIREMENTS - Bachelor’s degree in Computer Science, Information Technology, Business Administration, or related field or equivalent combination of education/experience - 2+ years’ of recent healthcare or IT experience must include the below: - 2+ year(s) of experience with end user support in an IT domain - 1+ year(s) of experience with application/system configuration and implementation of clinical information systems (and/or healthcare applications) - Familiarity with Oracle and SQL Server database programming, including complex query optimization and performance tuning - Demonstrated experience with formal software engineering practices (e.g. source code version control, validation, deployment, maintaining Microsoft-based applications, etc.) - Basic object-oriented programming skills using an integrated development environment like Visual Studio .NET - Demonstrated experience with requirements gathering and analysis, including direct work with end users or customers - Basic understanding of database design - Demonstrated problem solving and debugging skills - Foundational experience working with multiple APIs - Foundational experience juggling multiple system instances/environments (i.e. test, training, development, and production) - Foundational experience assisting team members and sharing knowledge, with exposure to mentoring others - Familiarity with database structures, data definitions, and data relationships - Recent experience with formal project management methods - Foundational experience supporting small scale enterprise customers, both internal and external - Basic understanding of enterprise change control processes UW MEDICINE – WHERE YOUR IMPACT GOES FURTHER UW Medicine is Washington’s only health system that includes a top-rated medical school and an internationally recognized research center. UW Medicine’s mission is to improve the health of the public by advancing medical knowledge, providing outstanding primary and specialty care to the people of the region, and preparing tomorrow’s physicians, scientists and other health professionals. All across UW Medicine, our employees collaborate to perform the highest quality work with integrity and compassion and to create a respectful, welcoming environment where every patient, family, student and colleague is valued and honored. Nearly 29,000 healthcare professionals, researchers, and educators work in the UW Medicine family of organizations that includes: Harborview Medical Center, UW Medical Center - Montlake, UW Medical Center - Northwest, UW Medicine Primary Care, UW Physicians, UW School of Medicine, and Airlift Northwest. Become part of our team. Join our mission to make life healthier for everyone in our community. Compensation, Benefits and Position Details Pay Range Minimum: $73,836.00 annualPay Range Maximum: $95,004.00 annualOther Compensation: -Benefits: For information about benefits for this position, visit https://www.washington.edu/jobs/benefits-for-uw-staff/Shift: First Shift (United States of America)Temporary or Regular? This is a regular positionFTE (Full-Time Equivalent): 100.00%Union/Bargaining Unit: Not Applicable About the UW Working at the University of Washington provides a unique opportunity to change lives – on our campuses, in our state and around the world. UW employees bring their boundless energy, creative problem-solving skills and dedication to building stronger minds and a healthier world. In return, they enjoy outstanding benefits, opportunities for professional growth and the chance to work in an environment known for its diversity, intellectual excitement, artistic pursuits and natural beauty. Our Commitment The University of Washington is committed to fostering an inclusive, respectful and welcoming community for all. As an equal opportunity employer, the University considers applicants for employment without regard to race, color, creed, religion, national origin, citizenship, sex, pregnancy, age, marital status, sexual orientation, gender identity or expression, genetic information, disability, or veteran status consistent with UW Executive Order No. 81. To request disability accommodation in the application process, contact the Disability Services Office at 206-543-6450 or dso@uw.edu. Applicants considered for this position will be required to disclose if they are the subject of any substantiated findings or current investigations related to sexual misconduct at their current employment and past employment. Disclosure is required under Washington state law.
Financial Data Analyst
BHG FinancialBHG is the original disruptor in business working capital and unsecured consumer loans.
•Maintain SQL based loan amortization logic to generate important loan information used for reporting. •Analyze large amounts of financial data to report on BHG’s growing list of loan portfolios. •Utilize SQL queries and stored procedures to maintain, enhance and develop reporting packages. •Involve in the monthly reporting process, review and enhance the process •Utilize SQL and Excel to build financial models upon closing of new portfolios. •Provide quantitative analysis on loan portfolios within BHG, build and monitor reports related to loan performance across different portfolios •Work with internal teams, provide analytical insights regarding BHG’s loan portfolios to internal teams, including Accounting, Collections, Legal. •Extract, transform, load large amounts of financial data to provide ad-hoc analysis •Coordinate with BHG’s development team and external parties on the implementation and validation of the new Loan Management System
Job Description Be part of a world-class academic healthcare system, Ingalls Memorial Hospital, as a Charge Master Analyst. This position will be 100% remote. Join us as a Charge Master Coding Analyst with our Shared Services - Revenue Cycle team in Harvey, IL. The Charge Master Coding Analyst is responsible for maintaining the integrity, accuracy, and compliance of the hospital’s charge description master (CDM). This role ensures that all clinical services, supplies, and procedures are correctly coded and mapped for appropriate billing and revenue reporting. The analyst works closely with Clinical, Finance, Revenue Cycle, and IT Teams to analyze and implement new service request, coding updates, price changes, and regulatory modifications. The position plays a key role in optimizing revenue capture, minimizing compliance risk, and supporting hospital operations through accurate and up-to-date charge data. Any candidate must possess a strong understanding in hospital billing, OPPS reimbursement, be proficient in excel, and able to work autonomously to resolve problems as they arise. Essential Job Functions - Perform analysis to understand net revenue effect of proposed chargemaster changes. This analysis may include, but is not limited to, pricing analysis on a periodic basis, new service revenue modeling and sensitivity analysis pertaining to applicable industry trends. - Analyzes data within the CDM and assigns accurate CPT/HCPCS and revenue codes to CDM to insure compliance with regulatory agencies. - Monitor and review daily revenue reports (specifically the Patient Accounting System) for accuracy and completeness using requisite I/T tools. - Performs annual pricing analysis with recommendations for optimizing revenue opportunities. - Understand the market place relative to pricing and suggest response to new providers. - Work with managed care contracting personnel in the development and analysis of contracts with payers. - Responds to CDM inquiries and requests timely. - Resolve coding discrepancies. - Assist with education of departmental staff on changes. - Report to management on monthly financial results. - Establish, maintain, and coordinate new charges and CDM process improvements. - Recommend, develop and maintain financial databases, computer software systems and manual filing systems. - Survey operations to ascertain CDM needs and to recommend, develop and maintain solutions to business and financial problems. - Utilize knowledge gained from educations programs in everyday work situations. - Annual General Education test. - Demonstrates commitment to professional growth and competence. - Attends all mandatory Departmental and Hospital in-services and meetings. - Formulates annual written objectives with supervisor. - Seeks educational and learning experiences in identified areas of need and reviews progress through the annual review process. Required Qualifications - Education: BS/BA in a Healthcare or business related field; 5-8 years of related experience in lieu of educational experience. - Licences/Certifications: RHIA, RHITA and/or CCS certification. - Thorough knowledge of CPT/HCPCS coding required. - Knowledge of UB-04 data elements requirements, state healthcare billing requirements and Medicare rules preferred. - Microsoft Excel and Access skills strongly preferred Position Details - Job Type: Full Time (1.0 FTE) - Shift: Days - Work Location: Remote - Department: Revenue Cycle - CBA Code: Non-Union Why Join Us For nearly a century Ingalls Memorial has pioneered sophisticated clinical care and developed the area's most convenient network of comprehensive outpatient centers, all dedicated to improving the health and wellbeing of the community. Now, partnered with UChicago Medicine, we have expanded our network of expert physicians, convenient facilities and scope of service to speed your healing process and help navigate your path to wellness. A skilled Medical Staff and talented employees dedicated to prevention, diagnosis, treatment and rehabilitation of illness and injury provide a firm foundation for our reputation for quality. To accomplish this, we need employees with passion, talent and commitment… with patients and with each other. We’re in this together: working to advance medical innovation, serve the health needs of the community, and move our collective knowledge forward. If you’d like to add enriching human life to your profile, UChicago Medicine Ingalls Memorial is for you. Here at Ingalls, we’re doing work that really matters. Join us! UChicago Medicine Ingalls Memorial is growing; discover how you can be a part of this pursuit of excellence at: Ingalls Career Opportunities UChicago Medicine Ingalls is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, ethnicity, ancestry, sex, sexual orientation, gender identity, marital status, civil union status, parental status, religion, national origin, age, disability, veteran status and other legally protected characteristics. As a condition of employment, all employees are required to complete a pre-employment physical, background check, drug screening, and comply with the flu vaccination requirements prior to hire. Medical and religious exemptions will be considered for flu vaccination consistent with applicable law. Compensation & Benefits Overview UChicago Medicine is committed to transparency in compensation and benefits. The pay range provided reflects the anticipated wage or salary reasonably expected to be offered for the position. The pay range is based on a full-time equivalent (1.0 FTE) and is reflective of current market data, reviewed on an annual basis. Compensation offered at the time of hire will vary based on candidate qualifications and experience and organizational considerations, such as internal equity. Pay ranges for employees subject to Collective Bargaining Agreements are negotiated by the medical center and their respective union. Review the full complement of benefit options for eligible roles at Benefits - UChicago Medicine.
Data Warehouse Analyst Seniors – Power BI/Tableau
FISAdvancing the ways the world pays, banks and invests.
Job Description FIS Management Services, LLC seeks Data Warehouse Analyst Seniors – Power BI/Tableau in Jacksonville, FL to execute end-to-end dashboard migrations between Tableau and Power BI, ensuring data accuracy and visual consistency. Translate complex calculations and business logic between DAX and Tableau expressions (including LOD expressions). Replicate data transformation logic using Power Query and Tableau Prep Builder. Design and implement optimized data models using star schema principles. Develop embedded analytics solutions for client-facing applications using Power BI Embedded and Tableau Embedded. Build and maintain data warehouse structures and ETL pipelines using SQL Server, SSIS, and other tools. Integrate data from diverse sources including cloud platforms, REST APIs, and financial systems. Manage deployments to Power BI Service and Tableau Server/Cloud, including refresh schedules and access controls. Collaborate with internal and external stakeholders to gather requirements and validate BI solutions. Provide training and support to ensure smooth transitions and user adoption. Ensure data accuracy, encryption and compliance with GDPR, PII, PCI, and other financial regulations. Conduct thorough QA testing to validate dashboards and reporting pipelines. Participate in Agile development cycles including sprint planning, retrospectives, and backlog grooming. Provide technical leadership and mentorship to junior analysts. Lead development of data visualization standards, documentation, and best practices. REQUIREMENTS: Bachelor’s degree or foreign equivalent in Computer Science, Computer Engineering or related field and seven (7) years of progressively responsible experience in the job offered or a related occupation: working in FinTech domain in roles including data warehousing, business intelligence, or analytics; utilizing Power BI language syntax (DAX, Power Query), Power BI Service, Power BI Embedded, Tableau language syntax (Calculated Fields, LOD Expressions), Tableau Prep, Tableau Server/Cloud, Tableau Embedded, and complex SQL development; implementing performance tuning in cloud-based data warehousing; utilizing ETL tools including SSIS, Tableau Prep, and Azure Data Factory; performing dashboard migration and embedded analytics development; working with data modeling, governance, and financial data compliance; and working in Agile environments using Jira and Rally tools. Telecommuting and/or working from home may be permissible pursuant to company policies. QUALIFIED APPLICANTS: Please apply directly through our website by clicking on “Apply Now.” Privacy Statement FIS is committed to protecting the privacy and security of all personal information that we process in order to provide services to our clients. For specific information on how FIS protects personal information online, please see the Online Privacy Notice. EEOC Statement FIS is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, marital status, genetic information, national origin, disability, veteran status, and other protected characteristics. The EEO is the Law poster is available here supplement document available here For positions located in the US, the following conditions apply. If you are made a conditional offer of employment, you will be required to undergo a drug test. ADA Disclaimer: In developing this job description care was taken to include all competencies needed to successfully perform in this position. However, for Americans with Disabilities Act (ADA) purposes, the essential functions of the job may or may not have been described for purposes of ADA reasonable accommodation. All reasonable accommodation requests will be reviewed and evaluated on a case-by-case basis. Sourcing Model Recruitment at FIS works primarily on a direct sourcing model; a relatively small portion of our hiring is through recruitment agencies. FIS does not accept resumes from recruitment agencies which are not on the preferred supplier list and is not responsible for any related fees for resumes submitted to job postings, our employees, or any other part of our company. #pridepass



