Data Warehouse Engineer

5 Days ago • 5 Years +

About the job

Summary_{By Outscal}

YouVersion seeks a Data Warehouse Engineer with expertise in Google Cloud Platform, SQL, Python, and data orchestration tools to design and deliver reliable data pipelines. Must have strong knowledge of data warehousing and modeling principles, and be proficient in database management systems. The role requires excellent communication skills and a passion for data-driven decision making.

Do you love the Bible and also enjoy writing code and processing data? This role may be for you!

The YouVersion Data Warehouse Engineer role will be responsible for providing data engineering support and delivery across all product lanes. This position will require expertise in areas of data engineering, architecture, governance, quality, and testing. This individual will need to understand the big picture of all things YouVersion data, yet be able to design and deliver at the detailed technical level.

This role is critical in increasing engagement and growth through the Bible App globally. The Data Warehouse Engineer will work tightly with the Data Analytics team, Software Engineering team, and Product teams. This role is responsible for defining and delivering quality data that is used to know our users more closely so our team can fulfill the YouVersion mission, “to encourage and challenge people to seek intimacy with God daily”!

YouVersion was created by the local church in 2007 and remains a ministry of Life.Church today. At Life.Church, our mission is to lead people to become fully devoted followers of Christ. Our team is committed to reaching people worldwide through innovative technology. And YouVersion is one of the ways we get to do that. Life.Church is a multi-site Christian church meeting in the United States and globally at Life.Church Online.

We wholeheartedly believe a daily rhythm of seeking intimacy with God has the power to transform lives. That’s why YouVersion creates biblically-based experiences that encourage and challenge people to seek God. We hope everyone in our community is on an active journey to become who God made them to be, abiding in Him, and drawing closer every day.

What You'll Do

Drive data awareness and provide accurate and actionable data for analytics and decision-making.
Design and deliver complex data pipelines that are reliable and scalable.
Support, maintain, and refine existing ETL processes and data interfaces.
Collaborate with data and product teams to ensure data solutions are prioritized and shaped for delivery.
Provide documentation and diagramming for the understanding of other engineers and leaders.
Develop data catalogs and data definitions for clear usage and understanding.
Develop expert-level knowledge of the data infrastructure, tools, and processes.
Assist across internal teams to define excellence in data governance, privacy, and security.
Continuously learning tools, technologies, and best practices of data engineering.
Develop testing and monitoring across all levels of data to deliver trusted quality data results.
Lead, mentor, and develop other data engineers.
Understand and support user events processing to bring our data knowledge to the next level.
Engage as an active contributor within our agile development process.
Own projects and oversee them with minimal direction.
Manage schedules and duties to efficiently meet the needs of the organization in the pursuit of leading others to become fully devoted followers of Christ.

Skills Needed to Succeed

Strong knowledge of the Google Cloud Platform including BigQuery, Dataflow, DataStream, etc. or other similar cloud platforms.
Strong SQL knowledge, with the capability to write complex SQL and provide performance tuning.
Highly skilled in Python, Go, Java scripting, or other general-purpose programming languages.
Proficient with data orchestration/transformation tools such as Airflow, Pub/Sub, FiveTran, CDC, DBT, streaming, etc.
Proficient in Database Management Systems, such as Postgres, BigQuery, or SQL Server.
Understanding of user event data collection products such as Firebase, GA4, or similar.
Preferred experience with JIRA, Gitlab, Amplitude, Backstage, Notion, and LucidChart.
Experienced in data warehousing modeling and design fundamentals.
Exceptional in time management to meet strict deadlines while remaining flexible and open to change.
Excellent verbal, written, and interpersonal communication skills to clearly explain complicated processes.
Strong knowledge of analytics tools like Tableau or others is a bonus.
Bachelor's Degree and/or Advanced Certification.
5+ years of data and engineering related work experience.

Benefits We Offer

- Paid parental leave, including maternity, paternity, and adoption leave.

- Generous employer-paid leave for the use of vacation, sick time, and other qualifying reasons.

- Innovative and comprehensive Medical, Dental, and Vision insurance that provides team members with useful resources and savings to navigate their holistic health.

- Life insurance policy provided for all staff members at 2x annual salary at no cost. Additional life insurance coverage is available to purchase.

- Short-Term and Long-Term disability is covered at 100% for full-time qualified staff members.

- Comprehensive wellness and mental health benefits allow staff to proactively invest in their physical and emotional health.

- Generous 401(k) retirement plan allowing a team member to have up to 12.5% (including employee contribution, employer match, and employer discretionary contribution) contributed into their account in their first year. It doesn’t stop there—the more years on staff, the greater the investment!

-$160 annually in development dollars for team members to invest in their professional growth.

- Casual dress and work environment.

- And much more!

Our Beliefs, Culture, and Commitment to Diversity

At Life.Church, every staff member, and intern is a minister and is expected to engage in the church's ministry fully. We consider ministry readiness and an individual’s capacity to represent Life.Church’s beliefs as a minister during the selection process for all staff and intern positions. An essential function within every position held by a staff member or intern at Life.Church is to uphold and represent the beliefs of Life.Church. Learn more about what we believe at Life.Church.

While we unite around our mission, we know unity doesn’t mean uniformity. Our calling is too great, and our mission is too important not to be intentional about strengthening our team through diversity. We know that diverse perspectives in race, ethnicity, background, age, and gender are essential to reaching the world for Christ. To learn more about how we strengthen our team through diversity, visit our careers page.

All data collected in our application process, from resume collection to application questions, is used for recruitment purposes only.