Exide Technologies

Senior BI Analyst/Developer

US-GA-Milton
Requisition ID
2017-1370
Category
Information Technology
Position Type
Regular Full-Time

Overview

Under the direction of the Director of Web Applications BI, and Reporting Systems, The Business Intelligence Developer will be responsible for defining and implementing business intelligence (BI) technologies and services to enable the analysis of data to support strategic initiatives and ongoing business requirements. The person in this position should be able to perform needs analysis – envisioning solutions end-to-end, design, configuration and implementation of data warehouses, business intelligence applications, and underlying relational databases. This role will develop data warehouse and business intelligence solutions using Microsoft Business Intelligence tools and underlying technologies.

Responsibilities

To perform this job successfully an individual must be able to perform each duty satisfactorily.  Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

  • Knowledge Areas:
    • Experience using Microsoft BI and SharePoint development tools to design and develop BI solutions.
  • Solid working knowledge of Finance, Accounting, Manufacturing, and Distribution principles.

 

Functional Requirements:

  • Design and implement multi-dimensional models, including the construction of data views, dimensions, and cubes.
  • Design and implement required ETL interfaces for the data warehouse via SSIS.
  • Translate functional and non-functional specifications into MS DW cubes.
  • Understanding of MS-BI architecture features with Tabular model and SharePoint interfaces.
  • Contribute to and support the organization’s business intelligence strategy and architecture.
  • Develop, implement and maintain test strategies and plans.
  • Design and implement reporting applications including Performance Point dashboards.
  • Convert existing reporting tools to a standardized reporting infrastructure using SQL and Microsoft products.
  • Works to turn down legacy reporting tools including MS Access.

 

  • Technical Analysis:
    • Ability to utilize the MS-BI tools for development (SSAS, SSIS, SSRS)
    • Provide technical leadership and guidance in future migration to tabular cube environment.
    • Participate in prototyping new tools for the purpose of enhancing business processes and operations.
    • Lead in the collection and maintenance of table and field level documentation.
    • Develop and maintain documentation for ETL processes, source to target data mapping.
    • Troubleshoot data warehouse problems, along with solutions requirements.
    • Adheres to best practices and standard development methodologies.
    • Make enhancements to the existing data bases as assigned and specified.
    • Develop and deploy various reports based on user requirements.

 

  • Installation Assistance.   Works with development, staging and production technicians to install applications.
  • Configuration.    Works with the appropriate IT Staff to identify and execute the proper configuration options for BI applications.

 

  • QA Testing.   Coordinate and perform in-depth tests, including end-user reviews, for modified and new systems.
  • Documentation.  Writes and maintain documentation for the installation and technical configuration.
  • Standard Reports.   Produces reports, timelines and graphics using advanced functions of a personal computer.  Creates reports from existing databases to satisfy user requests, data sampling, project analysis or testing verification.
  • Application Reviews.  Reviews upgrades, new releases and new solutions.  Maintains application up-to-date with vendor technical fixes, patches, etc.
  • Level 2 / 3 Support.   Application specific.
  • Performance.
  • Monitors and audits the use and performance of the supported applications; executes system quality control practices and procedures.
    • Develop strategies for improving the effectiveness and efficiency of existing systems or for further leveraging these systems.
  • Data Backup & Integrity.  Responsible for developing [along with the Technical Services team] the proper backup procedures for the application.  Test and audit the backup procedures.
  • Change Control.  Initiates and manages the flow and execution of changes / modifications; including source control.

Internal Controls   Assures system conformance to all Internal Controls and Audit requirements.

Qualifications

The requirements listed below are representative of the knowledge, skill, and/or ability required.

