The Data Analyst – Intermediate is responsible for the creation and maintenance of spreadsheets, databases, manuals, and system data calls used to support the business unit and/or enterprise. This position will compile data from multiple sources using Query tools to create dashboards, integrated views, and reports that can be used to drive decision making as well as identifying improvement opportunities.
Requirements
- Strong working knowledge of COGNOS business intelligence products such as Analysis Studio, Report Studio, Query Studio, Dashboards and Cognos BI Version 8 or equivalent Business Intelligence tools.
- Proficient level of knowledge of Microsoft Office Suite, specifically Excel and Access.
- Ability to perform advanced analysis on business data and deliver reports to management with a high level of quality and attention to detail.
- Professional experience and demonstrated ability to manipulate and analyze data using database tools such as Microsoft Access, ACL, SQL Server Management Studio or Advanced Query Tool, data warehouse, audit automation or data mining tools.
- Demonstrated ability to solve problems through analytical approaches.
- Experience retrieving data from Microsoft SQL Server, DB2, Oracle or comparable relational databases.
- Experience with SQL queries and working in a cloud data environment.
Responsibilities
- Utilize business systems and database tools to define, extract, create queries as well as analyze and compile statistical data to prepare various reports, charts or written summaries for management to support recommendations or validate results.
- Create, analyze, and maintain spreadsheets, relational databases, dashboards and reports used to measure, monitor and manage results of projects and assignments.
- Analyze and summarize data trends/performance using data from internal sources for various audiences including Citizens’ management teams and outside parties – frequency may be on a monthly/quarterly/annual basis.
- Serve as liaison between IT and business units for policy data coordination.
- Utilize knowledge of business systems and database tools to analyze results of projects and assignments.
- Participate in the maintenance and upkeep of standard reporting documentation and documented dependencies.
- Collaborate with business unit and various levels of staff including Executive Leadership, as directed, to evaluate work processes and identify enhancements to system functions or processing to facilitate improved turn-around times and performance risk and controls.
Other
- Models ethical behavior and executes job responsibilities in accordance with Citizens' core values, ethics, and information protection policies.
- Excellent verbal and written communication skills and ability to effectively interact with both internal and external contacts in person, by e-mail, or over the phone.
- Excellent interpersonal and relationship building skills, including ability to work in a team environment.
- Ability to manage multiple assignments and projects simultaneously with high level of attention to detail and accuracy.
- Strong quantitative, data analysis, analytical, and report writing skills.
