Note: The job is a remote job and is open to candidates in USA. Allied Benefit Systems is seeking a Senior IT Data Analyst responsible for performing quantitative analysis of complex business situations. The role includes various aspects of data analytics, such as programming, mining, generation, and visualization, while also providing technical leadership to ensure project success.
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 monitor routine maintenance of 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 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 the 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
- Attend continuing education classes as required, including but not limited to HIPAA training
- Other duties as assigned
Skills
- Bachelor's degree required with a focus in Computer Science, Math, Statistics, 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 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 are required
- Usage of SQL Profiler
- Health care experience preferred
- 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
Benefits
- Remote friendly culture offers flexibility and the comfort of working from home, while also ensuring you are set up for success
- Internet connection must be obtained through a cable broadband or fiber optic internet service provider with speeds of at least 100Mbps download/25Mbps upload
- Offers a competitive Benefit Package including, but not limited to, Medical, Dental, Vision, Life and Disability Insurance
- Generous Paid Time Off
- Tuition Reimbursement
- EAP
- Technology Stipend
Company Overview