| Immediate Hire - BI Analyst or Lead SQL - Los Angeles, CA (Remote) at Remote, Remote, USA |
| Email: [email protected] |
| From: Gangadhar, Intellectt [email protected] Reply to: [email protected] Hello, Hope you are doing great. This is Gangadhar 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 Months Description: 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. Ability to design and develop the database based on established requirements, including modifying any existing SQL database structure, as necessary. Ability to maintain application performance and scalability; focus on performance tuning SQL queries, table design, indexing, query plan analysis, and SQL refactoring. Ability to develop proactive working relationships with Providers and other managed care organizations to determine business and functional requirements and identify solutions to resolve needs. Ability to provide architectural/database technical expertise to the team concerning methods, procedures, and standards to be used during design and development phases. Ability to develop technical documentation and operational procedures for areas of responsibility. Ability to create test plans, test data sets, and automated testing to ensure all components of the system meet specifications; Investigate and fix defects; pre-and post-release. Ability to troubleshoot/resolve complex database issues. Proficient in database modeling & design with a focus on performance and scalability. Excellent organizational skills with the ability to achieve results within tight deadlines. Strong customer service orientation. Excellent verbal and written communication skills. Work under limited supervision. SQL Server, T-SQL, and healthcare experience are required. Qnext and Cactus are optional. Keywords: business intelligence California |
| [email protected] View all |
| Fri Feb 02 20:53:00 UTC 2024 |