ETL Data Warehouse SQL Developer / Script Writer

As a key member of the Software development team, you will be responsible for the delivery of high quality, reliable, sustainable software to satisfy technical designs for the customer solutions. This role is high paced and requires self-discipline to work remotely and meet delivery schedules.

  • Work closely with teams to turn technical project requirements into functioning code
  • Experience in uncovering requirements, conceptualizing solutions, and developing a framework for implementation of a data warehouse, data mart, or data web on at least one other project or work assignment
  • Working knowledge of fundamental concepts, practices, and procedures of data warehousing
  • Experience with data extraction, manipulation, and cleansing tools
  • Knowledge of database design, with emphasis on data warehousing, OLAP, star schemas or reporting cubes
  • Knowledge of software development and database structures
  • Develop, test and implement software components
  • Define and document requirements and develop supportable application solutions to automate business processes
  • Collaborate with end-users, business analysts, and systems analysts to determine features, requirements and solution design
  • Develop enhancements to applications using leading software principles
  • Document technical specifications and designs
  • Adhere to industry standard established design, coding, naming and standards
  • Participate in code reviews and apply corrections as required
  • Adhere to change control processes
  • Write/revise documentation including operations and user guidelines
  • Lead development efforts consisting of multiple developers or multi-thread development projects
  • Design, document, and enforce architectural and design standards
  • Gather and drive stakeholder requirements and product vision through the planning, analysis, development, and testing phases
  • Possess a thorough understanding of the data, sources of data, and relationships of data
  • Troubleshoot and resolve complex application issues as needed

Minimum Criteria

  • 6+ years database data warehouse development role
  • Extensive knowledge of data warehousing, data marts and concepts
  • Ability to write complex SQL Statements for ETL/ELT processing
  • Hands on Netezza/Teradata/Exodata/GreenPlum (including tools and utilities) experience desirable
  • Health Insurance experience desirable
  • Excellent oral and written communication skills
  • Work well independently and remote
  • Ability to collaborate effectively and work as part of a team
  • Strong attention to detail
  • Or an equivalent combination of education, training and experience
  • Expert knowledge of Object-Oriented Programming, ETL tools such as DataStage, and/or other package software applications
  • Expert knowledge of SQL Server, Oracle
  • Proficiency with Microsoft suite of tools
  • Problem-solving skills and proven record of working well in a team environment
  • Advanced proficiency in analysis, leadership, and communication skills (verbal and written) across all organizational levels
  • ETL Specific: Expert knowledge/experience in DataStage, AIX and Korn Shell scripting
  • Health Insurance experience desirable
  • Excellent oral and written communication skills
  • Work well independently and remote

Education Requirements

  • Bachelor’s degree in STEM
  • BA/BS in Computer Science or related field, or an equivalent combination of education and/or experience, preferred