ESSENTIAL DUTIES & RESPONSIBILITIES

General description of main/primary duties and responsibilities of the job, aptitude, level of complexity, span of control, autonomy, decision making and judgement. It is central and necessary to the satisfactory performance of the job. Includes the following and other duties as assigned.

Under limited supervision, this position will:

Perform data engineering and modernization by designing, building and maintaining data integration, transfer and analysis solutions for structured, and semi-structured data. Leverage T-SQL, Spark SQL, SSIS, Python, Synapse, Azure Data Factory, OneLake, Data Lake, DBT etc.
Lead the technical migration of data solutions, primarily SQL Server, to Azure (Microsoft Fabric), Snowflake and Databricks or other cloud data technologies.
Implement and adhere to data management best practices as well as adopted security, development and coding standards for solution designs, performance tuning and optimization.
Ensure solutions are compatible with state-based deployment operations and CI/CD ready using tools such as SSDT projects, ARM/BICEP, DAB, etc.
Provide operational support by investigating failed jobs, troubleshoot data issues and respond to user reported errors in collaboration with DBAs and other members of the IT Teams. Perform diagnostics, index tuning, resource and performance optimizations.
Ensure continuity and reliability of existing data solutions during modernization.
Initially develop and support SQL Server solutions like stored procedures, SSIS packages and views. Transition and deliver reports via Spotfire to transfer data between systems or extract data to be transferred to outside partners or agencies. These solutions are mostly T-SQL and SSIS with occasional Python and PowerShell.
While progressing on cloud initiatives, build the same types of solutions, leverage cloud technologies and platforms like Microsoft Fabric and/or Databricks, and convert solutions to the cloud technology.
Perform other duties as assigned.

QUALIFICATIONS

Education, Experience, Licensure (minimum level required)

Bachelor’s Degree from an accredited institution.
Field of Study: Computer Science, Computer Information Systems or related.
At least seven (7) years of experience in data solution in SQL Server (2016-2022), using advanced T-SQL, performance optimization and other programming languages.
At least five (5) years of experience as Sr. DBA or Data Engineer.
At least tw0 (2) years of experience with Oil & Gas data workflows and applications such as WellView, Enertia, ProCount, Petra, Cygnet, OSIPI (Aveva), etc.
Proven experience with set-based development techniques, object-oriented concepts, etc.
Experience with state-based database deployments (e.g., SSDT, Redgate, dbForge, ApexSQL).

CORE COMPETENCIES

List and describe the required factors (i.e. knowledge, skills, abilities, software programs), that are needed for this role.

Strong technical knowledge and application with Azure data services (Azure SQL, Synapse, Microsoft Fabric, Databricks).
Strong understanding in ETL/ELT design, data integration (API, JSON, XML, Excel, proprietary formats).
Proficiency in Python, and PowerShell for data engineering workflows.
Intermediate to advanced SSIS expertise for supporting and optimizing legacy ETL processes.
Strong problem-solving mindset with a bias for automation and scalability.
Excellent communication skills; able to mentor peers and collaborate across teams, business & IT leadership as well as external partners.
Self-starter who thrives in a modernization and transformation environment and disciplined adherence to standards and processes inside a fast-paced and results-oriented environment.
Ability to work with external partners and consultants, and partner with domain experts and senior leadership within the Company.

SUPERVISORY RESPONSIBILITIES

Functions as an individual contributor with no supervisory responsibilities.

WORK ENVIRONMENT

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Excludes occasional visitation to the field – reference Travel section.

Office Related:

Job is primarily performed in an office setting with exposure to computer screens and requires regular use of a computer, keyboard, mouse, and multi-line telephone system.
The noise level in the work environment is usually moderate.
Specific vision abilities required by this job include close vision, distance vision and ability to adjust focus.

HOURS / SHIFTS

Regular business hours.
Available for on-call rotation and responsibilities on weekends and holidays for urgent issues or emergencies during off hours, as needed.

PHYSICAL DEMANDS

Minimally required to sit, stand, walk, and reach with hands and arms.
Minimally lift, push, carry and/or move up to 50 pounds.
Minimally be able to bend, stoop, crouch, etc.

TRAVEL

Approximate amount of time.

Minimal travel may be required to other locations.

Summary of Available Benefits*:

Health Care eligibility including Medical & Prescription, Dental and Vision coverages
Health Savings Account (HSA), Dependent Care FSA and Dependent Care FSA match
Employer Paid Insurance: Basic Life and AD&D (employee, spouse, child), Short-Term and Long-Term Disability Coverage
Voluntary Insurance: Life and AD&D, Accident, Long Term Care, Critical Illness, Hospital Indemnity, Pet Insurance, Legal Services
Employee Assistance Program (EAP)
401(k) with employer matching
Student Loan Repayment Reimbursement
Vacation, Personal Choice Days (PCD), Sick Time
Paid Parental Leave
Company paid Holidays
Wellness Reimbursement
Subsidized Parking and Public Transportation
Financial Well-being Program
Professional Membership Reimbursement
Employee Discount Programs
Benefits eligibility is dependent on the employee’s job classification. Effective date is the first of the month after the event date or the first of the month if the event date is the first of the month.

Antero Resources Corporation

Latest Jobs

Data Engineer