Programmer / Analyst

Job Posted 1/14/2022
Northwestern Michigan College
Traverse City, MI
United States
Category Engineering
Job Description
Programmer/Analyst
Category: Salaried Staff
Job Location: 1701 E. Front Street,
Traverse City, MI
Tracking Code: 1446-443
Position Type: Full-Time/Regular
Description
Northwestern Michigan College
General Information
Job Title: Programmer/ Analyst
Department: Information Technology Services
Posted: January 13, 2022
Anticipated Start Date: March 7 , 2022
FLSA Status: Exempt
Supervisor: Director of Administrative Systems
Benefits: Excellent https://www.nmc.edu/departments/human-resources/salaries-benefits/files/flexible-benefits-plan.pdf, including 4 weeks paid vacation, medical, dental, paid sick leave, and tuition benefits. For more details about benefits, go to https://www.nmc.edu/hr/ and click on Salaries and Benefits, or request a copy from the Office of Human Resources. This position may be eligible for relocation pay (5% of starting salary).
Position Summary
The position develops software solutions to meet the needs of the college, including analyzing, designing, and implementing new software as well as providing training, documentation, and end-user support.
Qualifications
Required:
• Bachelor's degree
• Between 2-5 years of experience
• Oracle or similar large-scale database support
• UNIX and Windows operating systems
• Web Development tools
Preferred:
• Experience using PL/SQL, SQR, SQL*Plus, Brio or other ODBC related database access tools
• Experience with Student and Financial software
• Microsoft Office applications
Essential Responsibilities
(Critical)Analyzes current problems or needs department(s) is experiencing, defines functional/technical requirements.
(Critical)Designs new systems and builds database tables and indexes using Oracle and relational database methodologies. Determines hardware requirements.
(Critical)Develops programs and software modifications using a variety of programming languages and the procedures to transfer and receive data among computer systems.
(Critical)Develops reports using SQR, PL/SQL, SQL*Plus, C or other programming languages.
(Critical)Creates procedures for transferring and receiving data from other computer systems.
(Critical)Works with a team to ensure that the implementation project is successful, from project management through training and evaluation.
(Critical)Manages software maintenance and upgrades to ensure efficient operations within government guidelines, ensuring smooth implementation through effective testing and user training and documentation.
(Critical)Customizes software and systems according to the needs of the departments and clients, ensuring customization integrity throughout upgrades and modifications.
(Critical)Reviews practices and policies to ensure security.
(Critical)Investigates and solves problems as they arise, working with vendors as necessary.
(Critical)Works with Technical System Support staff to establish and maintain appropriate user access to programs and data and to obtain and document the necessary authorization for such access.
(Critical) Provides documentation and training for end-users.
(Very Important)Assists with the evaluation and purchase of new software.
(Very Important)Maintains own knowledge and remains current in the field.
Foundational Competencies
Ethical Behavior and Integrity
Displays honesty, trustworthiness, and ethical behavior. Earns respect. Behaves in a straightforward manner with others with no hidden agendas. Builds trust and credibility through reliability and authenticity. Leads by example; words and actions are consistently aligned.
Commitment to Lifelong Learning
Actively pursues learning and development. Stays current in the content area, acquiring and refining technical and professional skills.
Commitment to Quality Service, Responsible Stewardship, Continuous Improvement
Displays a commitment to excellence and to providing quality service to learners, coworkers, or others they serve. Consistently seeks feedback and looks for ways to improve service, promote quality, and make effective use of college resources.
Creating/Contributing to a Culture of Innovation and Thoughtful Risk-taking
Creates/contributes to an environment of safety and trust. Seeks to solve problems rather than affix blame. Willing to experiment and learn.
Agility/ Adaptability/Tolerance for Ambiguity
Easily adjusts to organizational and environmental changes; adapts responses and tactics to shifting or evolving situations; deals effectively with ambiguity and uncertainty.
Valuing All People
Genuinely interested in others. Shows concern and empathy for others. Shows patience, understanding, and acceptance of people with varied backgrounds and perspectives. Treats learners, coworkers,
and direct reports respectfully and fairly.
Collaboration/Teamwork
Actively and enthusiastically works with others to achieve a shared common goal. Gives credit and recognition to those who have contributed. Shares information and own expertise with others to enable them to accomplish group goals. Creates a sense of belonging in the team and a culture of inclusion. Collaborates across boundaries. Looks at problem solving at the institutional level (not just in own area or department). Open to sharing resources, working with other departments and organizations.
Accountability/Personal Responsibility
Meets commitments and keeps promises; gets things done. Acknowledges and learns from mistakes. Holds self and others accountable. Takes responsibility for achieving goals.
General Competencies
Building Effective Relationships — Proficient
Importance: Very Important
Relates well with all kinds of people in a variety of situations. Develops and maintains effective communication and relationships. Demonstrates understanding, friendliness, courtesy, tact, and empathy to others. Is approachable; makes time for others. Is sensitive to cultural diversity, race, gender, disabilities, and other individual differences. Excellent interpersonal skills; understands how he/she is perceived by others; reads a social situation and responds appropriately; adjusts own behavior in response to others' non-verbal cues; understands why people and groups behave the way they do; gives constructive feedback in a way that produces positive change rather than resentment or anger; provides direct, specific feedback respectfully and in a timely manner.
Communications / Active Listening — Proficient+
Importance: Critical
Has good sense of who needs to know what and keeps others informed. Communicates in a clear, concise, organized, and compelling manner. Gives others their full attention; listens without interrupting. Seeks to understand others' points of view. Interprets both the words spoken and the non-verbal cues used by others. Accurately hears implied as well as expressed messages; accurately interprets non-verbal cues; communicates more complex information effectively; adjusts vocabulary and approach to improve understanding; speaks and/or writes in a well-organized, clear, and concise manner.
Global Awareness / Internationally Skilled — Basic+
Importance: Very Important
Understands the complexities and interdependency of world events and issues. Understands one's own culture and history in relationship to others. Is open to new opportunities, ideas and ways of thinking. Is
self-aware about identity and culture; demonstrates sensitivity and respect for differences. Demonstrates
sensitivity and respect for cultural differences.
Strategic Understanding / Leadership — Proficient
Importance: Critical
Explains how their role supports NMC's mission and vision. Recognizes opportunities to help the organization accomplish its goals. Considers a broad range of internal and external factors in establishing goals and priorities. Consistently ensures a fit between individual or group actions and the organizational mission/strategy. Identifies the trends in the world and within higher education that will impact the organization; thinks broadly, placing current task or issue in the context of long-term implications; considers the impact of decisions on areas outside their own.
Functional Competencies
Business Knowledge / Business Sense / Understands How Business Works (Generic) — Proficient
Importance: Very Important
Understands NMC's financial model—the elements that affect NMC's financial viability/sustainability. Knows how businesses work. Knowledgeable about how policies, practices, trends, technology, and information affect an organization. Knows the competition. Is aware of how strategies and tactics work in the marketplace. Evaluates and reacts to current market conditions; sees how trends in one area impact other areas; sources and implements industry best practices; looks for ways to build external awareness within the organization.
Computer Languages (Information Technology) — Proficient+
Importance: Critical
Knowledge of computer languages and their applications to enable a system to perform specific functions. Independently uses one or more computer languages and associated applications to enable moderately complex functions. Reads and interprets an application system design and program specifications. Develops structured programming specifications.
Consulting Skills (Information Technology) — Proficient
Importance: Critical
Applies listening and questioning techniques to identify issues and to gather related information in order to provide advice and make recommendations. Collaborates with others to resolve issues or problems, including technical requirements, application design, and performance issues, etc. Uses open-ended questions to establish real issues employees or managers need to address; identifies and clearly communicates appropriate standards, policies and procedures that need to be applied; suggests alternatives where possible and makes recommendations for effective resolution or solutions to moderately complex problems.
Data Management (Information Technology) — Proficient
Importance: Very Important
Knowledge of the principles, procedures, and tools of data management, such as modeling techniques, data backup, data recovery, data dictionaries, data warehousing, data mining, data disposal, and data standardization processes. Uses one or more data management techniques independently, including modeling, data backup, data recovery, data dictionaries, data warehousing, data mining, data disposal, or data standardization.
Database Administration (Information Technology) — Proficient
Importance: Very Important
Knowledge of the principles, methods, and tools for automating, developing, implementing, or administering database systems. Automates, develops, implements, or administers database systems. Sets access controls and constraints on permissible values. Interprets and applies standards and procedures for data administration.
Hardware (Information Technology) — Proficient
Importance: Important
Knowledge of the specification, uses, and types of computer or computer-related equipment. Identifies proper function of hardware in the use of work-related technology. Participates in the implementation of new hardware platforms and products. Installs and supports hardware equipment. Performs routine maintenance of hardware.
Information Assurance (Information Technology) — Proficient
Importance: Very Important
Knowledge of methods and procedures to protect information systems and data by ensuring their availability, authentication, confidentiality, and integrity. Understands and applies information assurance concepts (for example, firewalls, PKI, systems certification and accreditation, security vulnerability testing, SSL, IPsec, VPN's) and their impact on the organization. Performs moderately complex procedures to protect information systems and data. Understands the laws, regulations, and procedures that impact information systems.
Project Management (Information Technology) — Proficient
Importance: Very Important
Knowledge of the principles, methods, or tools for developing scheduling, coordinating, and managing projects and resources, including monitoring and inspecting costs, work and contractor performance. Develops systematic, detailed action steps for completing projects sets measurable checkpoints; anticipates obstacles; develops contingency plans. Communicates project progress and plans.
Quality Assurance and Software Testing (Information Technology) — Proficient+
Importance: Critical
Defines quality assurance process and all steps required to ensure successful testing of applications, enhancements, and patches. Performs testing for all but most complex applications, enhancements and patches; guides the process for software QA testing; tracks completeness and timeliness.
Requirements Analysis (Information Technology) — Proficient
Importance: Very Important
Knowledge of the principles and methods to identify, analyze, specify, design, and manage functional and infrastructure requirements; includes translating functional requirements into technical requirements used for logical design or presenting alternative technologies or approaches. Examines user requirement inputs for completeness and uniqueness. Coordinates analyst-customer meetings to discuss and capture preliminary system needs. Updates data in automated tools to capture and organize requirements.
Software Development (Information Technology) — Proficient
Importance: Critical
Knowledge of the principles, methods, and tools for designing, developing, and testing software in a given environment. Proficient: Independently diagnoses and documents software problems for a specific environment. Assists in developing test parameters for preliminary software evaluation.
Systems Integration (Information Technology) — Proficient
Importance: Important
Knowledge of the principles, methods, and procedures for installing, integrating, and optimizing information systems components. Identifies major issues and considerations for a successful system integration. Consults to line areas on data, technology, and application integration issues.
Leadership
Scope
Supervises a single work unit within a department, or is an
intermediate-level professional individual contributor.
Subordinates
Direct:
Indirect:
Activities
Share special or technical information with others
Guide or facilitate projects
Bring commitment and drive into the workplace.
Serve as a spokesperson or advocate
Plan work
Tools and Equipment
Calculator
Copy Machine
Desk Top Computer
Lap Top Computer
MS Excel
MS Project
MS Word
Printer
Telephone
Work Environment
Lifting Activities
Most frequently lifted object: Under 10 lbs. lifted to waist level; carried 10-19 feet (Several times per day)
Heaviest object lifted: 20-29 lbs. lifted to waist level; carried 1-9 feet (Occasionally)
Non-lifting Repetitive Activities
Arm Movement (Several times per day)
Gripping (Several times per day)
Sitting (Continuously)
Standing (Several times per day)
Talking (Several times per day)
Typing (Several times per day)
Walking (Several times per day)
Writing (Several times per day)
Other Physical Demands
Prolonged visual work
Mental Demands
Complicated Planning
Exercising Independent Judgment
Performing Multiple Functions/Activities
Persuading Others
Other Challenges
Precise accuracy requirements
Production deadlines
Safeguarding organization assets and property
Contacts with Others
Internal Contacts
Employees in your own work unit or department — Purpose: Interact with or advise (Daily)
Employees in your function — Purpose: Share Information (Several times per week)
Managers in your function — Purpose: Share Information (Several times per week)
Senior executives in your function — Purpose: Share Information (Several times per week)
Managers in departments outside of your function — Purpose: Interact with or advise (Daily)
External Contacts
Vendors, Suppliers, Subcontractors — Purpose: Share Information (Once per week)
QUALIFICATIONS
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed in this job description are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
COMPUTER SKILLS
To perform this job successfully, an individual will have computer skills, including knowledge of and the ability to use the Internet, email, calendaring software, and word processing software.
LANGUAGE SKILLS
Ability to read, analyze and interpret the most complex documents. Ability to respond effectively to the most sensitive inquiries or complaints. Ability to write speeches and articles using original or innovative techniques or style. Ability to effectively present lectures and information to students and academic area leadership in a clear and understandable manner.
MATHEMATICAL SKILLS
Ability to calculate figures and amounts such as proportions and percentages. Ability to apply concepts of basic algebra.
REASONING ABILITY
Ability to apply principles of logical or scientific thinking to a wide range of intellectual and practical problems. Ability to deal with nonverbal symbolism (formulas, scientific equations, graphs, musical notes, etc.,) in its most difficult phases. Ability to deal with a variety of abstract and concrete variables.
PHYSICAL DEMANDS
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
While performing the duties of this job, the employee is occasionally required to stand; walk; sit; use hands to finger, handle, or feel; and smell. Walking and standing are required and sitting for long periods of time. Lifting up to 50 pounds and periodic heavy exertion may be required. Specific hearing and vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception, and the ability to adjust focus.
WORK ENVIRONMENT The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
While performing the duties of this job, the employee is occasionally exposed to outside weather conditions when traveling between campus buildings. The noise level in the work environment is usually quiet to moderate.
Non-Discrimination Policy Notice
Northwestern Michigan College is committed to a policy of equal opportunity for all persons and does not unlawfully discriminate on the basis of race, color, national origin, sexual orientation, gender, religion, disability, genetic information, height, weight, marital status or veteran status in employment, educational programs and activities and admissions. Read more at https://www.nmc.edu/about/policies/non-discrimination/index.html.
Michigan Law requires that a person with a disability or handicap requiring accommodation for employment must notify the employer in writing within 182 days after the need is known.
HOURS
This is a full-time 40+ hour per week position. Some nights and weekends may be required.
Some hybrid/telecommuting is possible as long as the candidate provides their own reliable internet source.
HOW TO APPLY
Applications must be submitted online at http://www.nmc.edu/jobs. The application deadline is Friday, February 4th, 2022, at 8 am EST.
This position will remain open until filled. For assistance call 231-995-2612 or 1-800-748-0566 x52612 or email mailto:hr@nmc.edu .
Special Instructions to Applicants Please submit a cover letter with your application. Official transcripts will be required of all finalists. Please email to hr@nmc.edu or mail to: Northwestern Michigan College Attention: Human Resources 1701 E Front Street Traverse City, MI 49686