Systems Developer/Integrator

WORKING FOR THE CITY OF MCKINNEY
Working for the City of McKinney is more than just a job; it’s a chance to make a meaningful impact in the lives of others. Proudly recognized on the Top Workplaces USA list by USA TODAY, our team is dedicated to making McKinney one of the best places to work, live, and raise a family. Join us and start making a difference today. 
 
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.

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.

• 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.     

• 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.

MINIMUM QUALIFICATIONS

Any work related experience resulting in acceptable proficiency levels in the below Minimum Qualifications is an acceptable substitute for the below specified education and experience requirements. Bachelor’s degree from an accredited college or university with major course work in computer science, information systems or a related field or two (2) years of experience in software development, application or systems programming or related position; Four (4) years of experience in application and integration development using with C#, .Net and Python. 

PREFERRED QUALIFICATIONS

• Proven experience as a SharePoint Developer.
• JavaScript frameworks (jQuery, Ext JS) as well as server-side JavaScript (node, V8).
• Understanding of Big Data functions and the application of functions (Mapping, Shuffling, Reducing).
• Native Mobile Application Framework Experience (PhoneGap, Titanium).
• Familiarity with Automation and Testing (unit, file transfer, integration, usability).
• Experience with HTML/5, CSS, JavaScript (developing a cross-browser compatible website), and Python.
• Knowledge of operational characteristics of various computer systems, applications, peripheral equipment, multiple operating systems and platforms. 
• Knowledge of data modeling, database design and administration.
• Knowledge of database systems, relational and other structures, and system architecture.
• Exposure to AS400.

• Must pass a drug screen and background check.
• Must have Class C Texas Driver’s License.

PHYSICAL DEMANDS
Tasks involve the ability to exert light physical effort in sedentary to light work, but which may involve some lifting, carrying, pushing and/or pulling of objects and materials of light weight (25 pounds).  Tasks may involve extended periods of time at a keyboard or workstation.   Some tasks require visual and sound perception and discrimination and oral communications ability.
 
WORK ENVIRONMENT
There is limited exposure to environmental conditions.
 
 
The above statements describe the general nature and level of work being performed as of the date of preparation and approval.  They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of the position.  Employees holding this position will be required to perform any other job-related duties as requested by management. The job description does not constitute an employment agreement between the employer and employee, and all requirements are subject to possible modification to reasonably accommodate individuals with disabilities.
 
The City of McKinney is an equal opportunity employer (EOE) committed to an alcohol / drug free workplace and to providing equal opportunities regardless of age, race, color, gender, religion, national origin, marital status, veteran status, disability or any other legally protected status.