Systems Developer/Integrator

  • City of McKinney, TX
  • McKinney, Texas
  • Mar 07, 2024
Full Time Information Technology and Communication Services
  • Salary: $80,906.59 - $117,314.08 Annually USD

Job Description

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.


Required Qualifications

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.

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


Physical Demands/Supplemental

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.

The City offers a full complement of benefits:

Health Insurance
  • Medical, Dental, Vision Insurance
  • Health Savings Account (HSA), Flexible Spending Medical and Childcare Account (FSA)
  • Mental Health Care and Employee Assistance Program (EAP)
  • City-paid and VoluntaryLifeInsurance
  • City-paid and VoluntaryLong Term Disability Insurance
  • Supplemental Insurance through Aflac
Additional Benefits
  • Legal Services through Legal Shield
  • Tuition Reimbursement (up to $10,000 per year)
  • Wellness Program (earn up to $600 per year)
Retirement
  • Texas Municipal Retirement System (TMRS)
    • Mandatory 7% employee contribution
    • City match 2:1
    • 5 year vesting
    • Retire after 20 years of service, or age 60 with 5 years of service
457(b) Deferred Compensation PlansPaid Time Off (PTO)
  • Paid Vacation (80 hours per year for new hires; tieredincreases after 2 yrs)
  • Sick Leave (135 hours per year for yourself and immediate family)
  • Paid Parental Leave (80 hours for birth, adoption, or placement of a child in foser care)
  • Ten Paid Holidays
  • Personal Day
  • Optional compensatory time for hourly employees
  • Compensatory time for salaried employees

For more detailed information, please see the City of McKinney's summary of benefits .

Closing Date/Time: Continuous

Job Address

McKinney, Texas United States View Map