Investment Data Analyst II

Western & Southern Financial Group•Cincinnati, OH

1d•Onsite

About The Position

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.

Requirements

Bachelor's Degree
4 - 6 years typical experience in SQL and data visualization.
Proficient in Structured Query Language (SQL).
Ability to build advanced Tableau dashboards.
Demonstrated project management skills, especially pertaining to technical projects and vague or unknown initial requirements.
Proven excellent relationship-building skills regarding IT functions (e.g., programmers, data modelers, data architects, etc.).
Possesses and displays excellent verbal and written communication skills with ability to convey information to internal and external customers in a clear, focused and concise manner.
Proven strong analytical skills, including demonstrated experience identifying and quantifying problems and providing effective resolutions with the ability to conceptualize and use new methodologies. Must have the ability to apply principles of logical thinking to define problems, collect data, establish facts, and draw valid conclusions.
Superior data access skills; access, transform and manipulate internal and external data in its base form.
Demonstrated knowledge of data-related tools and industry standards (ETL, business intelligence, report writing, SQL reporting services, Crystal Reports, etc.).
Integration tools (DTS, SSIS, Informatica, etc.) preferred.
Microsoft Office suite of products.
Data-related certifications Upon Hire

Responsibilities

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.