Data Engineer

Data Engineer

This is an exciting opportunity for a Data Engineer and ETL Developer to provide insights to County leadership by building and optimizing the infrastructure for data capture, cleansing, and storage. You will work both independently and as part of a collaborative team to help transform the County’s ETL infrastructure and overall data governance architecture. You will use your experience in data-oriented programming languages and data visualization tools such as Pentaho, SQL, Python, R, PowerBI/Tableau, and more. Your strong background in ETL development in a modern cloud architecture environment leveraging infrastructure such as code, containerization, and code standardization will contribute highly to the County’s IT goals.

About the Information Technology Division

The Information Technology Division's 130 staff are responsible for building, operating, and maintaining the technologies that power essential public services in Pierce County. We provide diverse technology solutions including commercial applications, geographic information systems, and sophisticated custom software, supported by a robust hybrid infrastructure combining both on-premises and cloud-based platforms, and all secured by a reliable network. Our team thrives in a positive, collaborative environment combined with continual learning and development to enable our highly impactful work. Join us and be part of a division where your contributions truly make a difference.

About the Finance & Enterprise Services Department

The Finance & Enterprise Services Department delivers enterprise-wide services that support every County department and many external partners, ensuring Pierce County operates effectively, efficiently, and with strong public stewardship. Finance & Enterprise Services staff provide a broad portfolio of high-impact, countywide services, including budgeting and performance management, fiscal services, procurement and contracting, information technology, general services, fleet services, and risk management. Employees have the opportunity to work on strategic, enterprise-level initiatives, collaborate across departments, provide the operational and technical backbone which ensures the smooth delivery of services across the organization, and deliver critical analysis and decision support that informs leadership and shapes County priorities. The Finance & Enterprise Services Department is focused on creating a culture where employees can help improve service delivery to make a meaningful impact on County operations and the community. The Department leads with safety, empowerment, and collaboration to create an environment where every person can contribute, challenge ideas, and continuously improve.

How to be Successful in the Role

Your success will come from being committed to continuous learning in this highly complex and evolving area of IT. You will need to stay updated with the latest trends and technologies in ETL development and data management. You will also be providing a high level of customer service working within your team and in supporting and explaining processes to others. Exploring and understanding source data as well as troubleshooting data pipelines to ensure data quality and integrity will ensure your success.

Your Future in this Role

The IT Division has access to numerous training opportunities, which include peer, industry, vendor, and official Pierce County training as well as access to established procedures, standards, practices, and system documentation. Our training program is designed to help you develop as both a professional in your role as an IT Systems Analyst and as a Pierce County employee. Your work will directly impact your community, and it offers a great foundation for future positions within the IT Division and Pierce County.

Core Daily Responsibilities

• Serve as the project coordinator for major business analysis efforts functioning as liaison between business units and technology services.
• Consult and coordinate with departments to match user requirements with technology solutions.
• Work with technologists, system designers, and programmers to research and determine technical solutions to enterprise applications and infrastructure; develop the plan, method, design and analysis for its execution; complete the configuration, integration and data migration; and perform the implementation of the application.
• Review and assess 3rd party software solutions.
• Coordinate multiple, complex enterprise application initiatives to ensure IT architecture alignment, system integration, compliance with IT standards, and customer business needs are met.
• Define enterprise-level system requirements and analyze fit/gap, plan, and provide recommendations for system workflows, application integration, product implementation, and deliverables.
• Work cooperatively and proactively with IT peers to establish the hardware, software, security, services, and administration for the production and test environments.
• Conduct the installation, implementation, administration, and support for 3rd party software solutions that support countywide initiatives.
• Troubleshoot problems and recommend solutions.
• Work with Department Business Analysts and IT peers to coordinate and create detailed project plans and schedules including risk identification to ensure the successful integration of new systems and applications.

Minimum Qualifications

• Four years of information technology or business analysis experience, AND Bachelor’s degree in information technology, computer sciences, business/public administration or related field.
• One year’s experience in a project lead role is required.
• A resume and cover letter are required for this position.

Additional Information

• As a condition of employment, the applicant will need to authorize and complete a background check.
• This is a competitive selection process. Your application will be reviewed and evaluated for the quality and quantity of education/experience.
• Applicants whose qualifications most closely correspond to the County's needs will be eligible for further consideration.
• Notification of application status normally occurs 2 to 3 weeks after the closing date.
• Short notice may be given to applicants to participate in further selection processes which may include assessments, phone screens, and interviews.

Key skills/competency

• Data Engineering
• ETL Development
• Data Governance
• SQL
• Python
• Cloud Architecture
• Containerization
• Code Standardization
• Business Analysis
• Project Coordination