• Would you like to be part of a growing national healthcare solutions company? Are you looking to positively affect thousands of lives each day via health benefits? Do you have experience in data analyst and healthcare?
• We are hiring a Data Analyst to join our team.

Who we are

• Allied is a national healthcare solutions company that supports healthy workplace cultures.

What we do

• We are problem-solvers, innovators, and collaborators. Our purpose is to work with employers to take care of their employees and their families every day – and it all starts with the Allied family.

What's in it for you?

• Allied supports an inclusive culture focused on developing employees to succeed, innovate & impact the community.

Here's how we do it

• Training and Development: Allied offers tailored learning and development curriculums for all employees and a Learning Management Database with thousands of courses for professional and personal development.'
• Career Mobility: Growth opportunities are endless at Allied. In 2021 alone, one in five employees had a job change. 75% of these job changes were promotions!
• Employee Engagement: We pride ourselves on employee engagement! With our recognition program, employees recognize their colleagues monthly or donate to charities with cash rewards. Allied has a dedicated committee planning monthly engagement activities to create endless opportunities to get to know your peers and destress in this new remote world.
• Employee Feedback: We regularly survey our employees throughout the year to seek continuous feedback, ideas and suggestions on new initiatives.
• Community Outreach: We have dedicated committees focused on fundraising efforts supporting our employees and their families, furthering education goals and providing funds for charitable organizations outside of Allied.

What will you be doing?

The Data Analyst is a goal-oriented, team player possessing a combination of technical and data skills used to help build and maintain a variety of reports and other analytical tools. 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

• 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, 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.
• 3-4 years of data analyst experience. Health care experience preferred.
• 2+ years' experience with MS SQL Server.
• Experience with SQL Server Development – creating and modifying stored procedures.
• Ability to use reporting and business intelligence tools like Microsoft SQL Server Reporting Services (SSRS) or 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
• Bachelor's degree required with a focus in Computer Science, Math, Statistics desirable.
• N/A
• This position requires long periods of sitting and computer work.

EXPERIENCE, SKILLS & ABILITIES

• 3-4 years of data analyst experience. Health care experience preferred.
• 2+ years' experience with MS SQL Server.
• Experience with SQL Server Development – creating and modifying stored procedures.
• Ability to use reporting and business intelligence tools like Microsoft SQL Server Reporting Services (SSRS) or 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 PowerPoint).
• Demonstrated analytical and problem-solving skills.
• Strong written, and verbal communication, and analytical skills are 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

Preferred

• 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

Education

• Bachelor's degree required with a focus in Computer Science, Math, and Statistics desirable.

PHYSICAL DEMANDS

• This position requires long periods of sitting and computer work.

WORK ENVIRONMENT

Remote

Hiring is contingent upon successful completion of our background and drug screening process. Allied is a drug-free and tobacco-free workplace.

Diversity creates a healthier atmosphere: Allied is an Equal Employment Opportunity / Affirmative Action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law.

#LI-MM1 #LI-REMOTE