American IT Systems

American IT Systems

·3 days ago

Etl developer/ data engineer

Apply now

Location

remote, MA, United States

Salary

$101k – $111k/yr

Commitment

Full Time

Level

Senior (5+ years)

Required skills

Data AnalyticsStat Tools & LanguagesSQLETL / Data TransformationETLOSSProgramming LanguagesDatastoresInfrastructureLibrariesComputeBig Data ToolsData Science Tools

Job Description

JOB DESCRIPTION

Job Title: ETL Developer

7+ Years experience

Contract duration: 6 months (potential to extend)

Location: Hudson, MA (Highly Preferred) or Remote candidates considered

Hybrid flexibility (if onsite role): hybrid if local candidates based on business requirements

Summary Description:

We are looking for a savvy ETL Developer/ Data Engineer to join our team. The hire will be responsible for expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection. The ideal candidate is an experienced data pipeline builder and data wrangler who enjoys optimizing existing data systems and building them from the ground up.

Primary Duties/Responsibilities:

  • Maintain and provide enhancements to data architecture within new/existing systems including Data Warehouse.
  • Recommend and implement processes to improve data quality, data reliability, and database performance.
  • Employ a variety of ETL and integration tools for system and data integrations.
  • Architect solutions that support data scientists and business stakeholders.
  • Conduct ETL testing and data transformation testing.
  • Develop data models for the data science team that can be utilized for data mining.
  • Maintain source to target documentation and process flow documentation.
  • Take on DBMS responsibilities and wear multiple hats such as: ETL's, serve as SQL Server DBA – Processes/Job/Error Handling/Troubleshooting/Scheduling, etc.
  • Proactively monitor ETL Processes / Jobs.

Experience:

Relevant hands-on work experience in a Data Warehouse testing role. ETL (Extract Transform Load)/ODS (Operational Data Store) experience. MS SQL Server Commercial Real Estate experience preferred.

Education:

Bachelor's degree in computer science or information technology from an accredited institution.

Skills:

Must Have:

  • ETL Tools: Azure Data Factory (ADF) 3+ years including API source exposure.
  • Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases. (4+ years of SQL) and working knowledge of Azure.
  • Proficient in Azure Managed MS SQL Server database including setting indexes, database security, and backups.
  • Data Testing: 3+ years.
  • Fundamental knowledge of data warehouse concepts.
  • Data Warehouse testing: 2+ years.
  • Must have Python skills Data frame, NumPy, Panda libraries.
  • C# 2+ Years.
  • Microsoft Fabric – 1 Year.
  • Should be able to Develop Azure Logic App, Azure Function in C#.
  • Experience in data duality, source systems analysis, and business rules validation.
  • Ability to write and understand Source to Target documentation.
  • Detail oriented and meticulous approach to duties.
  • Keep our data separated and secure.
  • Good analytical skills.
  • A knack for independent and group work.
  • Capacity to successfully manage a pipeline of duties with minimal supervision.

Good To Have:

  • Python.
  • Familiarity with data and cybersecurity.

Ready to join the team?

Apply now

Similar Jobs: