RCI-RID-17808 Senior Data Engineer (NO C2C)

Job Purpose

• The Senior Data Engineer is a collaborative, hands-on role 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 teams responsible for implementation.
• Solutions and design trade-offs are communicated to business and technical stakeholders for effective decision making.
• The Senior Data Engineer will work on a major IT initiative to enable Client Business Partners by improving how our employees serve our customers today and by creating the platform for tomorrow’s growth. Applicant must be fluent in data warehousing, with a focus on analytical platforms.

Key Accountabilities

• Perform and collaborate on system designs, data solution development including data migration and extracts from multiple legacy systems
• Updates to data mappings and data catalogs
• Participate in, and/or lead, design and pre-deployment reviews
• Data profiling
• Design and development of data synchronization processes
• Participate in the design/development of SaaS solutions, including data modeling
• 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

• 3 years’ experience in database development (Snowflake, SQLServer, Oracle, etc)
• Experience in data mapping, modeling and working with teams to define data models
• Proven ability to work well in a team environment, and be capable of building and maintaining positive relationships with other staff, departments, and customers
• 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