datawarehouse Health Care Systems Enterprise Data Warehouse SQL Experience Power BI   Requirement id 102074 Job title Developer Job location in San Mateo, CA Skills required datawarehouse, Microsoft SQL Server, Microsoft Azure, Health Care Systems Enterprise Data Ware Open Date 14-Jan-2020 Close Date Job type Not specified Duration 12 Months Compensation DOE Status requirement --- Job interview type Face to Face interview    Email Recruiter: coolsoft Job Description Developer: datawarehouse, Microsoft SQL Server, Microsoft Azure, Health Care Systems Enterprise Data Ware Note: Conference Call: January 22, 2020 @ 1:00 PM Note: Online Submission Submission Deadline: 1/31/2020 4:00 PM Start Date: 4/15/2020 End Date: 4/14/2020 Client: San Mateo County Health (SMCH) Description: Description/Scope of Work: The HIT Business Intelligence team maintains an Enterprise Master Person Index (EMPI) based on NextGates suite of products. In addition, HIT runs a Health Information Exchange named San Mateo County Connected Care (SMCCC) that aggregates information regarding treatment of SMCHS patients. The Health Information Technology Division (HIT) of San Mateo County Health (SMCH) is looking for a Microsoft SQL Server data warehouse developers with experience working in Microsoft Azure to design and implement a healthcare Enterprise Data Warehouse (EDW) . • Skills o SQL o Microsoft Azure o Power BI o Microsoft SQL Server Healthcare and Health Information Exchange (HIE) experience is highly desirable. The Data Warehouse SQL Developer will focus on designing, implementing, data cleaning and standardizing of the health enterprisewide data warehouse. They will design/implement data processing pipelines, data cleansing, standardization, data profiling, and enrichment processes to populate the data warehouse. They should have previous experience with Microsoft Azure data warehousing practices, including SQL Server Analytics and Integration Services and have a firm understanding of data warehousing layout. The Developer will provide creative and refined solutions to complex data and business requirements. Will work effectively under minimal supervision and may be required to provide technical oversight for the work of other team members. ________________________________________ Requirements: • Design, implement, and maintain complex ETL solutions on-premise and in Azure. • Design, implement, and maintain data solutions from data collection and curation through to content delivery via reports, dashboards, and other toolsets. • Model and develop databases and data structures to satisfy business processes and technical requirements. • Solve complex requirements using advanced-level SQL techniques such as window functions, CTEs, CROSS APPLY statements, etc. • Incorporate appropriate tools, technologies, techniques and design patterns to create maintainable, salable, high-performance database solutions. • Design, implement, and maintain code in development, test, and production environments. • Design solutions to support systematic promotion between environments. • Write, modify, tune, and debug database indexes, queries, stored procedures, views, user-defined functions, and other database entities. • Perform SQL Server administration activities including backup, restore, DBCC commands, and indexing. • Automate complex processes with SQL Agent jobs. • Design, develop, and troubleshoot permissions schemas using advanced security concepts. • Identify complex data patterns and inconsistencies through data analysis and data mining. • Collaborate with project managers and business analysts to develop solutions that meet client business requirements. • Stay current with Microsoft SQL Server tools and technologies. • Assist with code reviews. • Define standard work for EDW maintenance ________________________________________ Qualifications: • Fluent in TSQL • Use of Microsoft Azure Data Lake, Data Factory, and Data Warehouse • Strong SSIS development skills using SQL Server Data Tools and Visual Studio • Ability to write and maintain reports using SQL Server Reporting Services (SSRS) and Power BI • Proficiently use SQL Server Management Studio 2016+ • Fluent in C# and/or Python ________________________________________ Education and Experience: • Healthcare e   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 102074 while calling.   Other jobs in CA: Anaheim (4), Brea (3), Brisbane (2), Carlsbad (3), Concord (1), Culver City (1), Cupertino (5), Downtown Los Angeles (3), El Monte (3), El Segundo (1), Foothill Ranch (2), Irvine (1), La Jolla (2), Lake Forest (1), Larkspur Landing (1), Long Island (1), Los Angeles (27), Newport (1), Newport Beach (3), Orange (2), Orange County (7), Pasadena (1), Poway (5), Rancho Cordova (1), Redwood City (3), Sacrament (1), Sacramento (19), San Diego (87), San Francisco (24), San Jose (4), Simi Valley (1), South San Francisco (1), Westlake Village (2),    datawarehouse job openings in other states Jobs List VDOT Programmer Analyst 4/Datawarehouse (747993) Create date: 23-Oct-2024 **Hybrid Max Submittals by Vendor : 2 Start date : 11/18/2024 End Date : 06/30/2025 Submission deadline : 10/28/2024 Client Info : VDOT Description : ------------------------------------------------------ Data architect to provide data intake, data governance, data transfor.... (This job is for - datawarehouseSQL Jobs in VA Richmond Analyst - (in Richmond, VA)) Business Intel Technical Lead II -113309-SP Create date: 12-Jan-2023 Start date : 02/27/2023 End Date : 06/30/2023 Submission deadline :January 23rd at 4:00PM CST. Client Info :DCF Note : INTERVIEW NOTES: • Phone and web based interviews will be acceptable. • However, an in--person interview may be required. • Interviews will be set up .... (This job is for - datawarehouse Jobs in WI Madison TechLead - (in Madison, WI)) ITSAC 302CSD2205 Software Developer 2 -SP Create date: 17-Feb-2022 Note: RTR form must be signed by the candidate. Note: Total estimated hours per Candidate shall not exceed 750 hours. Submission Deadline: 2/24/2022 5:00 PM CT Start Date: 4/1/2022 End Date : 8/31/2022 Client: Office of the Attorney General of Texas (OAG) Description: Years Required/.... (This job is for - Datalake datawarehouse Jobs in TX Austin Developer - (in Austin, TX)) Data Warehouse Engineer-59214 Create date: 05-Jan-2022 Note:Candidates must be local to central Ohio or relocated by day one for consideration. Description: Our client is seeking a Data warehouse engineer with experience with the Microsoft stack of data warehouse tools (SQL, SSIS, SSAS, SSRS). The contractor will be part of a database team and responsible for participating i.... (This job is for - datawarehouseSSIS Jobs in OH Columbus Engineer - (in Columbus, OH)) INS-Database Administrator4 /DBA4 (673466) Create date: 05-Jan-2022 Start Date :01/31/2022 End Date :06/30/2022 Submison Deadline :01/10/2022 Client Info: INS Description : OITS Data Team It is seeking a Data warehouse engineer with experience with the Microsoft stack of data warehouse tools (SQL, SSIS, SSAS, SSRS). The contractor w.... (This job is for - datawarehouse SSAS SSIS Jobs in OH Columbus Administrator - (in Columbus, OH))    datawarehouse job openings in CA Jobs List RFO-CMAS-DTD-IT2019-002 Marine Data Warehouse Specialist -SP Create date: 20-Dec-2019 Note: Email Submission Note: The contractor is expected to work full-time hours (40 hours per week) onsite at the DTD offices, located in Sacramento, California. This contract shall not exceed $130,000. Submission Deadline: 1/8/2020 3:00 pm PST Start Date: 2/10/2020 End Date: 8/10/2020 Client: California .... (This job is for - datawarehouse Kimball SSIS Jobs in CA Sacramento Specialist - (in Sacramento, CA)) USPS-Cognos Developer - J-11-355-634 Create date: 04-Oct-2018 Senior level Cognos Developer (7+ years) with heavy experience in production support and development related to Cognos BI Applications 8.x,10.x (State, Government and/or CRM Analytics). Should have working knowledge of Cognos 10.2. Should have development experience with Cognos Framework Manager, Cognos Cubes and Cognos Admini.... (This job is for - datawarehouse SSO Jobs in CA SanDiego Developer - (in San Diego, CA)) SQL Server DBA - J-10-766-907 Create date: 04-Apr-2013 Job Summary: SQL Database Administrator is responsible for providing technical support for Amalga database environment including overseeing the development and organization of the databases, assessment and implementation of new technologies, and providing Information Technology with a long-term perspective on the relationship of database tech.... (This job is for - datawarehouse Jobs in CA ORANGE Analyst - (in Orange, CA)) Database Analyst 5 - J-10-765-854 Create date: 03-Apr-2013 Leads the planning, analysis, design, implementation, maintenance, and control of the organizations server-class databases. Consults with and advises senior management and multiple clients on high impact data or database management issues, influencing strategic direction. Handles and leads various large-scale or highly complex data/database managem.... (This job is for - datawarehouseUnix Jobs in CA IRVINE Analyst - (in Irvine, CA)) Project Manager (BI/DW Project) - J-10-755-122 Create date: 04-Mar-2013 Experis is working to fill a Senior Project Manager role in Los Angeles (Thousand Oaks), CA. This will be a 9 plus month contract and the candidates should have excellent communication skills and experience managing BI/DW projects. Responsible for leadership and execution of a new data warehousing / business intelligence program. Involv.... (This job is for - datawarehouse Business Intelligence Jobs in CA DOSVIENTOSRANCH Manager - (in DOS VIENTOS RANCH, CA)) (Developer: datawarehouse, Microsoft SQL Server, Microsoft Azure, Health Care Systems Enterprise Data Ware in San Mateo, CA)

Featured Jobs Budgeting Office Consultant (Jobs in Harrisburg, Pennsylvania) PMP Manager (Jobs in Atlanta, Georgia) Javascript Developer (Jobs in Tucker, Georgia) Architecture - - Specialist (Jobs in Raleigh, North Carolina) Typography Power Consultant (Jobs in Nashville, Tennessee) - Consultant (Jobs in Bismarck, North Dakota) SSIS JAVA Analyst (Jobs in Richmond, Virginia) TSOISPF Specialist (Jobs in Columbus, Ohio) Integration IT Specialist (Jobs in Columbus, Ohio) API CI Developer (Jobs in Richmond, Virginia)