Title: Junior Data Analyst

Responsibilities:

• Preparing data for creating, running, and modifying sample jobs.
• Developing complex SQL queries using join operators, subqueries and correlated queries, functions, set operators, virtual tables and procedures for large datasets.
• Performing data conversion, data cleansing, data masking, de-identification and encryption techniques.
• Extracting data for feasibility studies, raw data pulls, sample pulls and data appends.
• Liaising with Sales, Project Managers, and Programmers on ad hoc data requests.
• Own end-to-end process of developing and maintaining multiple reports, while ensuring timely and accurate delivery.
• Support business areas by delivering ad hoc data requests.
• Liaise with other departments to enhance knowledge of business products, system functionality and data quality.
• Data Analysis and Reporting.
• Create and execute queries to retrieve data in order to generate reports for internal and external stakeholders.
• Own end-to-end process of developing and maintaining data cycles, including data cleaning, preparation, exploration, analysis and reporting.
• Create (and automate - when necessary) operational dashboards including for example corporate KPI’s and client usage metrics.
• Maintain and update query library to aid in standardizing reporting.
• Support business areas by delivering ad hoc data requests.
• Data Documentation
  Create and maintain data documentation including artefacts such as data requests, data dictionaries, business glossaries, and data models.
• Maintain and document data processes.
• Data Governance
  Provide governance and support in maintaining quality data in root systems/ applications.
• Support consistency in reports and data through the data lineage activities and documentation.