Senior Data Analyst / Data warehouse Consultant Job at GSSR Inc in San Jose

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