Ashburn Consulting LLC

Data Architect

Ashburn Consulting LLC

full-time

Posted on:

Location Type: Remote

Location: Virginia • United States

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

Amazon RedshiftAWSCloudDockerNode.jsPythonSQLSSIS

About the role

  • 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

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