Location: Baytown, TX
Type: W2 Contract (1 year with possibility for extension)
Work Setup: On-site
Industry: Oil & Gas
Benefits: Medical, Dental, Vision & 401(k)
Job Summary
Airswift is seeking a Database Administrator II to support one of our major clients in the Energy sector. This mid-level position is suited for candidates experienced in data engineering, analytics engineering, and building highly reliable analytical data products across Snowflake, Power BI, and cloud-based data ecosystems.
The Database Administrator II will own a defined analytics workstream, such as reliability, performance, maintenance, energy, or production reporting, and will deliver analytics?ready datasets, certified KPIs, and governance?aligned data models. This role requires strong technical capabilities, attention to data quality, and the ability to collaborate with business stakeholders in a fast-paced operational environment.
Key Responsibilities
- Build analytics-ready data models and Power BI datasets, including DAX optimization and aggregation strategies.
- Design robust, cost?efficient data pipelines across Snowflake and other datalake environments, supporting both batch and near real?time data scenarios.
- Implement monitoring, alerting mechanisms, and data freshness tracking for production pipelines and datasets.
- Own and enforce data quality rules, ensuring alignment with dataset certification requirements and implementing Row-Level Security (RLS).
- Collaborate with OT/IT/IIT Security, networking, and compliance teams on cybersecurity, data privacy, and access controls.
- Steward Azure AD group-based access controls for secure dataset and workspace management.
- Translate operational processes into standardized KPI definitions and reconciled analytical datasets.
- Implement secure integrations using Azure AD OAuth2, service principals, and managed identities for APIs such as SharePoint REST/Graph and storage endpoints.
- Manage GitHub version control including branching, rebasing, and repository hygiene.
- Author high?quality pull requests that include testing notes and rollback plans.
- Version and tag pipelines, shared libraries, and related engineering assets.
- Contribute to GitHub Actions and CI workflows for automated testing and deployment.
Basic / Required Qualifications
- 3+ years of experience in data engineering or analytics engineering.
- Strong proficiency in Python, SQL, Excel, GitHub, SharePoint, and Power BI.
- Practical experience working with Snowflake.
- Experience with CMMS, RBI, and industrial time-series datasets.
- Familiarity with Azure or Microsoft Fabric-based data platforms.
- Understanding of petrochemical processes and downstream business operations.
- Demonstrated capability in Power BI performance tuning and dataset governance practices.
- Bachelor’s degree in Engineering, Computer Science, Data Systems, or a related field; Master's degree preferred.
Preferred Qualifications
- Experience working in operational technology environments or reliability/maintenance analytics.
- Prior involvement in building KPI frameworks and standardized data governance structures.
- Hands-on experience with API integrations using Azure Identity patterns.
- Background in industrial data modeling, production reporting, or asset health analytics.
- Contributions to CI/CD workflows or DevOps practices within data engineering teams.