The Data Analyst will provide critical data reporting delivery, packaging, and analytic capabilities. This role will analyze complex data structures to generate useful business insights and develop reporting to monitor business critical results. The Data Analyst will support the leadership team with data consultation, data gathering, data delivery, and data analysis.
ESSENTIAL DUTIES AND RESPONSIBILITIES may include the following. Other duties may be assigned.
Information Technology Team Member
Investigate data issues in account data from acquisition through presentation in the UI.
Assist in identifying issues that may adversely affect the performance of the Information
Perform unscheduled ad-hoc analysis for business partners and the credit union team.
Answer and document 'help desk' phone calls from credit union employees.
Participate on project teams.
Communicate with business partners to establish data requirements.
Be the official Information Technology representative in a variety of credit union endeavors.
Present final analysis to business partners and/or the credit union team.
Consult within and outside of Information Technology, professionally, to enlighten and educate.
Reporting and Analytics
Create tools or queries to obtain data from central data repository for the purposes of reporting and analysis.
Empower every user with data so they can make sound decision.
Perform ad-hoc analysis for business partners and the credit union team.
Implement analytic directives on data from senior staff and clients and develop written reports as needed.
Run SQL queries to produce counts, statistics, reports and graphs to circulate quantitative information to all departments.
Analyzing data sets and presenting results in an easily readable format.
Interpret available data to identify significant trends in operational statistics and prepare conclusions and forecasts based on those trends.
Use a variety of database software techniques to produce various media tools such as: reports, charts, graphs, lists, labels, memos, etc
Recommend and/or identify key business metrics.
Create or update reporting presentations and other documentation.
Documentation and Technical Writing
Assist in designing, documenting, programming and standardizing processes and reports.
Participate in quality assurance of measures including test case creation, SQL code review, independent results validation, and pulling sample cases from member data to support User Acceptance Testing.
Audit processes to ensure adherence to defined policies, processes, and procedures; generate formal report of audit findings.
Create or update documentation including policies, data flows, methods and procedures and other documentation as required.
Data Management and Data Integrity
Manipulating large data files using SQL, MS Query and MS Excel including pivoting capabilities and creating macros.
Ability to handle large data sets while maintaining database integrity.
Creating and scheduling targeted reports, data collection jobs, integration(s), and secure transfers of data.
May code new or modified programs, reuse existing code through the use of program development software alternatives and/or integrate purchased solutions.
Document, test, implement and provide on-going support for the application(s).
Assure validity by checking data accuracy, applying reasonability checks, and maintaining audit trails.
EDUCATION and/or EXPERIENCE:
BS in Computer Science or comparable accredited program with a quantitative emphasis or equivalent experience.
Experience with validating data from various data sources; flat files and relational databases (often in the same project).
Experience in data mining or profiling using query tools such as SQL, Excel, etc.
Experience with stdin/stdout and/or Batch Scripting a plus.
Some Familiarity with Unix environment a plus.
Experience with Symitar PowerOn (formerly RepGen) a plus.