Data Analyst - (Excel, VLookUp, Power BI, Pivot Tables)

28 Jun 2024

Vacancy expired!

Talent Solutions Group Inc is partnered with a world renowned healthcare organization that focuses their technology team on data and analytics to grow the organizations effectiveness. As a healthcare

Data Analyst you will be responsible for analyzing and organizing membership and eligibility data, insurance claims, RX dispensing trends, lab reports, along with many other healthcare related datasets. The best person for the position will possess strong Tableau, Dashboard, SQL, ETL, Excel VLookUp and Pivot Tables.

Responsibilities
  • Interpret data, analyze results using statistical techniques and provide ongoing reports
  • Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality
  • Identify, analyze, and interpret trends or patterns in complex data sets
  • Filter and “clean” data by reviewing reports and dashboards to locate and correct code problems
  • Work with operations to prioritize business and information needs
  • Responsible for building data models to organize important data for different teams across the business and for monitoring and handling data.

Skills & Abilities
  • Tableau, Dashboard, SQL, ETL, Excel VLookUp, Pivot Tables
  • Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
  • The ability to spot trends, challenges, and opportunities in the data analyzed.
  • Adept at SQL queries, report writing, presenting findings
  • Familiarity with ETL and data management/data operations
  • Ability to design maintainable and scalable solutions
  • Establishing automated processes to manage all data ingress and egress between payors, vendors, and applications.
  • Structuring and normalizing datasets within internal databases and file systems.
  • Querying and analyzing data to distribute insights to internal lines of business and external partners.
  • Designing and building sustainable and scalable dashboards, interfaces, and reports to inform on progress and gaps in operations.
  • Maintaining data integrity and quality across all systems and applications enabling our clinical and service teams to provide excellent care to every single patient.
  • Identifying opportunities to support, enable, and add efficiencies to the business’s operations.
We are seeking a Healthcare Data Analyst (Tableau, Excel, VLookUp, SQL, Pivot Tables) to become an integral part of our team! You will analyze data to understand business and market trends in order to increase company revenue and efficiency.
  • Use data to understand business patterns and trends
  • Analyze internal and external data through quantitative research
  • Communicate findings to company through standard and ad hoc reports
  • Promote best practices in data analysis and reporting
  • Collaborate with cross-functional teams
  • Previous experience in business intelligence, analysis, or other related field
  • Knowledge of statistical tools and business reporting
  • Strong problem solving and critical thinking skills
  • Strong attention to detail
  • Ability to prioritize and multitask

  • ID: #43664560
  • State: Illinois Chicago 60290 Chicago USA
  • City: Chicago
  • Salary: Depends on Experience
  • Job type: Permanent
  • Showed: 2022-06-28
  • Deadline: 2022-08-07
  • Category: Et cetera