City of McKinney
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. 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.
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 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.
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.
Assess and recommend tools, technologies, and platforms to support data engineering needs.
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.
REQUIRED QUALIFICATIONS
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 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 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.
#J-18808-Ljbffr
is more than a job. It is an opportunity to make a meaningful difference 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.
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 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.
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.
Assess and recommend tools, technologies, and platforms to support data engineering needs.
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.
REQUIRED QUALIFICATIONS
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 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 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.
#J-18808-Ljbffr