ETL Architect cum Onshore Project Manager

ALLTECH CONSULTING SVC INC; Denver (CO); On-site; USD 120,000 - 150,000; Full time

Job summary

A leading company is seeking an experienced ETL Architect to work directly from the client site in Denver. The role focuses on architecting and managing AWS-based ETL solutions while fostering strong client relationships and overseeing project delivery. Ideal candidates will possess significant expertise in AWS services and exhibit strong communication and problem-solving skills.

Qualifications

• 7-10 years IT experience with strong expertise in AWS cloud and ETL.
• In-depth knowledge of AWS Glue, Athena, and data processing on S3.
• Familiarity with PySpark and effective client interaction skills.

Responsibilities

• Architect and manage ETL solutions using AWS services.
• Lead data pipeline design ensuring scalability and security.
• Act as primary client liaison, managing expectations and project timelines.

Skills

AWS cloud services

ETL solutions

Client engagement

Project management

Problem-solving

Job description

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.