WHAT WILL YOU BRING
Required Education
Bachelors degree from an accredited college or university in Information Technology Data Analytics Business Intelligence or a closely related field.
High school diploma or equivalent and additional full-time experience in data analytics SQL SSIS business intelligence visualization tools MS Office Suite or related experience may be substituted on an equivalent year-for-year basis.
Required Experience
One (1) year of full-time experience in data analytics utilizing tools such as SQL SSIS or business intelligence and visualization tools or MS Office Suite to troubleshoot or recommend business solutions or related experience.
Experience may be concurrent.
A masters degree or doctoral degree in a closely related field may be substituted on an equivalent year-for-year basis.
Required Registration Certification or Licensure
None.
Preferred Qualifications
Experience with MS Power BI or MS Visual Studio.
Experience working with a star-schema data warehouse or other data analytic data structures.
Experience with integrations leveraging ETL tools.
Experience with data migration and/or reconciliation.
Experience with technical process writing in an application development environment.
Experience with troubleshooting or development of complex Spreadsheets utilizing formulas to create data analytics.
Knowledge Skills and Abilities
Knowledge of:
Knowledge of one or more of the following: business intelligence tools databases SQL or various job associated programming languages to support data analysis and predictive analytics.
Database modeling and data warehousing principles.
Project management and system development life cycle concepts.
Data manipulation methods that transform dates and accounting concepts that allow for business decision making and analytics
Skills in:
Experience using technical and statistical analysis skills to deliver clear concise and visually appealing management metrics and reports to inform decision making and actions.
Writing report queries including an understanding of relational data or set based datasets.
Using a computer in a Windows environment with Microsoft Office word processing spreadsheet and other business software.
Effective written and verbal communication skills.
Working in a team environment.
Ability to:
Operate effectively in a fast-paced environment with competing and shifting priorities.
Continually learn new concepts and tools to support job needs and strive for ongoing professional development.
Establish and maintain harmonious working relationships with co-workers agency staff and external contacts.
Work effectively in a professional team environment.
Understand the concepts of the pension industry and how data works to support the core line of business.