As a SQL Database Developer, you will be working in a challenging environment developing SQL databases and writing applications to interface with SQL databases.
This includes
Database Development
Develop SQL code base for a wide variety of products
Desired Candidate Profile
Produce advanced SQL queries, build stored procedures, indexes, tables, and ability to work with larger data sets
Provide advanced analytical support for business operations in all or some of the following areas claims, provider data, member data, clinical data, HEDIS, pharmacy, external reporting
Extract, load, model, and reconcile large amounts of data across multiple system platforms and sources
Review data to determine operational impacts and needed actions; elevate issues, trends, areas for improvement and opportunities to management.
Develop reports and deliverables and make recommendations to management
Experience managing projects or heavy involvement in project implementation
Model data using MS Excel, Access, SQL, Microsoft SQL Server SSIS/SSRS, Teradata database and/or other data ware house analytical tools
Assist management in driving business decisions based on data
Ensure compliance with federal and state deliverable reporting requirements by performing data quality audits and analysis.
Execute data changes and update core systems as needed
Handle multiple projects and timelines effectively and communicate risks and issues to manager regularly
Assist with training and mentoring other Data Analysts.
Assist with determining work load and related activities for other Data Analysts
Working Experience on MS SQL Server 2012-2017 and Azure databases as a service
Capable of running Perfmon or SQL tools to analyze and troubleshoot SQL performance and capacity
Capable of writing and troubleshooting store procedures and triggers
Produce advanced SQL queries, build stored procedures, indexes, tables, and ability to work with larger data sets
Provide advanced analytical support for business operations in all or some of the following areas claims, provider data, member data, clinical data, HEDIS, pharmacy, external reporting
Extract, load, model, and reconcile large amounts of data across multiple system platforms and sources
Review data to determine operational impacts and needed actions; elevate issues, trends, areas for improvement and opportunities to management.
Develop reports and deliverables and make recommendations to management
Experience managing projects or heavy involvement in project implementation
Model data using MS Excel, Access, SQL, Microsoft SQL Server SSIS/SSRS, Teradata database and/or other data ware house analytical tools
Assist management in driving business decisions based on data
Ensure compliance with federal and state deliverable reporting requirements by performing data quality audits and analysis.
Execute data changes and update core systems as needed
Handle multiple projects and timelines effectively and communicate risks and issues to manager regularly
Assist with training and mentoring other Data Analysts.
