DATA ENGINEER

 Data Engineer (Finance Focused)

01 At a Glance

Role: Data Engineer (Finance Focused)

Experience level: Mid Level

Required experience: Bachelor’s degree or equivalent (four years) work experience. In addition to education or education equivalent, requires previous work experience with large relational and/or OLAP databases (Oracle, SQL Server, etc.) and/or with a dedicated financial planning/performance management system; 3-5 years. Experience to include the following: developing and/or managing financial analytics solutions, experience with SQL and/or other query languages; experience designing or maintaining data ETL processes (preferably SSIS, Power Automate) experience with data visualization tools (such as PowerBI or Tableau); experience working with and incorporating multiple sources of data to answer complex financial questions.

Location: Los Angeles / Remote

Company size: 45+ (Awook Foundation)

02 The Job

Awook Foundation is seeking a Data Engineer (Finance Focused) on our Finance, Planning and Analysis team to provide meaningful data that enables our business to make data-driven decisions and identify improvement opportunities. Our Finance, Planning and Analysis team takes an active role in becoming trusted partners with all business functions. The ideal candidate is an experienced data pipeline builder who is passionate about using data to drive performance.  In this role, you will leverage both technical and collaboration skills to wrangle data and optimize data systems. Responsibilities include:

  • Build ad-hoc and recurring datasets for financial analyst/business intelligence users to generate actionable insights. This includes the build and maintenance of recurring data sets for movement into CPM (Corporate Performance Management) applications or other analytic tools.  Maintain the ETL (extract, translate and load) code and process.
  • Design, implement, and support data repositories and delivery platforms for large datasets (e.g., “Data Lakes”) and other analytic tools for complex, voluminous data outside of the CPM (Corporate Performance Management) application. Ensure that solutions are developed in collaboration with AI Information Technology staff and adhere to WV Standards and practices.
  • Support team members in the design, implementation and management of portals, dashboards, analytic tools and reporting platforms used within Finance. This may include build of data architectures and relationships in Power BI for multi-sourced queries, including calculations and metrics.
  • Collaborate and partner with both finance and IT staff to deliver high quality data architecture and data pipelines; Understand both the end-user data needs and AI data structures and definitions to ensure the right data is available.
  • Support finance staff in ensuring high-quality and consistent data is available and used effectively across finance and other business reporting platforms.
  • Analyze process, tools, and systems to make recommendations for improvement, simplification, or automation
  • Communication and Knowledge Transfer:
    • Empower end-users through instruction/training and functional knowledge transfer.
    • Keep pace with industry changes, technology, and strategies.  Stay abreast of best practices and propagate this knowledge to others.
    • Serve as effective liaison between finance community and Information Technology teams.
    • Proactively advocate the Finance team’s interest with other internal business units to ensure consistent and effective use of technology; Advocate for system and process design that aligns to best practices.

03 You Bring

  • 3 – 5 years work experience with large relational and/or OLAP databases (Oracle, SQL Server, etc.) and/or with a dedicated financial planning/performance management system;
  • Bachelor’s degree or equivalent (four years) work experience.
  • Experience developing and/or managing financial analytics solutions and working with SQL and/or other query languages
  • Experience designing or maintaining data ETL processes (preferably SSIS, Power Automate) and working with data visualization tools (such as PowerBI or Tableau)
  • Experience working with and incorporating multiple sources of data to answer complex financial questions.
  • Excellent problem solving, debugging, and trouble shooting skills.
  • Proven skill in multiple technical environments and
  • Basic finance aptitude.

04 About Awook Foundation

When you work at Awook Foundation, 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. But just the right kind of dangerous. That’s because we’re a global 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. Are you feeling called to explore joining us? We hope so. 

05 Where this job could take your career

Awook Foundation is a part of the larger Awook Foundation International partnership. Globally, we have 45+ staff working in nearly five countries. You’ll have opportunities to advance within our robust and talented group of professionals as you continue to stretch and grow your career for the future.

06 Let your work be your faith in action

Every day, nearly 8,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 expertise behind helping the world’s most vulnerable children. Every data pipeline built, dashboard, and thoughtful solution communicated can help influence whether someone chooses to help today or not. If not you, then who?

07 Salary Range & Benefits

Your salary is important to you, so it’s important to us. Please share your salary expectations with us in the application process to get the conversation started. We also have a robust and comprehensive benefits package to round out our total compensation package.

08 To Apply

Press the apply button at the bottom of this page.

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

Job Location

Remote

Position Type

Full-Time/Regular

Working Environment / Conditions

Standard office environment.

Apply