Job Details

Home

Sr Data Analyst/Warehouse Consultant at Remote, Remote, USA

Email: [email protected]

Job Title:
Sr Data Analyst/Warehouse Consultant

Client:
Santa Clara County (SCC)

Department:
Technology Services and Solutions (TSS) / Public Safety and Justice (PSJ)

Location:
San Jose, CA- Onsite

LinkedIn
- Yes

No H1B,CPT,OPT

Duration:
12 months

RFP ID:
eRFO-ISD-FY25-0046

Additional Information:

Candidate MUST have at least 10-12 of total IT experience.

Candidate MUST provide a signed an exclusive right-to-represent for this opportunity.

Resumes must Not include any Logos.

Must have state client experience

Local Candidates are preferred.

Please include candidate's copies of certifications related to this position

Project Scope:

This Resource will support data engineer and data analysis work for the Integrated Justice System and BI Platform Modernization projects

Roles/Responsibilities/ Typical Deliverables:

Creation of IT data models (e.g., conceptual, logical, physical, canonical);

Implementation of data design and transformation procedures;

Creation of frameworks for representing data elements;

Resolution of conflicts between data models;

Design, creation, and maintenance of relational and dimensional databases and data systems;

Recommendation and implementation of data reliability, efficiency, and quality improvements.

Enhancements to existing database systems to increase operating efficiency or adapt newer requirements

Recommendation and implementation of data reliability, efficiency and quality improvements;

Adherence and contribution to work plan timelines, managing workflows to meet project timeframes;

Design and creation of data processing systems that combine core data sources into data repositories

Map documentation of data elements from UI screens to database, mapping between 2 databases.

Data conversions, imports, and exports of data within and between internal and external systems;

Develop data migration scripts for loading data from old system to new target system(s).

Mandatory Skills:

3+ years experience in relational Database Modeling (conceptual, logical, and physical)

6-7 years of experience with tools: Microsoft Visual Studio, Microsoft SQL Server, Azure SQL Server, SSIS, SSRS, Power BI Report Server, Power BI Service, SSMS

1 year of experience with Tools: Quest Erwin or similar data modeling tool Creation of IT data models (e.g., conceptual, logical, physical, canonical);

Implementation of data design and transformation procedures;

Creation of frameworks for representing data elements;

Resolution of conflicts between data models;

Design, creation, and maintenance of relational and dimensional databases and data systems;

Recommendation and implementation of data reliability, efficiency, and quality improvements.

Enhancements to existing database systems to increase operating efficiency or adapt newer requirements

Recommendation and implementation of data reliability, efficiency and quality improvements;

Adherence and contribution to work plan timelines, managing workflows to meet project timeframes;

Design and creation of data processing systems that combine core data sources into data repositories

Map documentation of data elements from UI screens to database, mapping between 2 databases.

Desirables:

Bachelors degree higher in a quantitative field (i.e. Computer Science, Statistics, Engineering) or equivalent work experience

Dimensional Database Modeling

Data Vault 2.0 Methodology and architecture

Tools: Microsoft Azure Storage, ADLS GEN 2, Power Automate, Azure Logic Apps, Azure , AI Document Intelligence

Tools: Oracle RDBMS

Other Requirements:

1.Three (3) client references from different clients, containing the following details:

a. Name of Company/Agency

b. Contact Name

c. Contact Title

d. Contact Phone #

e. Contact Email

Thanks & regards

Praveen Kumar

Sr. US IT Recruiter

Phone:
571-479-4034
EXT : 327

Email: [email protected]

LARGETON INC.

13800 Coppermine Rd, Herndon, VA 20171

Disclaimer:

Largeton is an equalopportunity employer. There is no discrimination based on race, colour,religion, sex, national origin, age, disability, or any other protected status.

If you believe you have been treated unfairly, please contact our HR department at [email protected].

Keywords: artificial intelligence user interface business intelligence information technology California Idaho Virginia
Sr Data Analyst/Warehouse Consultant
[email protected]

[email protected]
View all

Fri Aug 16 23:33:00 UTC 2024

To remove this job post send "job_kill 1668256" as subject from [email protected] to [email protected]. Do not write anything extra in the subject line as this is a automatic system which will not work otherwise.

