Senior Cloud DBA/ETL/ELT Data Pipeline Engineer

Job Title: Senior Cloud DBA/ETL/ELT Data Pipeline Engineer

Standard Work Location: Boston, MA, Need only Local Candidates

Required

• Experience working with Oracle RDS
• Experience working with one or more AWS Cloud services such as S3 storage, Managed Airflow (MWAA), Data Migration Service (DMS) in support of building data pipelines
• Experience working with a variety of backend data sources (e.g. SQL Server, Oracle, Postgres, DynamoDB, Snowflake)
• Advanced SQL coding skills and ability to translate Oracle PL SQL and Stored Procedure code to alternative SQL platforms such as Snowflake
• Familiarity with data warehouse and data mart concepts such as normalization, facts, dimensions, slowly changing dimensions
• Familiarity with Change Data Capture (CDC) concepts and implementations. Knowledge of Kafka or similar replication tools is a plus
• Understanding of common file formats such as JSON, XML, CSV
• Basic experience using scripting tools to automate tasks (e.g.: Python, Windows PowerShell, bash)
• Ability to write unit test scripts and be able to validate migrated ELT/ETL code
• Preferred
• Experience configuring, managing, and troubleshooting Airflow tool. Knowledge of Airflow DAGs and concepts for managing dependent graphs and complex steps
• Knowledge of Snowflake data warehouse features such as Snowpipe streaming, cloning, time travel, role-based-access control
• Prior experience working at other large organizations, preferably state or federal government
• Business domain knowledge in the Education and Student data management area.
• Experience working with software development tools such as GitHub, Jira