Data Developer III

Job Summary

The Extract Transform Load (ETL) Developer III is responsible in delivering the data strategy and the construction, delivery and maintenance approach of the ETL portion of the data architecture at Patterson Companies. This includes driving the ETL standards and process on the design, build and maintenance of ETL jobs, their scheduling and monitoring. This position also is accountable for establishing and maintenance of appropriate source control around ETL and the establishment and the maintenance of appropriate recovery points within the execution of  ETL jobs.

The ETL Developer III will also provide a high level of ETL technical services and support to both internal and external clients; is considered an expert in multiple ETL technologies; maps data source to destination; has worked successfully integrating large vendor solutions and mentors others on ETL best practices and approaches within Patterson Companies’ technical organization.

Essential Functions

• Lead in the design, build, verification, implementation and maintenance of ETL code / jobs based on business needs;
• Accountable to establish the standards and processes around providing support for ETL tools, their jobs and the scheduling tools.
• Drive the life cycle of the ETL tool by enabling smooth upgrades and/or installation and support of new capabilities; work with the Data Architect to establish and implement a data architecture practice
• Prepare project and system related documentation consistent with standards and procedures outlined in the data architecture approach including data quality, security and availability requirements.
• Review new applications for their ability to be integrated into the existing environment – specifically around data to data integration. Also during design sessions, ensure the design meets or exceeds data quality standards.
• Coordinate support efforts in updating ETL jobs, performance tuning, optimization, establishing metrics and IS initiatives with impact on data.
• Lead the capacity planning function to properly identify needed hardware, software, ETL configuration / architecture to support application / business needs.
• Collaborate with Analysts, Application Developers, Quality Assurance, DBAs and Data Architects.

Job Qualifications

Minimum Qualifications:

• Bachelor’s Degree in Computer Science, Management Information Sciences, Mathematics, Engineering, or area of functional responsibility preferred, or a combination of equivalent education and experience.
• 5-9 years of industry experience with data warehouse development, business intelligence tools, or database administrator or equivalent.
• 4-6 years of additional experience with design, build, verification and implementation of ETL and scheduling of these jobs.
• Proficiency with Transact-SQL and SQL Data query and analysis.
• Understanding of database structures, theories, principles, and practices.
• Good analytical and problem-solving abilities.
• Good verbal and written communications with ability to effectively communicate at multiple levels in the organization.
• Good knowledge of reporting and query tools and practices.
• Working technical experience with designing, building, installing, configuring and supporting ETL repositories.

Preferred Qualifications:

• Ability to present ideas in business-friendly and user-friendly language.
• Highly self-motivated and directed.
• Ability to absorb new ideas and concepts quickly.
• Good analytical and problem-solving abilities.
• Strong customer service orientation.
• Ability to work effectively within a team and as an individual contributor in a fast-paced changing environment -- multi-tasks, prioritizes and meets deadlines in timely manner.
• Strong verbal and written communications with ability to effectively communicate at multiple levels in the organization.
• Strong organizational, attention to detail and task follow-up skills. Adept at handling multiple assignments in a timely manner and meeting assigned deadlines.

The potential compensation range for this role is below. The final offer amount would be based on various factors such as candidate location (geographical labor market), experience, and skills. $82,300.00 - $103,900.00