IT Analyst 2 - Data Engineer

Description Summary Why it's a great opportunity: In this exciting data engineer and ETL developer opportunity, you will provide insights to County leadership by building and optimizing the infrastructure for data capture, cleansing, and storing. You will be working 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. Information Technology'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 where your contributions truly make a difference. Why it's a great 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. Learn more about the Finance & Enterprise Services Department here. 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:

Information Technology 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 Information Technology 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. Trouble-shoot problems and recommend solutions. Conduct the installation, implementation, administration and support for 3rd party software solutions that support countywide initiatives. Trouble-shoot 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. A classification description with a more detailed list of essential functions can be found here. Minimum Qualifications Additional education or experience, which clearly indicates the ability to perform the essential functions of the position may substitute equally on a year of year basis for the recruiting requirements. 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. As a condition of employment, the applicant will need to authorize and complete a background check. Information received from the background check is reviewed case-by-case and will not necessarily remove an applicant from consideration. Supplemental Information To be considered for this opportunity please: Complete and submit a detailed online Pierce County Employment Application by selecting "APPLY" above or go to: www.piercecountywa.org/jobs. If you have a question about this opportunity, please email the Recruitment Team at PCHRRecruit@piercecountywa.gov and specify the Job Number and Title. If you do not have internet access, you may visit your local public library or any WorkSource location and use their computers. Individuals needing accommodation in the application, testing process or need this job announcement in an alternative format may call Human Resources at (253) 798-7480, at least two days prior to the need. This is a competitive selection process. Your application will be reviewed and evaluated for the quality and quantity of education/experience in the areas listed. 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 screen, and interviews. At Pierce County, diversity, equity, and inclusion means commitment, not a single step. We strive to foster an inclusive environment that supports equitable access to opportunities throughout your career. We want to recruit, develop, and maintain a talented workforce from various backgrounds, cultures, lifestyles, and perspectives, committed to our vision. Employees of the County have local, direct, and visible impact in our diverse community. Will you join us in keeping Pierce County a place people are proud to call home? We are unable to sponsor or take over sponsorship of an employment visa at this time.