Job Description :
Job Description :


Create complex SQL code packages to extract data from enterprise data warehouses
compare data across multiple platforms to interpreted business requirements to identify error conditions and/or new requirements
produce summary and detail reports for operational teams to monitor performance
maintain data processing routines to ensure service level agreement adherence
fulfill data research requests as needed
liaison between business and technology to translate business rules into technical requirements for application development
contribute to Metadata documentation such as business definitions and data lineage
Minimum Qualifications:

· 5+ years developing PC SAS

· 10+ years SQL code

· 5+ years using Teradata and DB2

· able to transform large data sets into actionable information for operations management consumption

Preferred Qualifications

5+ years of experience in Wealth Management with in-depth understanding of organizational hierarchy such as Regions, Markets, Managers, Relationship Managers, etc.
understanding of Wealth Management Book of Business concepts such definition of Relationships, Qualified Balance, and Wealth Tiers
Familiar with LOB specific account relationship rules (i.e. all accounts associated to a client with Wholesale relationship must reside within a single line of business)
report development in Microsoft Power BI Desktop and/or Power Pivot