Technical Data Analyst

Annuities, Data analysis, Data extraction, Business requirements, Impact analysis, Life insurance, RDBMS, Reporting, SQL, Microsoft Power BI, Microsoft SSIS, Stored procedures, Gap analysis, Data warehouse, DaaS
Full Time
Depends on Experience
Work from home available

Job Description

Job Summary:

The Technical Data Analyst is technical role responsible for detailed data analysis and utilization of technical tools to ensure overall organization objectives can be achieved.  This position reports to the Director, Data Services.

Main Accountabilities:

  • Uphold a data architecture that supports strategic and business goals. 
  • Create Reporting solutions that meet the needs of the business objectives.
  • Analyze and interpret data in existing databases to support projects and resolve data issues.
  • Strong knowledge of database reporting tools e.g., Microsoft Power BI 
  • Solve problems by interpreting SQL stored procedures and by analyzing data
  • Map source system data, to data warehouse and downstream applications.
  • Perform gap and impact analysis.
  • Interview business users to gain an in depth understanding of strategic/business direction. 
  • Gather requirements for data warehouse and other data solutions.
  • Perform project artifact (specifications, models etc) reviews with the business, development team and QA analysts.
  • Take ownership and drive all assigned tasks to completion according to project plan.
  • Develop a deep and comprehensive understanding of our Annuity and Life business and support systems.
  • Create well-written, clear, concise and above all accurate document artifacts including specifications, gap analysis documents, mapping documents and process diagrams for the purposes of data warehouse construction and reporting.

Qualifications:

  • 3 to 5 years of experience in IT as a Data Analyst.
  • Bachelors Degree in related field or equivalent work experience
  • Ability to understand how data relates to source systems, its relevance to our upstream and downstream applications.
  • Solid understanding of SQL, SSIS, stored procedures, Power BI, ad-hoc query development.  
  • Comprehensive understanding of relational databases.
  • Ability to document requirements for data extraction and develop transformation rules in accordance with business requirements.
  • Understanding of Annuity and Life Insurance.
  • Ability to provide functional and data requirements documents.
  • Solid team player.
  • Strong communication skills, both verbal and written as well as exemplary organizational skills
  • An understanding of or a background in development.  
Dice Id : 10485122
Position Id : PB10182021
Originally Posted : 1 month ago
Have a Job? Post it

Similar Positions

T-SQL/SSRS Data Engineer
  • ConsultNet, LLC
  • Indianapolis, IN, USA
Business Intelligence Analyst/Developer
  • Gables Search Group
  • Cincinnati, OH, USA
BI Analyst
  • CBTS
  • Cincinnati, OH, USA
Azure Data Architect
  • Cynet Systems
  • Louisville, KY, USA
Cloud Data Engineer - Architect
  • Deloitte
  • Louisville, KY, USA
Data Engineer, Enterprise Data Warehouse - M
  • Next Step Systems
  • Chicago, IL, USA
Power BI Analyst
  • Glotel
  • Lisle, IL, USA
IT Systems Analyst
  • Apex Systems
  • East Chicago, IN, USA
Technical Program Manager Data and Analytics
  • Randstad Technologies
  • Chicago, IL, USA
Senior Data Warehouse Developer | $100K | Columbus, OH
  • Vaco Technology
  • Columbus, OH, USA