Log in

Log in

Data Analyst

12/20/2022 1:56 PM | Dave Hilbig

Support EXP helps financial institutions deliver a differentiating customer experience by optimizing their CX performance. Our data-driven, comprehensive survey and mystery shop solutions; insight-rich actionable analytics; targeted CX research and expert guidance all work together to accelerate our clients toward success. Support EXP is seeking a Data Analyst as a key member of the Innovation & Technology team that will interpret and analyze customer experience data, develop and maintain custom code and reporting, analyze data and present findings to key internal and external stakeholders.

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, 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.

Education and Experience:

  • Bachelor’s degree or higher in data analytics, statistics, computer science, information technology or a related field
  • Previous work experience handling data, reporting, analysis or manipulating
  • Excellent communication skills and the ability to work in a fast-paced environment, both independently and as part of a team
  • Strong analytical and problem-solving skills
  • Advanced proficiency with Microsoft PowerPoint, Excel and Access.
  • Familiarity with SQL, including writing queries using Access or SQL Server Management Studio.
  • Experience with analytical or business intelligence software such as Power BI or similar platform.
  • Experience with data integration platform SQL Server Integration Services, a plus.
  • Experience using or desire to learn statistical computer languages such as R or Python for text analysis and data mining a plus

Meet our annual partners

Our Annual Partners share a common goal: to connect, strengthen and champion the technology community in our region. A Technology First Annual Partner is an elite member leading the support, development and expansion of Technology First services. In return, Annual Partners improve community visibility and increase their revenue. Make a difference in our region and your business. 

Become a partner

Technology First

1435 Cincinnati St, Ste 300, Dayton Ohio 45417

© Technology First, All Rights Reserved