Our client is seeking an experienced Senior Data Architect for a utility project that will last at least one year near Springfield MA.  This individual will be responsible for developing, optimizing, designing, defining and documenting a data blueprint for overseeing conceptual and logical data for an ADMS project.

The Data Architect will need have knowledge of data technologies such as replication, integration, databases, data structures, extract, transfer and load (ETL) techniques with Oracle and Microsoft products.  Being able to determine data types, utilize canonical models and data exchange methods such as services, APIs, etc. are also key. The Data Architect must know how to examine new and existing data distributed within systems, gather details, determine requirements, understand system interfaces, as well as manage the implementation data migration models with technical resources.   

Responsibilities:

• Design and implement effective data solutions and models to store and retrieve data.
• Examine and identify database structural necessities by evaluating business operations, applications, and programming.
• Ensure data transaction integrity with completeness, accuracy and flawless transfer between systems.
• Assess data usage and security, consumer /provider implementation procedures to ensure they comply with internal and external regulations.
• Implement and organize information systems to guarantee client's required functionality.
• Prepare accurate database design and architecture reports.
• Determine and oversee the migration of data from legacy systems to new solutions.
• Generate system performance data testing methodology for regular (regression) testing, troubleshooting data issues and validating/integrating new features.
• Describe the existing methodologies that will be employed to store the data, the database technology to be employed and the processes that will manipulate/transform/transfer.
• Describe and determine data in storage, data in flight, use and data in motion (transformation). Provide descriptions of data stores, data groups, data/information items, data mappings, data artifacts, to data quality, applications, locations, destinations and consumers defined during the design phase of the data architecture & schema.
• Describe/document common support for data/information operations (i.e. support matrix, emergency procedures, data imports, data backups, external transfers of data etc).
• Recommend solutions to improve new and existing data exchange between systems.
• Provide technical expertise on data storage structures, mining, and cleansing.
• Evaluate changes and updates to data source’s and destination systems
• Build confidence in the data by responding to problems with systems in a timely manner.

Required Experience & Skills

• A minimum of 5 years’ experience in a similar role and 10 years in IT
• Requires knowledge of systems development methodologies and systems integration methodologies
• Requires knowledge of business application technical design and implementation processes
• Strong analytical and problem solving skills. The candidate will attend and participate in project meetings and design sessions
• Strong knowledge of database structure systems and data hosting
• Candidate should have an understanding with deploying and supporting large systems and applications, infrastructure, configuration, security, and operations
  
• Managing and designing reporting environments, including data sources, security, and metadata
• Electric Utility Experience is required, as is experience with some or all of the following:  ADMS, GIS, OMS, DMS, SCADA, Maximo, CVR, DER, DR, PHEV.

************

Briefly, this is what I see the role doing:

NMS Project Data Architect:

1. Design, Define and document a data blueprint for NMS/OUA project and related applications, determine data target state, align data between systems during development and provide follow-up to ensure data is in the intended state for consumption defined by the blueprint.
2. Develop/set/manage a data standard for all NMS/OUA project and related data using an interactions consumer/provider model between (integration) the data systems.
3. Describe the data structures used by business and its computer applications software.
4. Describe and determine data in storage, data in flight, use and data in motion (transformation). Provide descriptions of data stores, data groups, data/information items, data mappings, data artifacts, to data quality, applications, locations, destinations and consumers.
5. defined during the design phase of the data architecture schema.
6. Provide an administrative structurer to manage the data resources.
7. Describe the existing methodologies that will be employed to store the data, the database technology to be employed and the processes that will manipulate/transform/transfer.
8. Determine/describe and assist with interfaces utilized by the data provided/consumed to other systems.
9. Describe/document common support for data/information operations (i.e. support matrix, emergency procedures, data imports, data backups, external transfers of data etc).

Michel Ghanem

President