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 data solutions, including data marts, integration layers, extracts, hierarchies, and point-to-point solutions.
• Provide data mapping details on attributes required, including how source system data will be transformed and stored in the target destination, leveraging metadata for insights.
• Provide all business rules, transformation logic, derived column expressions, SQL, etc., 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 properly translated into technical mapping documents.
• Perform peer code reviews and contribute to Mapping and Data Architecture Review Sessions.
• Provide status updates and estimates of work to Project Managers and Management.
• Mentor and train less experienced business and data analysts.
• Contribute to data models and Entity Relationship Diagrams, and use these to build efficient SQL.
• Assess the technical viability of new data solutions, providing design guidance, technical recommendations, and performance optimization.
• Contribute to technical documentation, specifications, and project artifacts for data solutions.
• Adhere to and help extend 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 extensive experience.
• 8+ years of data analytics experience or equivalent military/work experience.
• Strong written and verbal communication skills.
• Experience working 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 planning activities.
• Strong understanding of Risk Management practices in financial institutions.

Benefits & Perks

• Access to hundreds of clients, many with long-standing relationships with Genesis10.
• Opportunity to have a career-home within Genesis10, with many consultants working exclusively with the company.
• Access to an experienced, caring recruiting team with over 7 years of experience on average.
• Behavioral Health Platform.
• Medical, Dental, Vision insurance.
• Health Savings Account.
• Voluntary Hospital Indemnity (Critical Illness & Accident).
• Voluntary Term Life Insurance.
• 401K.
• Sick Pay (for applicable states/municipalities).
• Commuter Benefits (Dallas, NYC, SF).