Job Seekers
Post Resume
Find Jobs
Get jobs by email
Post Jobs
Find Resumes
Get resumes by email
Sr. Programmer/Analyst, Institutional Research (fully working remote)
Lake Michigan College in Benton Harbor, Michigan
Date Posted 02/17/2021
Employment Type Fulltime
Application Deadline Open until filled
  • This is a 40 hour per week position, with a summer schedule.

  • Supports the institution with data solutions, development of reports, and identifies project needs in order to assist in decision making to align with LMC mission and strategic plan.
  • Provides subject matter expertise in Cognos Analytics, Framework Manager, and Transformer solution architecture.
  • Senior level skills in building Reports, Dashboards, and Scorecards using IBM Cognos 11..
  • Gathers business requirements, analyzes data mapping, and outlines the design, development of reports using programming and analysis tools.
  • Functions effectively in a rapidly evolving environment with an ability to prioritize and handle multiple projects at once with efficiency and accuracy.
  • Identifies project needs and is comfortable controlling their own work destiny.
  • Demonstrates effective communication skills by providing clear, logical, and concise report documentation, project deliverables, and overall verbal/written communication.
  • Fully working remote.

    Essential Functions:
    1) Designs, develops, and deploys reporting solutions that leverage the Cognos tools utilized at LMC (Analytics, Excel Caf, Framework Manager, and Transformer).
    a. Develops and maintains reports using Cognos Analytics 11..
    b. Defines and follows Cognos development best practices.
    c. Develops and maintains Cognos dashboards and applies data visualization best practices.
    2) Provides system support for the Cognos environment (Cognos Administration for both the development and production environments).
    a. Manages data source connections and user accounts.
    b. Manages report security, folder security, and database row level security.
    c. Manages report schedules and report distribution.
    3) Works closely with the Director of Analytics and Programming and the IT Enterprise Solutions team to provide enterprise-level reporting, program assessment reporting, and federal or state compliance reporting (IPEDS, Perkins, etc.).
    a. Works with other IR team members to submit compliance reports for LMC by pre-determined deadlines.
    b. Works with the IT Enterprise Solutions team to develop SQL queries, custom database views, as needed for reporting.
    4) Works well with a variety of teams, particularly with gathering business needs and cross-departmental discussions, as well as within the IR/IT Team.
    a. Strategizes with other teams to create mutually beneficial reporting solutions.
    b. Coordinates with Banner Core Team members on user acceptance testing and production deployment.
    c. Works as a liaison with functional users, as a bridge of understanding related to technical documentation.
    d. Maintains strong working relationships at all levels across the institution.
    5) Clearly demonstrates sense of urgency and bias for action with the ability to work well under pressure and independently.
    6) Takes ownership of issues and opportunities, and works diligently to produce comprehensive solutions.

    Other Duties:

    Under the limited supervision of Dean of Accreditation, Planning, and Quality.

    Job Specifications:
    Bachelors degree is required, majoring in MIS, CIS, Computer Science or Data Analytics/Statistics preferred.
    Five or more years of experience in an educational institution is required.
    Five or more years of experience working with Cognos Analytics, Cognos Framework Manager, Cognos Transformer is required.
    o Motio, SPSS or SAS knowledge is desired.
    Five or more years of experience with Ellucian Banner table structures and creating custom reports is required.
    o Experience with Ellucian Degree Works table structures and creating custom reports is desired.
    Three or more years of experience with Oracle (12.x or 19c) SQL and PL/SQL programming is required.
    Three or more years of experience with SQL Server programming (Microsoft SQL Server 2012 and 2016), and associated data management tools is highly preferred.
    IBM certified designer or COGNOS Analytics Author vs11 certifications.
    The ability to write complex and nested SQL queries, and disseminate the information so it can be used by Cognos for reporting.
    Experience with Visual Basic .NET framework programming experience is desired.
    Experience with Atlassian tools Jira and Confluence for managing Help Desk tickets, Project Management tools, and Knowledge Base support is preferred.
    Some experience with AWS or Oracle Cloud is desired.
    Strong analytical, database, and communication skills.

    Grade: C14
    Salary Range:

    Special Instructions to Applicants:
    Due to necessary scheduling changes, our recruitment process is experiencing delays.

    Official College transcripts required upon hire.

    Open Date: 02/15/2021
    Closing Date:

    To apply, visit https://lmc.simplehire.com/postings/3488

    About Lake Michigan College
    Lake Michigan College is a community college in southwest Michigan. We have three campuses -two of which are located ten minutes from our namesakes breathtaking shoreline.

    Like other community colleges, we offer associate degrees, certificates, and even a baccalaureate degree. But what sets us apart from our peers is our seemingly limitless potential and our people - people who care deeply about our regions future and who are committed to student success and exemplary educational programs, strong alignments with both established and emerging industries, and productive partnerships with the communities we serve.

    Faculty and staff at LMC enjoy excellent benefits and a supportive and friendly work environment. LMC recently received a Capital Outlay grant from the State of Michigan and a new millage from the southwest Michigan community, so the colleges facilities will be getting innovative, sustainable upgrades in the next few years that will contribute to the comfort, productivity and collaborative environment for all employees.

    Living in Southwest Michigan
    Southwest Michigan attracts millions of tourists who come for our beaches, wineries, and nationally acclaimed golf courses. But many who visit, choose to stay for our great schools, low cost of living, and high quality of life.

    LMCs main campus is nestled in a watery and wooded wildlife sanctuary, yet its less than a half-days drive from major metro areas including Chicago, Milwaukee, Detroit, and Indianapolis.
*Please mention academicjobs.net to employers when applying for this job*
Academic Jobs
Academic Advertising
260 Peachtree Street, N.W.
Suite 2200
Atlanta, GA 30303
Google Plus
About Academic Jobs
Advertise Jobs
Contact Us
Site Map
Privacy Policy
Terms of Use
Resources / Links
Copyright © 2010 Academic Jobs - All Rights Reserved.