BI Analyst/Lead SQL

Only US citizens are eligible.

Duration : 12-Month Contract

We are looking for a BI Analyst/Lead SQL for health insurance company. This is a 12-month contract opportunity based out of Los Angeles, CA (Remote).

The Lead SQL Reports Developer provides business insights, serves as the focal point for data review and remediation in peak work periods, and develops a range of complex formal reports for government entities.

Qualifications:
• Bachelor's Degree or equivalent education.
• At least 5-7 years of direct experience developing complex reports derived from SQL or (Oracle) databases in a Managed Care environment which includes developing complex reports to external regulators and other entities with 3 years lead experience in a reporting, BI, or analytics team.
• Must have strong experience in Advanced Tableau to create reports.
• SQL Server, T-SQL, healthcare experience is required. Qnext and Cactus are optional.
• SQL Server is the primary database.
• Hands-on experience creating all key database objects – Tables, Views, Triggers, Indices, Stored Procedures, User Defined Functions, Dynamic SQL; Significant experience with SQL
• Loader, TOAD, and Korn Shell programming.
• Have well developed project management skills and experience leading a project that improved data integrity.
• Strong database (SQL Server) experience in an RDBMS environment.
• Strong general ETL / data integration experience; Experience developing/managing large-scale databases. "
• Extensive knowledge of SQL, SQL
• Plus.
• Ability to maintain application performance and scalability; focus on performance tuning SQL queries, table design, indexing, query plan analysis, and SQL refactoring.
• Proficient in database modeling & design with a focus on performance and scalability.

Responsibilities:
• Lead complex data reviews, develop complex formal reports, and audit provider data.
• Make or recommend ongoing changes to systems to better deliver provider data internally and externally.
• Oversee the quality of all outbound files and data transfers.
• Review the application of all provider data throughout the client systems environment and seek lasting solutions.
• Develop policies, procedures, and reports tailored to the various user groups of clients such as claims that identify provider issues, and moreover make recommendations as to how the issues could be resolved.
• Prepare and deploy complex schema updates, data migration, and ETL scripts.
• Timely, relevant, and actionable reports to frontline users and supervisors on provider data issues. Enroll users and design system security.
• Assist frontline staff resolve provider data issues through an in-depth knowledge of the data and upstream and downstream processes.
• Guide and mentor business analysts and other report writers in the department and for those staff working on providing data to clients.
• Become a key resource that can actively contribute to the fault-finding and resolution process when problems are identified with provider data.
• Mentor and train staff so they learn, understand, and are able to navigate the complexity of provider data.