SQL Report Writer / Analyst (Medical Insurance Industry)
SQL Report Writer / Analyst (Medical Insurance Industry)
Job ID: 41363
Location: Missoula, MT
Category: Accounting & Financial
Employment Type: Contract-to-Hire
Missoula, MT / 6-month contract
A Missoula-based insurance agency, that is passionate about fostering a healthy work-life balance for our employees, is seeking a SQL Report Writer/Analyst. They believe that this balance not only enhances the well-being of their team but also contributes to the satisfaction and success of their clients and members. Their mission goes beyond providing insurance, they are dedicated to helping people live better lives.
We are seeking a talented and detail-oriented SQL Report Writer/Analyst to collaborate with internal stakeholders across this company. In this role, you will be responsible for building and automating reports, dashboards, and customer correspondence templates. You will also work closely with internal teams to identify optimal data fields, design report layouts, and improve reporting processes. The ideal candidate will have strong technical expertise in SQL, report development tools, and data visualization, along with the ability to communicate insights in a clear and actionable manner.
Salary: $105,000
Schedule: Full-time – 6-month contract
Location: Missoula, MT (in office/hybrid with remote options)
Scope of Services
- Collect and translate reporting and dashboard requirements from internal stakeholders into reporting solutions to meet business needs. Partner with internal stakeholders to identify opportunities to improve existing reports before translating them into a VBA-compatible format, as applicable.
- Identify opportunities to scale the report development effort, such as leveraging standardized formats across multiple stakeholders using similar documents.
- Support internal teams to migrate the current backlog of proprietary formatted reports and customer correspondence templates into a new SQL-based reporting standard compatible with VBA Software.
- Write SQL queries to extract data from the Microsoft SQL Server database for ad-hoc requests.
- Design an automation of reoccurring report deliverables with Microsoft SQL Server Reporting Services (SSRS).
- Develop methods for improving internal techniques and processes to create highly effective reports and dashboards.
- Maintain audit performance dashboards from external data sources, leveraging and improving existing templates, as directed.
- Support documentation efforts, as directed.
- Drive a high level of accuracy and quality in all produced work.
- Other related duties as assigned by the Program Manager, Allegiance Reporting Manager or Allegiance Leadership.
KEY DELIVERABLES
- Business requirements for reports, dashboards, data extracts and other similar deliverables captured from engagement with internal stakeholders
- Reports, dashboards, data extracts and other similar deliverables converted from prior formats into a VBA Software-compatible SQL format, as directed by the Allegiance Reporting Manager
KEY QUALIFICATIONS
- Strong demonstrated SQL skills
- Demonstrated experience with Microsoft SQL Server Reporting Services (SSRS)
- Demonstrated experience working with business users to collect requirements for reporting artifacts
- Demonstrated experience creating reports, dashboards, data extracts and other similar deliverables converted from prior formats into a VBA Software-compatible SQL format
- Healthcare / health insurance experience a plus
If interested send resume to [email protected] or call 406.270.0583
41363