Sr Engineer, Data (Finance)

POSITION TITLE: Sr Engineer, Data (Full-Time Regular) (Classified)
REQUISITION #: req7882
DEPARTMENT: Information Technology
LOCATION: 215 OFFICE BLDG
BENEFIT CATEGORY: Classified (Non-CBU) View Classifications & Benefits
EMPLOYMENT TYPE: Full-Time Regular
ANNUAL SALARY RANGE: $83,416.00 - 139,024.00 (Salaries are paid biweekly)
ANNUAL ANTICIPATED HIRING RANGE: $99,000.00 - 123,000.00 (Salaries are paid biweekly)
SELECTION PROCESS: Application deadline is 3:00 p.m. MT on 12/5/2024.

The City of Fort Collins is a bias-conscious employer. We ask that you please avoid the use of photos when submitting a resume and/or an application for employment. You will receive an email acknowledgment when you have successfully submitted an application. Your completed application will be forwarded to the hiring manager. You will be notified if you are selected for further testing or interviews. Please keep your contact information up-to-date. The status of your application will be updated in your applicant profile. Post-offer background check required.

Why Work For the City of Fort Collins?

• Medical, dental, vision (for self, spouse, children) - eligible on the 1st of the month following date of hire
• Paid vacation, paid holidays, sick leave, and additional one-time bank of 40 PTO hours for new, full-time, Classified and Unclassified Management hires
• Retirement + company contributions - after 6 month probation period and immediate vesting
• Flexible spending: Medical expenses FSA, dependent FSA or both
• Employee Assistance Program: counseling, legal, financial assistance
• Life insurance, short-term and long-term disability
• Wellness program, workout facilities
• Employee/family onsite health clinic
• Learning and development opportunities at all levels in the organization with opportunities for career mobility
• Collaborative work environment

To learn more about The City of Fort Collins and Our Community, please read Our Community and Our Organization Brochure

Job Summary

The City of Fort Collins, CO has a position opening for a Senior Data Engineer who will be responsible for developing, scheduling, and monitoring data pipelines to ingest, validate, and verify data from various internal and external sources for both operational/transactional and analytics purposes. This role includes gathering and refining requirements to ensure alignment with organizational objectives. The ideal candidate will be organized, analytical, and proficient in managing multiple priorities within a collaborative team environment. Mentoring team members and collaborating across departments will be essential for success in this role.

This is a critical role within our organization, offering a unique opportunity to influence the evolution of our data management and engineering practices. As a Senior Data Engineer, you will play a key role in defining and implementing standards for data movement, storage, and governance, with a focus on a cloud-first strategy. Collaborating closely with the Data Architect, you will build and maintain a scalable, secure, and efficient data ecosystem, leveraging the Microsoft Cloud Stack, including tools such as Azure Synapse, Fabric, and Azure DevOps.

With at least 2+ years of experience in the Microsoft Cloud Stack and 4+ years of experience in the software development life cycle (SDLC), you will be instrumental in guiding our transition to modern data architectures like Medallion and Data Mesh. In addition to leading technical initiatives, you will mentor junior team members, promote Agile methodologies, and ensure strict adherence to data governance and security protocols. Candidates with data security certifications or equivalent experience are highly preferred, along with familiarity in data streaming technologies like Kafka or Azure Event Hub.

The workplace arrangement for this position will initially be onsite and in-person for onboarding and training. This role will evolve into a hybrid of remote and in-person work which will be based on current assignments. We invite you to apply!

Essential Duties and Responsibilities

The following duties and responsibilities are illustrative of the primary functions of this position and are not intended to be all inclusive.

• Collaborate with data analysts, application owners, and business users to define data requirements and address data quality challenges.
• Implement and refine performance monitoring, alerting, and version control for ETL/ELT processes, supporting the delivery of reliable Data Products.
• Apply innovative problem-solving techniques and critical thinking to resolve complex data issues efficiently.
• Translate business requirements into data movement, cleansing, and modeling solutions.
• Mentor data engineers, conducting code reviews, and sharing best practices.
• Partner with the Data Architect to enhance team processes, standards, and data governance practices.
• Drive the adoption of data engineering best practices and frameworks.
• Collaborate with the data engineering team in adopting agile methodologies for efficient project delivery.

Management Responsibilities

No

City Competencies

• Demonstrated cultural competence to effectively interact, work, and develop meaningful relationships with people of diverse identities, perspectives, and cultural backgrounds.
• Strong learning orientation. Leverages all resources and is creative in ways of learning for self to continue adapting to changing issues and trends.
• A desire and ability to understand the diverse needs of internal and external customers, and to create experiences and deliver services that exceed their expectations.
• A desire and ability to utilize digital tools for organizational information, individual, and teamwork.

Required Knowledge Skills and Abilities

