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
16 days ago
company-logo

IT Systems & Infrastructure Advisor Sr

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

IT Infrastructure Analyst

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

IT Infrastructure Specialist

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

IT Infrastructure Analyst

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

IT Infrastructure Manager

LS Power
Job Typefull_time
Salary
$131000 - $200790
Oakland, CA
5 days ago
LP

IT Infrastructure Manager

LS Power Development, LLC
Job TypeFull-time
Salary
$131000 - $200790
Oakland, CA
5 days ago
company-logo

IT Infrastructure Specialist I

Alliant Energy
Job TypeFull-time
Salary
$58000 - $75000
Cedar Rapids, IA
10 days ago
company-logo

IT Infrastructure Manager

Engie
Job TypeFull-time
Salary
$131000 - $200790
Oakland, CA
30 days ago
company-logo

It Systems Specialist

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

IT Systems Specialist

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

IT Advisor Systems

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

IT Infrastructure Engineer

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

IT Infrastructure Administrator I, II, or Senior

Southwest Power Pool
Job TypeFull-time
Salary
$62500 - $123700
Little Rock, AR
29 days ago
company-logo

Specialist Systems, IT Infrastructure

Independent Electricity System Operator (IESO)
 
Mississauga, ON
9 days ago
company-logo

IT Systems Analyst

Gravity Oilfield Services
Job TypeFull-time
 
Houston, TX
10 days ago
company-logo

IT Systems Analyst

Xcel Energy
Salary
$87001 - $117200
Golden, CO
11 days ago
company-logo

IT Business Technical Analyst, Senior | Infrastructure Security

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

Systems Consultant

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

IT Network & Systems Administrator

Windsor Salt Ltd.
Job Typefull_time
 
Belle Plaine, SK
3 days ago

Trending Jobs

company-logo

Assistant General Manager, Navy Yard Electric Utility

PIDC
Job TypeFull-time
Salary
$108000 - $108000
Philadelphia, Pennsylvania
about 1 month ago
company-logo

Electrical Engineer

Dudley Staffing
Job TypeFull-time
Salary
$55 - $75
Canonsburg, Pennsylvania
4 months ago
company-logo

Division Order Analyst

Coronado Resources
Job TypeFull-time
 
Dallas, Texas
about 1 month ago
company-logo

Accounts Payable Clerk

LPR Energy
Job TypeFull-time
Salary
$65000 - $65000
Dallas, Texas
about 2 months ago
company-logo

Division Order Landman

R. Lacy Services, Ltd.
Job TypeFull-time
 
Longview, Texas
15 days ago
company-logo

contract landman

HPS Oil & Gas Properties
Job TypeFull-time
 
Lafayette, Louisiana
4 months ago
company-logo

Oil and Gas Land and Title Analyst - SAM Associate II

Bank of America
Job TypeFull-time
 
Dallas, Texas
2 months ago
company-logo

Attorney

Toeppich & Associates
Job TypeFull-time
 
Houston, Texas
about 1 year ago
company-logo

Professional Landman

Penterra Services, LLC
Job TypeContract
 
Lovington, New Mexico
8 days ago
company-logo

Contracts Administrator

Third Coast
Job TypeFull-time
Salary
$70000 - $85000
Houston, Texas
about 2 months ago
company-logo

Senior Landman

Greenlake Energy
Job TypeFull-time
 
Austin, Texas
2 months ago
company-logo

Title Landman

Sustain Land Services
Job TypeFull-time
 
Norman, Oklahoma
3 months ago
company-logo

Electrical Designer

Dudley Staffing
Job TypeFull-time
Salary
$45 - $60
Canonsburg, Pennsylvania
4 months ago
company-logo

Landman

Stockyards Energy Land Services
Job TypeContract
 
Akiachak, Texas
5 months ago
company-logo

Title Reviewer

Innovation Land Services
Job TypeFull-time
 
Pittsburgh, Pennsylvania
4 months ago
company-logo

Oil and Gas Title Attorney

Oliva Gibbs PLLC
Job TypeFull-time
 
Houston, Texas
about 2 months ago
company-logo

HSE Operations Manager

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

Financial Analyst

Third Coast
Job TypeFull-time
 
Houston, Texas
4 months ago
company-logo

Mechanical/Piping Engineer

Dudley Staffing
Job TypeFull-time
Salary
$55 - $75
Canonsburg, Pennsylvania
4 months ago
company-logo

E & I - Office/Field Administration

Surepoint Group
Job Typefull_time
 
Grande Prairie, AB
11 days 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.