Your reply to [email protected] -

To

Subject
Message -

praveenk@largeton.us wrote:
Job Title: 
Sr Data Analyst/Warehouse Consultant

Client:
 Santa Clara County (SCC)

Department:
 Technology Services and Solutions (TSS) / Public Safety and Justice (PSJ)

Location: 
San Jose, CA- Onsite

LinkedIn 
- Yes

No H1B,CPT,OPT

Duration:
  12 months

RFP ID:
 eRFO-ISD-FY25-0046

Additional Information:

Candidate MUST have at least 10-12 of total IT experience.

Candidate MUST provide a signed an exclusive right-to-represent for this opportunity.

Resumes must Not include any Logos.

Must have state client experience

Local Candidates are preferred.

Please include candidate's copies of certifications related to this position

Project Scope:

This Resource will support data engineer and data analysis work for the Integrated Justice System and BI Platform Modernization projects

Roles/Responsibilities/ Typical Deliverables:

Creation of IT data models (e.g., conceptual, logical, physical, canonical);

Implementation of data design and transformation procedures;

Creation of frameworks for representing data elements;

Resolution of conflicts between data models;

Design, creation, and maintenance of relational and dimensional databases and data systems;

Recommendation and implementation of data reliability, efficiency, and quality improvements.

Enhancements to existing database systems to increase operating efficiency or adapt newer requirements

Recommendation and implementation of data reliability, efficiency and quality improvements;

Adherence and contribution to work plan timelines, managing workflows to meet project timeframes;

Design and creation of data processing systems that combine core data sources into data repositories

Map documentation of data elements from UI screens to database, mapping between 2 databases.

Data conversions, imports, and exports of data within and between internal and external systems;

Develop data migration scripts for loading data from old system to new target system(s).

Mandatory Skills:

3+ years experience in relational Database Modeling (conceptual, logical, and physical)

6-7 years of experience with tools: Microsoft Visual Studio, Microsoft SQL Server, Azure SQL Server, SSIS, SSRS, Power BI Report Server, Power BI Service, SSMS

1 year of experience with Tools: Quest Erwin or similar data modeling tool Creation of IT data models (e.g., conceptual, logical, physical, canonical);

Implementation of data design and transformation procedures;

Creation of frameworks for representing data elements;

Resolution of conflicts between data models;

Design, creation, and maintenance of relational and dimensional databases and data systems;

Recommendation and implementation of data reliability, efficiency, and quality improvements.

Enhancements to existing database systems to increase operating efficiency or adapt newer requirements

Recommendation and implementation of data reliability, efficiency and quality improvements;

Adherence and contribution to work plan timelines, managing workflows to meet project timeframes;

Design and creation of data processing systems that combine core data sources into data repositories

Map documentation of data elements from UI screens to database, mapping between 2 databases.

Desirables:

Bachelors degree higher in a quantitative field (i.e. Computer Science, Statistics, Engineering) or equivalent work experience

Dimensional Database Modeling

Data Vault 2.0 Methodology and architecture

Tools: Microsoft Azure Storage, ADLS GEN 2, Power Automate, Azure Logic Apps, Azure , AI Document Intelligence

Tools: Oracle RDBMS

Other Requirements:

1.Three (3) client references from different clients, containing the following details:

a.  Name of Company/Agency

b.  Contact Name

c.  Contact Title

d.  Contact Phone #

e.  Contact Email

Thanks & regards

Praveen Kumar

Sr. US IT Recruiter

Phone: 
571-479-4034
 EXT : 327

Email: praveenk@largeton.us

LARGETON INC.

13800 Coppermine Rd, Herndon, VA 20171

Disclaimer:

Largeton is an equalopportunity employer. There is no discrimination based on race, colour,religion, sex, national origin, age, disability, or any other protected status.

If you believe you have been treated unfairly, please contact our HR department at hr@largeton.com.

Keywords: artificial intelligence user interface business intelligence information technology California Idaho Virginia 
Sr Data Analyst/Warehouse Consultant
praveenk@largeton.us

Your email id:

Captcha Image:

Captcha Code:

Pages not loading, taking too much time to load, server timeout or unavailable, or any other issues please contact admin at [email protected]
Time Taken: 7

Location: San Jose, California