KEY ACCOUNTABILITIES
-Participate in connects with stakeholders during project requirements gathering, updates, feedback gathering, stand-ups etc.
-Data and data sources exploration across multiple data sources – Data Lake, Oracle, SQL, AFO, SAP etc.
- Perform complex ETL (Extract-Transform-Load) operation on large data sets, Execute efficient data transformation techniques depending on the tools.
-Create new reports / Tools / Automations /dashboards for business stakeholders, that drive insights and enable better decision making
-Deliver time savings through internal process automations
- Should possess strong knowledge of Tableau architecture (design, development), SQL, query optimization, and end user experience
-Should be able to understand and navigate through the back-end data architecture and troubleshoot data issues if any
-Ensure project related documentation is updated
-Ensure data accuracy and quality
-Support short term capabilities sustainance.
-Keep project notes and projects document updated and verified
-Support On-boarding of new team members
-Conduct basic on boarding trainings
-Proactive Participation in Technical, Soft Skill Training
-Participate/Lead other engagement activities across SC Analytics team.
-Demonstrate Effective written and verbal Communication
MINIMUM QUALIFICATIONS
-Education – Full time graduation from an accredited university (Mandatory- Note: This is the minimum education criteria which cannot be altered)
-Graduation in - BSc./MSc., B.E., B.Tech. , Engineering, MBA Operations/SC, BCA/MCA
-Specific Job Experience or Skills Needed:
-SQL – Intermediate Queries, Procedures
-Advanced MS Excel – Pivots, Array Formulas, Formulas (E.g.: SUMIFS; VLOOKUP; HLOOKUP; MAXIF etc), Conditional Formatting and other concepts.
-VBA – Functions, Procedures, Macro Development, Error Handling
-Visualization –Tableau Dashboard Development
-Project Management – Basic at execution level. Analytical and prioritization skills
-Problem solving skill
Competencies/Behaviors required for job:
-Agility
-Understands quality and strives to deliver on time.
-Thrives in working on couple of projects at one time.
-Has curiosity to learn
-Works with less / minimum supervision
-Executes one key expertise independently
-Deliver Results:
-Assume personal initiative and accountability for results, performance and behaviors.
-Be comfortable with ambiguity.
PREFERRED QUALIFICATIONS
-Masters
-SQL Certification
-Advanced Excel & VBA Certification
-MIS Reporting Certification