Investment Data Analyst II

Overview: This position leads enhancements to data quality management platform and analyzes data for accuracy. Responsible for implementing business solutions that use data to streamline processes. Uses data profiling of additional data sources in determining accuracy and identifying automation opportunities. Independently partners with business users and IT to document business requirements and translates into actionable data modeling, data movement and translation programs. Works under minimal supervision and escalates to manager when appropriate. Responsibilities: **What you will do:** * Leads enhancements to data quality management platforms and analyzes data for accuracy including assigning new reference data when needed * Maintains data integrity to ensure compliance with data governance processes * Responsible for implementing business solutions that use data to streamline processes; includes data mapping and validation * Uses data profiling of additional data sources in determining accuracy and finding automation opportunities * Independently works with business users and IT to develop data requirements including transformation requirements between systems * Create basic dashboards and workflows in support of business needs, including Tableau, KNIME and Structured Query Language (SQL) queries * Serves as liaison between the business and ETL developers, data modelers and IT programmers related to business specific technical specifications * Targets opportunities to minimize risk and eliminate data redundancy * Keeps up on current data related technologies * Performs other duties as assigned. * Complies with all policies and standards. Qualifications: * Bachelor's Degree \- Required * 4 \- 6 years typical experience in SQL and data visualization. \- Required * Proficient in Structured Query Language (SQL). \- Preferred * Ability to build advanced Tableau dashboards. \- Preferred * Demonstrated project management skills, especially pertaining to technical