Seneca Resources Company, LLC ยท 1 month ago
Data Solutions/AI Architect
Arlington, VA
Contract
Hybrid
Mid Level
3+ years expSeneca Resources is a staffing and consulting firm that connects professionals with meaningful work. They are seeking an experienced Data Solutions / AI Architect to design and deliver modern data architecture solutions for a Federal Government client, focusing on data warehousing and AI-ready architectures.
Oil & Energy
No H1B
Security Clearance RequiredU.S. Citizen Only
Responsibilities
Serve as the lead Solutions Architect and AI Architect for enterprise data platforms
Design and implement data warehouse architectures to support reporting, analytics, and AI workloads
Develop and optimize Azure ETL pipelines using Azure-native tools and Databricks
Design and maintain logical and physical data models using dimensional modeling techniques
Build and optimize PL/SQL packages and tune databases for high-performance workloads
Translate complex business requirements into scalable technical solutions
Ensure high data quality through profiling, cleansing, auditing, and validation processes
Lead QA efforts including unit, system, and integration testing
Partner with Business Analysts to produce functional and technical specifications
Produce clear system documentation and user-facing materials
Provide guidance on cloud data architecture and AI enablement best practices
Qualification
Required
Must be a U.S. Citizen and eligible to obtain a Public Trust clearance
Must have resided in the U.S. for the past 5 years and not traveled outside the U.S. for more than 6 months in total during that period
Bachelor's degree in Computer Science, Engineering, Data Science, or a related field (or equivalent experience)
3+ years of experience with Azure data services and ETL processing
3+ years of experience with data warehousing methodologies and architecture
Strong expertise with Azure Databricks
Hands-on experience writing and optimizing PL/SQL
Proficiency in data modeling (logical and physical)
Strong understanding of dimensional modeling techniques
Experience with database performance tuning and query optimization
Solid understanding of full SDLC in data and analytics environments
Excellent written and verbal communication skills
Preferred
Consulting experience in Agile environments
Familiarity with enabling data platforms for AI, analytics, and machine learning
Benefits
Comprehensive health, dental, and vision coverage
401(k) retirement plans
Company
Seneca Resources Company, LLC
Seneca Resources Company, LLC, the exploration and production segment of National Fuel Gas Company, headquartered in Houston, Texas, explores for, develops, and produces natural gas in the Appalachian Region including the Marcellus and Utica Shales.
201-500 employees
Funding
Current Stage
Growth StageLeadership Team
John McGinnis
Chief Operating Officer
Todd Abbott
Chief Operating Officer
Company data provided by crunchbase