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 ClientBusiness 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
