Technical Data Analyst

Responsiblties:

Profile new data sources, primarily through SQL and open-source tools; Derive insights and share with the team.
Identify edge use cases, data anomalies, and outliers as an outcome of Data Profiling activity.
Capture definitions for all data elements being sourced and document them; Capture the grain of the data and work with Data Modelers to pass on the information.
Create Source to Target Mapping across multiple layers of data propagation: source to canonical layer to semantic layer.
Suggest DQ rules for implementation based on data analysis/data profiling performed.
Liaise with Product Owner for deployment co-ordination, business signoffs, and release notifications.
Create and maintain business lineage maps in the Enterprise Data Catalog tool by working with the Data Catalog specialist.
Co-ordinate with multiple cross-functional teams and have good inter-personnel skills.

Qualification:

Minimum 4-year degree in computer science, data science, information science or related field, or equivalent work.
2-3 years of experience in working in a data warehouse environment would be required. The candidate must have technical skills as contrasted from a Business Analyst with only requirement gathering experience.
Experience working in a data warehouse environment along with experience in creating data mapping specification documents is needed
Understanding of Data Quality concepts- data profiling, data cleansing.
Ability to propose DQ rules based on Data Profiling results.
Ability to identify edge use cases, data anomalies, outliers.
Should understand relational concepts in slowly changing dimensions in the context of Data Modelling.
Good SQL skills required- the ability to articulate how real-time data scenarios can be analyzed with SQL.
Skills in handling data from various sources in Excel, Access, and Word editors.
Knowledge of working with and analyzing CRM data, Customer Data, Loyalty Programs, and 3rd party data enrichment processes is a big plus.
Good communication and collaboration skills; Ability to work with multiple stakeholders in a dynamic large program.