Data Analyst - Hireliving

Summary

The position relies on good judgment, experience, and guidance to perform analytical and technical functions to analyze and interpret data. The role requires a broad degree of knowledge and problem solving skills. The Data Analyst will serve as a data developer resource, should have knowledge of data analysis tools, data profiling techniques and computer systems technology. This position will work closely with the Data Architect to develop technical requirements and comprehensive solutions to extract data from multiple source systems or models, transform data according to Business Rules and Master Data Management, work with the Acquisitions team to assure attributes are properly governed and also loaded into operational and presentation models. The ideal candidate will have experience collecting user requirements, data analysis, documenting technical specifications, understand core data characteristics, and have experience working work with life insurance and annuity data. This role is expected to support and expand a culture of operational excellence. The ability to understand complex problems, logical problem solving skills, and strong written and verbal communication skills are required. Additionally, a strong understanding of database methodology, data analysis, and reporting technologies are required.

Responsibilities

• Map data source attributes to target system attributes
• Build reports using SSRS, PowerBI or other technologies
• Research data requests to determine availability, sourcing and fulfillment options
• Build and Maintain SSIS Packages
• Perform root cause analysis on data quality issues
• Monitor the state of data quality within their scope of responsibility
• Write SQL Statements, Stored Procedures, database functions and other queries.
• Identify the best approaches for resolving data quality issues
• Schedule and maintain nightly jobs using Control-M
• Work independently under the direction of the Data Architect

Requirements

• Bachelor’s degree or equivalent certifications / experience required
• Experience with Microsoft SQL Server required
• 2+ years experience with Microsoft Business Intelligence stack (SSIS, SSAS, SSRS, SQL Server) a plus
• 2+ years IT analysis experience required
• Experience working on a project team using Waterfall or Agile methodology a plus
• Experience in relational and dimensional data modeling required
• Experience and understanding of Software Development Life Cycle (SDLC)
• Ability to work independently
• Advanced knowledge of structured data, such as entities, classes, hierarchies, relationships and metadata
• Knowledge of database management system (DBMS) including tables, joins and SQL querying
• Ability to combine data from multiple sources when needed for analysis
• Familiarity with and ability to document the use cases, business purposes and quality of the data
• Familiar with reporting technology and methods of reporting different types of data
• Understanding of data quality concepts, best practices and tools
• Communication skills to help communicate complex data and concepts to business analysts and team members