IT Systems & Infrastructure Advisor Sr

LocationHouston, TX
Job Typefull_time

About This Job

Oxy is an international energy company with assets primarily in the United States, the Middle East and North Africa. We are one of the largest oil and gas producers in the U.S., including a leading producer in the Permian and DJ basins, and offshore Gulf of Mexico. Our midstream and marketing segment provides flow assurance and maximizes the value of our oil and gas. Our chemical subsidiary OxyChem manufactures the building blocks for life-enhancing products. Our Oxy Low Carbon Ventures subsidiary is advancing leading-edge technologies and business solutions that economically grow our business while reducing emissions. We are committed to using our global leadership in carbon management to advance a lower-carbon world. Visit oxy.com for more information.

Occidental strives to attract and retain talented employees by investing in their professional development and providing rewarding opportunities for personal growth. Our goal is to meet the highest employer standards by ensuring the health and safety of our employees, protecting the environment and positively impacting our communities where we do business.

We are seeking a highly skilled and experienced ETL Developer with a strong background in cloud-based data solutions to join our team. The ideal candidate will possess extensive expertise in building robust data pipelines using AWS services (Glue, Lambda, Airflow, Step Functions, DynamoDB, Redshift, S3, Iceberg, Data Zone) and a proven track record in ETL development and data warehousing. This role requires proficiency in CI/CD pipeline development with Terraform, strong scripting abilities in PowerShell, C#, Python, and PySpark, and in-depth knowledge of SSIS, SQL, and T-SQL. The successful candidate will be responsible for designing, developing, and maintaining complex ETL workflows, optimizing data processes, and addressing architectural challenges to ensure seamless data integration and migration. Experience with both AWS and Azure platforms and relevant certifications are highly preferred.

Requirements

Education: Bachelor's degree in Computer Science, MIS, or other IT-related fields.
Experience: Minimum of 5 years in software development.
Technical Skills:

+ Extensive experience in building data pipelines using cloud services like Glue, Lambda, Airflow, Step functions, Dynamo, Data Zone, Redshift, S3, Iceberg, etc. + Experience with ETL processes, data warehousing, and data modeling. + Experience in building CI/CD pipelines using Terraform. + Expertise in scripting and programming skills in PowerShell, C#, Python, PySpark (for automation). + Experience in SSIS (SQL Server Integration Services). + Strong SQL and T-SQL programming skills. + Knowledge of SQL Server databases, indexing, and performance tuning. + Understanding of error handling, logging, and troubleshooting in SSIS & AWS Cloudwatch. + Familiarity with Power BI, SSAS, and SSRS is a plus.

Soft Skills: Good communication skills and ability to learn new skills.


Responsibilities

ETL Development: Design, develop, and maintain ETL workflows using SSIS and custom-developed solutions.
Data Transformation: Extract data from various sources, transform it as per business requirements, and load it into data warehouses or databases.
Optimization: Optimize SSIS packages for performance and efficiency.
Data Integration: Design, develop, test, and deploy data integration solutions to consolidate data from multiple sources.
Data Migration: Perform data migration projects, ensuring data accuracy and consistency.
Incremental Data Loads: Handle incremental data loads and large-volume data processing.
Architectural Challenges: Address architectural challenges like cross-account data sharing issues and adding new data sources to data mover.
Problem Solving: Implement long-term fixes for recurring problems.
Data Mesh Principles: Ensure adherence to data mesh principles like domain ownership and interoperability.
Roadmap Maintenance: Maintain a product roadmap for internal ETL solutions and execute on the roadmap.
Stakeholder Communication: Communicate with stakeholders when new application features are rolled out.
Collaboration: Collaborate with the IT Application development team to add features and enhancements to the internal ETL solution.


Preferred Qualifications

Cloud Platforms: Experience with AWS and Azure.
Certifications: AWS Data Engineer Associate, AWS Solutions Architect Associate, Hashicorp Terraform Associate.

Recruitment Fraud

It has come to our attention various individuals and/or organizations are contacting people falsely pretending to recruit on behalf of Oxy. Please be aware that these recruiting scams and communications do not originate nor are they associated with our recruitment process. All Oxy job postings and offers will require a completed application through our company website.

Oxy does not charge a fee at any stage of the recruiting process. We will never:

Ask you to pay for applications, interviews, meetings, processing, training or for any other fees

Use recruiting or placement agencies that charge candidates an advance fee of any kind or
Request personal information such as passport and bank account details at an early stage of our recruitment process.

We recommend against responding to unsolicited business propositions or offers from people you don't know. Do not disclose your personal or financial details. If you believe you have been the victim of a recruiting scam, please contact your local police department.

All qualified applicants will receive consideration for employment without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by federal, state, or local law.

Similar Jobs

company-logo

IT Systems & Infrastructure Advisor Sr

Oxy
Job Typefull_time
 
Houston, TX
13 days ago
company-logo

IT Systems & Infrastructure Advisor Sr

Occidental
Job TypeFull-time
 
Houston, TX
13 days ago
company-logo

IT Systems Advisor

Occidental
Job TypeFull-time
 
The Woodlands, TX
about 1 month ago
company-logo

IT Infrastructure Analyst

Hawaiian Electric
Job Typefull_time
 
Hawaii, United States
20 days ago
company-logo

IT Infrastructure Analyst

