SignDesk – Data Analytics Architect – ETL/AWS

Job Description :

We are seeking a skilled AWS ETL/ELT Data Architect with a specialization in MongoDB to join our team. The ideal candidate will possess comprehensive knowledge and hands-on experience in designing, implementing, and managing ETL/ELT processes within AWS while also demonstrating proficiency in MongoDB database management.

This role requires expertise in data architecture, AWS services, and MongoDB to optimize data solutions effectively.

Responsibilities :

– Design, architect, and implement ETL/ELT processes within AWS, integrating data from various sources into data lakes or warehouses, and utilize MongoDB as part of the data ecosystem.

– Collaborate cross-functionally to assess data requirements, analyze sources, and strategize effective data integration within AWS environments, considering MongoDB’s role in the architecture.

– Construct scalable and high-performance data pipelines within AWS while integrating MongoDB for optimal data storage, retrieval, and manipulation.

– Develop comprehensive documentation covering data architecture, flows, and the interplay between AWS services, MongoDB, and ETL/ELT processes from scratch.

– Perform thorough data profiling, validation, and troubleshooting, ensuring data accuracy, consistency, and integrity in conjunction with MongoDB management.

– Stay updated with AWS and MongoDB best practices, emerging technologies, and industry trends to propose innovative data solutions and implementations.

– Provide mentorship to junior team members and foster collaboration with stakeholders to deliver robust data solutions.

– Analyze data issues, identify and articulate the business impact of data problems

– Perform code reviews and ensure that all solutions are aligned to pre-defined architectural standards, guidelines, best practices, and meet quality standards

Qualifications :

– Bachelor’s or Master’s degree in Computer Science, Information Technology, or related field.

– Minimum 5 years of hands-on experience in ETL/ELT development, data architecture, or similar roles.

– Having implemented more than a minimum of 3 – 4 live projects in a similar field would be desirable.

– Expertise in designing and implementing AWS – based ETL/ELT processes using tools like AWS Glue, AWS Data Pipeline, etc.

– In-depth knowledge of AWS data storage services such as Amazon S3, Redshift, RDS, DynamoDB, etc., alongside MongoDB database management experience.

– Proficiency in SQL, scripting languages (e.g., Python, Shell scripting), and MongoDB query language for data manipulation and automation within AWS environments.

– Strong understanding of data warehousing concepts, database systems, and data modelling techniques.

– Excellent analytical, problem-solving, and communication skills.

– Ability to manage multiple priorities in a fast-paced environment.

Preferred Skills :

– Relevant certifications in AWS (e.g., AWS Certified Solutions Architect, AWS Certified Data Analytics) and MongoDB.

– Experience with Snowflake, Kafka in conjunction with AWS services and MongoDB.

– Familiarity with MongoDB deployment, configuration, and optimization in production environments.