Data Integration

Job Description Summary
Responsible for designing, developing, testing and implementing data engineering processes to generate analytical and reporting solutions. Responsible for analyzing and preparing the data needed for data science based outcomes. Also responsible for managing and maintaining metadata data structures besides providing necessary support for post-deployment related activities when needed. Accountable to deliver results in a timely manner using agile methodologies.

Job Description
Role & Experience / Skills

• Engage with our utility clients to understand their Business Needs and how our solution can align, meet and exceed their business needs.
• Work collaboratively with a strong team of Technical Solution Specialists to provide input on solution architecture & integration needs based on client needs and solution capabilities. Define success criteria and contribute solution integration and / or architecture diagrams for the project.
• Conducts peer review of application designs and works with the application areas to ensure that project data modelling (including Network Model) requirements are met.
• Skilled in performing data profiling, creating source-to-target mapping documents, and ensuring data quality and integrity throughout the modelling process.
• Experience working with Data Architecture tools like Erwin and Enterprise Architect.

• Participate in deploying GE GridOS DERMS solutions to client environments.

• Prepare input data such as network model files, load & generation forecasts, future planning scenarios, and generation cost data.

• Lead in training the DERMS data models to ensure client success factors are met.
• Prepare, modify, and configure client and testing input data for solutions by creating scripts and automating data processing systems.
• Convert and validate client CIM distribution network models using development tools and scripts, validating powerflow results.
• Collaborate with our Service Engineering development lead during the development cycle to ensure all custom deliverables meet defined needs and standards.
• Respond to all client inquiries, participate in triage meetings, and submit product ideas for in-flight projects submitting tickets for the Product team.
• Perform data specific use case testing runs including factory and site acceptance testing.
• Debug SQL and model issues, documenting issues for the testing teams.

• Hands-On experience, with certification a plus, with cloud solutions such as AWS.

• Data Modelling needs and experience we seek:

• 5+ years of hands-on data modelling experience (including data analysis)

• Experience in data management and in data integration in a utility vertical
• Hands-On experience with modeling tools such as: Erwin, Oracle Data Modeler, Power BI
• 5+ years of hands-on experience with DB like: Oracle, Snowflake, SQL Server, Teradata, etc.
• Conceptual, logical, and physical modeling experience
• ER (Entity-Relationship) and dimensional modeling

• Data Management: Include responsibilities related to data quality and governance.

• Data governance and data standards

• Data architecture and data warehousing
• Data Vault modeling

• ETL processes

• Gathering & understand requirements, translating business requirements into data models

• Facilitating data requirements sessions

• Designed and implemented database structures using SQL Server

• Created and maintained source-to-target mapping documents

• Provided data model overviews and training to stakeholders at various levels of the organization

• Train utility clients and end users on how to use GE GridOS DERMS to achieve their business cases.

Complementary / Nice To Have Skills

• Experience.

• You have strong electricity industry knowledge (E.g. SCADA, ADMS, OT, OMS etc.), with 5+ years relevant work experience.

• You will bring enterprise software, with data integration skills and experience.
• You are comfortable automating processes and utilizing or building scripting solutions to support product solutions.
• Experience with enterprise software full stack development, including backend development and scripting including Java, Python, and DB connector experience.
• DevOps hands exposure or experience.
• Cybersecurity hands on experience.
• Familiarity with cloud-based solutions and deployment activities (Azure and / or GCP)

• Experience with power system analysis software (eg OpenDSS, CYME, Powerfactory, Synergi etc.)

• Knowledge.

• You are highly familiar with emerging energy industry trends and implications on utility clients in DER management, distribution planning, IT, SCADA and asset management with a strong background in analysis.

• Non-Technical Skills:

• You get things done within project deadlines, and with strong focus on quality.

• You are a natural collaborator and demonstrate a "we before me" attitude.
• You can quickly understand and analyze various approaches and processes and are able to configure solutions to client needs given existing product functionality.
• You can drill down to the details, obtaining the right level of specificity for your team. You can creatively solve complex problems.
• Strong written and verbal communication style. Can effectively share complex technical topics with various levels of audience.
• You are deeply curious and love to ask questions. You're a lifelong learner.
• You enjoy being in front of clients, listening to their needs. You are deeply focused on ensuring their success. You can create powerful user stories detailing the needs of your clients.
• A genuine interest in new tools and technology. You learn new software quickly without extensive documentation.

**Additional Information*
*Relocation Assistance Provided:
No