What are the responsibilities and job description for the ETL Architect position at Mergen IT Services?
ETL Architect
Dallas, Maine
12 Months
Job Description : ETL Architect and Onshore Project Manager Position Summary : We are seeking an experienced ETL Architect with a strong background in AWS Cloud, coupled with effective onshore project management skills, to work directly from the client site (no remote work).
The ideal candidate will have expertise in AWS ETL services and excel in client interaction and project delivery.
Key Responsibilities :
Architect, implement, and manage ETL solutions using AWS services, including AWS Glue, Athena, and S3, to meet client requirements effectively. ¿ Work onsite at the client location, building strong relationships and a deep understanding of the client
s business needs, challenges, and objectives.
Lead and oversee data pipeline design and deployment, ensuring scalability, performance, and security.
Act as the primary client liaison, providing proactive updates and maintaining a clear communication channel.
Manage project timelines, deliverables, and client expectations to achieve high quality outcomes and ensure project alignment.
Support and provide guidance on PySpark and other data engineering tools for efficient data transformations and processing.
Anticipate and address project risks and roadblocks to maintain smooth project progression.
Qualifications :
7 10 years of IT experience, with strong expertise in AWS cloud services and ETL solutions.
In depth knowledge of AWS Glue, Athena, and data processing on S3.
Familiarity with PySpark is an added advantage. ¿ Proven ability to engage with clients effectively, understand their pulse, and deliver tailored solutions.
Strong communication, problem solving, and onshore project management skills. Additional
Requirements : Preferred Skills :
Experience with data warehousing and data modeling.
Familiarity with additional AWS services like Redshift, Lambda, and EMR.
Ability to balance technical proficiency with strong business acumen, thriving in a fast paced, client facing environment. This position is ideal for a technically skilled professional who excels in client relationships and enjoys hands on project management at the client¿s location.
