Jr. Data Analyst

QUALIFICATIONS (Minimum requirements in terms of experience and background, skills and competencies for sourcing purposes)

• Experience working with SQL required
• Experience in Google Data Studio, Google Sheets, Excel required
• Experience in Google BigQuery, Tableau, Power BI, Metabase, DaaS preferred
• Experience in Hadoop or Big Data technologies preferred
• Experience working with MySQL preferred
• Experience working with Python/Scala preferred
• Experience in JIRA and Confluence preferred

ROLES AND RESPONSIBILITIES

A. Does (The tasks / responsibilities that the role performs to address requirements in Key Result Areas)

• Ability to gather business requirements and translate the requirements to reports and dashboards
• Create simple yet effective dashboards, reports, etc. as needed by the business in support of projects and operational requirements
• Provide actionable insights by performing data analysis and data mining
• Perform complex ad hoc data queries and provide data extracts as needed by the business
• Create and update documentation and help maintain the team document portal
• Build complex queries on large volumes of data using SQL
• Act as primary Analyst for urgent data and reporting requirements as required by the Leadership team
• Act as L1/L2 Analyst for urgent operational data requirements
• Ability to provide requirements, updates, and resolve known issues in timely manner
• Support Delivery team in the distribution of reports, data files, etc. via email and sftp, and maintenance of distribution list
• Create and update operations support documentation, and maintain tech and operations support document portalEnsure data security practices in the deployed pipelines
• Standardize different queries and optimize them to speed up query times
• Build automation workflows and ensures job uptime and performance
• Attend escalated support calls during business hours and outside business hours (e.g. weekdays after 6 PM, during weekends and holidays, etc.)
• Identify automation opportunities and implement workflows
• Maintain uptime for different automation tasks

B. Displays (The Knowledge, Skills, and Behaviors indicating how tasks / responsibilities will be performed)

● Ability to handle urgent data and reporting requirements from the business

● Willingness to work with different stakeholders across the organization

● Leadership skills to help establish the team’s ways-of-working, processes,   deliverables, and documentation

● Strong collaboration skills

● Agile mindset with ‘fail fast, learn fast’ attitude

● Detail-oriented to verify the integrity of gathered data and reports

● Experience in analytics and data warehousing concepts, terminologies, and architecture

● Good oral and presentation skills are a must

● Excellent team player with good analytical skills in providing insights to numbers

● Ability to work closely with colleagues to try and identify data related problems and solve them

● Capability to adapt, develop or introduce projects that can be used for data analysis

● Coordinates and supports the Technical Team on the updates of the Data Sources System

B. Delivers (The specific outputs / tangible results produced by the role; resources responsible for)

● Dashboard, reports, data extracts, and ad hoc requests to the business

● Top-notch analytics support in accordance with agreed SLAs and KPIs

● Comprehensive and up-to-date support documentation

● Improvements in queries and reporting performance

● Processes and workflows in accordance with best practices

● Initial engagement: 6 months subject for performance evaluation for renewal