Data Warehouse Engineer

Description

BACKGROUND

Tulsa For You and Me: a collection of talent and economic development programs building a vibrant and inclusive city through a booming economic landscape for Tulsa. We are forging strategic connections between talented professionals and innovative companies in future-focused industries. Operated under the stewardship of the George Kaiser Family Foundation (GKFF®), affiliated programs include nationally recognized and innovative organizations like Tulsa Remote, LLC, Tulsa Innovation Labs, LLC, inTulsa Initiative, LLC, Build In Tulsa, LLC, Atlas School, LLC, Campus Tulsa program, and Tulsa Service Year program, among others. 

Our North Star goal is both ambitious and clear: to attract and build 20,000 jobs in high-growth industry clusters by the year 2033. A cornerstone of this mission is our commitment to ensuring that at least one-third of these opportunities are accessible to Tulsans from historically underrepresented communities. This is an extension of our broader vision for a more equitable, innovative, and vibrant Tulsa, where a strong state of economic health provides the basis for equal opportunity. 

The Integrated Strategies group is composed of several expert teams dedicated to fostering cross-program collaboration, driving operational excellence, and equipping Tulsa for You programs with the tools, insights, and best practices to drive tangible results. The Integrated Strategies group includes teams focused on Technology, Research & Analytics, Marketing, and Operations. Join our high-impact team, where your work will have a lasting impact on the Tulsa community and its future.

PRIMARY PURPOSE AND FUNCTIONS

In this position, you will play a crucial role in managing and optimizing our data processes within our emerging Data Warehouse/Data Lake environments. This position requires a strong foundation in Python programming, ETL systems, and tools and a solid understanding of relational databases. You will work to ensure the efficiency and reliability of our data pipelines, contributing directly to the success of our projects. You will maintain all the back-end hardware and platforms to enable these applications and systems to run harmoniously with the Research and Data Analytics department. Azure experience is a strong plus.

Requirements

ESSENTIAL FUNCTIONS AND RESPONSIBILITIES

• Monitor performance and troubleshoot issues within ETL projects, proposing and implementing effective solutions to optimize system performance.
• Collaborate with data engineers, analysts, and other stakeholders to integrate new data sources and ensure seamless data flow and accessibility across the organization.
• Assist in the development and testing of new features, models, or data processes within our data warehouses, leveraging feedback to drive continuous improvement.
• Document data processes, models, and workflows within our data warehouses for internal knowledge sharing and to support ongoing learning and development.
• Stay updated on the latest data warehouse management features and best practices, applying this knowledge to innovate and improve project outcomes.
• Implement and maintain security protocols and data governance practices to ensure compliance with organizational policies and industry regulations.
• Evaluate and recommend new tools, technologies, and methodologies to enhance data processing and storage capabilities.
• Collaborate with data engineers, analysts, and other stakeholders with data flows, scripts, and models within Dataiku and other ETL systems, optimizing for performance and reliability.
• Collaborate with data engineers, analysts, and other stakeholders to ensure integrity and quality of data throughout the entire data lifecycle, from ingestion to analysis, by implementing data validation and cleansing processes.
• Other duties as assigned.

KNOWLEDGE EXPERIENCE AND SKILL REQUIREMENTS

Education & Experience:

• 4+ years experience managing data warehouses and ETL systems.

Preferred:

• 4-5 years working with Azure Data Warehouses.
• 2-3 years experience with version control systems, such as Git.
• 2-3 years experience in other data science and machine learning tools and frameworks (e.g., scikit-learn, TensorFlow, PyTorch, Java, Apex).

Skills & Abilities:

• Strong abilities in creating and optimizing data warehouses in Azure, but knowledgeable in AWS and GCP.
• Conceptual understanding of relational databases and data querying.
• Strong proficiency in writing and modifying database centric API’s.
• Familiarity with Dataiku and other ETL systems or a willingness to learn and master the platform.
• Excellent problem-solving skills and attention to detail.
• Strong proficiency in cloud computing platforms.
• Proficiency in containerization and virtualization technologies.
• Ability to work independently and collaboratively in a team environment.
• Strong communication skills, with the ability to document and explain technical details clearly.

Physical Requirements:

• Position continually requires the ability to talk and hear both in person and over the phone, visual acuity; ability to operate equipment, read, and use a keyboard.
• Position frequently requires the ability to sit, walk, and stand for extended periods of time.
• Position requires limited travel, predominantly for professional development and/or learning opportunities.

Hours & Location:

• You must live in or be able to relocate to Tulsa, OK or the surrounding area.
• This is not a fully remote position as we work in a hybrid office environment. In-Office and hybrid/flexible schedules are based on business need, staff readiness, and approved by one's supervisor. 
• This is a full-time position with an expectation of working 40 hours per week.
• The typical hours of operation are Monday through Friday, 8:00 a.m. to 5:00 p.m.
• Ability to occasionally work hours outside of 8:00 a.m.- 5:00 p.m. for events.

Benefits and Compensation:

As part of our overall compensation package, we offer work/life flexibility, comprehensive health benefits, paid time off, and generous retirement contributions designed to support you and your family. 

Details:

• 100% employer paid medical, dental, and long-term disability for full-time employees only. Option to add vision and dependents.
• 401K employee and employer contributions.
• Paid time off to support you while you are out of the office.
• Paid holidays so our employees can spend time with those they care about.
• Employer paid AD&D life insurance, with employee option to add supplemental life insurance.