• Proficient in modern ELT/ETL design, implementation, and performance optimization.
• Demonstrated experience pulling data from a variety of sources, leveraging both Microsoft technologies (e.g., MS SQL Server, Synapse, Azure Data Factory) and open-source tools.
• Extensive knowledge of Medallion architecture principles and data engineering best practices.
• Experience managing and utilizing source code repositories in both cloud and on-premise data environments (e.g., Git, Azure DevOps).
• Familiarity with Data Mesh and Data Product concepts and architectures.
• Expertise in data streaming technologies (e.g., Kafka, Azure Event Hubs) and integration with real-time processing systems.
• Demonstrated experience with Python and the development of Synapse/Fabric notebooks for data engineering tasks.
• Strong understanding of GIS data structures and reporting methodologies.
• Proven experience working with Azure services, including automation tools like Azure Automation, Logic Apps, or Azure Functions.
• Ability to lead and guide teams while collaborating effectively with cross-functional stakeholders.

Required Qualifications

MinimumPreferredCollege degree or equivalent work experience. Some positions may require functionally related certification or advanced degrees Bachelor's degree in Computer Information Systems, Computer Science, or related directly related area.

Experience Requirements

• Four or more years of experience in data engineering within the Microsoft Data Stack (e.g., MS SQL Server, Azure Synapse, Azure Fabric).

Studies have shown that women and people of color are less likely to apply for jobs unless they believe they can perform every job description task. We are most interested in finding the best candidate for the job, and that candidate may come from a less traditional background. The City may consider an equivalent combination of knowledge, skills, education, and experience to meet minimum qualifications. If you are interested in applying, we encourage you to think broadly about your background and skill set for the role.

Certifications/Licenses/Specialized Training

• Microsoft Certifications

The content in this posting was created for recruitment purposes. To view the full job description click the link below.

Sr Engineer, Data

The City of Fort Collins will make reasonable accommodations for access to City services, programs and activities and will make special communication arrangements for persons with disabilities. Please call (970) 221-6535 for assistance.

Notice Regarding Medical and/or Recreational Marijuana Use:
Because the possession and use of marijuana, whether for medical use or otherwise, constitutes a federal offense and because the City is a drug free workplace, the City will not accommodate the medical use of marijuana and enforces written policy prohibiting working for the City while marijuana is in the body. The fact that state law recognizes medical marijuana as a prescribed, or otherwise permitted, medication does not alter or otherwise change this policy.

The City of Fort Collins is an Equal Opportunity Employer. Applicants are considered for positions for which they have applied without regard to race, color, religion, creed, national origin or ancestry, sex, sexual orientation (including perceived sexual orientation), gender identity and expression, disability, age 40 years or older, pregnancy or related condition, genetic information, and, in certain specific circumstances, marriage to a coworker or any other status protected under federal, state, or local law.

BACKGROUND CHECK REQUIRED.

Note: Some information in your application may be public information under the Colorado Open Records Act.Job Summary

The City of Fort Collins, CO has a position opening for a Senior Data Engineer who will be responsible for developing, scheduling, and monitoring data pipelines to ingest, validate, and verify data from various internal and external sources for both operational/transactional and analytics purposes. This role includes gathering and refining requirements to ensure alignment with organizational objectives. The ideal candidate will be organized, analytical, and proficient in managing multiple priorities within a collaborative team environment. Mentoring team members and collaborating across departments will be essential for success in this role.

This is a critical role within our organization, offering a unique opportunity to influence the evolution of our data management and engineering practices. As a Senior Data Engineer, you will play a key role in defining and implementing standards for data movement, storage, and governance, with a focus on a cloud-first strategy. Collaborating closely with the Data Architect, you will build and maintain a scalable, secure, and efficient data ecosystem, leveraging the Microsoft Cloud Stack, including tools such as Azure Synapse, Fabric, and Azure DevOps.

With at least 2+ years of experience in the Microsoft Cloud Stack and 4+ years of experience in the software development life cycle (SDLC), you will be instrumental in guiding our transition to modern data architectures like Medallion and Data Mesh. In addition to leading technical initiatives, you will mentor junior team members, promote Agile methodologies, and ensure strict adherence to data governance and security protocols. Candidates with data security certifications or equivalent experience are highly preferred, along with familiarity in data streaming technologies like Kafka or Azure Event Hub.

The workplace arrangement for this position will initially be onsite and in-person for onboarding and training. This role will evolve into a hybrid of remote and in-person work which will be based on current assignments. We invite you to apply!

Essential Duties and Responsibilities

The following duties and responsibilities are illustrative of the primary functions of this position and are not intended to be all inclusive.
Collaborate with data analysts, application owners, and business users to define data requirements and address data quality challenges.Implement and refine performance monitoring, alerting, and version control for ETL/ELT processes, supporting the delivery of reliable Data Products.Apply innovative problem-solving techniques and critical thinking to resolve complex data issues efficiently.Translate business requirements into data movement, cleansing, and modeling solutions.Mentor data engineers, conducting code reviews, and sharing best practices.Partner with the Data Architect to enhance team processes, standards, and data governance practices.Drive the adoption of data engineering best practices and frameworks.Collaborate with the data engineering team in adopting agile methodologies for efficient project delivery.
Management Responsibilities

No