What are the responsibilities and job description for the Python Data Engineer position at The Bergaila Companies?
Overview
We put the unity in "opportunity."
Opportunity Snapshot:
- Compensation: $105.00/hour
- Location: Houston, TX (Downtown)
- Duration: 6 months
- Schedule: 9/80, M-Th 9 (hours), Friday (4 hours) in-office
- Benefits: Comprehensive insurance, 401(k) program, PTO & Holidays
- Must be a Houston local with right to work to be considered
Responsibilities
- Design and implement reliable data pipelines to integrate disparate data sources into a single Data Lakehouse
- Design and implement data quality pipelines to ensure data correctness and building trusted datasets
- Design and implement a Data Lakehouse solution which accurately reflects business operations
- Assist with data platform performance tuning and physical data model support including partitioning and compaction
- Provide guidance in data visualizations and reporting efforts to ensure solutions are aligned to business objectives
Qualifications
- 5 years of experience as a Data Engineer designing and maintaining data pipeline architectures
- 5 years of programming experience in Python and ANSI SQL
- 2 years of development experience with DBT, Data Build Tool
- Experience in various data modelling methods such as Star Schema, Snowflake, and Data Vault design
- Experience in implementing a Data Lakehouse using a Medallion Architecture with Apache Iceberg on S3 Object Storage
- Experience in various data integration patterns including ELT, Pub/Sub, and Change Data Capture
- Experience with common Python Data Engineering packages including Pandas, Numpy, Pyarrow Pytest, Scikit-Learn, and Boto3
- Excellent communication skills with experience presenting complex concepts to technical and non-technical stakeholders
- Experience in software development practices such as Design Principles and Patterns, Testing, Refactoring, CI/CD, and version control
- Experience with Dremio, Apache Airflow, and Airbyte is preferred
- A minimum of a high school diploma or G.E.D equivalent is required
The Bergaila Way:
The Bergaila Companies is a nationally recognized leader in providing staffing services to all sectors of the energy industry. We continually focus on partnering with talented professionals, engineering the perfect fit between our clients and employees. Choosing a career path with Bergaila grants you immediate access to nationally recognized organizations we partner with. Bergaila consistently attracts and retains its Employees with our dedicated internal service team, top tier benefits programs for contractors and their families, and commitment to place you in the desired career of your choice.
Client Overview:
Our client is one of North America's largest Midstream Oil & gas companies. A publicly traded company they are a leading provider of midstream energy services to producers and consumers of natural gas, natural gas liquids (NGL's), crude oil, and refined products/petrochemicals.
Salary : $105