- Microsoft SQL Server
- Business Intelligence
- Data Warehouse
As a Data Analyst at Ascensus, you will conduct data analysis to support data scientist studies through a broad spectrum of data mining responsibilities such as data interpretation, quality validation, trend computations and metric and categorical derivations. Additionally, you will manage and expand the data sources available for analytics using primarily Microsoft DBA skills including SSIS, SQL and BCP. The position will also support business awareness of analytic results delivering reports and visualizations with available reporting and business intelligence tools. May fulfill other duties in support of overflow needs of EIM team.
Job Functions, Essential Duties and Responsibilities
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 at the direction of the Data Scientist or project lead
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
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.
Experience, Skills, Knowledge Requirements
Bachelor’s degree or equivalent work experience
Excellent analytical skills
Excellent oral and written communication skills including active listening. Asking appropriate questions, clarifying information and writing clear, concise documents.
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
Experience with relational databases: Sybase ASE, SQL Server, Oracle, MySQL
Proven data structure experience or education; its organization, management and storage format
Preferred knowledge, skills and abilities:
Retirement or Government Savings domain knowledge
Working knowledge of all Ascensus data sources; their purpose, structure, definitions and how data is populated
Data mining and BI reporting tool usage
We are proud to be an equal opportunity employer.
Ascensus is a place to have a career, not just a job. As the largest US independent retirement and college savings services provider, we put our focus on people. Our culture is guided by sound principles, is committed to high standards, operates with transparency, and welcomes diversity. When you join our team, you get to go to work every day knowing that you help over 6 million Americans save for retirement and college.
Ascensus is an Equal Opportunity Employer and does not discriminate on the basis of race, color, creed, national origin, ancestry, religion, age, citizenship, sex, marital or veteran status, disability or handicap, sexual orientation or any other basis prohibited by applicable law. Ascensus also takes affirmative action to employ, and advance in employment, qualified women, minorities, and covered veterans. Ascensus also makes reasonable accommodations for qualified individuals with disabilities, in accordance with the Americans with Disabilities Act and applicable state laws