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).

Summary and Qualifications:

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.

Essential Responsibilities and Tasks:

• 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.

Special Working Conditions:

• 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.

Experience, Education and/or Training:

• 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.

Salary Range:

The pay range for this role is $93,707 - $128,847.

The pay range listed reflects a general hiring range for the area, with the specific rate determined based on the candidate's experience, skill level, abilities, and education, and may vary depending on location and schedule.

This posting will remain open for a minimum of two weeks or until a sufficient pool of qualified applicants has been received.

Benefits:

Here at Banfield, we prioritize your well-being and professional growth by offering a comprehensive total rewards package, including health, wellness, and financial support for you, your family, and even your pets. Check out some of our “Meow-velous” benefits:

• Comprehensive Medical, Dental, and Vision Insurance: Enjoy peace of mind knowing your health and wellness are our top priorities. We've got your essential medical, dental, and vision care covered.
• Generous Retirement Plans (401(k) and Roth): Invest in your future and enjoy a generous company match to help you build a secure financial future.*
• Paid Time Off and Holidays: Take a break, recharge your wellbeing, and celebrate days of personal significance with paid time off and holidays.*
• Top-Tier Mental Health and Wellbeing Resources: Your mental health matters. Access our industry-leading resources, including free coaching and counseling sessions, to support your overall wellbeing and help you thrive.*
• Associate Life Insurance (company-paid) & Supplemental Life Insurance: Protect your loved ones with our company-paid Associate life insurance and have the option to purchase additional coverage for extra peace of mind.
• Company-Paid Short- and Long-Term Disability: Feel secure knowing that if you face a temporary or long-term disability, you'll have financial protection.
• Flexible Spending Accounts (FSA): Save on healthcare and dependent care expenses by setting aside pre-tax money. It's a smart way to manage your budget and take care of your needs.
• Health Savings Account (HSA): Make the most of your healthcare dollars with a tax-advantaged HSA, allowing you to pay for medical expenses with pre-tax funds.
• Paid Parental Leave: We support growing families with paid parental leave for both birth and adoption, giving you precious time to bond with your new family addition.
• Continuing Education Allowance (for Eligible Positions): Banfield is committed to supporting the professional growth of our Associates. This allowance provides financial assistance to pursue continuing education opportunities.*
• Back-Up Child and Elder Care & Family Support Resources: When life's unpredictable moments arise, our backup care and family support benefits provide the help you need to keep things running smoothly.*
• Fertility and Family Building Support: We're here for you on your journey to parenthood, offering comprehensive support for fertility treatments and family-building options.
• Digital Exercise Therapy: Stay active and healthy with our digital exercise therapy program, designed to fit your busy lifestyle, and keep you moving.
• Voluntary Protection Benefits: Get peace of mind with protection against the unexpected. You can purchase coverage to help support you financially during hospital stays, critical illness, and accidents.*
• Legal Plan: Gain extra peace of mind with our affordable and accessible legal plan which includes coverage for a wide range of legal needs.*
• Identity Protection: Identity Protection helps safeguard your personal information by alerting you to suspicious activity and providing support if your information is stolen.*
• Commuter Benefits: Say goodbye to commuting stress with our commuter benefits, making your daily journey more convenient and cost-effective.*
• Three Free Optimum Wellness Plans for Pets: We care about your furry friends too! Enjoy three free wellness plans to ensure your pets receive the best preventive and general care.*
• Exclusive Discounts: Unlock a world of savings with our wide variety of exclusive discounts on products and services, making life more affordable and enjoyable.*

Benefits eligibility is based on employment status. Full-time (FT) Associates are eligible for all benefit programs; Part-time Associates are eligible for those benefits with an asterisk (*).

WE ARE A DRUG-FREE, SMOKE-FREE, EQUAL OPPORTUNITY EMPLOYER.

Banfield Pet Hospital® strongly supports and values the uniqueness of all individuals and promotes a work environment where diversity is embraced. Banfield Pet Hospital is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, sex, sexual orientation, gender identity, age, genetic information, status as a protected veteran, or status as a qualified individual with disability. Banfield Pet Hospital complies with all applicable federal, state and local laws governing nondiscrimination in employment in every Banfield location. #FT