Data Engineer
City of Eugene
THE CITY OF EUGENE’S INFORMATION SERVICES DIVISION (ISD) IS
CURRENTLY ACCEPTING APPLICATIONS FOR:
Data Engineer
Are you a positive, productive, and collaborative individual with excellent customer service skills and a passion for highly detailed work? Are you committed to helping implement programs that help our community make data-driven decisions?
If so, we invite you to apply for this rewarding job opportunity. Our work environment is flexible and relies on strong ties and collaboration with other work groups, agencies, and community members. As part of our dynamic team, you will play an integral role in delivering data to City Council so they can make data-driven decisions.
THIS POSITION IS OPEN UNTIL FILLED
The next review of applications will take place: Weekly until filled
For your application to be considered, please apply online.
You must attach a resume and cover letter to your online application.
The Information Services Division (ISD) supports the City of Eugene's technologies and meets the evolving needs of the organization and the community.
The Data Engineer (classification: Application Systems Analyst) performs an array of cutting edge professional and technical support activities for City's enterprise applications and systems. These duties include:
- Data Warehouse development, specifically using data vaulting methodology SQL Server/SSIS ETL development, including logic for data cleansing and data aggregation
- Python Programming Tableau report development
- Data analysis
- Design, implementation, and testing of new databases
- Data integrations
- Development and support of data visualizations to be used by various teams or stakeholders to enable strategic decision making
- Development of system specifications, procedures, and other documentation
The ideal candidate also possesses excellent knowledge, skills, and abilities in:
- TFS, JIRA, or a similar ticket tracking system for development
- Source code control with Git
- SQL Server Database Development and T-SQL Programming, with experience developing and maintaining temporal tables
- Writing queries, reports, and presenting findings
- Performance optimization and troubleshooting
- Analyzing, designing, and developing applications using object-oriented concepts in a .NET environment using C#
- The ability to implement, modify, and support vendor supplied software solutions a plus
- Communication skills & a drive to understand customers
- Working effectively in a team environment and independently p
- Ability to analyze problems critically and have a high attention to detail
- Developing technical documentation to guide future software development projects
- Collaboration, project management, time management, planning and multi-tasking skills
- Agile/Kanban and continuous delivery
- Building and maintaining relationships with business users of the data to support their requirements through effective communication
- Recommending improvements to IT systems to further facilitate data collection and analysis
Application Systems Analyst 2:
If assigned a supervisory role, the Application Systems Analyst 2 is responsible for the selection, supervision and evaluation of assigned staff; assigns work and ensures appropriate training is provided; investigates complaints; recommends and administers disciplinary actions; handles sensitive personnel matters and recommends grievance responses; exercises full supervision over employees.
To view a full list of duties, knowledge and skills required for this position you can link to the position's classification here:
Department / Division: Central Services Department / Information Services Division (ISD)
Work Schedule: 40 hours/week, Monday-Friday with additional or flexible hours as needed to meet business needs. Flexible, work from home options available, some hours / days in the office may be required.
COMPENSATION PACKAGE
Annual Salary Range:
Application Systems Analyst 1 : $69,971.20 - $90,521.60
Application Systems Analyst 2: $76,128.00 - $100,505.60
Based on candidate qualifications, the position may be filled at either the Analyst 1 or Analyst 2 level. See Qualifications Section for additional information.
Retirement Program
Upon eligibility, the City will contribute an employee contribution of 6%, as well as the employer contribution, to a retirement program administered by the Oregon Public Employees' Retirement System (PERS). In addition, the City will pay a 3% contribution to a deferred compensation program if the employee contributes at least 1%.
Additional Benefit highlights:
- Paid time off
- Up to 90% employer paid medical, pharmacy, vision, and dental insurance – includes alternative care and massage therapy
- Free fitness facilities, including fitness classes and biometric screening
- Employer paid long term disability insurance
- Employer paid life insurance
The City of Eugene offers a great benefit package including holidays, vacation, sick leave, retirement benefits and a range of insurance benefits as well as training and advancement opportunities. To view more information about the benefits and current insurance premium rates, click the respective links. While these positions operate in a challenging and fast-paced environment, they are part of a supportive, collaborative team that is flexible and values work-life balance.
QUALIFICATIONS
Studies have shown that women and people of color are less likely to apply for jobs unless they believe they are able to perform every task in the job description. We are most interested in finding the best candidate for the job, and that candidate may be one who comes from a less traditional background. If you are interested in applying, we encourage you to think broadly about your background and skill set for the role.
The City of Eugene values diversity in its workforce and is committed to Affirmative Action.
POSITION REQUIRED QUALIFICATIONS:
These skills are required of the work needed from this Data Engineer position.
- Data Warehouse development, specifically using data vaulting methodology
- SQL Server/SSIS ETL development, including logic for data cleansing and data aggregation
- Development and support of data visualizations to be used by various teams or stakeholders to enable strategic decision making
MINIMUM QUALIFICATIONS:
Experience: Three years of progressively responsible experience in computer analysis and programming.
Training: Requires a Bachelor’s degree from an accredited college or university with course work in computer languages and programming, management of information systems, or related field.
Experience: Five years of progressively responsible experience in computer analysis, design and programming; business process engineering; knowledge of hardware and software used by the City.
Training: Requires a Bachelor's degree from an accredited college or university in computer languages and programming, management of information systems, or related field.
MUST PASS A CRIMINAL RECORDS CHECK.
Valid Oregon driver's license, or ability to obtain by date of hire; must pass driving records check and, if hired, maintain a driving record that meets the City's standard. Oregon law requires that an out-of-state license holder must obtain a valid Oregon license (with appropriate endorsements) within 30 days of becoming domiciled in the state (ORS 803.355).
Some positions require applicants to have a psychological evaluation and/or physical examination and a drug test prior to employment. Marijuana use is evaluated consistent with current state law regulations.
ABOUT OUR ORGANIZATION
Calling Eugene Home
Eugene is located at the southern end of the agriculturally rich Willamette Valley. From here, it is a short jaunt east to the Cascade Mountains, west to the stunning Pacific Ocean coastline, or north to Portland. We're a small city with unlimited things to do: Downtown Eugene is revitalizing; the Oregon Bach Festival and Eugene Symphony call the Hult Center for the Performing Arts home; you can float the Willamette River and hook a salmon after work in the shadow of downtown; a booming food and beverage economy, including topnotch local craft breweries and wineries in the surrounding countryside, is the foundation of a local restaurant scene; the University of Oregon brings arts, culture, and educational opportunities, as well as championship athletics (Go Ducks!); a nationally-recognized transit system helps you move around the city, and our Gold rating as a Walk- and Bicycle-Friendly Community ensures that safe travel options abound! Known as Track Town USA, the community annually plays host to numerous track and field events at historic Hayward Field, including the IAAF World Championships in 2022! The impact of track and field can be seen beyond the track, with abundant trails coursing through the south hills, along the Willamette River, and through hundreds of acres of city parks. To learn more about Eugene, visit Eugene Cascades and Coast.
The Organization
The City of Eugene has a Council-Manager form of government. In this form of government, the city council develops legislation and policies to direct the City. The city manager, hired by the city council, provides administrative direction to the organization, oversees City of Eugene personnel and operations, and carries out the city council's direction. The City of Eugene has over 1,500 employees and a $840 million total budget. The City of Eugene is a service-oriented and welcoming organization that provides services through six departments: Central Services, Fire and Emergency Medical Services, Police, Public Works, Planning and Development, and Library, Recreation and Cultural Services. The State of the City video shows how the city is meeting new challenges, learning from one another, building connections, and celebrating our city. The City of Eugene encourages our employees to bring their true selves to work with the knowledge that they are valued and protected. We embrace all of the identities and cultural legacies that our employees represent and strive to be an inclusionary and safe place to work. At the City, we learn and grow best as a team of individuals unafraid to use their unique voices to propel us to meet our goals as we serve our community today and into the future.
As an organization we are focusing on six Core Competencies for employees:
- Trust & confidence – Making our intent and actions be transparent and honest while fostering healthy, inclusive relationships, actively listening and maintaining open communications, delivering on our promises, investing in other’s success, and engaging each other and the community
- Creative work environment – Exploring meaningful new ideas and relationships to foster innovation and encourage collaboration and creativity. Challenging the standard method of doing business in a positive environment.
- Now & later perspective – Looking beyond day-to-day challenges to better anticipate the future and adjust to change.
- Respectful & inclusive work environment – Seeking out a wide range of voices and making each other feel respected and included.
- Self-awareness & emotional intelligence – Learning to recognize and understand our own emotions and the emotions of others and recognizing our individual strengths and weakness to raise self-awareness so we can perform better.
- Wellbeing - We take care of ourselves and each other.
The City of Eugene is committed to a Respectful Work Environment, we value the cultural, educational, and life experiences of each employee. We believe that a diverse workforce enables us to deliver culturally responsive services to all members of our community. As part of our commitment to diversity, equity and inclusion we desire to welcome, respect, and create a sense of belonging a wide range of identities and experiences in our workforce. Women, people with disabilities, and persons of color are strongly encouraged to apply.
The City of Eugene complies with the Americans with Disabilities Act of 1990. Any applicant with a qualified disability under the Americans with Disabilities Act may request accommodation by contacting an employment coordinator at (541) 682-5061.
In compliance with the Immigration Reform and Control Act of 1986, the City of Eugene will request all eligible candidates who accept employment with the City to provide documentation to prove they are eligible for employment in the United States.
If you are interested in joining our team, please apply online. You must attach a resume and cover letter to your online application.
Full Time
Salary range:
$75,000 – $100,000