Principal Data Analyst, EIM Analytics

Ascensus; Needham (MA); On-site; USD 140,000 - 170,000; Full time

Job summary

Ascensus is seeking a Principal Data Analyst, EIM Analytics in Needham, MA to architect and execute a data analytics and data management roadmap, lead governance, and design ETL strategies for the EIM platform. You will mentor the team and collaborate with business leaders to align priorities with strategy, addressing data gaps and ensuring on-time delivery.

The role focuses on CRISP-DM leadership, data quality, and delivering actionable insights through BI dashboards while maintaining

Qualifications

• Post graduate degree in data, math, or related field.
• 10+ years of data-related experience with proven ability to derive business value through analysis.
• Advanced analytics and data mining skills, including translating findings into actionable business insights and recommendations.
• Database technology experience including data warehousing concepts, data mart and data definition practices supporting quality and re-use, and ability to write complex SQL statements.
• Strong verbal and written communication skills, including explaining complex concepts to non-technical audiences.
• Team orientation with strong interpersonal and collaboration skills.
• Solid business relationship experience and ability to learn Ascensus products, services, clients, and business considerations.
• Time management and prioritization skills to meet deadlines and lead others to prioritize work.
• Initiative and strong work ethic, driving efforts to completion and pursuing successful outcomes.
• Excellent analytical skills
• Experience with relational databases: Sybase ASE, SQL Server, Oracle, MySQL
• Proven data structure experience or education
• Experience building BI reports and dashboards
• Leadership experience (formal or informal)
• Retirement or Government Savings domain knowledge
• Working knowledge of all Ascensus data sources (purpose, structure, definitions, and how data is populated)
• 2+ years of Microsoft DBA skills including SSIS, SQL, and BCP, including experience with recent versions of Microsoft SSIS
• 2+ years of relevant experience in ETL or data analyst roles, including data mining and/or ETL development

Responsibilities

• Develop, illustrate, maintain, and execute a data management and data analytics roadmap and vision.
• Collaborate with business leaders and analytics team members to align priorities with business strategy.
• Identify technology gaps, investigate needs, and present recommended solutions.
• Coordinate with the EIM team to transition prioritized data and reporting to the EIM platform using line of business chosen reporting and dashboard solutions.
• Maintain milestone-level project plans to anticipate resource needs, mitigate risks, and support on-time delivery.
• Delegate and support delivery of ad hoc analytical requests.
• Validate that data sources meet requirements and expected outcomes.
• Analyze data quality, identify improvements, and address data gaps.
• Build deep working knowledge of Ascensus data sources, including purpose, structure, definitions, and population approach.
• Execute data preparation using CRISP-DM (as a CRISP-DM leader or team member).
• Perform data segmentation plus review and reporting of expansive data sources.
• Support data and model monitoring and charting for scheduled ongoing jobs.
• Adhere to and recommend improvements to data governance.
• Build and deliver analytics findings and machine learning updates to business stakeholders in a consumable way using BI and other available tools.
• Support users with BI resources by developing well-rounded knowledge of Ascensus business intelligence.
• Create and maintain analytics data source documentation including current and future state.
• Design, code, tune, and modify analytics ETL solutions, including ETL design and documentation.
• Apply standards and best practices for implementing Ascensus ETL tools in collaboration with Data scientists, DBA leadership, and the EIM team.
• Protect and properly handle all confidential data to prevent unauthorized access, improper transmission, or unapproved disclosure.
• Provide leadership for the overall data analytics practice by ensuring team members have needed tools and technologies.
• Mentor, train, and support analytics team development as requested.
• Manage and support staff needs including education, clear goals and objectives, and leadership by example.
• Perform leadership tasks such as performance reviews, time off, and other administrative responsibilities.
• May take on additional duties to support overflow needs of the Analytics & Insight team

Skills

Advanced analytics

Data mining

SQL proficiency

Verbal and written communication

Team orientation

Leadership

Mentoring

BI reports and dashboards

Data governance

CRISP-DM knowledge

ETL development

