Data Architect

  • Full-time

Company Description

Ashburn Consulting, a Small Business based in the Washington, DC metropolitan area, specializes in providing network and network security solutions in complex environments to a select set of government and business clients. The company, an established leader in its field, is composed of an elite team of engineers and business consultants, each of whom is recognized —and highly regarded—within the network and security communities.

Job Description

Ashburn Consulting LLC, seeks a Data Architect to work in the Application Development 
and Data Management team. Responsibilities of the team include building ETL scripts to support Client 
data warehouse and performing data management tasks to enable data sharing for external and internal 
use.
The employee will serve as a key interface between the DTS and other departments and must have 
demonstrated the ability to communicate and discuss business issues with technical and non-technical 
audiences at all organizational levels. The Data Architect will work closely with the technical manager 
and key stakeholders to implement data strategies and promote data management best practices for 
use across the Clients organization

Responsibilities:

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

Qualifications

• 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 skill

Additional Information

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

Ashburn Consulting is an Equal Opportunity Affirmative Action Employer.
In compliance with the American with Disabilities Act Amendments Act (ADAAA), if you have a disability and would like to request and accommodation in order to apply for a position with Ashburn Consulting, please e-mail [email protected].”