Enterprise Data Consultant I

Title: Enterprise Data Consultant I

Job Location: One Seneca Street, Buffalo, NY 14203.

Job Description:

Design, implement and operationalize end-to-end data quality solutions. Collaborate with data owners, data stewards, data analysts, and other database roles to ensure alignment and consistency of data quality policies and processes. Finalize database sources and data quality control points using Microsoft SQL, Oracle DB to query and analyze data. Analyze data models, profile data, and design data rules. Identify data patterns and ensure data quality. Improve data accuracy and compliance by utilizing ETL, Data Warehouse, SQL and BI. Design and implement database quality rules and metrics to measure and monitor the quality of critical data elements (CDEs) that are used for critical business processes. Create data reports and visualizations using Tableau and Power BI. Enhance data quality and provide training and guidance to database users. Automate current processes for effective performance. Capture and understand Data Lineage and trace data flows. Troubleshoot tasks, bugs and data issues using Agile methodologies. 

Minimum requirements: Master's degree, or foreign equivalent, in Computer Science, Engineering, or related technical field, and two (2) years of experience (or Bachelor's degree, or foreign equivalent, in Computer Science, Engineering, or related technical field and four (4) years of experience) in analyzing data models and profiling data using database technologies, including Oracle or Microsoft SQL; troubleshooting tasks, bugs and data issues using Agile methodologies; of which one (1) year of experience includes utilizing ETL, Data Warehouse, SQL and BI to improve data accuracy, quality, and compliance; and using Tableau or Power BI to create data reports and visualizations.

Salary: $136,400.00 - $146,400.00 per year.

LocationBuffalo, New York, United States of America