ETL Architect cum 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 : This role requires a full-time, on-premise presence at the client site, with no remote work option. 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. We are an Equal Employment Opportunity employer. We promote and support a diverse workforce at all levels of the company. All qualified applicants will receive consideration for employment without regard to race, religion, color, sex, age, national origin or disability. All applicants will be evaluated solely on the basis of their ability, competence, and performance of the essential functions of their positions with or without reasonable accommodations. Reasonable accommodations also are available in the hiring process for applicants with disabilities. #J-18808-Ljbffr ALLTECH CONSULTING SVC INC