Job Description

Top 3 Things looking for when reviewing resumes
1. Data mapping and modeling experience
2. SQL, SAS and Python
3. Felxibility to be a DA (complex dataset creation), lead mapping review meetings as needed, but also to fill a BA role to ensure continuity of delivery with business 


Essential Job Functions:
·       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.