Lead SQL BI Analyst- Remote - No H1B at Los Angeles, California, USA |
Email: [email protected] |
From: Bhanu Prakash, Intellectt [email protected] Reply to: [email protected] Hi Hope you are doing well This is Bhanu from Intellectt INC; we have an immediate opportunity with one of our clients. Please find the below job description and if you are interested, please forward your resume to [email protected] Role: BI Analyst/Lead SQL Location: Los Angeles, CA (Remote) Duration:12-month contract Description: 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. The Lead SQL Reports Developer will work closely with the IT. enterprise data warehouse and application development teams. The Lead SQL Reports Developer will represent the Department at key multi-disciplinary and technical meetings that impact the department's policies, procedures, and supporting technical systems. The Lead SQL Reports Developer will work with claims, member services, finance, and compliance departments to provide guidance and information on provider data related issues. The Lead SQL Reports Developer will develop expert level knowledge of the systems data structures in the clients three core systems and provide high-level advice and guidance to management on systems development and data integration 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. 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. Must have the ability to code complex functions and procedures. Proven ability in overseeing SQL & Oracle databases of 500+ GB in size. Keywords: business intelligence information technology California |
[email protected] View all |
Sat Feb 03 00:39:00 UTC 2024 |