South Metro Fire Rescue

IT Systems - Data Engineer

Job description

IT SYSTEMS - DATA ENGINEER

Open Until Filled


Reports To:
DevOps/GIS Manager
Division/Bureau: Support Service
FLSA Classification: Exempt
Grade: 16


South Metro Fire Rescue (SMFR) is currently accepting internal and external applications for Data Engineer. The ideal candidate will have senior level experience as a Systems Administrator and knowledge and/or experience in Systems Integration.

** All candidates interested in applying are required to submit a resume and cover letter.**


GENERAL POSITION SUMMARY

This position is responsible for assisting with the implementation and maintenance of South Metro Fire Rescue’s enterprise-wide data management solution which is used for analytics and reporting. The includes the analysis, design, development, testing, implementation, and maintenance of the data warehouse solution and interfaces. The position will focus on delivering secure and reliable integrations that can be used by the organization to deliver high quality, complex, and timely data to all business units. Works closely with other members of the Data Analytics team to help improve South Metro’s ability to import and process data in a more scalable fashion. Serves as a liaison between SMFR’s product owners and enterprise data analytics team.

ESSENTIAL DUTIES AND RESPONSIBILITIES (The following statements are illustrative of the duties and responsibilities of the position and do not list every duty that may be required of the employee for this position. The District retains the right to change the duties and responsibilities of the position at any time without notice.)

Support the design, build and execution of post source system extraction, data lake ingestion and business transformation.

Develop quality framework to ensure delivery of high-quality data and analyses to stakeholders.

Implement development best practices, version control and deployment strategies to ensure product quality, agility, and recoverability.

Work with internal customers to understanding the business requirements and implementing data solutions.

Coordinate implementation with 3rd party contractors.

Implement new functionality to existing applications to support business needs.

Work with data analysts to identify business processes and propose new applications.

Provide integration development and maintenance and support existing integration workflows and APIs.

Contribute to the overall integration platform, enhancing processing speed, and error handling.

Assess and develop long-term strategic goals for production databases in conjunction with data owners and Division/Bureau managers.

Create models for data interoperability between on-prem and cloud-based solutions.

Monitor, optimize and allocate physical data storage for database systems and respond to and resolve data access and performance issues.

Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements.

Plan and coordinate data sharing, migration between systems.

Develop, implement, and maintain change control and testing processes for modifications to databases.

Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.

Establish appropriate SMFR end-user database and business applications access control levels.

Continually strive to improve the efficiency and usability of SMFR’s solutions, leveraging ongoing research and understanding of business needs.

Always maintains a positive customer service attitude with the public, agency members, co-workers, and supervisors.

Contributes to and supports the mission, vision and values of the Bureau and South Metro Fire Rescue.

May be required to be on-call, remain on duty after shift-end and respond to emergency situations at any time.

Performs other related assignments, as needed, or directed.

MINIMUM QUALIFICATIONS

EDUCATION, EXPERIENCE, LICENSES & CERTIFICATIONS (An equivalent combination of education, training, and experience that demonstrates the ability to perform the duties of the position is qualifying.)

Bachelor’s degree in Computer Science or related field; or equivalent supplemented by advanced technical training in a related technology field.

Five years of experience with Microsoft SQL Server database administration or an equivalent combination of education, training, and experience.

A minimum of three years of experience with Microsoft Azure (or similar) and other business Software as a service (SAAS) solution.

Minimum of 5 years’ experience with Microsoft SQL Server 2012 or higher.

Minimum of 5 years’ IT operation experience with strong understanding of database structures, theories, principles, and practices, database tuning and troubleshooting and business application support.

Possess and maintain a valid Colorado Driver’s license.

Possess and maintain an acceptable driving record in accordance with the SMFR’s Driving Records Policy.

Must obtain CPR certification within one (1) year of hire.

NECESSARY KNOWLEDGE, SKILLS AND ABILITIES

Experience with data warehouse technical architectures, ETL/ELT reporting/analytic tools and scripting.

Experience with Azure services including, Data-pipeline and other big data technologies.

Experience with scripting (Python experience is a strong plus).

Experience with data processing flowcharting techniques.

Windows operating system and hardware experience to include basic administration of a server including service packs and hot fixes.

General knowledge of networking to include IP, DNS, Load Balancing.

Relies on experience and judgment to plan and accomplish goals. Works with project stakeholders daily.

Knowledge of applicable data privacy practices and laws.

Outstanding organizational skills with the ability to prioritize tasks and manage projects from concept to production; must be able to work independently with minimal supervision.

Strong understanding of the organization’s goals and objectives. Also, remains familiar with

South Metro’s standard concepts, practices, and procedures.

Excellent written, verbal, and interpersonal communication skills; including the ability to present ideas in both business-friendly and user-friendly language.

Ability to brainstorm with others, thrive in a collaborative and productive team environment, multi-task and quickly adapt to change.

Excellent customer service skills with demonstrated professional demeanor.

Demonstrated interpersonal skills to establish and maintain effective working relationships with department member, co-workers, supervisors, citizens, community contacts, elected officials, members of other governmental agencies.

Able to establish and maintain cooperative working relationships both within and outside SMFR, exercise good judgment in representing SMFR to external personnel and agencies.

Commitment to personal and professional growth by studying state-of-the-art development tools, programming techniques, and computing equipment; participating in educational opportunities; maintaining personal networks; participating in professional organizations.

SUPERVISION RECEIVED

Work is performed under general oversight and guidance from the DevOps/GIS Manager.

SUPERVISION EXERCISED

Supervise project members as assigned.

EQUIPMENT and SYSTEMS

Requires frequent use of personal computer, including various software packages, database and spreadsheet programs, District automobiles, calculator, telephones, mobile computers, copy machines, cameras, printers, uninterruptable power supplies, network equipment, tools, and other general office equipment.

PHYSICAL DEMANDS

While performing the duties of this job, the employee is regularly required to perform climbing, balancing, stooping, kneeling, crouching, crawling, reaching, standing, walking, pushing, pulling, lifting, fingering, grasping, feeling, talking, hearing, seeing and repetitive motions.

Medium Work: Exerting up to 50 pounds of force occasionally, and/or up to 20 pounds of force frequently, and/or up to 10 pounds of force constantly to move objects.

Specific vision abilities required by this job include close and distance vision acuity and the ability to adjust his or her focus, allowing a broad field of vision.

Visual and fine/gross motor skills enabling the safe operation of a vehicle during normal as well as hazardous weather situations.

WORK ENVIRONMENT AND GENERAL INFORMATION

The primary responsibilities of this job are performed in a climate-controlled office environment. The noise level in the work environment is usually moderate.

BENEFITS

South Metro Fire Rescue’s compensation philosophy is designed to attract and retain highly skilled and motivated employees. As such, SMFR’s compensation is more than base pay. All regular fulltime SMFR employees enjoy a total compensation package including: base wages, leave accruals, medical, dental, vision and life insurance employer paid premiums, Retiree Health Savings, Death & Disability and employer paid pension contributions as well as a positive work culture including a robust Fitness, Wellness and Rehabilitation Program, educational opportunities and support, job security and other positive non-monetary values which are intended to collectively position SMFR as an employer of choice in its geographic area. SMFR recognizes that being an employer of choice has different meaning to different people depending on what elements a person highly values. But SMFR's overall goal is to be a great place to work.

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.