To advance the college’s mission, vision, principles, values and strategic initiatives through continuous improvement decisions. GENERAL JOB SUMMARY:
The Systems Reporting Analyst I position is part of a project team in a matrix management arrangement to design, code, deliver, and support SQL based reports, data, and dashboards used by the college to make informed decisions. The analyst works with various departments and tactic groups across the college to understand their data needs and creates a solution. The Systems Reporting Analyst also has maintenance and production support duties, and creates system documentation. This position is responsible for supporting information needs for Kirkwood’s mission.UNIVERSAL CORE COMPETENCIES: Advocate for Continual Improvement- empowering each other to identify opportunities for excellence. Collaborate with Mutual Accountability- working together with a willingness to take ownership and account for our actions. Champion Service- anticipating needs and create a welcoming, diverse, and inclusive environment. Perseverance- commitment to excellence even in the face of adversity or delay in achieving success. Lead- regardless of title, through positive influence.
DUTIES/RESPONSIBILITIES:Work proficiently in a Microsoft SQL Server Database environment to:Create and run SQL queries in a proficient mannerBuild stored proceduresCreate SQL reports in an SSRS development environment.Generate routine and ad hoc reports.Create and update dashboards in Tableau and iDashboards.Present complex information in an understandable and visually compelling manner.Perform basic statistical analyses for projects and reports.Unit test reports and support UAT.On analyst-led projects, business analysis and requirements elicitation.Grant and remove user access to reports according to security policies.In collaboration with others, develop and maintain databases and data systems necessary for projects and department functions.Acquire and abstract primary or secondary data from existing internal or external data sources.Import/Export data via SSMS.Distribute data to outside parties following FERPA rules.Adhere to data security and privacy policies.Demo reports in small to medium sized audiences.Perform other related work duties as assigned.
The Systems Reporting Analyst must be customer focused, extremely attentive to details, team oriented, flexible, self-directed yet able to take direction from lead programmers, organized, and should be a self-starter who can work with minimal supervision. The role requires strong verbal and written communication skills with both technical and non-technical audiences. PERFORMANCE EXPECTATIONS:Be able and willing to represent the College in the most positive manner with prospective, former and current students, clients, suppliers and the community we serve.Must possess excellent customer service skills.Must be self-motivated and energetic, with strong computer skills, and proven success working within a team-based environment.Must possess communication skills and personality to work in a team environment.Must pay attention to details. Must be able to work independently, accept responsibility with limited supervision, manage multiple tasks to completion, and work with frequent interruptions.Must have a good understanding of the software development process.Must possess excellent planning, organizational, and presentation skills.Strong customer service orientation, including excellent planning, organizational, communication, interpersonal and presentation skills. Understand how to successfully communicate information to both technical and non-technical audiences.Ability to make oral and written reports and presentations in a concise and effective manner.Ability to interpret questions, identify problems, propose solutions and process improvements, and read reference manuals.Seek and participate in development opportunities surpassing required training.Be able to establish relationships within the College and the community that will further promote future opportunities for Technology based training programs.Welcome, value, and nurture people of all backgrounds, perspectives, and experiences, as well as support and promote an environment that accepts differences. The statements contained herein reflect general details as necessary to describe the essential job duties/responsibilities and performance expectations of the job, which should not be considered an all-inclusive listing of work requirements. Individuals may perform other duties as assigned.
PHYSICAL ACTIVITIES WITH/WITHOUT REASONABLE ACCOMMODATION:
Position involves working in an office setting. Occasional (10-33%) standing, pushing, pulling and grasping. Frequent (34-66%) reaching and viewing a computer and other types of close visual work. Constant (67-100%) sitting, walking, repetitive motion, talking and hearing.MINIMUM QUALIFICATIONS:
Associate’s or Bachelor’s Degree in computer science, information systems or related technical field or 2 years of programming experience in a professional capacity. PREFERRED QUALIFICATIONS, LICENSES, CERTIFICATIONS, OR REGISTRATIONS: 1 to 2 years’ experience with writing SQL and database utilization.Knowledge of Microsoft SQL Server.Understanding and experience using integrated databases in an educational environment.Microsoft Visual Studio experience.Experience creating dashboard reports utilizing Tableau, iDashboards or other dashboarding tool.Rudimentary experience in web development in HTML, PHP and Web APIs.Rudimentary knowledge of statistical analysis and data analytics.Rudimentary knowledge of python.Must have good understanding of the software development lifecycle process. EEO STATEMENT:
Kirkwood Community College shall not engage in nor allow unlawful discrimination against any employee or applicant for employment. This includes all employment practices, hiring practices, and unwelcome harassment of applicants or employees based on race, color, national origin, creed, religion, sex, sexual orientation, gender identity, age, disability, genetic information or actual or potential parental, family, marital status or veteran status. If you have questions or complaints related to compliance with the policy, please contact the Vice President of Human Resources at Kirkwood Community College, 313 Kirkwood Hall, 6301 Kirkwood Blvd., SW, Cedar Rapids, IA 52404, Telephone: 319-398-5572, Email: [email protected]
or the Director of the Office for Civil Rights U.S. Department of Education, Citigroup Center, 500 W. Madison St., Suite 1475, Chicago, IL 60661-7204, Telephone: 312-730-1560, Fax: 312-730-1576, Email: [email protected]