SSIS

SQL

BCP

Education

Post graduate degree in data, math, or related field

Tools

Sybase ASE

SQL Server

Oracle

MySQL

Job description

Ascensus is hiring a Principal Data Analyst, EIM Analytics to develop and execute a data analytics and data management roadmap while supporting enterprise delivery through its EIM platform. In this onsite role in Needham, MA, you will lead analytics and governance activities, design and tune ETL solutions, and coordinate data and reporting transitions with the EIM team. You will also contribute to team mentorship and supervision when applicable.

What you’ll do

• Develop, illustrate, maintain, and execute a data management and data analytics roadmap and vision
• Collaborate with business leaders and analytics team members to align priorities with business strategy
• Identify technology gaps, investigate needs, and present recommended solutions
• Coordinate with the EIM team to transition prioritized data and reporting to the EIM platform using line of business chosen reporting and dashboard solutions
• Maintain milestone-level project plans to anticipate resource needs, mitigate risks, and support on-time delivery
• Delegate and support delivery of ad hoc analytical requests
• Validate that data sources meet requirements and expected outcomes
• Analyze data quality, identify improvements, and address data gaps
• Build deep working knowledge of Ascensus data sources, including purpose, structure, definitions, and population approach
• Execute data preparation using CRISP-DM (as a CRISP-DM leader or team member)
• Perform data segmentation plus review and reporting of expansive data sources
• Support data and model monitoring and charting for scheduled ongoing jobs
• Adhere to and recommend improvements to data governance
• Build and deliver analytics findings and machine learning updates to business stakeholders in a consumable way using BI and other available tools
• Support users with BI resources by developing well-rounded knowledge of Ascensus business intelligence
• Create and maintain analytics data source documentation including current and future state
• Design, code, tune, and modify analytics ETL solutions, including ETL design and documentation
• Apply standards and best practices for implementing Ascensus ETL tools in collaboration with Data scientists, DBA leadership, and the EIM team
• Protect and properly handle all confidential data to prevent unauthorized access, improper transmission, or unapproved disclosure
• Provide leadership for the overall data analytics practice by ensuring team members have needed tools and technologies
• Mentor, train, and support analytics team development as requested
• Manage and support staff needs including education, clear goals and objectives, and leadership by example
• Perform leadership tasks such as performance reviews, time off, and other administrative responsibilities
• May take on additional duties to support overflow needs of the Analytics & Insight team

Required qualifications

• Post graduate degree in data, math, or related field
• 10+ years of data-related experience with proven ability to derive business value through analysis
• Advanced analytics and data mining skills, including translating findings into actionable business insights and recommendations
• Database technology experience including data warehousing concepts, data mart and data definition practices supporting quality and re-use, and ability to write complex SQL statements
• Strong verbal and written communication skills, including explaining complex concepts to non-technical audiences
• Team orientation with strong interpersonal and collaboration skills
• Solid business relationship experience and ability to learn Ascensus products, services, clients, and business considerations
• Time management and prioritization skills to meet deadlines and lead others to prioritize work
• Initiative and strong work ethic, driving efforts to completion and pursuing successful outcomes
• Excellent analytical skills
• Experience with relational databases: Sybase ASE, SQL Server, Oracle, MySQL
• Proven data structure experience or education
• Experience building BI reports and dashboards
• Leadership experience (formal or informal)
• Retirement or Government Savings domain knowledge
• Working knowledge of all Ascensus data sources (purpose, structure, definitions, and how data is populated)
• 2+ years of Microsoft DBA skills including SSIS, SQL, and BCP, including experience with recent versions of Microsoft SSIS
• 2+ years of relevant experience in ETL or data analyst roles, including data mining and/or ETL development

Technologies

• CRISP-DM
• Sybase ASE
• SQL Server
• Oracle
• MySQL
• SQL
• SSIS
• BCP

Supervision

In some scenarios, this role includes small team supervision, requiring balancing the core data analyst responsibilities with managing team deliverables and performing management responsibilities, including administrative leadership tasks.