Senior Data Engineer

For over 16 years, Trilyon has been a leader in global workforce solutions, specializing in Cloud Technology, AI/ML, Software Development, Technical Writing, and Digital Transformation. We partner with top companies to deliver high-quality talent in engineering, IT, and emerging technologies. For additional information or to view all of our job opportunities, please visit our website https://trilyonservices.com/careers/ We are seeking a Senior Data Engineer – Snowflake to join our team. This role will involve developing and maintaining data integrations, pipelines, and models supporting Snowflake-based analytics and reporting. The ideal candidate will have experience in data engineering, Snowflake, Oracle, Databricks, Python, SQL, and Airflow, and a passion for modern data architecture. Job Title: Senior Data Engineer – Snowflake Location: Chicago, IL (On-site) Duration: 6 months Rate/Salary: $55/hr. Job Description: Key Responsibilities Data Integration • Implement and maintain data synchronization between on-premises Oracle databases and Snowflake using Kafka and CDC tools. Support Data Modeling • Assist in developing and optimizing the data model for Snowflake, ensuring it supports analytics and reporting requirements. Data Pipeline Development • Design, build, and manage data pipelines for the ETL process, using Airflow for orchestration and Python for scripting, to transform raw data into a format suitable for the Snowflake data model. Reporting Support • Collaborate with the data architect to ensure the data within Snowflake is structured to support efficient and insightful reporting. Technical Documentation • Create and maintain comprehensive documentation of data pipelines, ETL processes, and data models to ensure best practices are followed and knowledge is shared. Tools and Skillsets Data Engineering • Proven track record of developing and maintaining data pipelines and data integration projects. Databases • Strong experience with Oracle, Snowflake, and Databricks. Data Integration Tools • Proficiency using Kafka and CDC tools for data ingestion and synchronization. Orchestration Tools • Expertise in Airflow for managing data pipeline workflows. Programming • Advanced proficiency in Python and SQL for data processing tasks. Data Modeling • Understanding of data modeling principles and experience with data warehousing solutions. Cloud Platforms • Knowledge of cloud infrastructure and services, preferably Azure, as it relates to Snowflake and Databricks integration. Collaboration Tools • Experience with version control systems such as Git and collaboration platforms. CICD Implementation • Utilize CICD tools to automate deployment of data pipelines and infrastructure changes, ensuring high-quality data processing with minimal manual intervention. Communication • Excellent communication and teamwork skills, detail-oriented mindset. • Strong analytical skills with the ability to work independently and solve complex problems. Why Join Us? • Trilyon, Inc., offers a comprehensive benefits package. • Opportunities for growth and professional development. • Collaborative and inclusive company culture. Equal Employment Opportunity (EEO) Statement: Trilyon, Inc., is an Equal Opportunity Employer committed to diversity, equity, and inclusion. We do not discriminate based on race, color, religion, gender, gender identity, sexual orientation, national origin, age, disability, veteran status, or any other protected status under applicable laws. Our diverse team drives innovation, competitiveness, and creativity, enhancing our ability to effectively serve our clients and communities. This commitment to diversity makes us stronger and more adaptable.