This is Girish, - Recruitment and Resources from SancroSoft USA Inc.
We have an urgent requirement as follows:
Please respond with resumes in MS-Word Format with the following details to Girish@sancrosoftusa.com
Full Name :
Location :
Contact Number :
Email :
Availability :
Visa Status :
Data Architect With Kimball
Location: San Jose, CA
Duration: 1+ year
Rate: Market
Description:
The Data Architect will provide specialized expertise and focus to ensure that a comprehensive, coherent, and effective data warehouse and data lake architecture is in place for storing, maintaining, and managing all of the data associated with the PSJSP program in its transition from a central mainframe environment to a distributed architecture.
The Data Architect will need to operate at both a high level in helping to establish the guidelines, practices, and models for understanding and managing the “big picture”, and at a low level to guide team members in implementation details such as: data modeling; data warehouse, data lakes, and database design and optimization.
Primary Responsibilities:
- The Data Architect will be responsible for understanding the requirements and detailed data ecosystem of the components and applications associated with the PSJSP program, and using this knowledge to prepare and champion specific recommendations, guidelines, practices, and design models which will ultimately form the basis for the program data architecture.
- The Data Architect will also act as an in-house expert to mentor and assist technical staff in mastering techniques and best practices associated with: data modeling; data warehouse, data lakes, and database design and optimization and related activities.
- The Data Architect will collaborate as part of a team composed of technical leaders representing the enterprise, application, data and network architecture, interface development, security, and business relationship management areas of the program.
- Research, analyze and define technical problems and recommend alternative solutions.
- Review, understand, and apply business requirements to guide the creation of a comprehensive, coherent, and effective overall data architecture for PSJSP;
- Prepare and propose standards and templates for documenting data definitions, data provenance, and data structures;
- Lead and collaborate in the creation, maintenance and dissemination of data models, mentoring PSJSP staff in the skills and techniques required;
- Participate in the creation, maintenance and dissemination of data documentation;
- Collaborate in the creation, maintenance and testing of database backup and recovery and business continuity protection procedures;
- Collaborate in the creation and implementation of procedures to ensure data quality, data integrity, security enforcement, and data retention according to SCC policies and regulatory or business requirements;
- Monitor and tune database performance, including making recommendations for creating or updating indexes, query modification, or changes to data structures as appropriate;
- Participate in the establishment of guidelines and code review of data related artifacts, including integrity constraints, triggers, views, and stored procedures;
- Prepare weekly status reports;
- Coordinate with other ISD staff and management;
- Coordinate project activities with customers and external stakeholders;
- Provides leadership and mentoring to other Data Architecture team members;
Skills Requirement:
- Recent relevant experience involving a complex, multiple application and multiple agency environment with both traditional data warehouse and big data is strongly preferred.
- Ability to understand, model, and portray the big data picture, spanning multiple applications.
- Ability to define and implement practices for aligning data architecture with business requirements.
- Knowledge of both established and emerging data technologies, including the ability to identify when each can be effectively applied and the advantages / disadvantages of each.
- Ability to clearly document data structures, data definitions, and data provenance.
- Understanding of data indexing strategies for a variety of data types.
- Knowledge of national standards and policies related to public safety and justice data, including NIEM and CJIS, is desirable.
- Ability to work closely with agency and department technical and management resources.
- Must be able to produce high quality work, both independently and on a team, in a fast-moving environment.
- Must be able to plan and prioritize personal tasking.
- Must be able to communicate effectively both verbally and in writing.
Experience Requirement:
- 10+ years of related experience in software development, of which at least:
- Five years includes specific duties as a data architect, data warehouse architect, data modeler, or data analyst;
- Five years “hands on” experience managing one or more of the following database systems: Microsoft SQL Server 2008 or higher, Oracle, or IBM DB2, involving implementation of database schemas, indexes, and query optimization;
- Three years “hands on” experience implementing database stored procedures. Note: The above role specific experience may have been acquired concurrently.
- Experience defining and implementing data security, quality enforcement, and retention policies in a complex, multiple application environment;
- Experience creating, implementing and testing procedures for backing up and recovering databases;
- Experience supporting data management functions in public safety and justice domains (Court and Probation Case Management, Law Enforcement Records Management, Jail Management) is desirable;
Must have a solid understanding of principles and practices of:
- Kimball methodology;
- Data lakes, data warehouse, and big data;
- Software development;
- Technical problem solving;
- Customer service;
- Project and technical documentation;
- Programming, including programming languages and utilities is desirable;
Education Requirement:
- Bachelor’s degree in Engineering, Computer Science, or a related field and 10+ years of related experience.
Regards,
Sai Girish
Cell: 916-671-5591| girish@sancrosoftusa.com | www.sancrosoft.com
The Power of Support
Corporate Head Office: SancroSoft USA Inc
#4944, Sunrise Blvd. Fair Oaks CA - 95628. USA
This is not an unsolicited mail. If you are not interested in receiving our e-mails, please reply with a "REMOVE" in the subject line. All the removal requests will be duly acted upon. “If you are receiving this email in Spam or Junk folder, please mark it as ‘not spam’ and add our email ID to your contacts or safe sender’s list.”
No comments:
Post a Comment