Data Solutions/AI Architect

Hello,

Position Title: Data Solutions / AI Architect

Location: Arlington, VA (Hybrid – Remote with 1 day onsite per week)

Position Status: Contract (Part-Time – Approx. 20 hours/week)

Clearance Requirements: 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.

Position Description:

We are seeking an experienced Data Solutions / AI Architect to design and deliver modern data architecture solutions supporting a Federal Government client in Arlington, VA. This role is ideal for a hands-on architect with deep expertise in Azure data platforms, data warehousing, and AI-ready architectures who enjoys solving complex business challenges through scalable, secure, and analytics-driven solutions.

In this role, you will serve as the technical lead for data warehousing initiatives, collaborating closely with business stakeholders, engineers, and analysts to design optimized data models, ETL pipelines, and analytics platforms. You will play a key role in enabling AI and advanced analytics by ensuring data environments are well-architected, performant, and scalable.

This position offers flexible part-time hours and the opportunity to work on mission-critical systems with real-world impact.

Key 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.

Required Skills / Education:

- 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.

- Consulting experience in Agile environments preferred.

- Familiarity with enabling data platforms for AI, analytics, and machine learning.

About Seneca Resources

At Seneca Resources, we are more than just a staffing and consulting firm, we are a trusted career partner. With offices across the U.S. and clients ranging from Fortune 500 companies to government organizations, we provide opportunities that help professionals grow their careers while making an impact.

When you work with Seneca, you’re choosing a company that invests in your success, celebrates your achievements, and connects you to meaningful work with leading organizations nationwide. We take the time to understand your goals and match you with roles that align with your skills and career path. Our consultants and contractors enjoy competitive pay, comprehensive health, dental, and vision coverage, 401(k) retirement plans, and the support of a dedicated team who will advocate for you every step of the way.

Seneca Resources is proud to be an Equal Opportunity Employer, committed to fostering a diverse and inclusive workplace where all qualified individuals are encouraged to apply.