Sorry, this listing is no longer accepting applications. Don’t worry, we have more awesome opportunities and internships for you.

Data Architect - NMS Project

Testa Search Partners

Data Architect - NMS Project

Windsor, CT
Paid
  • Responsibilities

    Our client is seeking an experienced Data Architect for a utility project that will last at least one year near Windsor CT.  This individual will be responsible for developing, optimizing, designing, defining and documenting a data blueprint for overseeing conceptual and logical data related Outage management systems. The duties will include developing, setting, describing and managing a data standard for all project related data using an interactions “consumer/provider” model between (integration) the outage systems.

    To succeed, the Data Architect will need to be analytical, detail oriented, and comfortable with data minutia. A knowledge of data technologies such as replication, integration, databases, data structures, extract, transfer and load (ETL) techniques/functions with Oracle and Microsoft products is also required.  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 system technical resources. A fine eye for detail, prior experience as a data analyst, and a deep understanding of the data analysis tools (OracleBI, PowerBI) and databases (Oracle and SQL Server) is critical.  

    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 functionality.
    • Prepare accurate database design and architecture reports for architecture and management teams.
    • 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
    • Candidate is expected to have strong analytical and problem solving skills.The candidate will attend and participate in project meetings and design sessions
    • Candidate should be outgoing and enjoy working on a team
    • Individual in this position must demonstrate strong communication skills, including written, verbal and interpersonal skills
    • Strong knowledge of database structure systems and data hosting
    • Ability to translate complex problems clearly and in nontechnical terms
    • Comfortable with deliverying management presentations.

       

      Other Beneficial Skills & Experience

    • Candidate should have an understanding with deploying and supporting large systems and applications, infrastructure, configuration, security, and operations
    • Experience with ‘big data management’ is useful but not required
    • Managing and designing reporting environments, including data sources, security, and metadata
    • Managing users, user roles, and user authentication is helpful
    • Energy / Electric / Gas Utility Experience is ideal, as is experience with utility outage management systems, GIS, SCADA, Maximo, and field workforce solutions

    Technical skills that are preferred:

    Oracle database and products knowledge

    Infrastructure Specific Knowledge

    MS SQL

    Microsoft Azure

    UNIX (AIX), Linux

    Storage and Network concepts