Data Warehouse Engineer
Data Warehouse Engineer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job 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 20000 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.
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 APIs.
- 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 ones 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.
- The typical hours of operation are Monday through Friday 8:00 a.m. to 5:00 p.m. with flexibility required for various events meetings and relevant business needs.
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.
Employment Type
Full-Time
