What are the responsibilities and job description for the Hybrid role: ETL Developer: Baltimore MD position at Connexions Data Inc?
ETL developer
Work Type: HYBRID with 40% onsite requirement in Baltimore City or Linthicum MD
12 months with one-year renewal options.
Highly skilled ETL developer whose responsibilities include designing, building, automating, and maintaining sophisticated programs that extract, convert, and load data into the Provider Management Module (PMM). This role may also support other projects within the Project Management Office(PMO) as needed.
Position Description: Responsible for designing, building, and maintaining data pipelines and infrastructure to support data-driven decisions and analytics. The individual is responsible for the following tasks:
- Design, develop and maintain data pipelines, and extract, transform, load (ETL) processes to collect, process and store structured and unstructured data
- Build data architecture and storage solutions, including data lakehouses, data lakes, data warehouse, and data marts to support analytics and reporting
- Develop data reliability, efficiency, and qualify checks and processes
- Prepare data for data modeling
- Monitor and optimize data architecture and data processing systems
- Collaboration with multiple teams to understand requirements and objectives
- Administer testing and troubleshooting related to performance, reliability, and scalability
- Create and update documentation
- Minimum 5 years ETL coding experience
- Proficiency in programming languages such as Python and SQL for data processing and automation
- Experience with distributed computing frameworks like Apache Spark or similar technologies
- Experience with AWS data environment, primarily Glue, S3, DocumentDB, Redshift, RDS, Athena, etc.
- Experience with data warehouses/RDBMS like Redshift and NoSQL data stores such as DocumentDB, DynamoDB, OpenSearch, etc
- Experience in building data lakes using AWS Lake Formation
- Experience with workflow orchestration and scheduling tools like AWS Step Functions, AWS MWAA, etc..
- Strong understanding of relational databases (including tables, views, indexes, table spaces)
- Experience with source control tools such as GitHub and related CI/CD processes
- Ability to analyze a company s data needs
- Strong problem-solving skills
- Experience with the SDLC and Agile methodologies