Senior Data Analyst/Data Warehouse Consultant

vTech Solution
California, United States
Full-time

Submission Deadline : Aug 19, 2024 5 : 00 : 00 PM EDT Contract Term : 12-months Max Allowed Submission : 2 Requesting Department : TSS - PSJ On-Site Requirements : Hybrid 3 Days onsite Objective : This Resource will support data engineer and data analysis work for the Integrated Justice System and BI Platform Modernization projects.

Education : Bachelor’s degree higher in a quantitative field (. Computer Science, Statistics, Engineering) or equivalent work experience Required Skills & Abilities :

  • Creation of IT data models (., 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
  • 30+ days ago
Related jobs
Promoted
VirtualVocations
Fremont, California

Data Architect for a 100% remote position. ...

Promoted
Apple
Cupertino, California

As a Senior BI Engineer on the Services Data Science & Analytics team, you will work with massive internet-scale data across numerous product and customer touch-points, undertaking in-depth quantitative analysis, and distilling data into actionable and intuitive visualizations to drive informed deci...

Promoted
VirtualVocations
Huntington Beach, California

A company is looking for a Senior Data Scientist, Energy Intelligence. Key Responsibilities:Apply statistical and machine learning techniques to enhance building energy modeling algorithmsConduct data analyses to guide the Energy Intelligence roadmapCollaborate with software engineers to integrate m...

Cardless
San Francisco, California

We are looking for a senior data analyst to join the data team at Cardless. Monitor and ensure data quality within the data warehouse, troubleshooting and resolving issues as needed. Experience with data warehouse and visualization tools, such as Redshift, Snowflake, Looker, Tableau, Micro-strategy ...

Unreal Gigs
San Francisco, California
Remote

As a Senior Data Analytics Consultant, you'll play a pivotal role in delivering data-driven solutions and driving business value for our clients. Competitive salary: The industry standard salary for Senior Data Analytics Consultants typically ranges from $150,000 to $200,000 per year, depending on e...

eStaffLLC
Sacramento, California

Minimum of ten (10) years demonstrable experience in the data management space with at least 5 years specializing in database design-Minimum of five (5) years of experience as a data analyst or in other quantitative analysis or related disciplines, such as researcher or data engineer supportive of k...

Blue Shield Of Ca
Long Beach, California

The Data Analyst team is responsible for performing detailed data analysis, source to target designs, data profiling, and metadata management in support of new development, implementation or enhancement of existing data assets. Strong experience in data management, data integration, data warehouse, ...

Udemy
San Francisco, California

Udemy is looking for a data scientist to join a team largely focused on exploring and building novel applications of generative AI to improve the teaching and learning experience. You will work as part of a cross-functional agile team that includes data scientists, machine learning engineers, softwa...

Voltron Data
Mountain View, California

Senior Query Optimizer Software Engineer. On the team, you’ll have the opportunity to help support and grow the Voltron Data and Apache Arrow ecosystems. You will work closely with Voltron Data development teams to build and maintain a SQL parser and query optimizer for large scale single node and d...

Aurora
San Francisco, California

Design and develop large scale data and analytics services that transform datasets into consumable tool formats for ML modeling teams (ie. Our team is responsible for building data and analytics services to improve our Motion Planning team’s Machine Learning Platform. The tools we build are mission-...