Cloud Data Engineer
Malvern , PA- OR Charlotte , NC -Hybrid Must
shyam@hanstaffing.com

Writes ETL (Extract / Transform / Load) processes, extract data from APIs, designs database systems and, develops tools for real-time and offline analytic processing using Python and AWS technologies
Re-platforming existing data processes i.e. existing Excel workbooks with macros, VBA code to scalable Cloud services and processes
Collaborate with Modernization/Cloud Business Office/Global Technology Office teams to collect and run diverse & large datasets that support better business decisions
Writes complex ad hoc queries using Python/SQL
Participate all phases of solution development and explain technical considerations at related meetings, including those with internal clients and other team members
Mastery of data visualization tools like Tableau, PowerBI or Excel.
Translates technical specifications, and/or design models into code for new or enhancement projects.
Writes programs and reports
Elevates code into the development, test, and Production environments on schedule.
Participates in design, code, and test inspections throughout life cycle to identify issues and ensure methodology compliance.
Participates in systems analysis activities, including system requirements analysis and definition, e.g. prototyping. Participates in other meetings, such as those for use case creation and analysis.
Writes the system/technical portion of assigned deliverables. Assists technical team members with the system/technical portion of their deliverables, e.g., systems testers with test plans.
Performs unit testing and writes appropriate unit test plans to ensure requirements are satisfied.
Assists in integration, systems, acceptance, and other related testing as needed.
Develops understanding of client business functions and technology needs. Develops understanding of Vanguard's tools, technologies, and applications/databases, including those that interface with the business areas and other systems
Interfaces with cross functional teams, including associated Data Analysts, Scientists and Developers.
Complies with IT policies and procedures, especially those for quality and productivity standards that enable the team to meet established milestones.
Understands and adheres to Vanguard's Diversity mission and policies.
Participates in special projects and performs other duties as assigned
Qualifications
AWS experience: Familiarity w/ AWS Services (Lambda, EKS, ECS, EC2, CloudFormation, RedShift, S3, Glue, AWS SDKs, IAM, Storage Gateway)
Software Development and implementation: the below languages and tools are of particular interest:
Mastery of Python, SQL (nice to have: Java, R)
Mastery of data visualization tools such as Tableau, PowerBI, Excel
Big Data: Athena, Spark
Collibra
AI/Client concepts
Data Lake concepts and architecture
3rd Party API integrations