Job Title: ETL Lead Developer

Department: Technology – Analytics (Enterprise Data Warehouse)

SUMMARY

This position will be responsible for the analysis, design, development and maintenance of the enterprise ETL systems and applications.  The ETL Lead will work closely with diverse operational data systems, external data partners, business intelligence, statistical analysts and report developers.  They will work with the business partners to identify and ensure that all service level agreements are met.  They will perform ongoing monitoring of the environment and applications for capacity planning, performance tuning and improvement opportunities.

ESSENTIAL DUTIES AND RESPONSIBILITIES include the following:

-        Work with application developers, DBAs, external data providers, SAS analysts, and Business Intelligence teams

-        Develop ETL procedures based on business requirements and service level agreements

-        Responsible for delivering quality data integration projects

-        Responsible for reviewing requirements, architecture and design components of ongoing and upcoming projects

-        Responsible for developing and documenting the systems, processes and logic required to expose the existing data sets in the warehouse to end users for reporting and analysis purposes

-        Responsible for hands on development using Sqoop, Pig, Hive, SSIS and MapReduce tools

-        Keep abreast of the tools, techniques and components being used in the industry through research and applies this knowledge to the system(s) being developed

-        Monitor ETL applications for performance and improvement opportunities

-        Ensure the quality, consistency and security of company data and data warehouse systems

JOB SPECIFICATIONS

-        Minimum 6 years overall experience analyzing, designing and developing of ETL systems

-        Hands-on experience with all aspects of architecting, designing, developing, testing and implementing ETL solutions

-        Strong technologist with excellent data analysis and ETL architecture/design/development skills

-        Work comfortably with both business and technologists

-        Experience with designing and implementing data staging, including staging database design and staging logic

-        Excellent knowledge of data modeling and designing databases

-        Good knowledge of metadata, and using/managing metadata

-        Ability to develop and organize high-quality documentation

-        Take responsibility for performance tuning

-        Understanding of building data warehouses for analytical and business intelligence solutions

-        Ability to understand the business solution that the data warehouse serves

-        Experience with E/R Studio a plus

-        Experience with data warehousing and star-schema (dimensional) data models

-        Ability to provide hands-on leadership to other developers

-        Ability to troubleshoot issues in a multi-tier environment

-        Excellent verbal and written communication skills;

EDUCATION and/or EXPERIENCE

BS degree in Computer Science or related field from four-year college or university.

DISCLAIMER

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed above are representative of the knowledge, skill, behavior and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.