Systems Developer/Integrator

Summary

WORKING FOR THE CITY OF MCKINNEY

Working for the City of McKinney is more than a job. It is an opportunity to make a meaningful difference in the lives of others. It is also an opportunity to have a hand in the development of one of the fastest growing communities in the nation. In 2014, our community was named "The #1 Best Place to Live in America." Although proud of that honor, everyone on our team is committed to making McKinney an even better place to live, work and raise a family. That's why we exist.

OUR CORE VALUES

City of McKinney employees work hard and at a very fast pace. However, we also look after and support one another. All of us are guided by four employee-inspired values - Respect, Integrity, Service, and Excellence (RISE). We are also supported by servant-based leaders who foster and support a healthy, family-oriented culture. All new employees are expected to embrace and live by our core values and commit to helping us sustain our exceptional work environment as a high performance organization (HPO).

SUMMARY OF POSITION

Our organization is looking for a dynamic - out of the box thinker, who has experience working with modern technologies. This individual will be given professional and creative latitude in performing functions which include systems integration, custom development, database interaction, and data analytics. It is our goal to become one of the leaders in municipal technology delivery and our intent to hire competent, knowledgeable, dynamic, self-motivated, and action orientated talent to help us meet our goal. This is the opportunity for the right individual to use creativity to deliver solutions that have a direct impact on one the country's top City's.

Essential Functions/Knowledge, Skills, & Abilities

GENERAL EXPECTATIONS FOR ALL EMPLOYEES

In order for us to continue to achieve our primary function of making McKinney a better place to live, work, and raise a family, we hold these expectations for all employees.

• Learn and demonstrate an understanding of how team, department, and City goals are interconnected.

• Contribute to a positive work culture.

• Ability to assess his/her work performance or the work performance of the team.

• Contribute to the development of others and/or the working unit or overall organization.

• Ability and willingness to work as part of a team, to demonstrate team skills, and to perform a fair share of team responsibilities.

• Ability to continuously learn and develop through a mix of internal and external training opportunities, and if applicable, encourage subordinates to do the same.

ESSENTIAL DUTIES AND RESPONSIBILITIES

• Defines solution objectives by analyzing user requirements, system features, and functionality.

• Designs and develops user interfaces to internet/intranet applications by setting expectations and features priorities throughout development life cycle; determining design methodologies and tool sets; completing programming using languages and software products; designing and conducting tests.

• Recommends system solutions by comparing advantages and disadvantages of custom development and commercial off the shelve (COTS) alternatives.

• Integrates applications by designing database architecture and server scripting; and establishing connectivity with network systems, search engines, and information servers using API.

• Creates a variety of customer solutions by integrating enterprise applications with custom scripting and development.

• Completes applications development by coordinating requirements, schedules, and activities; contributing to team meetings; troubleshooting development and production problems across multiple environments and operating platforms.

• Establishes and maintains effective working relationships.

• Supports users by developing documentation.

• Modifies custom tools and engages in new tool development.

• Enhances organization reputation by accepting ownership for accomplishing new and different requests; exploring opportunities to add value to job accomplishments.

• Develops, maintains and enforces data resource management standards and procedures; develops standards for maintaining data integrity and security; develop strategies for data recovery.

• Develops and implements large or complex computer software applications; designs, configures and tests system software; debug or troubleshoot user software problems.

• Provides advanced technical support to systems staff and system users; mentors staff in resolving application software problems.

• Works towards maintaining awareness of new technologies and advances in the profession; reads professional literature; attends workshops and training sessions as appropriate.

• Suggests and maintains departmental standards, procedures, and documentation.

• Complies with all written City policies and procedures.

• Adheres to assigned work schedule as outlined in City and department attendance policies and procedures.

• Performs other related duties and responsibilities as required.

KNOWLEDGE, SKILLS, ABILITIES, AND BEHAVIORS

• Ability to embrace and embody the City's core values of Respect, Integrity, Service, and Excellence (R.I.S.E.).

• Ability to communicate effectively with peers, supervisors, subordinates, and people to whom service is provided.

• Ability to produce desired work outcomes, including quality, quantity, and timeliness.

• Ability to plan and organize work, time, and resources, and if applicable, that of subordinates.

• Experience with large scale applications such as (ERP, CRM, Land Management).

• Experience integrating 3rd party vendor's product into corporate enterprise.

• Utilize programming languages like JavaScript, Java, HTML/CSS, TypeScript, SQL, Python, a RDBMS and NoSQL databases,

• Extensive knowledge of Scripting languages such as Powershell.

• Strong SQL skills: stored procedures, functions, views, triggers, etc.

• Understanding and experience with ETL methodologies

• Experience designing RESTful and SOAP API

• Demonstrates ability to solve problems using the best technology available.

• Ability to evaluate client business requirements and implement information technology solutions.

• Troubleshoot hardware, network, and software application or integration problems.

• Create and maintain technical documentation.

• Support QA phase by tracking and repairing any defects.