Apply Now

Job Title : Data Warehouse Analyst

Location : Ocoee, FL (Hybrid)

Job Type : Contract

Salary Range : 100-125k

Referral Fee :

Employment Eligibility : Gravity cannot transfer nor sponsor a work visa for this position. Applicants must be eligible to work in the U.S. for any employer directly

Position Overview

Our client is seeking a skilled Data Warehouse Analyst to work within the Business Intelligence Systems Management group.

The Data Analyst performs queries, analyses, and evaluation of data in a data warehouse environment. This analyst also uses data mining and data analysis tools to isolate and extract data based on specific parameters and monitors toll transaction data flow to identify any inconsistencies.

The Data Analyst performs regular monitoring and trend analysis of system performance and Key Performance Indicators (KPIs).

This team member recommends changes to systems or operations where needed. Reviews and validates data in the data warehouse for accuracy.

The Data Analyst also maintains knowledge of software tools, languages, scripts, and shells that effectively support the data warehouse environment in different operating system environments

Duties and Responsibilities

• Performs queries, analyses, and evaluation of data in a data warehouse environment
• Uses data mining and data analysis tools to isolate and extract data based on specific parameters and monitors toll transaction data flow to identify any inconsistencies
• Performs regular monitoring and trend analysis of system performance and Key Performance Indicators (KPIs)
• Recommends changes to systems or operations where needed. Reviews and validates data in the data warehouse for accuracy
• Maintains knowledge of software tools, languages, scripts, and shells that effectively support the data warehouse environment in different operating system environments
• Provides data extraction, analysis, development, and support in multiplatform environments
• Works on multiple projects as a team member and may lead projects of moderate complexity

Required Experience and Skills

• 5+ years of experience as Data Analyst.
• 3+ years SQL experience.
• 3+ years Excel experience including functions and formulas.
• Excellent analytical, problem-solving, and decision-making skill.
• Willingness to learn new tools and skills and cross train.
• Strong technical writing (reports and SOPs) experience, for all levels of the organization utilizing MSOffice, Visio, Share Point or similar applications.
• Strong oral communication skills.
• Ability to work on multiple projects across the organization collaboratively and proactively.

Desired Experience and Skills

• Experience with Power BI, Tableau, or similar BI tools.
• Experience with Python.
• Experience with MS SQL Server, Linux Unix background and PowerShell scripting.
• Experience Windows server 2008 and above.
• Experience of software and hardware testing.
• Tolling experience
• B.S. degree in Business, Information Technology, or another subject such as Accounting, Finance, Computer Science, Statistics or Engineering.
• Relevant work experience related to information and communication technologies, toll operations, and / or intelligent transportation systems (ITS), including toll collection systems, toll infrastructure, electronic payment, call centers, or traffic management.
• Knowledge of supporting and maintaining production systems.

Apply Now

Taking care of people is at the heart of everything we do, and we start by taking care of you, our valued colleague. A career at Sedgwick means experiencing our culture of caring.

It means having flexibility and time for all the things that are important to you. It’s an opportunity to do something meaningful, each and every day.

It’s having support for your mental, physical, financial and professional needs. It means sharpening your skills and growing your career.

And it means working in an environment that celebrates diversity and is fair and inclusive.

A career at Sedgwick is where passion meets purpose to make a positive impact on the world through the people and organizations we serve.

If you are someone who is driven to make a difference, who enjoys a challenge and above all, if you’re someone who cares, there’s a place for you here.

Join us and contribute to Sedgwick being a great place to work.

Great Place to Work

Most Loved Workplace

Forbes Best-in-State Employer

Data Analyst

PRIMARY PURPOSE To collect, analyze and report data; to be responsible for the data integrity; and to generate reports verifying and ensuring data integrity and accuracy.

ESSENTIAL FUNCTIONS and RESPONSIBILITIES

• Compiles data; prepares and distributes reports; and analyzes results.
• Ensures data integrity; develops and produces reports utilized in measuring data accuracy.
• May assist in the completion of appropriate client set-up and maintenance (parameter) forms.
• Supports internal and external users including reports, installation, screen, etc.
• Creates exception reports to identify fields of incorrect data.
• Generates custom reports for internal and external client.

ADDITIONAL FUNCTIONS and RESPONSIBILITIES

• Performs other duties as assigned.
• Supports the organization's quality program(s).

QUALIFICATIONS

Education & Licensing

Bachelor's degree from an accredited college or university preferred.

Experience

Five (5) years of related experience or equivalent combination of education and experience required. Two (2) years of query and report writing experience strongly preferred.

Skills & Knowledge

• Strong knowledge of query and report writing
• Excellent oral and written communication, including presentation skills
• PC literate, including Microsoft Office products
• Analytical and interpretive skills
• Strong organizational skills
• Excellent interpersonal skills
• Excellent negotiation skills
• Ability to meet or exceed Performance Competencies

