31 Jan
Data Warehouse Analyst
Missouri, Jeffersoncity , 65109 Jeffersoncity USA

Vacancy expired!

Primary Responsibilities: The Database Analyst would gather and analyze data, helps build a data dictionary, establishes data validation rules, and assists in building data strategies. Maintains data storage and access by evaluating, designing, and implementing database[s]. Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams, and documents the process. Writes codes for database access, modifications, and constructions. This work encompasses several duties and responsibilities, including: Collaborate with team members to collect and analyze data Create data quality metrics and reports for internal teams Define key performance indicators to track operational process performance and apply data mining, analysis, and visualization for KPI reporting Establish KPIs to measure the effectiveness of business metrics and measurements Interpret results using a variety of techniques, ranging from simple data aggregation to more complex statistical analysis Prepare standard and ad hoc reports Identify, analyze, and interpret trends or patterns in complex data sets Use graphs, infographics, and other methods to visualize data Create presentations and reports based on recommendations and findings Present data in a way that is understandable to those with limited data knowledge or experience Build source system data ETL processes, verify data accuracy, design of complex interactions between data fields within the client solution Innovate new ways of validating data Establish and maintain a set of processes and controls aimed at ensuring data quality and integrity issues are surfaced and addressed on an ongoing basis Work closely with members of the business team to surface and address data quality issues Identify, investigate, and manage the resolution and escalation of data quality issues Coordinate and lead regular and ongoing data quality audits Address the root cause of data problems and develop a recommendation on how to resolve them. Partner with data source stakeholders to implement the resolution Analyze and validate data completeness, consistency, accuracy, and compliance with data standards and principles Perform data profiling activities (in conjunction with the business data team) to ensure completeness and accuracy relative to the data's quality specifications. Perform analysis of data sources with an emphasis on identifying critical data elements and developing data metrics and quality checks Investigate, evaluate, and analyze current data requirements and processes' effectiveness and efficiency and develop strategies for improving these processes. Work with business representatives to elicit use of data and business rules Perform data profiling tasks on existing data to prepare for data cleansing and data migration activities Consolidate data analyses in support of data strategy and data governance documentation in association with the DWC Program Data Architect Implement data quality monitoring reports, alerts, and processes Benchmark and improve data quality from all data sources Design-build and maintain ETL feeds for new and existing data sources Ensuring ongoing accuracy of data ETL feeds, monitoring for changes in source systems Per solution requirements, build appropriate linkages and relationships between data fields and the data warehouse Documentation of all metadata including data source, field type, definition, etc. for each field and table created SME for data sources, structure, and definitions Structuring data in a way that is easy to understand, query, and display Skill Set Desired: A Bachelor's degree from an accredited college or university in related field such as in either Data Science, Computer Information Systems, Computer Science, Information Science, Statistics or Business 10+ years of Technical and/or professional experience in statistical analysis and research. Ability to creatively problem-solve, including accessing needed resources from multiple areas and sources and helping management think outside the box in developing solutions Strong analytical skills; ability to collect, organize, analyze and interpret data/information with key attention to detail In-depth technical expertise regarding data models, data analysis and design, master data management, metadata management, and data quality improvement Expert proficiency in SQL building, maintaining, and extracting data from relational databases Proficiency in IBM i SQL preferred Understanding of relational database structure; ability to design and maintain robust database schemas Knowledge of Structured Query Language (SQL) and Transact-SQL (T-SQL) Data analysis skills - ability to understand and conduct advanced data analysis An understanding of and ability to apply process and systems improvement principles Structured, data-driven, and quantitative problem-solving approach Ability to query, analyze, and present data Ability to drive strategic discussions and convert strategy to action Ability to understand data integrity and correctness 9+ years of relevant experience in ETL development required User interface design skills, work ethic, critical thinking, problem-solving ability, effective communication skills, and overall positive attitude Experience with Data Visualization software such as Tableau Ability to create advanced formulas and dynamic dashboards Advanced understanding of relational databases required, with knowledge of IBM DB2 and C2E preferred 9+ years analyzing methods for transforming existing data into a format for a new environment and the loading data into other database structures. 9+ years reviewing existing migration tools and providing recommendations for improving the performance of the migration process. 9+ years providing necessary change and support documentation for data migration efforts 9+ years experience migrating data 9+ years of full-time professional work experience in Information Technology. 9+ years Data Warehousing Management 9+ years Senior Database Analyst 9+ years Data Administrator 9+ years Database/Data Warehouse Analyst 9+ years overseeing Data Migration efforts on large complex projects

Vacancy expired!


Related jobs

Report job