Remote Role - ETL Architect

Remote Role - ETL Architect

Posted 3 days ago by Elegant Enterprise Wide Solutions

Apply
Negotiable
Undetermined
Remote
Remote or Virginia
Apply
Amazon Web Services (AWS) Cloud Computing Cloud Technologies Cloud Technology Code Conversion Data Architecture Data Mining Data Quality Data Warehousing Docker (Software) Extract Transform Load (ETL) File Servers Microsoft SQL Servers Nodes (Networking) Python (Programming Language) Software Development SQL (Programming Language) System Requirements Web Services

Summary: The ETL Architect role involves developing database solutions using AWS data warehouse and data lake architecture, modernizing SSIS packages, and ensuring data quality and performance improvements. The position requires a strong background in data architecture and cloud technologies, particularly AWS. The role is remote, allowing flexibility in work location. Candidates should possess proven analytical skills and experience in software development environments.

Key Responsibilities:

  • Develop database solutions to securely store and retrieve County information utilizing the 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.

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

Salary (Rate): undetermined

City: undetermined

Country: undetermined

Working Arrangements: remote

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

About this Position:

Job Title: ETL Architect

Essential Duties:

  • Develop database solutions to securely store and retrieve County information utilizing the 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.

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.

Apply
Similar Jobs
Loading data...