Hawaiian Electric Company, Inc.
Salary
$78000 - $99600
Honolulu, HI
21 days ago
company-logo

IT Infrastructure Specialist

Chugach Electric Association
Salary
$95680 - $114400
Anchorage, AK
21 days ago
company-logo

It Systems Specialist

Metalworking Solutions
Job Typefull_time
 
Chattanooga, TN
9 days ago
company-logo

IT Systems Specialist

EPCOR
Job TypeFull-time
 
Glendale, AZ
21 days ago
company-logo

IT Advisor Systems

Occidental
Job TypeFull-time
 
Houston, TX
14 days ago
company-logo

IT Client Infrastructure Specialist

Hawaiian Electric Company, Inc.
Salary
$71100 - $88800
Honolulu, HI
28 days ago
company-logo

IT Supervisor - Infrastructure

Devon Energy
Job TypeFull-time
 
Oklahoma City, OK
about 1 month ago
company-logo

IT Infrastructure Engineer

Kairos Power
Job Typefull_time
 
Albuquerque, NM
15 days ago
company-logo

IT Systems Consultant - SAP

Avangrid
Job TypeFull-time
Salary
$120000 - $157208
Augusta, ME
about 1 month ago
company-logo

IT Business Technical Analyst, Senior | Infrastructure Security

Arizona Public Service - APS
Job Typefull_time
 
Greater Phoenix Area
13 days ago
company-logo

Systems Consultant

Tipmont
Job TypeFull-time
 
Lafayette, IN
26 days ago
company-logo

Principal IT Systems Analyst

Salt River Project
Job Typefull_time
 
Tempe, AZ
12 days ago
company-logo

IT Systems and Network Administrator

Alamos Gold Inc.
Job Typefull_time
 
Lynn Lake, MB
14 days ago
company-logo

IT Systems and Network Administrator

Alamos Gold Inc
Job TypeFull-time
 
Lynn Lake, MB
14 days ago
company-logo

IT System Analyst

G.I.S.
Job Typefull_time
 
Galliano
14 days ago
company-logo

IT Network & Systems Administrator

Windsor Salt
Job TypeFull-time
 
Windsor, ON
19 days ago

Trending Jobs

company-logo

Foundry Professionals

Penticton Foundry
Job TypeFull-time
 
British Columbia, Canada
about 1 month ago
company-logo

Deckhand

Ballard Marine Construction
Job TypeFull-time
 
Bradenton, FL
about 1 month ago
company-logo

HSE Operations Manager

ProPetro Services, Inc
Job Typefull_time
 
Midland, TX
19 days ago
company-logo

Apprentice Lineman

N Line Electric
Job TypeFull-time
Salary
$68640 - $106080
Longmont, CO
30 days ago
company-logo

Lineman, Apprentice

Imperial Irrigation District
Job TypeFull-time
Salary
$82706 - $95679
Imperial, CA
about 1 month ago
company-logo

EAST VALLEY NIGHT BILINGUAL JANITORIAL UNIT MANAGER( MESA,CASA GRANDE, GILBERT)

ENVIRONMENT CONTROL
Job TypeFull-time
Salary
$41600 - $47840
Mesa, AZ
about 1 month ago
WO

Field Service Technician

Westar Oilfield Rentals Inc
Job TypeFull-time
 
Fort St. John, BC
26 days ago
company-logo

Inventory Materials Specialist

HF Sinclair
Job Typefull_time
 
Artesia, NM
12 days ago
company-logo

Manager, IT - BMO

Constellation
Job Typefull_time
 
Kennett Square, PA
26 days ago
company-logo

NIGHT BILINGUAL JANITORIAL SUPERVISOR(SOUTH EAST VALLEY)

ENVIRONMENT CONTROL
Job TypeFull-time
Salary
$41600 - $47840
Gilbert, AZ
about 1 month ago
company-logo

HVAC Sales Comfort Advisor

Quality Degree, Inc.
Job TypeFull-time
Salary
$64924 - $200000
Royersford, PA
about 1 month ago
company-logo

LCL66 Apprentice Lineman Distribution

CenterPoint Energy
Job TypeFull-time
 
Houston, TX
about 1 month ago
company-logo

Heavy Truck Driver

Halliburton
Job TypeFull-time
 
Bossier City, LA
about 1 month ago
company-logo

Quality Plus Store Associate

Quality Oil Company LLC
Job TypePart-time, Full-time
 
Halifax, VA
30 days ago
company-logo

Asset Management Intern_PTIN5C

ENGIE North America Inc.
Job Typeinternship
 
Houston
23 days ago
company-logo

Quality Inspector

ACCIONA
Job Typefull_time
 
British Columbia, Canada
26 days ago
company-logo

Accounts Payable Clerk

Drax
Job TypeFull-time
 
Monroe, LA
about 1 month ago
S

Electrical Lineman

Smarthire
Job TypeFull-time
Salary
$62400 - $72800
Austin, TX
about 1 month ago
AW

Water Well Driller

Able Well Drilling
Job TypeFull-time
Salary
$45760 - $83200
Bowling Green, OH
about 1 month ago
company-logo

Electrician (Residential Solar)

Freedom Forever
Job TypeFull-time
 
Tucson, AZ
about 1 month ago

Notice: The inclusion of job postings or company information on our platform does not imply endorsement, partnership, or affiliation. Listings may include publicly available roles from various sources, and companies shown may not have a direct relationship with Energy Hire.