Data Analyst

Essential Duties and Responsibilities:

• Implement and automate manual process by creating new database objects in SQL, VBA modules in Microsoft Access, and automations in low code/no code applications.
• Use SQL, Access, and VBA to develop reports and update client information.
• Analyze data for accuracy to ensure integrity.
• Provide report generation using SQL, Excel and Power BI for testing and production purposes per client requests.
• Provide report generation developing SQL queries, Excel workbooks and Power BI reports to analyze client data including quantitative analysis as well as qualitative text/comment analysis to identify trends and problems and determine root causes.
• Presentation of findings in the form of graphs, tables, charts and multimedia presentations including presentation delivery where needed to client and internal stakeholders.
• Create/Modify HTML pages for integration into automated processes.
• Develop SQL queries to maintain data validation; store procedures to maintain data consistency.
• Perform data extraction, transformation and loading (ETL) between systems using SQL tools such as SSIS and automation applications.
• Develop Microsoft Access interaction with SQL server utilizing VB for applications, and SQL.
• Ensure the assigned applications are properly administered and updated, and processes are completed efficiently.
• Actively seek ways to improve system performance and stability as well as improve end user experience.
• Identify, troubleshoot, and resolve system issues as reported by end users.
• Provide technical support and utilize appropriate resources with minimal guidance to provide proper issue resolution.
• Support existing process and provide appropriate feedback and recommendations on process improvements.
• Assist with the implementation of new releases of the software, including regression testing, scheduling, and change management. Ensure that the new features are communicated and fully tested.
• Serve as the subject matter expert for assigned systems and projects related to the core applications.
• Support business units throughout the organization by understanding workflows, processes, data collection, reporting needs and other technical issues associated with application software.
• Perform basic to level SQL coding for data mining, building reports, creating formatted data files, and researching data integrity issues. Manage the flow of information to members, administration, branch levels, and external parties.
• Full or part-time candidates will be considered; candidates must be able and willing to commute to Centerville, Ohio.