Lead Integration Engineer
Artech LLC
Remote, NY(remote)
JOB DETAILS
SKILLS
Aftercare, Agile Programming Methodologies, Cloud Architecture, Communication Skills, Continuous Improvement, Cross-Functional, Data Analysis, Data Management, Data Mapping, Data Modeling, Data Processing, Data Profiling, Data Quality, Database Administration, Database Architecture, Database Extract Transform and Load (ETL), Database Programming, ESRI, Employee Relations, Energy & Utilities, IBM WebSphere DataStage, Informatica, Master Data Management (MDM), Metadata, Microsoft Excel, Microsoft Office, Microsoft SQL Server, Microsoft Visio, Microsoft Word, Oracle Database, Presentation/Verbal Skills, Procedure Development, Process Improvement, Quality Assurance, Quality Management, Requirements Management, Salesforce.com, Snowflake Schema, Software Development, Software as a Service (SaaS), System Integration (SI), Team Lead/Manager, Team Player, Traceability, Writing Skills
LOCATION
Remote, NY
POSTED
6 days ago
Location: Remote
Duration: 6-12 months
Job Purpose:
The Lead Integration Engineer is a collaborative, hands-onrole on the Digital Platform Data Engineering Team responsible for designing sound, scalable, and performant solutions that meet the requirements in a large data volume enterprise, and leading the team responsible for implementation. Solutions and design trade-offs are communicated to business and technical stakeholders for effective decision making.
The Lead Integration Engineer will work on a major IT initiative to enable National Grid Business Partners by improving how our employees serve our customers today and by creating the platform for tomorrow’s growth.
Key Accountabilities
• Perform and collaborate on system designs, data solution development, with a focus on data integration pipelines to/from various platforms and/or legacy systems.
• Provide day-to-day supervision and leadership of engineering team(s) responsible for implementation.
• Updates to integration process data-mappings and data catalogs
• Participate in, and/or lead, design and pre-deployment reviews.
• Data profiling
• Must be comfortable reading/understanding data models.
• Design and development of data synchronization processes
• Participate in the design/development of integration solutions.
• Assist in determining the cross-application data standards, data distribution standards and promote data-driven design
• Create database deliverables ensuring quality and traceability to requirements and adherence to all quality management plans and governance standards
• Work with the team to ensure that all components work together to meet objectives and performance goals as defined in the requirements. Identify and communicate any cross-area or cross-release issues that may affect other areas of the project
• Participate in go-live preparation activities such as QA, dress rehearsals, issue remediation, cutover and go-live aftercare
• Participate in data management maturity assessments to identify gaps and pain points for capabilities including data quality, governance, analytics, metadata management, master data management
• Seek opportunities for continuous improvement in processes, procedures and systems with regards to data
Supervisory/Interpersonal- Experience Required
• Good team leadership and influencing skills for colleagues, partners / vendors; project sponsors
Qualifications
• 5+ years experience in database development (Snowflake, SQLServer, Oracle, etc)
• 5 years experience designing, coding, and delivering ETL workflows using Matillion (preferred), Informatica, Ab Inito, or DataStage.
• Excellent oral and written communication skills.
• MS Office (Word, Excel, PPT, Visio, et al).
• Experience in data mapping, modeling and working with teams to define integration pipelines.
• Experience in a dynamic work environment
• Proven ability to work well in a team environment, and be capable of building and maintaining positive relationships with other staff, departments, and customers
• Strong communicator
• Experience with cloud database architecture is a plus
• Experience with Snowflake is a plus
• Experience with Matillion is a plus
• Experience with real-time data loads is a plus
• Experience with Agile/Lean software development process and practices is a plus
• Experience in with SaaS solutions such as Salesforce, ESRI and Workforce is a plus
Other requirements:
• Ability to work with cross-functional teams, subject matter experts, and architects
About the Company
A