Data Architect Job at System One, Arlington, VA

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

Job Tags

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

Similar Jobs

Sage Hospitality

Room Attendant Job at Sage Hospitality

 ...prompt repair/resolution. Secures and maintains custody of equipment, keys and supplies at all times in order to protect and preserve hotel property. Maintains a friendly, cheerful and courteous demeanor at all times. Performs other duties as assigned, requested or... 

A.P. Moller Maersk

Driver Helper Job at A.P. Moller Maersk

 ...e-commerce, direct to store, dropship, returns, and more, leveraging asset-based, asset-light, and non-asset models. The drivers helper is responsible for assisting the driver in all day-to-day activities. this includes but is not limited to loading and unloading... 

Woodward, Inc.

Business Intelligence Developer Job at Woodward, Inc.

 ...position. Salary will be determined by the applicant's education, experience, knowledge, skills, and abilities, as well as internal equity...  ..., and vision Insurance upon date of hire ~ Vacation / Sick Time / Vacation Buy-up / Short Term Disability / Bereavement leave.... 

Mile Hi Water

Class B Local Water Truck Driver Job Job at Mile Hi Water

Class B Local Water Truck Driver JobSeeking a full-time water truck driver who is comfortable with mountain driving. The route includes rural and city locations in the Boulder County area. Driver needs to be able to comfortably drive mountain roads and negotiate narrow... 

Confidential

Warehouse Associate / Freight Handler- Anderson, SC Job at Confidential

 ...**Job Summary:**Humano is currently seeking motivated Warehouse Associates / Freight Handlers to join our team at our Anderson, SC warehouse location for 1st and 2nd shift. As a Warehouse Associate/Freight Handler, you will be responsible for unloading containers by...