Snowflake Data Engineer

Position: Snowflake Data Engineer Location: Orlando, FL (onsite 3x a week) Duration: 6-12 month contract (potential to hire) Description: Project Details – Size, Scale, Scope How does candidate fit into this? Disney cruise line environmental project. Regulatory side of DCL has changed. Accurately understand fuel types for ships. Gauge distance, fuel consumption, what may or may not use, front end built in to determine changes in itinerary (location changes within applications to forecast). Adding brand new destinations and onboarding new ships. Assigned to introduce historical data on fuel consumption from prior ships Now will start to apply towards planned itinerary going forward GPS tracking for prior and future routes to determine how to save fuel Weather aspect and fuel consumption to avoid future weather patterns. Bring data together in central location. Will automate from source system Nav Fleet. Technical Environment: Snowflake, Python, Docker Team Size & Structure: 3 on team under Ron (Randall, Matt, Anthony)-Engineers Day to Day Responsibilities: Building out data pipelines Source systems analysis Match up to data requirements Data modeling Extraction in raw environment and then transfer Create tables within raw data and target data What are the top 3 MUST HAVE technologies or Required experience of the position: 1-4 projects exp. knowing Snowflake (snowsql, ddl for creating tables) Airflow (going to learn some new things that aren’t traditionally seen) Data extraction within CSV or flat files Python Docker NICE TO HAVES: GitLab around CI/CD AI/ML Job Description: The Data Engineer role will be hands-on data engineering development across multiple projects. You will work with technologies such as AWS, Docker, Gitlab, Airflow, Python, Snowflake, or PostgreSQL. Daily activities include designing and implementing database schema/tables/views, design and coding of data pipelines, implementing data services API’s, automation, testing, performance tuning, monitoring, proactive data validation, building data visualizations, and evolving our data engineering code base. Beyond the needs of projects, this role will support our existing data pipelines and enhance current functionality to support our partner teams in data science and analytics. Basic Qualifications: 3-5 years of data engineering experience Proven experience and expertise using Python, SQL, Docker, Snowflake, or PostgresSQL High Proficiency in SQL coding Experience managing and deploying code using GitLab/GitHub Experience leveraging containerization technologies such as Docker or Kubernetes Experience leveraging job scheduling software like Apache Airflow Experience with Agile project management (i.e. Scrum) Strong understanding of relational and dimensional database design Knowledgeable on cloud architecture and product offerings, preferably AWS Preferred Qualifications: 3-5 years of Python programing experience – High proficiency Hands-on experience with SnowSQL in Snowflake Experience or background in media planning, ad sales, and research is a plus -- -- --- ---- Thanks & Regards, Ujwala Pinninti Thoughtwave Software and Solutions 314 N. Lake St, Suite 6, Aurora IL 60506 Desk: 6302168656, EXTN: 156 Email: ujwala@thoughtwavesoft.com Website: www.thoughtwavesoft.com Linked in: https://www.linkedin.com/in/ujwala-pinninti-675285213/ A Certified Minority Business Enterprise, Disadvantaged Business Enterprise, SAM.gov, SOC2 & ISO2005, Vendors for: · STATES: IL, PA, TN, AK, OR, CT, GA, VA, ID, IA, UT, FL, MN & CO · NATIONAL LABS: ARGONNE & FERMI · COUNTIES: HENNEPIN, MN, FULTON & GA · PUBLIC SCHOOLS: ATLANTA.