Data Architect Job at System One, Arlington, VA

SE5HR0U1dG9NeDArRndNYkVDWC81eDFmMHc9PQ==
  • System One
  • Arlington, VA

Job Description

Data Architect
REMOTE

Overview
If interested reach out directly to kimberly.spicer@systemone.com

Responsibilities

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

System One, and its subsidiaries including Joulé and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.

System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.

#LI-KA1
#M1
Ref: #851-Rockville-S1


System One, and its subsidiaries including Joulé, ALTA IT Services, TeamPeople, and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.

System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.

Job Tags

Contract work, Work experience placement, Local area, Remote work

Similar Jobs

Cummins Worldwide

Personal Assistant Job at Cummins Worldwide

 ...Were Hiring an Experienced Personal Assistant for Mr. Tom Cummins ! Location: Clearwater, FL Schedule: MonFri | 7:00 AM 3:00 PM | In-Office Cummins Worldwide is a management organization built to support and grow other companies. We offer services in accounting... 

Northwestern Memorial Healthcare

Outpatient Physical Therapist - Flexible Part-Time(Glenview) Job at Northwestern Memorial Healthcare

 ...seeking a dedicated Physical Therapist to provide high-quality care at their Outpatient Glenview Clinic and nearby clinics. This part-time role requires a minimum commitment of 16 hours per month, with strong outpatient experience preferred. The successful candidate will... 

Aptyx

Production Worker Job at Aptyx

SUMMARY Daily running of manufacturing equipment (extrusion) as well as other duties typical of manufacturing. PRIMARY RESPONSIBILITIES Start up and shut down of all production and manufacturing equipment as required. Repair of all production and manufacturing equipment...

Confidential

Infusion Nurse - Part-time Job at Confidential

 ...Part-Time Infusion Nurse (RN) Boston, MA Overview Our client, a long-standing infusion therapy provider, is seeking a Part-Time Infusion Nurse to support a growing branch. This is a flexible, one-day-per-week role that will convert to full-time in 6 months.... 

Carrington Homes, Inc

Custom Residential Architectural Designer Job at Carrington Homes, Inc

 ...Custom Residential Architectural Designer Carrington Homes | Fishers, IN Carrington Homes is all about family and we treat our customers like family too. Established in 1992 by Carl McIntyre and his parents Chuck and Sandy, Carrington Homes has completed hundreds...