WORK ENVIRONMENT

When applicable and appropriate, consideration will be given to reasonable accommodations.

Mental : Clear and conceptual thinking ability; excellent judgment, troubleshooting, problem solving, analysis, and discretion;

ability to handle work-related stress; ability to handle multiple priorities simultaneously; and ability to meet deadlines

Physical : Computer keyboarding, travel as required

Auditory / Visual : Hearing, vision and talking

NOTE : Credit security clearance, confirmed via a background credit check, is required for this position.

The statements contained in this document are intended to describe the general nature and level of work being performed by a colleague assigned to this description.

They are not intended to constitute a comprehensive list of functions, duties, or local variances. Management retains the discretion to add or to change the duties of the position at any time.

Sedgwick is an Equal Opportunity Employer and a Drug-Free Workplace.

If you're excited about this role but your experience doesn't align perfectly with every qualification in the job description, consider applying for it anyway! Sedgwick is building a diverse, equitable, and inclusive workplace and recognizes that each person possesses a unique combination of skills, knowledge, and experience.

You may be just the right candidate for this or other roles.

Job Description : Analytics

Analytics

• This position will be responsible for selecting and applying appropriate analytical methods to answer questions and test hypotheses as specified by researchers, administrators and clinicians.
• This position will require proficiency in database design, data ontology practice and statistical analyses.
• Using word processing, spreadsheet, presentation and organizational analyses (e.g. Microsoft Office products), provides reports of analyses to decision makers.
• Will also be responsible for developing reporting mechanisms via dashboards.
• Supports development of autonomous ongoing strategy for data analytics at the Center.
• Harness data in support of the strategic mission of the center.
• Present and publish data in such a way as to be accessible by lay and professional audiences

Technology

Using R, SAS, RedCap, Python, SPSS, Tableau, and / or other database / analytical software platforms at an intermediate level of proficiency to manipulate and analyze data associated with research studies.

Data Management

• Design, create and support for data collection management and storage system at the Center.
• Prioritize and coordinate multiple research projects often under tight deadlines.
• Set strategies and priorities for responding to research data requests
• Manages queue of incoming research data requests
• Set policies to limit collection of unnecessary data
• In accordance with data governance plan, set priorities and strategies for incorporating new sources of data into the data repository.
• Training and supervision of research staff as it relates to data warehouse use and security.

Data Security and Integrity

• The PHRC aims to provides secure, accurate, and reliable data to support rigorous research.
• The person in this position must uphold the highest standards of data quality, conduct data quality analyses, and describe data quality strengths and weaknesses in the context of research.
• Assists in the development and execution the organizations’ strategy for improving and maintaining research data integrity.
• With the PHRC team, defines and establishes data integrity definitions and rules consistent with unit and organizational priorities.
• Supports a consistent ontology.
• Defines data integrity metrics and establishes processes to measure and monitor them continuously.
• Ensures compliance with data security standards.
• Manage communications related to data quality both good and bad.
• Works with PHRC team and IT partners to prevent and remediate identified quality issues using both manual and automated solutions.

Other Duties

• Participate in all required meetings and training sessions as necessary.
• Other miscellaneous duties as assigned.

Performs other duties as assigned

Expected Salary :

$72,100-$82,400 commensurate with experience and education

Minimum Requirements :

Master’s degree in an appropriate area and two years of relevant experience; or a bachelor’s degree in an appropriate area and four years of relevant experience.

Preferred Qualifications :

Bachelor's or master's degree in computer science, statistics, information systems, or related field and four years of relevant experience.

EXPERIENCE

Must demonstrate experience with database design, reporting tools, and project management and familiarity with health care information system industry.

Working in healthcare or academic research environments

A customer-service orientation and / or experience working with older adults

Committed to participant protection and privacy

KNOWLEDGE

Must demonstrate experience with EMRs (such as Epic), systems, and data design.

Knowledge of SQL or other relational database management systems

Knowledge of basic principles of clinical research.

SKILLS

Proficiency with general statistical software (e.g. SAS, R)

Proficiency with machine learning frameworks (R, Python, Weka, RapidMiner, etc)

Proficiency in Microsoft Office Word, Outlook, PowerPoint, and data analysis software (Excel, SPSS)

Excellent technical writing and communication skills

ABILITIES

Ability to plan, organize and coordinate work assignments.

Ability to work effectively and independently.

Ability to communicate effectively verbally and in writing.

Ability to establish and maintain effective working relationships with others.

OTHER QUALIFICATIONS

Creativity

Attention to detail

Professionalism

Good judgement

