Senior IT Data Analyst

Allied Benefit Systems, Inc.; Illinois; Remote; USD 95,000 - 105,000; Full time

Job summary

A leading company in the health insurance sector seeks a Senior Data Analyst to perform complex analyses and develop monitoring tools. This role entails ensuring data quality and providing insights through advanced data analytics techniques. If you have expertise in SQL, data visualization, and a strong analytical background, we invite you to apply.

Benefits

Medical, Dental, Vision Insurance

Generous Paid Time Off

Tuition Reimbursement

Technology Stipend

Qualifications

• 4-5 years of data analyst experience required.
• Health care experience preferred.
• Experience with SQL Server Development and data warehouse environment.

Responsibilities

• Perform quantitative analysis of complex business situations.
• Develop tools for data monitoring and reporting.
• Create dashboards for insights and visualization.

Skills

Data analysis

SQL

Data visualization

Problem-solving

Attention to detail

Education

Bachelor’s degree in Computer Science, Math, or Statistics

Tools

SQL Server

Power BI

SSRS

SSIS

Job description

Job Details

Job Location: Allied Benefit Systems - CHICAGO, IL

Position Type: Full Time

Salary Range: $95000.00 - $105000.00 Salary

Job Category: Information Technology

Description

POSITION SUMMARY

The Senior Data Analyst is responsible for performing quantitative analysis of complex business situations, such as strategies, performance, and solutions involving sales and customer performance. They may apply SQL skills, database tools to conduct the analysts. The ideal candidate is skilled in various aspects of data analytics, such as programming, mining, generation, and visualization. As a technical lead, the data analyst will be responsible for resolving issues and ensuring success of projects assigned to their team.

ESSENTIAL FUNCTIONS

• Respond to data and product related inquiries in real-time to support business and technical teams

• Provide expertise and translate the business needs to design; and develop tools, techniques, and metrics, and dashboards for insights and data visualization

• Responsible for developing and executing tools to monitor and report on data quality

• Responsible for establishing appreciation and adherence to the principles of data quality management, including metadata, lineage, and business definitions

• Provide support to Tech teams in managing security mechanisms and data access governance.

• Develop an understanding of the health insurance world in different areas of the business such as claims, eligibility, customer service, and stop loss.

• Perform analyses of varied healthcare data to evaluate programs and product solutions using medical, dental, flex, pharmacy, lab, provider, and utilization data.

• Maintain high standards of data quality and integrity.

• Work closely with stakeholders to create dashboards and reports.

• Design and code efficiently using SQL and other data reporting languages.

• Help create and test SQL statements for data presentation and further automation.

• Set up and monitoring routine maintenance SQL jobs and developing / maintaining an alert strategy(s) for failed jobs and database problems and/or failures.

• Data modeling, including an understanding of all normalized forms, design and development of stored procedures, views and triggers.

• Manage daily / monthly data and reporting processes automated through SQL Server agent

• Create reports using a variety of tools and formats such as Excel, Power BI, PDFs, .txt files, etc.

• Document methods, specifications, and findings clearly; contribute to the writing and the presentation of results, findings, and conclusions.

• Excellent attention to detail, ability to detect and correct problems within SQL script

• Meet Allied’s expectations for productivity, quality, and goal accomplishment.

• Work closely with manager to complete assigned tasks

• Adhere to, and apply all applicable privacy and security laws, including but not limited to HIPAA, HITECH and any regulations promulgated thereto.

• Perform other duties and responsibilities, as assigned.

• Attend continuing education classes as required, including but not limited to HIPAA training.

EDUCATION

• Bachelor’s degree required with a focus in Computer Science, Math, Statistics desirable or equivalent work experience required.

EXPERIENCE AND SKILLS

• 4-5 years of data analyst experience required. Health care experience preferred.

• 4 to 5 years’ experience with MS SQL Server required.

• Experience with SQL Server Development – creating and modifying complex stored procedures.

• Proficient with reporting and business intelligence tools like Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Integration Services (SSIS), and Power BI.

• Ability to collaborate well with team members.

• Experience in working in a data warehouse environment as well as the ability to work with large data sets from multiple data sources.

• Proficient computer skills, including Microsoft Office Suite (Word, Excel, Access and Power Point).

• Demonstrated analytical and problem-solving skills.

• Strong written, verbal communication and analytical skills required.

• Usage of SQL Profiler

• Experience with Power Automate
  • Knowledge of integrating SQL Server solutions in .NET environments, with working knowledge of C#, ASP.NET and SOA with web services

POSITION COMPETENCIES

• Job Knowledge

• Time Management

• Accountability

• Communication

• Initiative

• Customer Focus

PHYSICAL DEMANDS

• This is an office environment requiring extended sitting and computer work

WORK ENVIRONMENT

• Remote

The company has reviewed this job description to ensure that essential functions and basic duties have been included. It is not intended to be construed as an exhaustive list of all functions, responsibilities, skills, and abilities. Additional functions and requirements may be assigned by supervisors as deemed appropriate.

Compensation is not limited to base salary. Allied values our Total Rewards, and offers a competitive Benefit Package including, but not limited to, Medical, Dental, Vision, Life & Disability Insurance, Generous Paid Time Off, Tuition Reimbursement, EAP, and a Technology Stipend.

Allied reserves the right to amend, change, alter, and revise, pay ranges and benefits offerings at any time. All applicants acknowledge that by applying to the position you understand that the specific pay range is contingent upon meeting the qualification and requirements of the role, and for the successful completion of the interview selection and process. It is at the Company's discretion to determine what pay is provided to a candidate within the range associated with the role.

Qualifications