What are the responsibilities and job description for the eRFO-ISD-FY25-0046 Senior Data Analyst/Data Warehouse Consultant position at Omega Solutions Inc?
Objective :
This Resource will support data engineer and data analysis work for the Integrated Justice
System and BI Platform Modernization projects.
Typical Deliverables :
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
Keep a pulse on the job market with advanced job matching technology.
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution.
Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right.
Surveys & Data Sets
What is the career path for a eRFO-ISD-FY25-0046 Senior Data Analyst/Data Warehouse Consultant?
Sign up to receive alerts about other jobs on the eRFO-ISD-FY25-0046 Senior Data Analyst/Data Warehouse Consultant career path by checking the boxes next to the positions that interest you.
Not the job you're looking for? Here are some other eRFO-ISD-FY25-0046 Senior Data Analyst/Data Warehouse Consultant jobs in the San Jose, CA area that may be a better fit.
We don't have any other eRFO-ISD-FY25-0046 Senior Data Analyst/Data Warehouse Consultant jobs in the San Jose, CA area right now.
