Loading...

IT Data Analyst

Location: 

Bangalore, KA, IN

Company:  ExxonMobil

Job Role Responsibilities

Customer  Management
  • Provide consulting and troubleshooting for Analytic tools and capabilities (reporting and dashboards)
  • Requirements gathering, leading discussions, validation, and testing
  • Create data marts to address customer requirements
Team collaboration
  • Participate actively in AGILE meetings (refinement, planning, retrospectives, and daily standup meetings)
  • Knowledge transfer, work shadowing, and work validation
  •  AGILE - Able to complete tasks via Agile work methodologies (Scrum board on TFS) in dedicated work Sprints
Reports / Dashboards
  • Create and update reports and dashboards (multiple platforms)
Data Sources
  • Expertise in ticketing solution backend data model and processes (Service Now)
  • Expertise in IT data sources to be able to leverage data and correlate datasets 
Data Management
  • Analyze database usage, cleanup, TFS source control
  • Metadata monitoring, maintenance, and cleanup
Data Modeling
  • Ability to create simple to intermediate relational data models to address specific requirements
SQL
  • Ability to create, analyze, debug, and optimize SQL queries
SQL SSIS
  •  Create, update, optimize, and troubleshoot SSIS packages
Platform infrastructure
  • Platform maintenance, optimizations, and migrations (On premises or Cloud)
  • Troubleshoot platform performance issues (SQL server, Network, Windows Server)
  • Monitoring and troubleshooting of platform health 
Constant learning
  • Adapt continuously to new technologies to respond to constantly-changing customer needs
Problem Solving
  • Analyze requirements, come up with options, and make suggestions
  • Thorough analysis of problems, show initiative, and end-to-end ownership of work items 
  • High quality work delivery through solid organization skills and attention to detail

 

Job Requirements

  • Bachelor’s degree from an accredited university in Technology, Computer Science, or related field with minimum GPA 6.5 (out of 10) or equivalent. 
  • Required technical skills (At least 6 years of experience in following):
    • Data Visualization and Reporting - Advanced development of visualization and reporting solutions, ability to create enterprise level Analytics solutions from various data sources.
    • Microsoft SQL - Strong level of relational database concepts, ability to write/read complex SQL queries and scripts
    • SSIS - Advanced experience with development, testing/QA/troubleshooting and deploying SSIS packages to a Production enterprise environment
    • Ability to understand and implement documented processes and procedures 
  • Required problem solving skills:
    • Analyze requirements, come up with options, and make suggestions
    • Thorough analysis of problems, show initiative, and end-to-end ownership of work items 
  • Required behavioral skills:
    • Strong verbal and written communication skills in English
    • Take initiative and can work with little supervision and validation
    • Able to articulate technical issues to a non-technical audience
    • Effectively and efficiently communicate with team and business end users
    • Good decision making skills and able to make sound business decisions with little to no guidance from team 
  • Required knowledge of the below technologies:
    • Microsoft SQL, T-SQL, SSMS, SSIS, SSRS, Tableau
    • Microsoft Office Suite 
  • Good to technical skills or tool experience:
    • Service Now
    • Azure Cloud
    • Microsoft Power BI
    • Snowflake
    • Microsoft SQL spotlight
    • Microsoft SSAS
    • Qlik Replicate

 

ExxonMobil does not use recruiting or placement agencies that charge candidates an advance fee of any kind (e.g., placement fees, immigration processing fees, etc.). Follow the LINK to understand more about recruitment scams in the name of ExxonMobil.


Job Segment: Database, Consulting, Computer Science, SQL, System Administrator, Technology