About Us
Beacon Systems, Inc, delivers Program Management, Science, Engineering, and Technology Solutions to Federal, Commercial State, and Local Agencies. We are a subsidiary of Radiant Digital Solutions. Our Technology support to many DoD Agencies, NASA, Voice of America, FDA, and State Agencies such as State of FL, RI, MS, ND, VA, and WV extends our delivery of solutions worldwide.
Job Title: Data Architect
Location: Remote-Arlington, VA
Duration: 12 Months+
Job Description:
Data Architect to work in the Application Development and Data Management team. Responsibilities of the team include building ETL scripts to support County 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 organization.
Essential Duties:
Develop database solutions to securely store and retrieve County information utilizing the County’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
Desirable skills:
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
Never miss an opportunity! Create an alert based on the job you applied for.
