Sr. ETL / Business Intelligence Developer

Industry: Energy / Utilities


5 - 7 years

Posted 344 days ago

Position Summary Information

General Summary

This is a non-merit system, employment-at-will, long-term contract position.

The Sr. ETL/BI Developer is responsible for planning, designing, configuring, developing, testing, deploying and supporting ETL/BI solutions. Develops and uses ETL applications to perform data analysis, create technical designs and provide applications support.

Essential Functions

• Participates in requirements definition, solution development and the implementation phases of data warehouse and reporting projects

• Creates and maintains ETL specifications and process documentation to produce the required data deliverables (data profiling, source to target maps, ETL flows)

• Assists in definition of logical and physical data models for B2C e-commerce business

• Configures and tunes ETL infrastructure to optimize the data warehousing architecture

• Designs, implements and maintains a reporting, monitoring and dashboard framework

• Develops aggregation, monitoring and alerting tools/modules

• Investigates new technologies and advances, especially in the areas of business intelligence

• Troubleshoots and resolves data, system and performance issues

Other Functions

● Participates in the overall development process via architecture guidance, design and code reviews, and estimation and planning assistance

● Performs other related duties as required

Work Environment And Physical Demands

Business casual office environment.

Required Knowledge, Skills, And Abilities

● Strong analytical and organizational skills

● Ability to work with Oracle, SQL Server, and IDMS mainframe databases

● Ability to work with Business Objects, OBIEE, and other BI development and presentation tools

● Ability to work with Informatica PowerCenter, Oracle ODI and other ETL data warehousing tools and concepts

● Ability to document and troubleshoot problems and effectively communicate with business and technical team members at all levels

● Ability to manage multiple tasks simultaneously

Minimum Education, Experience Requirements

● BS degree

● 5+ years software development experience in one or more of the following areas: ETL, BI and DW

● 2+ years experience in DW multi-dimensional modeling


● High School diploma or equivalent

● 11+ years software development experience in one or more of the following areas: ETL, BI and DW

● 2+ years experience in DW multi-dimensional modeling

Additional Requirements

Must be available, if required, on a 24-hour on-call basis and work at odd and irregular hours.


• Experience implementing and supporting Oracle Exalytics system

• Experience in big data technologies like Hadoop and Spark

• Experience working with water/wastewater utility operational systems

Salary$91,800 - $137,700

Posting Detail Information

EEO Statement

It is the policy of the Commission to select new employees and to promote current employees without regard to race, sexual orientation, sex, religion, national origin, marital status, or handicap. The Commission does not discriminate against qualified individuals with a disability and will make reasonable accommodation for any disability that does not result in undue hardship for the Commission.

Close Date
Open Until Filled Yes

Requisition Number 18-0069

$91K - $137K