ETL Developer (5962)
Federal Way, WA

Job Description

Join World Vision as an ETL Developer

00 At a Glance

Role: ETL Developer for enterprise data warehouse (EDW)

Salary Range: See sections 08 & 09 below.

Required experience: ETL Development, relational databases, SQL

Preferred experience: Microsoft SQL Server Integration Services (SSIS) development, SSAS, SSRS, MDS

Experience level: Associate to mid-level

Industry: Enterprise, non-profit charity

Company size: 1,000+

01 The Job You are an ETL Developer with strong technical proficiency in SQL development who can plug-in quickly and make key contributions to our high performing 6-person enterprise data warehouse (EDW) team that serves as the central data hub for the organization. The team includes a business analyst who together with the senior team leader serve as a bridge between the internal customers and the work, so you can keep your primary focus on the technical solutions. The nature of the work will call on you to take a design from the data architect and be inspired to turn it into a working solution using Microsoft SQL Server Integration Services (SSIS). The end result will lend valuable historical insight into how our fundraising efforts are performing in the marketplace. Our team of ETL developers extracts and combines data from our enterprise source systems that originates from platforms such as Microsoft CRM, NetSuite, and Adobe Campaigns in support of business units such as Planning Analysis & Reporting, Donor Insights, and Prospect Development. All contributing towards everyone here at World Vision USA working from a single source of truth that positions our marketing teams to deliver excellent donor experiences that inspire giving. In similar fashion our enterprise wide reporting is used by senior leaders to guide the decision making and direction that World Vision USA will head towards in the future. It's important work with meaningful impact. Is it calling you?

02 What success looks like You actively participate and contribute to taking designs and turning them into working solutions for our internal clients. The code you deliver has been tested well. Roadblocks naturally happen but you are resourceful and adept at finding a workaround or escalating any blockers to keep yourself and the team on-track and moving forward. It's a cliché but teamwork makes the dreamwork so you are found to be consistently participating and contributing to team design sessions. The same old thing isn't always best so you bring a rigor and willingness to challenge a past design by contributing ideas to the conversation that could make it better but ultimately in the end you support the decision of the larger team and work towards the collective goal set. Your individual and team contributions helps us reduce our backlog of commitments and level-up our service to the organization.

03 Where this job could take your career World Vision USA is a part of the larger World Vision International partnership. Globally, we have over 40,000+ staff working in nearly 100 countries. Just over 1000 of us call World Vision USA home. You'll have opportunities to advance within our robust and talented group of technologists as you continue to stretch and grow your career for the future.

04 About World Vision USA When you work at World Vision, your passions and talents come together to meet the greatest needs in the world today. We go to ends of the earth and into the margins. Where few go and the road is less traveled. Because Jesus is alive in the hardest places to be a child. We are dangerously soft-hearted. But just the right kind of dangerous. That's because we're a global Christian humanitarian organization. We partner with children, families, and their communities to reach their full potential by tackling the causes of poverty and injustice. We empower people out of poverty. For real. For good. For nearly the last 70 years. Jesus' love at the center. Always. We're Christian and follow Jesus' example to show unconditional love to the poor and oppressed. Serving every child we can regardless of faith. Are you feeling called to explore joining us? We hope so.

05 You bring A Bachelor's degree in programming/systems or Computer Science or other related field or equivalent work experience (4 years). Your work experience includes a minimum 1-4 years of ETL, data warehousing, process design, and data management. In addition, you have experience with SQL and relational databases.

06 Additional skills we're interested in You have worked with Microsoft SQL Server Integration Services (SSIS) development, SSAS, SSRS, MDS. You're someone who rolls up your sleeves and gets the job done with a successful track record of delivering the work you commit to on-time.

07 Let your work be your faith in action Together we could change more lives in more ways. We've already impacted the lives of over 200 million vulnerable children by tackling the root causes of poverty but our work is not finished. Every day, nearly 16,000 children under the age of 5 die from preventable causes. Our call to action is urgent. That's why we're looking for someone who is ready to place their giftings and talents behind helping the world's most vulnerable children. Every design and solution crafted, line of code written, or blocker fixed can help influence whether someone chooses to help today or not. If not you, then who?

08 Salary range & benefits Your salary is important to you so it's important to us. If you need the approximate range to inform your decision on whether to apply or not contact Chad using one of the ways below. We have a robust and comprehensive benefits package to round out our total compensation package. Click here to learn more.

09 To apply See the Apply box in the lower left corner. Still not sure? I really want to hear from you, even if it's just to ask some questions about the job or have a chat in confidence. Contact Chad in Talent Acquisition at 253-815-2216 (text ok) or ckopkas@worldvision.org. Also, feel welcome to schedule a short call on my calendar on a day and time that works for you over at https://calendly.com/ckopkas/wvinfocall. Connect with me on LinkedIn here. I post jobs on Twitter too so follow me there for more updates.

10 What happens next? Glad you asked. We owe you that and strive to not leave you wondering. We review applications nearly every day assessing strength of fit for the role. Sometimes questions arise on our end so we message you to learn more. Short-listed candidates are contacted for an initial phone conversation with our recruiting staff. Moving deeper into our selection process you can expect to interview 1:1 with a hiring manager. Finalists normally participate in a panel interview where the opportunity to meet additional members of our staff lends itself to more of a 360-view of the role. Our most valuable resource is our talented staff. Our goal is to fill this vacancy with the right person in the shortest amount of time, so we have all hands on deck to move this important work forward.

Required Experience

See "05 You Bring" section above.