Senior Data Warehouse Consultant

1 month ago

San Jose, United States Optima Global Solutions Inc. Full time

Optima Global Solutions Inc.is a valuable IT Services and Solution provider that customers, employees, and stakeholders feel proud to be associated with. Optima's Intelligent Automation Solutions leverage robotic process automation, intelligent data capture, and business process management best practices to streamline operations. Our IT Services practice provides organizations with highly personalized, comprehensive, U.S. based recruiting services supported by our internal onsite team of subject matter experts. Currently, we are hiring for the following position.


Position Title: Senior Data Analyst/Data Warehouse Consultant

Duration: 12+ Months

Location: San Jose, CA (3 Days On-site Mandatory)


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 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

  • Senior Data Analyst/Data Warehouse Consultant

    3 months ago

    San Jose, United States Resource Informatics Group Inc Full time

    Job DescriptionJob DescriptionTitle: Senior Data Analyst / Data Warehouse ConsultantLocation: San Jose, CADuration: 6 months.RATE: DOE Description:Collaborates with vendors, administrators and owners of third-party databases toestablish data mapping plans and methods, enabling the sharing of data;Develops computer testing and audit policies and assists end...

  • Senior Data Warehouse Consultant

    1 month ago

    San Jose, United States CrowdPlat Full time

    Objective: The Senior Data Warehouse Consultant / Data Analyst will support data engineering and analysis tasks for the Integrated Justice System and Business Intelligence (BI) Platform Modernization projects. The role focuses on enhancing database systems, data modeling, and data transformation to ensure data reliability, efficiency, and quality.Key...

  • Senior Data Warehouse Consultant

    1 month ago

    San Jose, United States CrowdPlat Full time

    Objective: The Senior Data Warehouse Consultant / Data Analyst will support data engineering and analysis tasks for the Integrated Justice System and Business Intelligence (BI) Platform Modernization projects. The role focuses on enhancing database systems, data modeling, and data transformation to ensure data reliability, efficiency, and quality.Key...

  • Sr. Data Warehouse Consultant

    2 months ago

    San Jose, United States Tata Consultancy Services Full time

    Job DescriptionThe candidate should also have a good understanding of B2B and B2C interactions and how BI was utilized in those experiences.Enterprise Data Warehouse, Data Model, Business Insights.Must Have Technical/Functional Skills • Design & Implementation of large Enterprise Data Warehouse• Design high level Conceptual model for Enterprise worthy...

  • Sr. Data Warehouse Consultant

    2 months ago

    San Jose, United States Tata Consultancy Services Full time

    Job DescriptionThe candidate should also have a good understanding of B2B and B2C interactions and how BI was utilized in those experiences.Enterprise Data Warehouse, Data Model, Business Insights.Must Have Technical/Functional Skills • Design & Implementation of large Enterprise Data Warehouse• Design high level Conceptual model for Enterprise worthy...

  • Sr. Data Warehouse Consultant

    3 weeks ago

    San Jose, United States Tata Consultancy Services Full time

    Must Have Technical/Functional Skills • Design & Implementation of large Enterprise Data Warehouse• Design high level Conceptual model for Enterprise worthy entities of corporate domains (Finance, HR, Legal, Real Estate etc.)• Knowledge of data profiling, master data management, ETL/ELT• Well versed in Data protection strategies for Enterprise Data...

  • Sr. Data Warehouse Consultant

    1 month ago

    San Jose, United States Tata Consultancy Services Full time

    Must Have Technical/Functional Skills • Design & Implementation of large Enterprise Data Warehouse• Design high level Conceptual model for Enterprise worthy entities of corporate domains (Finance, HR, Legal, Real Estate etc.)• Knowledge of data profiling, master data management, ETL/ELT• Well versed in Data protection strategies for Enterprise Data...

  • Senior Data Warehouse Expert

    2 days ago

    San Jose, California, United States SiGlaz Full time

    About SiGlazSiGlaz is a leading provider of data warehouse solutions, dedicated to helping organizations unlock the full potential of their data. We are seeking a highly skilled and experienced data warehouse professional to join our team as a Principal Consultant.Job SummaryThe Principal Consultant will be responsible for leading the design and...

  • Senior Data Warehouse Analyst

    4 weeks ago

    San Jose, United States Impresiv Health Full time

    Title: Senior Data Analyst/Data Warehouse Consultant***Please no third party candidates at this time***Duration: 12 months Location: Hybrid, onsite in Santa Clara, CA 3 times a weekSummary The Senior Data Analyst will support data engineer and data analysis work for the Integrated Justice System and BI Platform Modernization projects.Typical Deliverables:...

  • Senior Data Warehouse Consultant

    1 month ago

    San Jose, United States Satwic Inc Full time

    Job description • 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...

  • Senior Data Warehouse Consultant

    1 month ago

    San Jose, United States Satwic Inc Full time

    Job description • 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...

  • Senior Data Warehouse Engineer

    4 weeks ago

    San Francisco, United States Unreal Gigs Full time

    Job DescriptionJob DescriptionCompany Overview: Welcome to the forefront of data-driven innovation! Our company is dedicated to leveraging the power of data to drive transformative change and solve complex problems across industries. We're committed to building scalable and efficient data warehousing solutions that enable advanced analytics, reporting,...

  • Senior Data Warehouse Engineer

    3 months ago

    San Francisco, United States Unreal Gigs Full time

    Job DescriptionJob DescriptionCompany Overview: Welcome to the forefront of data-driven innovation! Our company is dedicated to leveraging the power of data to drive transformative change and solve complex problems across industries. We're committed to building scalable and efficient data warehousing solutions that enable advanced analytics, reporting,...

  • Senior Data Analyst

    1 month ago

    San Jose, United States GSSR Inc Full time

    Job DescriptionJob DescriptionObjective:This Resource will support data engineer and dataanalysis work for the Integrated Justice System and BI Platform Modernizationprojects.Required Skills Abilities:• 3­ + years’ experience relational Database Modeling(conceptual, logical, and physical).• Tools: Microsoft Visual StudioMicrosoft SQL ServerAzure SQL...

  • Senior Data Scientist

    2 days ago

    San Jose, California, United States PayPal, Inc. Full time

    About UsPayPal, Inc. is a leading global digital payments company that enables individuals and businesses to make and receive payments online and in-person. We are committed to building an equitable and inclusive global economy, and we believe that our employees are central to advancing our mission.Job SummaryWe are seeking a highly skilled Senior Data...

  • Senior Data Integration Specialist

    6 hours ago

    San Jose, California, United States HCLTech Full time

    Job SummaryHCLTech is seeking a highly skilled Senior ETL Developer to join our team. As a key member of our data warehousing team, you will be responsible for designing, developing, and implementing ETL processes to extract, transform, and load data into our enterprise data warehouse.Key ResponsibilitiesTroubleshoot and resolve complex ETL and data...

  • Senior Data Engineer

    1 month ago

    San Jose, United States ByteDance Full time

    Team IntroThe Global Payments team provides professional payment solutions with the smooth functioning of payment channels to all global businesses of ByteDance to support the expansion and growth of ByteDance’s global businesses.The Data Intelligence team is responsible for designing & building data intelligence architecture, including data warehouses,...

  • Senior Data Science Consultant

    3 months ago

    San Francisco, United States DesignMind Full time

    Job DescriptionJob DescriptionDesignMind is seeking a Senior Data Science Consultant to join one of the country's top data and analytics consulting teams. Applicants must reside within the United States. DesignMind is a Microsoft Solutions Partner in Data & AI, and has partnerships with Snowflake, Databricks, AWS, Profisee, PowerON, and other leading...

  • Senior Data Analytics Consultant

    4 weeks ago

    San Francisco, United States Unreal Gigs Full time

    Job DescriptionJob DescriptionCompany Overview: Welcome to the forefront of data-driven consulting! Our company is dedicated to providing innovative data analytics solutions to empower organizations and drive strategic decision-making. We specialize in leveraging advanced analytics techniques to unlock the full potential of data and deliver actionable...

  • Senior Data Analytics Consultant

    3 months ago

    San Francisco, United States Unreal Gigs Full time

    Job DescriptionJob DescriptionCompany Overview: Welcome to the forefront of data-driven consulting! Our company is dedicated to providing innovative data analytics solutions to empower organizations and drive strategic decision-making. We specialize in leveraging advanced analytics techniques to unlock the full potential of data and deliver actionable...