Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
SQL Power BI SQL Server Administration TSQL SQL Server Management Studio C# Python
 
Requirement id 89271
Job title Developer
Job location in Redwood City, CA
Skills required Microsoft SQL Server, Data Warehouse Development, Microsoft Azure, SQL Power BI SQL Server Administration T
Open Date 28-Feb-2019
Close Date
Job type Not specified
Duration 18 Months
Compensation DOE
Status requirement ---
Job interview type ---
   Email Recruiter: coolsoft
Job Description Developer: Microsoft SQL Server, Data Warehouse Development, Microsoft Azure, SQL Power BI SQL Server Administration T

Note: Email Submission
Note: Only Submit TWO consultant candidate per company.

Conference Call: 3/4/2019 @ 11:30 AM PST

Submission Deadline: 3/15/2019 4:00 PM PST
Start Date: 4/29/2019
End Date: 10/28/2020

Client: Health Information Technology(HIT)

Description:

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.

Project Description/Scope of Work

The Health Information Technology Division (HIT) of San Mateo County Health (SMCH) is looking for two (2) Microsoft SQL Server data warehouse developers with experience working in Microsoft Azure to design and implement a healthcare Enterprise Data Warehouse (EDW) .

• Skills
– SQL
– Microsoft Azure
– Power BI
– Microsoft SQL Server

Healthcare and Health Information Exchange (HIE) experience is highly desirable.

The Data Warehouse SQL Developers 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 Developers will provide creative and refined solutions to complex data and business requirements. They will work effectively under minimal supervision and may be required to provide technical oversight for the work of other team members.

Work Requirements/Deliverables

• 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, scalable, high-performance database solutions.
• Design, implement, and maintain code in development, test, and production environments.
• Design solutions to support systematic promotion between environments.

Work Requirements/Deliverables

• 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

Experience Required/Preferred

Knowledge, Skills, and Abilities:
• Love of data
• 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 wr
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 89271 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),
 
 Microsoft SQL Server job openings in other states
Jobs List

Programmer/Developer - FSDETLOHS2
Create date: 28-Feb-2024
start date : 04/01/2024

End date :03/31/2025

submission deadline :03/07/2024

client info : CT DAS

Note:

* Position Location: Hybrid

Description :



We are seeking a highly motivated and skilled Full-Stack Develo.... (This job is for - Data WarehousingASPNet Jobs in CT Hartford Developer - (in Hartford, CT))

NJITO-Senior Consultant 1 (728646)
Create date: 23-Feb-2024
Start date : 03/03/2024

End date : 09/07/2024

Submission deadline : 2/28/2024

Client info : Judiciary

Note :

* Hybrid

Description :

· Extensive knowledge of Identity and Access Management Infrastructure

· .... (This job is for - IIS Jobs in NJ Trenton Consultant - (in Trenton, NJ))

AGE ITC - IT Consultant 1 (726524)
Create date: 31-Jan-2024
Start date : 01/02/2024

End date : 06/30/2024

Submission deadline : 02/05/2024

Client info : AGE

Note :

* 2 Days/week on-site,

Description :

The Ohio Department of Aging (ODA) is looking for a skilled, experienced, and motiv.... (This job is for - job Jobs in OH Columbus Consultant - (in Columbus, OH))

Systems Engineer II - 126730
Create date: 31-Jan-2024
Start date : 03/04/2024

End date : 06/30/2024

Submission deadline : 2/7/24 at 4:00PM CST.

Client info : DFI

Note :

* Interview Process: Teams

* Duration of the Contract: 6/30/2024, likely to be extended

* Onsite or Remote? Candidates MUST be a WI resident or willing t.... (This job is for - WSUS Jobs in WI Madison Engineer - (in Madison, WI))

PDE- Technical Architecture Specialist TAS3 A4 SC2 (709759)
Create date: 04-May-2023
start date : 05/15/2023

End date : 06/30/2023

submission deadline : 04/28/2023

client info : PDE

Description :

The General Government Delivery Center (GGDC) is seeking a motivated and skilled SQL Server and Database Administrator for all PDE Appli.... (This job is for - job Jobs in PA DauphinCounty Specialist - (in Dauphin County, PA))
 
 Microsoft SQL Server job openings in CA
Jobs List

Contingency Staffing 956-Data Warehouse Developer-SP
Create date: 14-Jan-2020
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 a.... (This job is for - datawarehouse Jobs in CA SanMateo Developer - (in San Mateo, CA))

Operations Team Lead - NTTJP00011510
Create date: 19-Nov-2018
Start Date :11/26/2018
End Date :06/30/2023
Submission Deadline :11/26/2018

Note - Client-Accepted Visa Types : Citizen only, EAD, H-1, L-1, Perm Resident/Citizen only

Description :

we know that with the right people on board, anything is possible. The quality, integrity, and co.... (This job is for - Tableau Sql Server 2008 Jobs in CA Anaheim Consultant - (in Anaheim, CA))

Imperva Admin - 34354
Create date: 07-May-2018
Client Info :Wells Fargo SoCal

Candidate must be our W2 Employee

Job Description :

Database Analyst 5 – SecureSphere Administrator

This candidate will provide technical systems support the Enterprise Database Management platforms for the Dealer Services line of business. The position will be responsible f.... (This job is for - job Jobs in CA Irvine Administrator - (in Irvine, CA))

USPS-IT BI Developer/Engineer - J-11-154-115
Create date: 16-Aug-2016
Start Date : 08/26/2016

End Date : 08/26/2017

Submission Deadline : 08/20/2016

description :

US Citizen/Green Card
Must be local to San Diego. Work on site

Business Intelligence (BI) Developer, SSRS Report Writer, SSIS Developer, Database Analyst, Microsoft SQL Server Migration / Upgrade <.... (This job is for - BI Jobs in CA SANDIEGO Developer - (in San Diego, CA))

Customer Information System
Create date: 12-Aug-2015
*Description:
The Client invites proposals from qualified firms with outstanding qualifications, experience and knowledge to provide a fully integrated, preferably Windows-based, web-enabled applications information system for a Customer Information System (CIS).

*Required Skills:
•The CIS must be composed of a single set of .... (This job is for - job Jobs in CA Palmdale Developer - (in Palmdale, CA))
(Developer: Microsoft SQL Server, Data Warehouse Development, Microsoft Azure, SQL Power BI SQL Server Administration T in Redwood City, CA)
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     

    About Us     Services    Privacy policy    Legal     Contact us