Senior Systems Reporting Analyst

Location
Cedar Rapids, IA
Posted
Jun 09, 2021
Administrative Jobs
Technology, Analysts & Programming
Employment Type
Full Time
Institution Type
Community College
JOB GOAL:

To advance the college’s mission, vision, principles, values and strategic initiatives through continuous improvement decisions.


GENERAL JOB SUMMARY:

The Senior Systems Reporting Analyst position is part of a software development team with responsibility to design, write SQL 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, present prototype demonstrations, and create solutions. The Senior Systems Reporting Analyst also has mentoring and training responsibilities for junior staff members. There are also maintenance and production support duties, and system documentation requirements. 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:

  • Team Lead & mentor to Junior Developers.
  • Ability to lead large and small projects (Large is over 400 hrs and more than 1 team member).
  • Communicate and work with Senior Leadership.
  • Work proficiently in a Microsoft SQL Server Database environment to:
  • Create and run SQL queries in a proficient manner.
  • Build stored procedures.
  • Create SQL reports in an SSRS development environment.
  • Create and update dashboards in Tableau and iDashboards.
  • Generate routine and ad hoc reports.
  • Present complex information in an understandable and visually compelling manner.
  • Perform complex statistical analyses for projects and reports.
  • Unit test reports and support UAT.
  • On analyst-led projects, business analysis and requirements elicitation.
  • Second level support for issues that may occur with user report access and creation.
  • 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.
  • In collaboration with others, develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality.
  • Assist on hiring committee for new team members.
  • Perform other related work duties as assigned.
  • 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 7 years of programming experience in a professional capacity.
  • 7+ years’ experience with writing SQL code and database utilization.
  • PREFERRED QUALIFICATIONS, LICENSES, CERTIFICATIONS, OR REGISTRATIONS:

  • Knowledge of Microsoft SQL Server.
  • Understanding and experience using integrated databases in an educational environment.
  • Microsoft Visual Studio experience.
  • Experience creating dashboards 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 AA/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]