Allied Benefit Systems · 1 day ago
Senior IT Data Analyst
United States
Full-time
Remote
Mid, Senior Level
$100K/yr - $115K/yr
4+ years expAllied Benefit Systems is seeking a Senior Data Analyst who will perform quantitative analysis of complex business situations, focusing on sales and customer performance. The role involves developing tools for data visualization, ensuring data quality, and supporting technical teams while managing healthcare data analysis.
Health CareInsuranceWellness
Responsibilities
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
Qualification
Required
Bachelor's degree required with a focus in Computer Science, Math, Statistics desirable or equivalent work experience required
4-5 years of data analyst experience required
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
Preferred
Health care experience preferred
Benefits
Medical
Dental
Vision
Life & Disability Insurance
Generous Paid Time Off
Tuition Reimbursement
EAP
Technology Stipend
Company
Allied Benefit Systems
Allied offers insurance products, self-insurance solutions, custom insurance and healthcare solutions to the individuals and organizations.
501-1000 employees
Funding
Current Stage
Late StageTotal Funding
unknownKey Investors
Stone Point Capital
2021-02-18Private Equity
Leadership Team
D
Dina H. Tank
Senior Vice President of Sales, Western Region
Recent News
2025-06-04
2025-06-03
Company data provided by crunchbase