Data Warehouse Developer

This position requires an onsite presence at the Banfield Pet Hospital headquarters in Vancouver, Washington, with a hybrid work schedule (3 days/week).

The Data Warehouse Developer contributes at the enterprise level to the development of designing, building, testing, and maintaining data products and applications. They will work with programming languages and data tools and technologies to create data consumption solutions for internal end users. They will collaborate with the Data Architects and leads of the team to implement and maintain data products under the direction of the Architects/Leads.

They will work within the development team in collaboration with internal, external development teams, and product managers.

• Live and exemplify the Five Principles of Mars, Inc. within self and team.
• Spend 80% of time in active development tasks within the designated data platform primarily on Azure/Cloud.
• Apply modern development practices in data management, configuration, development, and extension of the designated platform within the Mars Veterinary Health (MVH) and Banfield environment.
• Analyze user needs and translate them into software specifications, converting business requirements into stories and work items for the platform backlog.
• Execute tasks from the team backlog.
• Work independently with support from the Architect/Lead to enable systems integrations.
• Write and implement clean, scalable code.
• Test and deploy quality applications, regularly assessing for improvements.
• Develop technical documentation to support future software development projects
• Recommend and execute program improvements.
• Other job duties as assigned.

• Ability to work at a computer for long periods of time.
• Must have mental processes for reasoning, remembering, mathematics, and language ability (reading, writing, and speaking the English language) to perform the duties proficiently.
• Ability to carry out instructions furnished in written, oral, or diagram form and to solve problems involving several variables.
• Ability to stand, walk, stoop, kneel, crouch, and climb as well as manipulate (lift, carry, move) up to 25 pounds.
• Requires good hand-eye coordination, arm-hand-finger dexterity with the ability to grasp, and visual acuity to use a keyboard and operate necessary equipment.
• The noise level in the work environment is normally moderate.
• Environment where pets are present.
• The physical demands and work environment characteristics described here are representative of those that must be met by an associate to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Bachelor’s degree in Computer Science or a related field is required, or the equivalent combination of education, training and experience that provides the required knowledge, skills, and abilities.
• A minimum of five years of data warehousing and analytics experience are required.
• Five years of experience working directly with data warehousing and analytical tools in Azure and Databricks are required.
• Demonstrated proficiency and experience with data warehouse implementation methodologies (Kimball/Inmon), scripting for data processing (Python/Spark), Azure Data Bricks for data processing and engineering are required.
• Understanding of data warehousing/engineering principles and patterns is required.
• Strong analytical and problem‑solving skills are required.
• Effective written and verbal communication skills to collaborate with colleagues and team members are required.
• Knowledge data warehousing development lifecycle is required.
• Willingness to learn and adapt to new technologies and methodologies is required.
• Azure Data Engineer and/or Associate Data Engineer Databricks certification is preferred.
• Experience in Oracle/Teredata/Netezza data warehouse is preferred.
• Knowledge of object‑relational mapping frameworks is preferred.
• Experience with Agile and Scrum development methodologies is preferred.

The pay range for this role is $93,707…