Senior Data Engineer

About the Role

Key Responsibilities

• Own the attribution mapping details for data elements from source systems to target data assets and finance and regulatory reporting specific data solutions, including data marts, integration layers, extracts, hierarchies, and point-to-point solutions.
• Provide data mapping details on attributes required, including transformation and storage of source system data in the target destination, leveraging metadata for insights.
• Develop and document business rules, transformation logic, derived column expressions, and SQL to build mapping documents.
• Translate business requirements into detailed mapping documents, develop and unit test datasets by building maintainable code to accelerate delivery through reusability.
• Collaborate with Data Architects, Developers, and Enterprise Testers to drive design, development, and testing based on given requirements.
• Work with Lines of Business, including Business Analysts and Subject Matter Experts, to ensure business requirements are clear, concise, and vetted, translating them into technical mapping documents.
• Perform peer code reviews and contribute to Mapping and Data Architecture Review Sessions.
• Provide status updates and estimates to Project Managers and Management.
• Mentor and train less experienced business and data analysts.
• Contribute to data models and Entity Relationship Diagrams, using these to build efficient SQL.
• Assess the technical viability of new and emerging data solutions, providing design guidance, technical recommendations, and performance optimization.
• Contribute to technical documentation, specifications, and project artifacts.
• Adhere to and promote standards and best practices within the Data Supply Chain.
• Create and enhance context diagrams for data solutions to maintain auditability.
• Gain knowledge of portfolio planning, project prioritization, and remediation activities.
• Apply knowledge of Risk Management practices related to Financial Institutions and financial data.

Requirements

• Master's Degree with 5+ years of data analytics experience, or a Bachelor's Degree with 8+ years of data analytics experience, or equivalent military/work experience.
• Strong written and verbal communication skills.
• Experience with Google Cloud Platform, notably BigQuery.
• Programming experience in Python, SAS, and SQL.
• Experience with AbInitio or AbInitio SpecToGraph.
• Experience with Agile methodologies, Jira, and Confluence.
• Extensive experience analyzing and interpreting business data, including automation and data quality validations.

Nice to Have

• Experience in data modeling and Entity Relationship Diagrams.
• Knowledge of portfolio planning, project prioritization, and remediation activities.
• Understanding of Risk Management practices in financial contexts.

Qualifications

• Educational qualifications as specified in requirements.