Job Description IT / Data Analyst II

IT


Data Analyst II
Kansas City Life Insurance Company, a recognized leader in the insurance industry, is seeking an energetic, self-motivated individual to join our IT department. The ideal candidate would meet the following requirements:
    QUALIFICATIONS/REQUIREMENTS:
  • B.S. or B.A. degree in Engineering, Computer Science, or equivalent work experience
  • At least 3 years of experience in business intelligence development
  • Experienced in at least one of the following visualization packages: Microsoft SQL Server Reporting Services (SSRS), Power BI, Tableau, RStudio Connect / R Shiny
  • Working knowledge of R, Python, SAS, or another analytical tool
  • Experience writing complex set based T-SQL queries working in Microsoft SQL Server or like database technology
  • A working knowledge of MDX
  • Experience optimizing SQL queries by analyzing query plans and effectively using indexes
  • The ability to communicate effectively with both business and technical team members
  • Regular and reliable attendance and punctuality is an essential function of this position.
    DUTIES/RESPONSIBILITIES:
  • Deliver key business metrics and data reporting
  • Develop & deploy ad-hoc, canned and self-service reports and dashboards that expose key business insights
  • Support, optimize, and build dashboards and interactive data visualizations from multiple data sources
  • Create visualizations and reports for requested projects within IT
  • Analyze legacy system data to identify the most accurate data sources and ensure use of standardized values, formats definitions, metrics and business rules in reporting and other data requirements
  • Conduct validation and testing of reports and dashboards to ensure consistent and accurate reporting across the organization. Maintain proper documentation and adhere to change management process.
Kansas City Life Insurance Company
ATTN: Human Resources Department
3520 Broadway
P.O. Box 219139
Kansas City, MO 64121-9139
EOE/MFVH
e-mail:resumes@kclife.com

Print this job description
Close this job description