Data Management Design Lead

Greater Boston Area, Massachusetts 02421

Post Date: 08/20/18 Job ID: 6553 Category: Database/Data Warehousing

Position Title:  DW ETL Design Lead
Job Location: Greater Boston Area, MA
Interview Expectations: Onsite required
Local Candidate: Required
Duration:  6 months plus extensions

Design, specify, and deliver enterprise reporting and analytics data structures to support financial and medical analysis in our Oracle Exadata-based environment. Position may require team leadership or key development contribution or user interaction depending upon the profile of the project.

Experience:
  • At least 6 years functional design, technical design, coding, and testing of data acquisition and ETL process.
  • Technical leadership of several (3+) person development teams.
  • Development and usage of Data Warehousing best practices and standards.
  • Repeated design/development of large-scale data warehousing environments.
  • Design experience with a variety of DW languages and tool  sets.
  • Working knowledge of healthcare services industry-preferred.

Demonstrable Skills:
  • Functional/Technical document (specification) authorship. Required. Critical.
  • Oracle Exadata  DW appliance ETL development skill via SQL and other tools. Understand Oracle Exadata  ETL best practices. Preferred.
  • Ability to independently, or with business counterparts, profile, navigate and reverse engineer the data of source application databases in preparation for data and ETL design. Required.
  • Graphical and written design of complex ETL processes – including the exceptional. Required.
  • Good SQL PLSQL development in Oracle and/or SQL Server. Required.
  • Process and Data modeling in large-scale data warehousing environments. Strongly preferred.
  • Estimation, planning and execution of small-team data warehousing projects. Preferred.
  • Hands on skill with common ETL tools – especially Informatica. Preferred.
  • Design/Configuration of jobs using scheduling tools like Tidal or Autosys. Preferred.
  • Very good written, oral and meeting-based communications in mostly technical settings. Must be able to explain your design/position to multiple audiences. Required.
  • Skill in the techniques and tools used for high-volume data acquisition and replication. Strongly preferred.
  • Respects timelines and surfaces issues without direct supervision. Required.
  • Translate business information requirements to technical structure and specification. Required.
  • Leads and participates in code walk throughs and other deliverable reviews. Required.
  • Oracle Exadata certification. Preferred

Education:
  • Bachelor’ s degree in MIS, computer science or related field preferred.

Kristin Murphy
Senior Technical Recruiter

Contact Kristin today about this great opportunity with Queen Consulting Group!


Not ready to apply?

Send an email reminder to:

Share This Job:

Related Jobs: