The City of Houston Hiring for IT Professional- Applications (SQL/ETL Developer) at Houston, Texas Full Time

IT Professional- Applications (SQL/ETL Developer)

Print (http://agency.governmentjobs.com/houston/job_bulletin.cfm?jobID=3431449&sharedWindow=0)

Apply

IT Professional- Applications (SQL/ETL Developer)

Salary

$90,961.00 – $95,000.00 Annually

Location

16930 John F. Kennedy Blvd., TX

Job Type

Full Time

Department

Houston Airport System

Job Number

27706

Closing

3/5/2022 11:59 PM Central

• Description

• Benefits

• Questions

POSITION OVERVIEW

Applications accepted from: ALL PERSONS INTERESTED

Division/Section: Information Technology / Technology Applications

Workdays & Hours*: Shift work, could include a Rotating Schedule – weekends and holidays

(*Subject to change)

DESCRIPTIONS OF DUTIES/ESSENTIAL FUNCTIONS

The Information Technology Division of the Houston Airport System (HAS) provides technology systems and information that enhances the passenger experience and empowers the Houston Airports to meet its mission and vision.

The IT Professional – Applications (SQL/ETL Developer) position builds data integration solutions using SQL, SSIS, ETL/ELT, AWS based cloud technologies (Lambda, Glue, etc.). This position supports and contributes to day-to-day data development and administration for HAS Digital Airport Platform and data architectures/integrations within HAS and provides customer support and technical issue resolution. The IT Professional – Applications investigates data errors/variances and derives solutions independently with appropriate follow-up monitoring, makes recommendations for optimal data extraction, manipulation, and integration methodologies based upon research and analysis and develops high-complexity integrated data sets to support analysis, data science, operation improvement, and decision support activities. The IT Professional – Applications becomes an expert and thought leader in HAS Digital Airport Platform and performs validation and ensures quality standards for high-complexity data sets created by fellow team members. This position works closely with data analysts, data engineers and vendors to understand and provide feedback on complex functional requirements, identifies gaps and technical limitations, proposes solutions and workarounds and formalizes solutions in technical design documents, followed by coding unit and regression testing. This position provides support for existing data interfaces, APIs and the development of outbound/bidirectional interfaces and data integration solutions and completes required implementation and validation checklists and documentation for new interfaces and upgrades. “Must be able to pass a criminal background check, obtain and maintain federally mandated security clearances where required.”

The IT Professional – Applications duties include but are not limited to:

SYSTEMS ANALYSIS & PROGRAMMING: Under general direction, formulates and defines system scope and objectives based on user needs. Develops and tests moderately complex applications by applying knowledge of programming or database techniques and computer systems. Devises or modifies procedures to solve moderately complex problems considering computer equipment capacity and limitations, operating time, and form of desired results. Prepares detailed specifications from which programs will be written. Analyzes and revises existing system logic difficulties and documentation as necessary. Ensures effectiveness of applications by performing preventive maintenance work; applies patches; performs upgrades.

CUSTOMER SERVICE: Provides technical assistance on moderately complex software issues. Serves as tier 2 support to resolve end-users problems. Evaluates user’s requests for new or modified application features. Determines feasibility, cost and time required, compatibility with current system and computer capabilities.

ADMINISTRATION: Prepares technical support documentation to describe application development, configuration, logic, coding and corrections. Reads manuals, periodicals, and technical reports to learn ways to develop programs that meet user requirements.

TEAM EFFORT: Contributes to team effort by accomplishing related results and performing related responsibilities as needed.

WORKING CONDITIONS

The position is physically comfortable; the individual has discretion about walking, standing, etc. Operates a motor vehicle. There are no major sources of discomfort, i.e., essentially normal office environment with acceptable lighting, temperature and air conditions. Significant time spent using computer display, keyboard, and mouse. Requires the ability to make closely coordinated eye/hand movements within very fine tolerance and/or calibration demands.

MINIMUM REQUIREMENTS

EDUCATIONAL REQUIREMENTS

Requires a Bachelor’s degree in Computer Science, Management and Information Systems (MIS) or a closely related field.

Information systems-specific technical certifications may be substituted for 1 year of either the education or the experience requirement, as applicable.

Related professional Information Systems experience may be substituted for the education requirement on a year-for-year basis.

EXPERIENCE REQUIREMENTS

At least five (5) years of technology experience supporting IT applications.

A Master’s degree in Computer Science, Management and Information Systems (MIS) or a closely related field may be substituted for two years of the experience requirement.

LICENSE REQUIREMENTS

None

PREFERENCES

Preference shall be given to eligible veteran applicants provided such persons possess the qualifications necessary for competent discharge of the duties involved in the position applied for, such persons are among the most qualified candidates for the position, and all other factors in accordance with Executive Order 1-6.

Preferences will be given to applicants with the following skillsets:

• High technical proficiency in SQL, ETL/ELT, knowledge in Data modelling, Data Warehouse/Data Lake.

• Other programming languages used in data science (such as Python) is preferred, but experience in other programming languages may be considered.

• Microsoft Office products (particularly Excel).

• Data visualization tools (such as Tableau, Quicksight, or PowerBI).

• API integration applications such as Mulesoft.

• Problem-solving; Creative problem diagnosis and solving.

GENERAL INFORMATION

SELECTION/SKILLS TESTS REQUIRE

The selection process will involve application review and/or interview. Department may administer skills assessment test.

SAFETY IMPACT POSITION

YES – If yes, this position is subject to random drug testing and if a promotional position, candidate must pass an assignment drug test.

Pay Grade – 26

SALARY INFORMATION

Factors used in determining the salary offered include the candidate’s qualifications as well as the pay rates of other employees in this classification.

APPLICATION PROCEDURES

Only online applications will be accepted for this City of Houston job and must be received by the Human Resources Department during active posting period. Applications must be submitted online at: www.houstontx.gov .

To view your detailed application status, please log-in to your online profile by visiting: http://agency.governmentjobs.com/houston/default.cfm or call 281-233-1842.

If you need special services or accommodations, call 281-233-1842; (TTY 7-1-1)

If you need login assistance or technical support call 855-524-5627.

Due to the high volume of applications received, the Hiring Department will contact you directly, should you be selected to advance in our recruitment process.

All new and rehires must pass a pre-employment drug test and are subject to a physical examination and verification of information provided.

Applicants are encouraged to attach a cover letter and resume along with their completed application when applying. For further information pertaining to the Houston Airport System, please visit: https://www.youtube.com/watch?v=EDWLV_sJFoM

EEO Equal Employment Opportunity

The City of Houston is committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual’s sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, genetic information, veteran status, gender identity, or pregnancy.

The city offers a competitive benefits program, including competitively priced health coverage and a defined contribution pension plan.

Benefits include:

• Medical

• Dental

• Vision

• Wellness

• Life insurance

• Long-term disability

• Retirement pension

• 457 deferred compensation plan

• Employee Assistance Program

• 10 days of vacation each year

• 10 city holidays, plus one floating holiday

• Flexible schedules

• Professional development opportunities

• Transportation/parking plan

• Section 125 pretax deductions

• Dependent Care Reimbursement Plan

• Healthcare Flexible Spending Account

For plan details, visit http://www.houstontx.gov/hr/benefits.html

01

Are you a veteran who served on active duty in the Armed Forces (United States Army, Navy, Air Force, Marine Corps, or Coast Guard) for more than 90 consecutive days and received either an honorable discharge or a general discharge under honorable conditions?

• Yes

• No

  02

  Are you a current Houston Airport System Employee?

• Yes

• No

  03

  What is your “highest” level of education obtained?

• Less than High School

• High School/GED

• Associates Degree

• Bachelors Degree

• Masters Degree and above

  04

  How many verifiable years of professional Technology experience supporting IT Applications do you possess?

• Less than 3 years

• 3 years but less than 5

• 5 years but less than 7

• 7 years but less than 9

• 9 years or more

• No experience

  05

  What was your degree concentration?

• Computer Science

• Management Information System

• Information Technology

• Computer Technology

• Other

• None of the above

  06

  If “other” selected on question 5 list degree concentration otherwise enter N/A

  07

  How many verifiable years of development experience in SQL/ETL Development do you possess?

• Fewer than 3 years

• 3 to less than 5 years

• 5 to less than 7 years

• 7 to less than 9 years

• 9 + years

• No experience

  08

  Do you have experience in using source code control processes such as GIT?

• Yes

• No

  09

  Do you possess a SQL Developer Certification such as MCSA/MCSE? (If yes, please attach certification)

• Yes

• No

  10

  Have you ever developed complex SQL queries? If so, please describe your knowledge in window functions or dynamic SQL. (See resume is not acceptable, if no experience please insert N/A.)

  11

  How many years of experience ETL/ELT do you have? What ETL/ELT tools are you familiar with? (See resume is not acceptable, if no experience please insert N/A.)?

  Required Question