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. 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. That’s why we exist. 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
The Data Engineer is responsible for building, optimizing, and maintaining data pipelines and models that support data-driven decision making and actionable business insights; identifying, collecting, and analyzing data and workflows to create innovative and advanced solutions that can improve operational and service-level efficiencies, while also creating and implementing special programs and initiatives that further the goals and objectives of the City. The Data Engineer collaborates with cross-functional teams, including data architects, analysts, and business stakeholders, to translate business requirements into technical solutions, ensuring data integrity, accessibility, and security.
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.
- Maintain regular and reliable attendance.
- 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
- Identify, collect, organize, and analyze data and workflows to support advanced solutions that are customer-focused and lead to improved operational and service-level efficiencies.
- Collaborate with internal customers to understand data requirements.
- Design and implement scalable and efficient data pipelines from data warehouses or data lakes to the end business user.
- Apply data transformation techniques to cleanse, validate, and enrich incoming data, ensuring its quality, integrity, and consistency.
- Design and construct data warehouse schemas and tables to optimize data storage, retrieval, integration, and analytics performance.
- Develop and maintain data models to support reporting, analytics, and visualization needs.
- Continuously monitor and enhance data pipelines and warehouse performance, identifying and resolving bottlenecks, and optimizing data retrieval and processing times.
- Create and maintain comprehensive documentation for data pipelines, data models, and data dictionaries to facilitate knowledge sharing and support data governance initiatives.
- Maintain an extensive knowledge of the datasets associated with the applications used by the City while maintaining a broad understanding of the services offered by City employees and how the two may correlate.
- Design, develop, and integrate scripts that automate business processes, spatial and non-spatial tasks, and procedures using tools such as SQL, Python, and/or R.
- Establish and enforce data governance policies, ensuring data accuracy, security, and compliance with industry regulations (e.g., PCI-DSS, HIPAA, CJIS).
- Assess and recommend tools, technologies, and platforms to support data engineering needs.
- Maintain awareness of new technologies and advances in the profession; reading professional literature; attending workshops and training sessions as appropriate.
- Produce detailed, consistent, error-free work based on defined parameters.
- Adhere to assigned work schedule and department attendance policies and procedures.
- Travel to meetings, trainings, and City events as necessary.
- Comply with all written City policies and procedures.
Other Job Functions
- Perform other duties as assigned or directed.
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.
- Ability to forge strong professional relationships with internal staff, in an outgoing and friendly way.
- Proficiency with software tools, applications, and languages including, but not limited to, SQL, Python, Cloud Computing, YAML, Snowflake), Power BI, Shell, and/or JSON.
- Skill to evaluate, audit, deduce, and/or analyze data.
Skilled and proactive project manager with ability to independentlyplan,coordinate,andorganizework;setpriorities,andmeetcriticaldeadlines.Ability to identify and resolve problems in atimely,efficient,andeffectivemanner.Ability to summarize complicated technical issues in a brief, common-sense manner.Technical writing experience in relevant areas, including queries, reports, and presentations.Ability to quickly gain job knowledge and technical competency through independent learning, collaborative training, and supportive coaching from management and peers.
- Ability to learn and effectively communicate about professional fields which may be outside the employee’s previous experience.
- Ability to exercise the independent judgment, decisiveness, and creativity required in situations involving the evaluation of data against measurable or verifiable criteria.
- Skill in facilitating discussions and interaction with potentially large groups of individuals.
- Ability to work in ateamenvironment;contributeasateammemberandtreatco-workers,subordinates,andcustomerswithrespect.
- Ability to multi-task in a high activity/energy professional environment that includes multiple and concurrent projects and project deadlines
- Exhibits flexibility and adaptability, especially during times of change.
Required Qualifications
MINIMUM QUALIFICATIONS
Any work related experience resulting in acceptable proficiency levels in the below Minimum Qualifications may be an acceptable substitute.
Bachelor’s degree in Computer Science, Information Systems, Software/Computer Engineering, Data Science, or a related field. Three (3) years of experience in ELT/ETL pipeline development, data warehousing/modeling, data quality and governance.
Preferred Qualifications
- Master’s degree in Computer Science, Information Systems, Data Science, Data Engineering, or a related field.
- Industry-recognized certifications such as Cloud Data Engineering Certificates (Data Engineer Associate, AWS Certified Data Engineer Associate, or Google Professional Data Engineer); dbt Developer/Fundamentals; Certified Data Management Professional (CDMP);: Microsoft Power BI Data Analyst.
- Two (2) years of experience with data lakehouse architectures and tools (e.g., Snowflake, Databricks).
CONDITIONS OF EMPLOYMENT
- Must pass a drug screen and background check.
- Must have Class C Texas Driver’s License.
- Must have or obtain CJIS Certification within 30 days of hire.
- Must obtain Snowflake SnowPro Core within 6 months of hire.
- Must obtain Snowflake SnowPro Advanced: Data Engineer within 12 months of hire.
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 (5-10 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.
