What are the responsibilities and job description for the Data Architect (AWS/Redshift) position at Trigyn?
Job Description: Data Architect (AWS/Redshift)
Position Id:
J0426-0030
Job Type:
6-12 months (contract)
Country:
United States
Location:
Arlington, VA / Remote
Pay Rate:
Open
Contact Recruiter:
703-454-2948
Job Description:
Trigyn's Direct Client based out of Arlington, VA has a contract assignment (REMOTE) for a Data Architect.
The Department of Technology Services seeks a Data Architect to work in the Application Development and Data Management team.
Responsibilities of the team include building ETL scripts to support data warehouse and performing data management tasks to enable data sharing for external and internal use.
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 organization.
- Develop database solutions to securely store and retrieve County information utilizing 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
- Proven work experience as a Data Architect, Data Scientist, Data Analyst role
- In-depth understanding of database structure principles
- Experience gathering and analyzing system requirements
- Experience in cloud technologies, specifically AWS suite of services; specifically – Redshift
- Knowledge of data mining and segmentation techniques
- Prior experience working in a software development team/environment
- Experience in SQL Server and SSIS
- Experience writing code in Node, Python
- Experience in DBT
- Proven analytical skills, Self-starter with problem-solving skills
Please send your resume to RecruiterPS@Trigyn.com or call 703-454-2948
Trigyn-8181
TRIGYN TECHNOLOGIES, INC. is an EQUAL OPPORTUNITY EMPLOYER and has been in business for 35 years. TRIGYN is an ISO 27001:2022 and CMMI Level 5 certified company.