Mainframe Analyst

Reporting & Data Analyst

The Reporting & Data Analyst designs and develops reporting & analyses to support Managed Services customers and coworkers. This role focuses on providing the best solutions through useful and accurate reporting and dashboards based on a thorough understanding of data, systems, and reporting tools.

What you will do:

• Report Generation: Create weekly, monthly, bi-monthly, quarterly, and annual reports based on management requirements for content, frequency, and formatting.
• Design standardized reporting formats for utilization within department, incorporating system data and other practice specific requirements.
• Perform ad-hoc reporting utilizing reporting systems, based on manager and team needs.
• Interact with business stakeholders to help identify and develop new reports or updates to existing reports which will enable the business to take a deeper look at data and increase productivity.
• Troubleshoot and improve existing reporting and data solutions.
• Implement and maintain testing processes to ensure data quality in reporting.
• Perform analysis of data being shared and design solutions using best practices.
• Lend expertise to others in the department as necessary to help resolve process or reporting issues.
• Design and develop reporting and analytics to support the key internal clients.
• Document and maintain Standard Operating Procedures as required.

What we expect of you:

• Bachelor's degree in business, plus 3 years of experience with Microsoft Excel advanced functions to include: formulas, V-lookups, pivot tables, and data manipulation, OR 7 years of experience with Microsoft Excel advanced functions to include: formulas, V-lookups, pivot tables, and data manipulation.
• Experience with VBA, and/or Excel to develop analytical customer solutions.
• Experience with MS Office applications (Word, Outlook, PowerPoint).
• Applicants should demonstrate solid attention to detail with a penchant for accuracy.
• Demonstrated commitment to quality, accuracy, and completeness in reporting.
• Exceptional oral and written communication skills and the ability to deal effectively with a variety of internal customers.
• Strong customer focus – committed to building and maintaining strong working relationships with management and staff.
• Ability to balance multiple priorities simultaneously and adapt to the changing needs of the business while meeting deadlines, especially in a fast-paced environment.
• Adaptable, dependable, and proactive in determining managers' needs.
• Excellent analytical skills. Demonstrated ability to understand data findings, draw conclusions, and develop actionable recommendations.
• Demonstrated time management skills with the ability to meet deadlines while maintaining strong attention to detail.
• Ability to compute, analyze and interpret complex statistical data and/or to develop forecasts and other statistical reports as needed.
• Proven ability to shift priorities quickly.
• Preferred qualifications, all a plus:
• SAS, Crystal Reports, IBMi experience, Mainframe.
• Experience with SQL, views, functions, indexes, and query tuning.
• Working knowledge of ITS business data and processes.
• 2 years of SQL experience to include: query writing, data extraction and manipulation.
• Understanding a relational database.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to View email address on click.appcast.io.