• Owns the attribution mapping details for data elements from the source systems to the target analytics data assets and Wealth-specific data solutions including, but not limited to star marts, extracts, hierarchies, and point-to-point solutions to support Wealth domain assets.
• Independently translates business requirements to detailed mapping documents, develops and unit tests datasets building maintainable code to accelerate delivery through reusability, and performs peer code reviews.
• Embraces mentorship and provides training for less experienced business and data analysts.
• Provides continuous improvement ideas to reduce expenses, improve efficiency, and elevate quality.
• Assesses the technical viability of new and emerging data solutions providing design guidance, technical recommendations, performance optimization, and development insights.
• Contributes to technical documentation, specifications, and project artifacts for developing data solutions.
• Adheres to and identifies standards and best practices to be extended beyond the Foundational Analytics and Wealth Squad.
• Give input into Data Models and Entity Relationship Diagrams and use those documents to build efficient SQL.
• Create and enhance context diagrams for data solutions to maintain auditability.
• Provide all the business rules, transformation logic, derived column expressions, SQL, etc. to build mapping documents.
• Participate and give feedback in Mapping Review Sessions and Data Architecture Review Sessions.
• Knowledge of portfolio planning, project prioritization, and remediation planning activities.
• Strong knowledge of Risk Management practices associated with Financial Institution or financial data.   

Required Qualifications:

• Education: Master's Degree and 4+ years data analytics experience, Bachelor's Degree and 7+ years data analytics experience, or equivalent military/work experience.
• Possess strong written and verbal communication skills.
• Experience in Google Cloud Platform, notable Big Query.
• Experience programming in SQL, SAS and Python.
• Experience in data mapping and modeling.

Preferred Skills/Qualifications:

• Experience with Agile Methodologies, Jira, Confluence, Miro, and Asana.
• Experience working with Wealth Systems including Envestnet, Pershing, GlobalPlus, and Omnipay Nextgen or similar products is highly preferred.
• Extensive experience analyzing and interpreting business data leveraging various techniques including automation for data quality validations.
• Experience in AbInitio or AbInitio Spectograph.
• Experience working with APIs and a solution orchestration layer is a plus.