Data steward will be responsible for data quality / cleansing, de-duplication and harmonization of data across the various source systems.
Automate end to end data validation and data loading solutions using SSIS ETL packages.
Develop & Implement and manage data strategies that optimize the data quality to improve standardization.
Maintain and create the data governance standards, rule books and metadata to support current master and transactional data.
Manage process activities to support conversion of data from multiple source system to consolidated system.
Identify the patterns and frequency of the data in the dataset and prepare the reports.
Manage the data quality audits/rules and generate the reports.
Convert business rules into technical rules for data quality analysis.
Report data quality/integrity issues to the business users , identify root causes and provide solutions
Create, define and maintain the documentation representing data validation processes and data elements across multiple systems.
Writing SQL code (stored procedures, triggers, database scripts) to implement business logic and database maintenance.
Develop queries and stored procedures for data extraction, using SQL queries and one or more relational databases such as SQL Server/Oracle/MS Access.
Work Experience (Years, setting, etc.)
Experience with SQL Server 2005/2008, Oracle 10g/11g, MS Access 2010
At least 4+ to 8 years of Experience in writing complex SQL queries, designing, developing, debugging and deploying SQL Server stored procedures.
At least 4+ years of solid experience on MSBI tools.
At least 3+ years of demonstrated experience in working with data quality, data validation and data governance initiatives.
At least 3+ years of experience in providing data analysis, identifying data related issues and business needs and providing practical and workable solutions.
Understanding of how data is used within business processes and its impact on desired business process outcomes.
Bachelors degree in Computer Science, MIS, Mathematics or other related degree
Fluent in English both spoken and written
Major Skills (Technical & soft skills)
Ability to design complex SQL Queries
Strong understanding of data flow and governance
Strong Analytical skills
Superior interpersonal skills. Ability to talk with individuals and groups about their needs and ask the right questions to surface essential information
Ability to communicate effectively in a multicultural, multinational environment
Demonstrates a strong customer orientation
Demonstrates cross-functional expertise and the ability to thrive in a highly complex environment
Superior problem solving ability
Ability to work independently and with a team
Proficiency in Excel