Enterprise Solutions, Inc.
https://www.enterprisesolutioninc.com/wp-content/uploads/2020/07/Enterprise-Logo-web.png
https://www.enterprisesolutioninc.com
https://www.enterprisesolutioninc.com
USD
80
95
HOUR
true
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 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
Senior Data Analyst/Data Warehouse Consultant
san jose, CA 95131 United States
Posted: 08/12/2024
2024-08-12
2024-11-14
Job Number: z5G7h3l6a1kMvyS65NP3cxJCvwpsrKXcm3sI0mz240E=
Pay Rate: 80-95 Hourly USD
Job Description
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 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
Meet Your Recruiter
Share This Job:
Related Jobs:
Login to save this search and get notified of similar positions.About san jose, CA
Explore exciting job opportunities around San Jose, California! Known as the heart of Silicon Valley, this vibrant city offers a dynamic career landscape with countless growth prospects in tech, engineering, and beyond. San Jose boasts a thriving arts scene, with landmarks like the Tech Museum of Innovation and the San Jose Museum of Art, as well as fantastic dining options that range from trendy cafes to authentic taquerias. With its proximity to beautiful parks like Alum Rock Park and numerous entertainment options, including performances at the San Jose Center for the Performing Arts and cheering for the San Jose Sharks hockey team at the SAP Center, there's no shortage of reasons to kick-start your career in this enchanting city. Discover your next big opportunity in San Jose today!