Support Engineer - Data Ops
1-5 years of experience in BI, Reporting & Data Warehousing domain
Experience in production support for Data queries - monitoring, analysis & triage of issues
Expertise in doing RCA (root-cause analysis) and collaborating with development teams for CoE (correction of errors).
Experience in using BI tools like MicroStrategy, Qlik, Power BI, Business Objects
Expertise in data-analysis & writing SQL queries to provide insights into the production data.
Good communication & collaboration skills - liaison with product, operations & business teams to understand the requirements and provide data extracts & reports on need basis.
Experience in working in an enterprise environment, with a good discipline & adherence to the SLA.
Good understanding of the ticketing tools, to track the various requests and manage the lifecycle for multiple requests e.
g. JIRA, Service-Now, Rally, Change-Gear etc.
Orientation towards addressing the root-cause for any issue i.e. collaborate and follow-up with development teams to ensure permanent fix & prevention is given high priority.
Ability to create SOPs (system operating procedures) in Confluence / Wiki to ensure there is a good reference for the support team to utilise.
Experience with relational database (RDBMS) & data-mart technologies like DB2, RedShift, SQL Server, My SQL, Netezza etc.
Ability to monitor ETL jobs in AWS stack with tools like Tidal, Autosys etc.
Self-starter and a collaborator having the ability to independently acquire the knowledge required in succeeding the job.
Experience with Big data platforms like Amazon RedShift
Address queries for existing reports
Ad-hoc data requests for product & business stakeholders :
Transactions per day, per entity (merchant, card-type, card-category)
Job failures resolution - re-runs based on SOPs
Report failures resolution
Resolution of the issue
Root-cause Analysis & handover to Dev team