Previous Job
Senior Data Warehouse ETL Developer Permanent Position in Cleveland, OH
Ref No.: 18-00890
Location: Cleveland, Ohio
Position Type:Direct Placement
Relocation OK 

The Senior Data Warehouse ETL Developer is responsible to design, develop, implement, and support ETL (Extract, Transform, Load) processes used within custom and packaged applications responsible for loading data into the data warehouse. The developer is also responsible for the timely data availability and system up-time through support functions and in-depth testing. Work with business stakeholders to elicit, analyze, communicate, and validate requirements for changes to business processes, policies and information systems.

Essential Functions
Strategy & Planning
  • Full life cycle experience (requirements gathering through production deployment) in all aspects of BI/DW (ETL, data modeling, analytics and reporting)
  • Seek out and apply new technologies and skills for ETL improvement in daily work through conferences, online training, reading, participation in organizations and user groups, etc.
  • Translate business needs into technical and system design specifications
  • Prepare and maintain system documentation
Execution & Deployment
  • Design and develop or modify ETL processes that load data for the data warehouse using ETL tools (Oracle ODI) and PL/SQL
  • Maintain existing ETL Oracle PL/SQL procedures, packages, and Unix scripts
  • Provide ETL performance tuning
  • Design data warehouse schema and star schema data models using Kimball methodology
  • Design and develop reporting end user semantic layers (Business Objects Universes, Oracle RPD, etc.) and BI reports/dashboards.
  • Troubleshoot and resolve production issues under tight deadlines
  • Provide guidance to the IT community on best practices and internal standards
  • Assist with the creation of reusable components as they relate to the ETL framework
  • Conduct ETL design reviews with the Data Architect and DBAs to ensure that code meets performance requirements.
Operational Management
  • Assist in  DW support activities, issue tracking, escalation and resolution
  • Execute project plans to successfully meet objectives.
Incidental Functions
  • Attend meetings on behalf of the DW team.
  • Make presentations to internal and external clients, and peer groups as requested.
  • Train and share knowledge with DW team.
  • Assist with Lean projects as may be required to contribute to the efficiency and effectiveness of the DW/BI team.
  • Participate in hiring activities and fulfilling affirmative action obligations and ensuring compliance with the equal employment opportunity policy. 
  • Minor travel may be required (domestic and international).
  • Work hours outside the standard office 7.5 hour work day as required. 
Position Requirements
Formal Education & Certification
  •  Bachelor degree or foreign equivalent in a related field or equivalent experience. 
Knowledge & Experience
  • 5+ yrs IT experience.
  • 5+ years of experience in advanced Oracle PL/SQL scripting.
  • 2+ years of experience with ETL tools/PLSQL in a Data Warehouse environment.
  • 1+ years of hands-on BI experience (SAP Business Objects, Microstrategy, OBIEE, Tableau or Power BI preferred).
  • Proficiency with ETL tools such as Oracle ODI,Talend, Informatica Power Center (ODI preferred).
  • Strong experience with UNIX/Linux scripts.
  • Understanding of Star schema database modeling using the Kimball Methodology.
  • Experience developing Oracle Application Express (APEX) applications.
  • Experience evaluating existing data warehouse implementation, architectures and processes
  • Experience in Data Warehouse integration methodology; In-depth knowledge of developing and supporting data warehouses.
  • Experience working directly with business analysts or business sponsors clarifying business details.
Personal Attributes
  • Excellent written and oral communications skills.
  • Exceptional ability and initiative to learn and research new concepts, ideas, and technologies quickly.
  • Excellent systems/process orientation with demonstrated analytical thinking, organization skills and problem solving skills.
  • Ability to work in a team-oriented, collaborative environment.
  • Ability to quickly pick up new tools and technologies.
  • Strong ability to train and teach others.
  • Ability to facilitate meetings and follow up with resulting action items.
  • Ability to prioritize and execute tasks in a high-pressure environment.
  • Excellent presentation and interpersonal skills.
  • Ability to work effectively in a multi-cultural environment, and to lead and influence cross-organizationally with and without direct authority.
  • Exceptional ability to effectively move forward on tasks even with ambiguous or changing requirements.