Principal Data Analyst, EIM Analytics

Section 1: Position Summary

As a Principal Data Analyst at Ascensus, you will collaboratively develop, illustratively communicate and successfully execute the data analytics and data management roadmap and vision.   You will both lead and perform analytics and data management tasks including, but not limited to: support of data scientist studies through a broad spectrum of data mining responsibilities; manage, clean up and expand data sources available for analytics; perform analytics studies driving business value; inform on insights developing and delivering reports and visualizations; transition prioritized data and reports to the EIM platform coordinated with the EIM team; identify, justify and install new tools and technologies as needed.  May fulfill other duties in support of overflow needs of Analytics & Insight team.

Section 2: Job Functions, Essential Duties and Responsibilities

• Strategy and Planning
  • Develop, illustrate, maintain data management and data analytics roadmap and vision
  • Collaborate with business leaders and analytics team to ensure roadmap and vision are clear and priorities align with team needs and business strategy
  • Identify technology gaps and needs; investigate and present recommended solutions
  • Work successfully with EIM to transition data and reporting priorities to the EIM platform for enterprise delivery through line of business chosen reporting & dashboard solutions
• Project and workload management
  • Successfully execute data management and data analytics roadmap
  • Support workload delegation and delivery of ad hoc requests
  • Maintain milestone level project plans to anticipate resource needs, mitigate risks and delivery on time
• Mentor and train: support analytics team development and training as requested
• Data Analysis
  • Validate that data sources meet requirements of the effort and outcomes
  • Analyze data quality identifying improvements and solutions for data gaps
  • Develop a deep understanding and working knowledge of all Ascensus data sources; their purpose, structure, definitions and how they are populated
  • Effectively execute data preparation responsibilities in the CRISP-DM methodology; as CRISP-DM leader or project team member
  • Perform data segmentation, review and reporting of expansive data sources
  • Perform data and model monitoring and charting for scheduled ongoing jobs
  • Adhere to and recommend improvements to data governance
• Reporting thru BI Utilization
  • Build and deliver analytics findings, machine learning updates and results to business in a consumable and efficient manner using BI and other available tools
  • Develop well rounded knowledge of Ascensus business intelligence to direct users on available BI resources
• Data Management
  • Create and maintain analytics data source(s) documentation including current and future state
  • ETL design and documentation specific to managing data sources for analytics
  • Design, code, tune and modify analytics data source ETL solutions 
  • Apply standards and best practices for implementing Ascensus ETL tools in support of Ascensus design guidelines and collaboratively with the Data scientists, DBA leadership and EIM team
• Ascensus Information Security
  • Responsible for protecting, securing, and proper handling of all confidential data held by Ascensus to ensure against unauthorized access, improper transmission, and/or unapproved disclosure of information that could result in harm to Ascensus or our clients.
• Our I-Client service philosophy and our Core Values of People Matter, Quality First and Integrity Always® should be visible in your actions on a day to day basis showing your support of our organizational culture.

Supervision  

• In some scenarios this role will include small team supervision requiring the candidate to balance their time to perform their above listed data analyst responsibilities alongside managing their entire team deliverables to successful and valuable outcomes and performing management responsibilities including the following:
  • Responsible for the design, mentorship and progress of the overall data analytics practice ensuring team members are effectively working and have the tools and technologies needed
  • Develop staff skills; encourage and reward areas of high aptitude and exceptional effort; coach on areas of improvement and identify
  • Support and provide feedback on development goals
  • Facilitate creativity and foster intellectual curiosity in your team and in how they work with others.
  • Manage staff; supporting needs including education, setting clear goals and objectives and leading by example.
  • Perform leadership tasks including performance reviews, time off and other administrative tasks

Section 3:  Experience, Skills, Knowledge Requirements

• Post graduate degree in data, math or related field
• 10+ years of data related experience with proven ability to derive business value thru analysis
• Advanced analytics and data mining: the ability to apply appropriate analytical techniques and translate findings into actionable business insights and recommendations. Identify and utilize best math principles and methods to achieve goals tapping into experience, knowledge and research
• Database technologies: understanding of data warehousing concepts including displayed experience or knowledge of data mart and data definition practices that support quality and re-use, with the ability to write complex SQL statements to store, retrieve, manipulate, integrate, validate, and summarize data
• Strong communications skills: both verbal and written, with the ability to explain complex concepts to non-technical audiences
• A team orientation: strong interpersonal and collaboration skills, with the ability to network with internal business partners across the organization
• Solid business relationship experience with the ability to quickly learn about Ascensus products, services, clients and business considerations.  Ability to obtain valuable information and insight through dialog with SMEs.
• Time Management/Prioritization – Ability to manage time and lead others to prioritize work to meet deadlines and deliver most valuable results first.  Responsibility to manage own and others tasks as assigned along with resolving priority conflicts and collaborating to ensure common expectation understanding with clients.
• Initiative/Work Ethic – Drives efforts to completion setting and managing personal goals. Proactively seeks out opportunities to ensure successful outcomes. 
• Excellent analytical skills

• # of Proposals

  Experience with relational databases: Sybase ASE, SQL Server, Oracle, MySQL
• Proven data structure experience or education; its organization, management and storage format

• Experience building business intelligence reports and dashboards
• A wide spectrum of database and statistic technology experiences demonstrating ability to learn new technologies and advise on best solutions
• Preferred knowledge, skills and abilities:
  • Leadership experience; formal or informal
  • Retirement or Government Savings domain knowledge
  • Working knowledge of all Ascensus data sources; their purpose, structure, definitions and how data is populated
  • 2+ years of Microsoft DBA skills including SSIS, SQL and BCP including experience using recent versions of Microsoft SSIS
  • 2+ years of relevant experience in ETL or data analyst role, including data mining and/or ETL development

We are proud to be an Equal Opportunity Employer

Be aware of employment fraud. All email communications from Ascensus or its hiring managers originate from @ascensus.com or @futureplan.com email addresses. We will never ask you for payment or require you to purchase any equipment. If you are suspicious or unsure about validity of a job posting, we strongly encourage you to apply directly through our website.