Data Architect (Design Lead)

ETL, Architect, Data Design
Contract W2, Contract Corp-To-Corp, 12 null
open
Work from home not available Travel not required

Job Description

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.
  • 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.

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
Dice Id : 10511767
Position Id : 811986
Have a Job? Post it

Similar Positions

Data Architect - Oracle
  • IT Mantra
  • Boston, MA
Data Modeler/Architect
  • Metasys Technologies
  • Boston, MA
Data Architect
  • enableIT LLC
  • Boston, MA
Data Architect
  • Computer Merchant, Ltd., The
  • Boston, MA
Data Modeler
  • SSI
  • Boston, MA
Data Warehouse Intake Coordinator
  • Eliassen Group
  • Boston, MA
Data Warehouse Developer
  • Cynet Systems
  • Boston, MA
DW Data Architect
  • TEKsystems
  • Waltham, MA
Data Architect
  • Alechemy Software Solutions LLC
  • Boston, MA
Data Architect
  • National Engineering Service Corp
  • Walpole, MA
Data Architect
  • Millennium Consulting
  • South Walpole, MA
Data Warehouse Developer
  • The Tri-Com Consulting Group
  • Boston, MA
Data Warehouse Developer
  • NTT DATA, Inc.
  • Boston, MA
Data Modeler (Analytical Systems)
  • Mass Mutual Financial Group
  • Boston, MA
Data Modeler
  • Empower Recruiting Services
  • Boston, MA