BI Developer

Designs, develops, and maintains Enterprise Business Intelligence (EBI) solutions. Ensures data accuracy and integrity while collaborating with end users, providing reports and predictive analytics, and managing the ongoing operation of data warehouses.

The list of essential functions, as outlined herein, is intended to be representative of the duties and responsibilities performed within this classification. It is not necessarily descriptive of any one position in the class. The omission of an essential function does not preclude management from assigning duties not listed herein if such functions are a logical assignment to the position.

Designs, develops, tests, and maintains the EBI database, application and reporting, while identifying and resolving technical and data-related issues
• Designs and monitors end-user reporting tools and systems to ensure timely, accurate, and reliable reporting
• Creates BusinessObjects (BO) Universes, reports, report templates, and analytic environments to meet business and technical requirements
• Collaborates with end users to gather, define and document data requirements that drive database design, data extraction, analysis and cleansing efforts
• Ensures accuracy and reliability of reports and their underlying data sources
• Maintains, supports, and enhances the business intelligence data backend, including data warehouses
• Contributes to the design of data models including robust data definitions, entity-relationship-attribute models, and relational or dimensional models, while providing guidance on their application
• Implements strategies for data acquisition, archive recovery, and enterprise-level database implementation
• Sustains the Predictive Analytical initiative, maintaining day to day Predictive analytical activities within a team environment
• Provides production support for data warehousing.

To perform this job successfully, an individual must be able to perform each essential duty and responsibility satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.

EDUCATION AND/OR EXPERIENCE:

Bachelor's degree in Computer Science (Master's preferred), MIS or related field from an accredited college or university; seven (7) or more years of related technical experience; or an equivalent combination of education, certification, training, and/or experience.

CERTIFICATES, LICENSES, REGISTRATIONS AND DESIGNATIONS:

None

KNOWLEDGE, SKILLS AND ABILITIES:

• Knowledge of design, development, and maintenance of enterprise-level data systems, such as cloud-based Native HANA, SQL Server 12, or Oracle 11g
• Skilled in SQL Server and SAP Native HANA Modeling, data provisioning and reporting
• Knowledge of advanced SQL techniques, including complex stored procedures, triggers, indexes
• Ability to utilize reporting tools such as SAB BusinessObjects suite and Tableau, including full SDLC Reporting in SAP Business Object and SAP Analytical Cloud
• Ability to build BO Universes, dashboards and scorecards
• Knowledge of relational database design, logical data modeling, data warehousing, and relational database management systems
• Knowledge of business intelligence and data warehousingconcepts
• Knowledge of ETL concepts and development, including OLTP, OLAP, Star Schema, KPIs, Fact and Dimensions tables, as well as conceptual, physical and logical data modeling
• Skilled in ETL development using SAP Data Services and SQL Server Integration Services (SSIS)
• Strong analytical skills with consultative approach in resolving complex issues
• Knowledge of Predictive Analytics with Python or other related tools
• Ability to communicate effectively both orally and in writing
• Ability to work with minimal supervision
• Ability to establish and maintain effective and cooperative working relationships with those contacted in the course of work
• Ability to support ad hoc requests and provide off-hours support as needed.

PHYSICAL REQUIREMENTS:

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Ability to exert light physical effort in sedentary to light work, which may involve some lifting, carrying, pushing and/or pulling of objects and materials of light weight (up to 20 pounds).

ENVIRONMENTAL REQUIREMENTS:

The work environment characteristics described here are representative of those an employee may encounter while performing the essential functions of this job.

Functions are regularly performed inside without potential for exposure to adverse conditions, such as inclement weather, atmospheric elements and pathogenic substances.