Data Architect

Ashburn Consulting LLC

Data Architect developing database solutions utilizing AWS data warehouse and lake architecture. Collaborating with teams for data management, quality checks, and performance improvements.

Posted 4/11/2026full-timeRemote • Virginia • 🇺🇸 United StatesMid-LevelSeniorWebsite

Tech Stack

Tools & technologies

Amazon RedshiftAWSCloudDockerNode.jsPythonSQLSSIS

About the role

Key responsibilities & impact

Develop database solutions to securely store and retrieve Client information utilizing the Client’s Amazon Web Services, (AWS) data warehouse and data lake architecture.
Rewrite SSIS packages to a modern framework using Docker, Node, Python, dbt.
Analyze existing package to plan and develop roadmap for code conversion.
Perform data testing and data quality checks.
Analyze and recommend performance improvements to Redshift Datawarehouse.
Extend and apply security for data warehouse usage.

Requirements

What you’ll need

5-8 Years of proven work experience as a Data Architect, Data Scientist, Data Analyst or similar role
In-depth understanding of database structure principles
Experience gathering and analyzing system requirements
Knowledge of data mining and segmentation techniques
Prior experience working in a software development team/environment
Experience in SQL Server and SSIS
Experience in cloud technologies, specifically AWS suite of services; specifically – Redshift
Experience writing code in Node, Python
Experience in DBT
Proven analytical skills
Self-starter with problem-solving skills

Benefits

Comp & perks

Equal Opportunity Employer/Veterans/Disabled
An Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status.

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

database solutionsAWSdata warehousedata lakeSSISDockerNodePythondbtSQL Server

Soft Skills

analytical skillsproblem-solvingself-starter