AWS & Snowflake Data Engineer
Vipula ReddyUnited StatesMIDPosted 46m ago
SQLPysparkPythonETLApache AirflowAWS EC2EMRS3DBTAzure Data FactorySnowflakeRedshiftDatabricksData ModelingData GovernanceGit
About the Role
We are seeking an AWS & Snowflake Data Engineer for a 9-month contract position at our Auburn Hills, MI location. This role requires 100% on-site presence and involves designing and implementing data architecture strategies.
Key Responsibilities
• Designing and implementing through data architecture strategies
• Analyzing complex issues to create innovative solutions
• Upholding standards in project deliverables
• Developing a thorough understanding of the business environment
• Managing and navigating complex scenarios effectively
• Building and maintaining excellent client relationships
• Enhancing personal brand and technical skills
• Mentoring and guiding junior team members
• Implementing end-to-end solutions catering to business requirements
Requirements
• Proficient in SQL, Pyspark, and Python
• Proficiency in building ETL/ELT pipelines using tools like Apache Airflow, AWS EC2, EMR, S3, DBT, Azure Data Factory
• Expertise in data warehousing solutions like Snowflake or Redshift, Databricks
• Working knowledge of cloud providers (AWS)
• Experience in designing efficient schemas (star/snowflake) for dimensional modeling and semantic models for visualization tools
• Knowledge of data governance and security, including data encryption, masking, and role-based access control
• Problem-solving and troubleshooting skills to identify bottlenecks in data workflows
• Collaboration skills to work with data scientists and analysts to understand business needs and deliver actionable data
• Version control using tools like Git for managing code for data pipelines