Cloud Engineer

This is a 12 month contract with Vanguard. Hybrid onsite in Malvern PA. 2 days onsite and 3 days remote. Visa - All. Python - Required Familiar with AWS - such as lambda, S3 - has to be able to leverage the cloud. SQL - important Data Visualization skills - Dashboard, Power BI Knowledge of excel Looking for a mix of developer/analyst skills 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/ML concepts Data Lake concepts and architecture 3rd Party API integrations