Senior Business Information Analyst

MY-Penang
Job ID
44491
Function
IT

Overview

As part of Service Delivery Operations team, ETL SQL Developer analyzes, creates, maintains and executes reporting requirements for external \ internal customers. The individual is able to consistently demonstrate the ability to deliver at a high level of competency in report development, data analysis and software performance improvements making the solution robust. 

Responsibilities

  • Develops and produces analytical and operational ad hoc and ongoing reports, datasets or report information for end-users using system tools, databases and/or data warehouse queries and scripts.
  • Reviews data from multiple sources to produce requested or required data elements.
  • Operate, build and maintain systems to transfer data from various data sources, such as Oracle,  Flat Files, CSV files into SQL Server.
  • Extract Transform Load (ETL) development using SQL server scripting, tools and SQL Integration Services (SSIS).
  • Utilize SSIS to develop jobs for extracting, cleaning, transforming and loading data.
  • Design, code and maintain moderately complex data extraction, transformation and loading (ETL) processes using SSIS.
  • Develop new and maintains existing SSIS packages.
  • Proactively seek out data update process improvements and documentation
  • Responsible for editing existing and creating new and more efficient ways of updating database tables
  • Operate and enhance internal utilities used for loading and processing data files
  • Actively cultivate and maintain collaborative relationships with key technical and business stakeholders to collect and disseminate knowledge.
  • Assist with gathering user requirements, analyzing business process flow, and collaborating with the team.
  • Recognize, investigate, and resolve data discrepancies and anomalies.
  • Participate in software database quality assurance and testing
  • Provide data support – serve as a technical resource in resolving client issues related to database or other data issues.
  • Work directly with business stakeholders, designs complex reports\dashboards using data from one or multiple systems to specifications. Delivers report in format to aid stakeholders, including executive staff, outside the functional area (PowerPoint, PDF, etc.).

Qualifications

Preferred Education:

  • Bachelor's degree required or equivalent experience.
  • Advanced Degree preferred in Computer Science, IT, Engineering, Math and Science

Preferred Work Experience (years):

  • Minimum of 3+ overall years of experience
  • 3+ years of experience with hands on SQL query writing and software development environment 

Key Skills and Competencies:

  • Proficient at data analysis and quality checking
  • Strong problem solving and analytical skills 
  • Advanced Presentation skills required
  • Experience presenting to Director and above audiences
  • Excellent communication skills 
  • Experience with end user issues
  • Demonstrated technical experience
  • Demonstrated experience working independently and collaboratively on projects
  • Demonstrated experience trouble shooting
  • Broad knowledge of applicable IT systems/applications
  • Experience developing new systems and tools
  • Experience in documenting and maintaining up to date systems procedures
  • Advanced analytical skills
  • Demonstrated Project Management skills
  • Proven ability to perform effectively in a fast-paced, high growth, rapidly changing environment
  • Experience identifying and implement process improvements
  • Strong attention to detail
  • Extremely organized, ability to prioritize work and manage multiple projects at one time
  • Note**Wiling to hire within different regions

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share with your network