Job description

Data Analyst

6 month contract to hire

Pittsburgh, PA (Fully remote - EST hours)

$80k-$90k

Our healthcare client is leading a healthcare transformation through their partnerships with physicians and healthcare insurers. Through their unique models, our client empowers physicians to truly manage a patient’s health, delivering high quality, affordable care in a modern, patient focused approach.

The Data Analyst is responsible for data extraction, data mining, data profiling, and data source to target mapping activities using SQL. The Data Analyst will work closely with business subject matter experts and engineers to operationalize business processes using data, in support of data integrations and warehousing projects. In this role, the Data Analyst will play a critical role in connecting our client's partners and enabling their critical solutions through our client’s use of actionable data and empowering processes through harmonized data across the entire spectrum from care provision, claim payment and process visibility. Join our fast-paced, experienced team of healthcare leaders and re-shape healthcare!

Essential Functions

· Write SQL scripts to analyze, validate, or correct data according to requirements, which may include complex stored procedures, views, and functions.

· Perform data extraction, data mining, and data profiling activities.

· Profile data sets for completeness and validity, and build automated SQL scripts to assess completeness, validity, and other data metrics.

· Analyze and pull data as well as measure, monitor, review, analyze, and troubleshoot data quality issues using SQL.

· Work with business subject matter experts, business analysts, data modelers, and engineers to complete source to target data mappings with detailed transformations to be used by engineers in writing code for implementation of data integrations and warehousing projects.

· Convert existing datasets from a diverse array of file formats, including Excel, Access, SQL, ASCII, text files, etc., into analytic datasets.

· Communicate with business units to obtain data requirements and perform data analysis on data provided.

· Work with engineers to support the development of new and/or modification of existing database, data warehouse, data mart and business intelligence solutions to meet business and system requirements.

· Work closely with the business units to gain in-depth understanding of business strategies and processes in order to operationalize and measure using data.

· Works with stakeholders to analyze operational processes and trends and identify issues.

· Resolves complex issues, optimizes performance, and provides timely follow-up on identified issues.

· Utilize technical expertise to ensure data is accurate and high-quality.

· Performs other duties as assigned.

Education

· A bachelor’s degree in computer science or a closely related field preferred.

Skills & Experience

· 5+ years of relevant work experience in a role with SQL, Excel, relational databases (MS SQL, Azure SQL) and database mapping techniques.

· Demonstrated advanced data analytics, data mining, data profiling, and data validation skills.

· Strong data quality understanding of data quality concepts and familiarity with data quality tools and methods.

· Strong understanding of health data, including managed care, population health, or health insurance operations.

· Experience working in an environment using Agile/SCRUM methodologies and principles.

· Familiarity with data visualization tools, such as PowerBI, a plus.

· Ability to communicate and make recommendations to management.

· Demonstrated advanced interpersonal/verbal and written communication skills.

· Demonstrated analytical and problem-solving skills.

· Ability to work as part of a team.

· Self-starter, with a strong work ethic and attention to detail.

· Familiarity with working in a regulated industry.

Job Types: Full-time, Contract

Pay: $80,000.00 - $90,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Disability insurance
• Health insurance
• Life insurance
• Vision insurance

Schedule:

• 8 hour shift
• Day shift
• Monday to Friday
• No nights
• No weekends

Application Question(s):

• Are you able to work on W2?

Experience:

• SQL: 4 years (Preferred)
• Data mining: 4 years (Preferred)

Work Location: Remote

colinoncars.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, colinoncars.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, colinoncars.com is the ideal place to find your next job.