Data is used now more than ever for both operational decision making and exploratory analysis. This senior position will help define LANL's data strategy to govern, manage, and deliver enterprise data.
The Institutional Data Services team is looking for an experienced Data Architect to manage our data delivery services. The job entails requirements gathering from stakeholders, learning and understanding current inventory and approaches, as well as developing and driving a multi-year initiative to define and implement a modern data delivery strategy.
In addition, the Data Architect will be responsible for LANL's Oracle Operational Data Store (a large data warehouse), Denodo data virtualization, and delivering data to customers via SQL and Web Services.
The Data Architect will also oversee design and maintenance of a sophisticated, custom-built Extract, Transform and Load (ETL) job system using the Control-M job scheduler and shell scripts, and will mentor and consult with other developers at LANL to ensure the consistency of the data and structures in these tools.
Minimum Job Requirements:
- Extensive experience designing and maintaining a medium to large data warehouse, with experience designing facts and dimensions
- Extensive experience with Oracle's RDBMS, with experience using advanced Oracle capabilities (e.g., partition exchange, query optimization, transportable tablespaces, ORDS. PL/SQL)
- Extensive experience analyzing customer data requirements in a complex and regulated environment, then modelling and implementing data warehouse solutions
- Experience designing or building data delivery solutions including technologies such as Web Services, Web API Gateways, Data Virtualization, Web Service Catalogs, and/or Data Catalogs.
Education/Experience: Position requires a bachelor's degree and 15 years of related experience, or an equivalent combination of education and experience directly related to the occupation. At this level, postgraduate coursework may be expected.