EDUCATION / SKILL REQUIREMENTS

  • Bachelor’s degree from four-year college, preferably in Information Systems or related business field.
  • Must have extensive skills in Microsoft SQL Server 2008/2012 specifically including:
    • 5 yrs. + SQL Server Analysis Services (SSAS)
    • 5 yrs. + SQL Server Integrated Services (SSIS)
    • 3 yrs. + SQL Server Reporting Services
  • 5 yrs + experience with MDX query language in a data-warehousing environment.
  • 5 yrs. + experience in gathering technical requirements and preparing specifications.
  • Experience working on team centric data-warehousing environment.
  • Strong experience building ETL processes to convert operational transactional data into dimensions and fact tables.
  • Proven experience in developing Business Intelligence solutions (reports, dashboards, scorecards) using SSAS.
  • High level of computer literacy with spreadsheets, word-processing and database software and business systems (Word, Access, Excel, PowerPoint, MS Project, VISIO and other graphic software).

 

 

PREFERRED CANDIDATES WOULD ALSO MEET THE FOLLOWING CRITERIA:

  • Programming with SQL queries and stored procedures
  • Provides examples of previous tabular cube creation.

 

ORGANIZATION RELATIONSHIPS:

 

  • Has the ability to work with project leads to identify and resolve application issues.
  • Has the proven ability to work well with others in a matrix project environment.

 

SUPERVISORY RESPONSIBILITIES

 

No direct supervisory responsibilities, but may supervise external contractors engaged in projects they lead.

LANGUAGE SKILLS:

 

Required:  English.  Ability to read, analyze and interpret industry periodicals, professional journals, technical procedures or government regulations.  Ability to write reports, business correspondence and procedure manuals.  Ability to effectively present information and respond to questions from groups of managers, clients and customers.

Preferred:  Working knowledge of a second language (e.g. Spanish, French, Italian, or German) would be considered a plus.

 

MATHEMATICAL SKILLS:

 

Ability to calculate figures and amounts such as discounts, interest, commissions, proportions, percentages, area, circumference and volume.  Ability to apply concepts of basic algebra and geometry.

 

REASONING ABILITY:

 

Solves difficult problems with effective solutions; asks good questions and probes all fruitful sources for answers; can see underlying or hidden problems and patterns; is excellent at honest analysis’ looks beyond the obvious and does not stop at the first answers.  Ability to define problems, collects data, establish facts, and draw valid conclusions.  Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables.

 

PHYSICAL DEMANDS:

 

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

 

While performing the duties of this job, the employee is regularly required to sit and talk or hear.  The employee frequently is required to stand; walk; use hands to finger, handle, or feel; and reach with hands and arms.  The employee is occasionally required to climb or balance and stoop, kneel, crouch, or crawl.  The employee must occasionally lift and/or move up to 10 pounds.  Specific vision abilities required by this job include close vision and ability to adjust focus.

 

TRAVEL REQUIREMENTS:

 

Some travel is expected (no more than 5-10%).  The position may require international travel for conferences and/or implementation support.

EEO Statement

Exide Technologies is an equal opportunity employer where an applicant's qualifications are considered without regard to race, color, religion, sex, national origin, age, disability, veteran status, genetic information, sexual orientation, gender identity or expression, or any other basis prohibited by law.

About Exide

Exide Technologies (www.exide.com) is a global provider of stored electrical energy solutions—batteries and associated equipment and services for transportation and industrial markets. With 128 years of industry experience and operating in more than 80 countries, Exide produces and recycles a broad range of products that keep customers and their businesses powering forward. Leading car, truck and lift truck manufacturers trust Exide as an original equipment supplier, and Exide serves the transportation and industrial aftermarket through a comprehensive portfolio of products and services. The Company’s extensive sales, distribution and service network provides flexibility and quality for an exceptional customer experience.

At Exide Technologies, It All Starts Now. History and scale, combined with a start-up mentality, make Exide the faster, more nimble, more innovative, more digital, and more responsive alternative for customers who want more than simply a battery supplier. Exide is "the 128 Year Old Start-Up," and the Company is moving forward—bringing the energy of the “new Exide” to customers around the world.

Options

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