Click here to login or register
Reference # : 19-13594 Title : Data Warehouse Developer
Location : Quincy, MA
Position Type : Full Time/Contract
Experience Level : Start Date / End Date : 12/23/2019 / 06/30/2020  
Job Title: Data Warehouse Developer
Location: Quincy, MA
Contract Duration: Through June 30, 2020, long term extensions
Mandatory 37.5 hour work week

The Data Warehouse Developer, will be responsible for analysis, design, coding, and testing of moderate to extremely complex data warehouse development. The DWD will analyze and develop data warehouse schematic solutions to support business requirements as outlined by a Business Analyst. The role will also support existing warehouse infrastructure and provide input on best practices and potential efficiencies. The DWD will be expected to work on multiple assignments concurrently and be required to complete work by aggressive due dates. The role uses a range of their expert technical skills based on keen knowledge of data warehouse concepts and must be highly proficient with Oracle SQL. The DWD is expected to participate in all meetings they are invited to as part of the project management office and create and deliver deliverables and/or review materials as expected.

  • Design and Develop ETL solutions in an Oracle Exadata environment based on specifications
  • Determine appropriate sourcing and storage of data from multiple source systems
  • Codes Oracle ETL scripts that will extract data from an operational database as well as other external data sources and populate the staging and target data warehouse schemas
  • Documents code and processes for distribution to all interested parties
  • Documents design using industry standards including ERWIN diagramming
  • Provides query writing support and tuning expertise to analysts and end users
  • Develops shell scripts for production job automation
  • Work in a 24x7 environment which requires on-call rotation

  • 5+ years of experience in database architecture and development including analyzing, designing, documenting, coding, testing and implementing primarily SQL code
  • Thorough knowledge of data warehouse principles and techniques, specifically dimensional data architecture modeling
  • Exceptional Oracle SQL skills and PL/SQL skills
  • Hands on experience with set based operations, analytic functions and query hints
  • Command of data warehouse modeling concepts is required
  • Strong problem solving and analytical skills
  • Strong ERD modeling
  • Proficiency with Linux and shell scripting
  • Experience working with a large, multi-terabyte data warehouse
  • The ideal candidate must demonstrate that they have relevant experience, creativity, a keen problem-solving ability.
  • Excellent interpersonal skills for collaboration and facilitation work with a broad range of people while keeping projects on track.

EXPERIENCE that will distinguish candidates:
  • BS in Computer Science or related degree, or equivalent experience
  • Medicaid or other healthcare or claims processing experience
  • AWS (Cloud) Experience
  • Informatica ETL experience