Senior Data Analyst / Data warehouse Consultant

Objective:

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 Studio

Microsoft SQL Server

Azure SQL Server

SSIS, SSRS

Power BI Report Server, Power BIService

SSMS: 6-7 years experience

Tools: Quest Erwin or similar data modeling tool 1year experience

Responsibilities:

Creation of IT data models (e.g., conceptual,logical, physical, canonical).

Implementation of data design and transformationprocedures.

Creation of frameworks for representing dataelements.

Resolution of conflicts between data models.

Design, creation, and maintenance of relational anddimensional databases and data systems.

Recommendation and implementation of datareliability, efficiency, and quality improvements.

Enhancements to existing database systems toincrease operating efficiency or adapt newer requirements.

Recommendation and implementation of datareliability, efficiency and quality improvements.

Adherence and contribution to work plan timelines,managing workflows to meet project timeframes.

Design and creation of data processing systems thatcombine core data sources into data repositories.

Map documentation of data elements from UI screensto database, mapping between 2 databases.

Data conversions, imports, and exports of datawithin 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 processessupporting 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 databasemanagement systems.

Develop and maintain a query library to supportrecurring data requests.

Maintain data dictionaries and other related dataprocessing 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.;