Job Title: Sr. Data Analyst / Data Warehouse Consultant
Location: Hybrid (San Jose, CA)
Contract: 12+ Months/Contract
Interview Mode: MS Team + Face to Face
USC/GC Only
Client : Santa Clara County
This is a hybrid opportunity that requires the consultant to work onsite 3x per week.
Mandatory Requirements:
- 3+ years' experience in Relational Database Modeling (conceptual, logical, and physical)
- 6+ years' experience with Microsoft Visual Studio, Microsoft SQL Server, Azure SQL Server, SSIS, SSRS, Power BI Report Server, Power BI Service, SSMS
- 1+ years' experience with Quest Erwin or similar data modeling tool
- Dimension Database Modeling
- Data Vault 2.0 methodology and architecture
- Able to work onsite 3x per week
Desired Qualifications:
- Tools: Microsoft Azure Storage, ADLS GEN 2, Power Automate, Azure Logic Apps, Azure AI Document Intelligence
- Tools: Oracle RDBMS
Objective:
This Resource will support data engineer and data analysis work for the Integrated Justice System and BI Platform Modernization projects.
Required Skills & Abilities:
- 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 to 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).
- Develop data transformation and automation processes supporting business systems and data flows.
- Maintain data repositories quality by adding, modifying, and deleting data as needed and as requested.
- Troubleshoot data issues and data processing tools, systems, and software.
- Identify and resolve problems related to database management systems.
- Develop and maintain a query library to support recurring data requests.
- Maintain data dictionaries and other related data processing metadata.
- Implement statistical models to identify trends, correlations, and patterns in data sets.
- Catalog data sources.
- Perform data cleansing and filtering.
- Design analytical dashboards and reports.
- Mine and analyze multiple data sets (Dimensional) for trends, insights, problems, etc;
- Document models, solutions, data mapping, technical specifications, data dictionaries, test cases, etc.
- Relational Database Modeling (conceptual, logical, and physical): 3+ years’ experience;
- Tools: Microsoft Visual Studio, Microsoft SQL Server, Azure SQL Server, SSIS, SSRS, Power BI Report Server, Power BI Service, SSMS: 6-7 years’ experience.
- Tools: Quest Erwin or similar data modeling tool – 1 year experience
Desired Qualifications:
- 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
Education:
Bachelor’s degree higher in a quantitative field (i.e. Computer Science, Statistics, Engineering) or equivalent work experience
Thanks & Regards
Mangal Thakur
SKILLBIRD LLC.
4 Peddlers Row, Unit#5, Newark, DE 19702
|
| |
|