Data Analyst will be responsible for the performance, integrity and security of membership and program database. The Data Analyst will be involved in the planning and development of the database, as well as providing technical assistance / training for users and ensuring data remains reliable and consistent.

The position monitors the effective use of data collection and reporting systems, manages staff use of outcome measurement tools and data entry, guides the analysis and translation of data, and produces weekly, monthly, annual, and ad hoc reports for senior management.

KEY ROLES (Essential Job Responsibilities) :

Data and Outcomes :

• Responsible for maintaining the integrity of and performance of membership and program database.
• Ensure accurate and efficient data collection and entry by auditing staffs’ use of database, as well as training Staff on systems.
• Identify and evaluate potential risks and make necessary recommendations.
• Analyze trends affecting program operation, performance and outcomes, and make necessary recommendations.
• Inform end users of changes in databases and train them to utilize systems.
• Manage annual registration, survey implementation, survey results analysis, report preparation.
• Prepare weekly, monthly, annual, and other reports as needed.
• Maintain knowledge of all data systems utilized by Operations division.
• When necessary, develops new data collection and tracking tools for membership, outcomes, and quality oversight.
• Identifies discrepancies in data and advises appropriate departments on how to remedy the discrepancies.
• Communicates directly with membership database vendors to ensure organizational needs are met.
• Provides timely reporting to enhance agency annual goals around average daily attendance, frequency of attendance, membership, and outcomes achievement.
• Delivers support, technical assistance, and training to staff around membership database usage and data collection.

Audits :

• Create standardized Membership Audit Checklist for use at each Club.
• Produce follow-up audit report and corrective action plan, if needed. Audits to include but not limited to the following : Programming Schedules Scan In / Out of Facility and Programs Sign In / Out Sheets
• Prepare data reports to verify if collected data is correct. Provides guidance to staff to fix discrepancies.

QUALIFICATION REQUIREMENTS :

• Bachelor’s Degree required.
• 2-3 years of database management experience.
• Salesforce experience preferred; Salesforce Admin certification a plus.
• 2-3 years of experience working with outcome measurement tools, creating reports, and conducting data analysis
• Advanced proficiency in Microsoft Word, Excel, and Outlook as well as experience using web-based data collection systems and other databases.
• Strong and effective communication skills, both verbal and written along with excellent presentation and facilitation skills to small, large, and diverse groups.
• Ability to lead and collaborate with others.
• Ability to identify issues, problem solve, prioritize, multi-task, and delegate assignments to strengthen overall company performance with limited supervision.
• Knowledge and use of technology to maintain and improve outcome assessment, surveys, reports, and audits.
• Demonstrates ability to manage time and projects efficiently
• Ability to troubleshoot and resolve basic hardware and software challenges.
• Valid Florida Driver’s License

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.

Open to candidates living in Eastern Time Zone.

Position Purpose : Responsible for analytic data needs of the business unit. Handle complex data projects and acts as a lead for other Data Analysts.

Continuously identify reporting and analytic processes for improvement and automation using Microsoft Power BI, MS SQL, Server Reporting Services (SSRS), SSAS and other analytic / programming tools.

Provide advanced analytical support for business operations in all or some of the following areas : claims, provider data, member data, clinical data, HEDIS, pharmacy, external reporting.

Extract, load, model, and reconcile large amounts of data across multiple system platforms and sources.

Review data to determine operational impacts and needed actions; elevate issues, trends, areas for improvement and opportunities to management.

Develop reports and deliverables for management.

Model data using MS Excel, Access, SQL, and / or other data ware house analytical tools.

Ensure compliance with federal and state deliverable reporting requirements by performing data quality audits and analysis.

Assist with training and mentoring other Data Analysts.

Education / Experience : Bachelor’s degree in related field or equivalent experience. 4+ years of statistical analysis or data analysis experience.

Healthcare experience preferred. Advanced knowledge of Enterprise Reporting and Analysis tools, SQL, and Microsoft Office applications, including Excel and Access.

Experience managing projects or heavy involvement in project implementation. Experience in writing SQL code preferred. Healthcare analytics experience preferred.

BUSINESS ANALYTICS : :

Bachelor’s degree in related field or equivalent experience. 4+ years of statistical analysis or 2+ years of related IT experience, including data warehouse, coding or ETL experience.

Healthcare experience preferred. Advanced knowledge of Enterprise Reporting and Analysis tools, SQL, and Microsoft Office applications, including Excel and Access.

Experience managing projects or heavy involvement in project implementation. Encounters experience preferred.

Our Comprehensive Benefits Package : Flexible work solutions including remote options, hybrid work schedules and dress flexibility, Competitive pay, Paid time off including holidays, Health insurance coverage for you and your dependents, 401(k) and stock purchase plans, Tuition reimbursement and best-in-class training and development.

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.