- Write programs of moderate complexity using various computing and scripting languages.
- Debug computer program code.
- Develop and modify interfaces for existing applications and systems while maintaining the integrity of data and processes.
- Develop components for new multi-faceted computer systems and revise existing systems comprised of numerous application components.
- Work with and understand complex data models and databases for the most effective and efficient organization of data based on processing requirements.
- Contribute to the review, development, and modification of best practices and technical solutions.
- Communicate project, issue, and system status to project leads and managers.
- Perform load and stress testing to anticipate the impact of application usage on the production service environment.
- Complete calculations used to estimate various capacity requirements such as database size.
- Search and gather information from a variety of sources including computer applications, internet, and legislative documentation and consolidate relevant information to complete environmental scans.
- Develop time and cost estimates for project assignments.
- Work cooperatively with others to effectively determine information and understand business requirements of a complex nature.
- Deliver presentations to team members as it relates to project work.
- Exchange technical information with colleagues during the application development process.
- Explain and exchange technical concepts and information to clients in a non-technical manner to ensure that the customer comprehends the issue.
- Provide advice to customers on alternative and recommended approaches to computing system solutions for meeting their business requirements.
- Provide production service implementation training to clients.
- Provide expertise and working knowledge of application components such as internet, intranet, mainframe, personal computer, and database structures. Interpret complicated technical program specification documents, translate, and develop into application code.
- Prepare and review operations documentation, training materials, and timelines.
- Provide Level III post implementation support to users regarding technical issues.
- Take ownership of technical issues by identifying underlying problems, analyzing potential solutions and implementing system resolutions, including workarounds.
- Apply and enforce department change control policies and procedures.
- Participate in all phases of testing including, but not limited to, system, integration, acceptance, regression, and performance.
- Manage defects identified during all phases of a project.
- Resolve problems in the test, production implementation, and post-implementation phases in coordination with other technical and business groups.
- Communicate testing results to others.
- Maintain information technology process flow, methodology, and control documentation.
- Update and maintain knowledge of application components such as, internet, intranet, personal computer, and database structures.
- Remain current with relevant development and project methodologies.
- Remain current with frequent updates and changes to technology.
- Work with project leads and managers to prioritize and schedule issues resolution.
- Remain current with security policies and procedures and work with System Administrators to implement security changes.
- Facilitate effective dialog between technical staff.
- Read and understand complex Business Process Diagrams and develop basic (Level II) models.
- Read and understand a complex project plan and develop simple project plans.
- Understand the different levels of testing and develop simple use cases and test scripts.
- Follow a test script and document defects.
- Acquire and maintain a basic understanding of Business Intelligence and Data Warehousing principles.
- Develop simple queries using basic Business Intelligence tools.
- Provide recommendations to supervisor.
- Perform a range of varied work activities in a variety of structured environments.
- Understand and use appropriate methods, tools, and applications to complete work tasks.
- Demonstrate a rational and organized approach to work and identify development opportunities.
- Plan, schedule, and monitor own work within short time horizons.
- Absorb technical information when it is presented systematically and apply it effectively.
- Organize time, work and resources to accomplish objectives in the most effective and efficient way.
- Use measurement methods to monitor progress toward goal attainment, tenaciously working to meet or exceed those goals, while deriving satisfaction from the process of goal achievement and continuous improvement.
- Ensure that the internal and external customer perspective is a driving force behind decisions and activities.
- Follow service practices that meet customers' and University needs.
- Interact with others in a way that gives them confidence in one's intentions and those of the University.
- Work collaboratively with others to achieve departmental and institutional goals. Actively participate as a member of a team to move the team toward the completion of goals
- Bachelor's degree in Computer Science, Business, or a related field of study.
- Requires 2 years of relevant experience.
- Reporting tools ie XML Publisher, Crystal Reports
- PL/SQL against Oracle 19 on Windows and Unix environments
- Writing and executing SQL statements
- Knowledge and skills related to BI development and data modeling
- Working knowledge of Oracle database environment and relational database technology
- System development life cycle(SDLC), handling sensitive data and promotion from development to production
- Experience with a fundraising database or CRM - direct experience with Ellucian Advance Web is preferred.
- Experience with MS SQL Server, C, Javascript, CSS, XML, TOAD knowledge
- No formal superision of others is required
Developer (I) - Hamilton, Canada - McMaster University
Description
Job DescriptionUniversity Advancement (UA) at McMaster University is an integrated department that encompasses the areas of Development, Alumni Engagement, Stewardship, and Advancement Services & Operations, working collaboratively with McMaster's Faculties and units across campus to build relationships and resources on behalf of the University.
Advancement Services & Operations is a service-oriented and collaborative team that helps enable UA's mission by providing high-quality, client-focused support and tools to all of our stakeholders in the areas of human resources; budgeting/finance; gift processing and biographical records; IT and systems; research and prospect analytics; and administration for the Office of the Vice-President.
Within this team, the IT/Systems unit plays a key role in supporting the IT and data needs of our UA colleagues. We maintain the various applications that support our fundraisers, alumni officers, and stewardship & advancement services professionals. We also play an integral role in data maintenance and governance within our alumni and donor database.
Job Summary
The Developer (I) programs and develops applications software that meet specified client and business requirements. Provides input into the planning of the work packages based on expertise and understanding of the current applications and systems and the impact that they will have on the current production environment. Works under routine supervision without frequent reference to others and uses minor discretion to resolve various problems and inquiries. Specific instruction is given and work is frequently reviewed.
Purpose and Key Functions
Requirements
Assets
Supervision