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.

Key Skills:

• HTML.
• ‌Microsoft Excel.
• ‌Javascript.
• ‌Python.
• ‌Statistical programming languages.
• ‌A/B testing.
• ‌Data visualization.
• ‌Omniture.