Hybrid Data Engineer II — Snowflake, dbt & AWS Specialist

3Core Systems, Inc; Irving (TX); Hybrid; USD 110,000 - 150,000; Full time

Job summary

3Core Systems, Inc. seeks a Data Engineer II / AWS Data Engineer to join a hybrid team in Miami, FL or Irving, TX on a contract-to-hire basis.

You will own transformation and modeling work across finance and land initiatives, rebuilding the financial reporting data stack and preparing consolidated data assets for internal agents. Day-to-day is about 80% dbt/transformation and data-modeling, with 20% collaboration with stakeholders.

Qualifications

• Strong SQL and Python fundamentals.
• Snowflake experience and an understanding of how modeled data supports reusable data products.
• Data modeling and semantic modeling experience, not merely extraction and loading.
• Critical thinking, adaptability, project ownership, and comfort working directly with stakeholders.

Responsibilities

• Design, implement, and support an analytical data infrastructure and working knowledge of Modern Data Warehouse concepts.
• Design, build, and maintain efficient and scalable data pipelines and ETL processes to process large volumes of structured and unstructured data.
• Optimize data storage and retrieval methods to ensure performance, scalability, and cost-efficiency.
• Manage AWS resources including EC2, S3, Glue, Lambda, API’s, IAM, CloudWatch, etc.
• Interface with other technology teams to extract, transform, and load data from a wide variety of data sources using SQL and AWS big data technologies.
• Explore and learn the latest AWS technologies to provide new capabilities and increase efficiency.
• Collaborate with Data Scientists and Business Intelligence Engineers (BIEs) to recognize and help adopt best practices in reporting and analysis.
• Help continually improve ongoing reporting and analysis processes, automating or simplifying self-service support for customers.
• Maintain internal reporting platforms/tools, including troubleshooting and development. Interact with internal users to establish and clarify requirements in order to develop report specifications.
• Work with Engineering partners to help shape and implement the development of BI infrastructure including Data Warehousing, reporting and analytics platforms.
• Contribute to the development of the BI tools, skills, culture, and impact.
• Write advanced SQL queries and Python code to develop solutions.
• Working Knowledge of Snowflake.
• Collaborate across teams to align AI initiatives with organizational goals and an understanding of AI concepts
• Knowledge of CI/CD pipelines and working on deployments when necessary.

Skills

SQL

Python

Snowflake

Data modeling

Semantic modeling

Critical thinking

Project ownership

Stakeholder interaction

Education

Bachelor's degree in Computer Science, Information Technology, or related field

Tools

dbt

Apache Airflow

AWS Glue

AWS S3

EC2

Lambda

Job description

3Core Systems, Inc. seeks a Data Engineer II / AWS Data Engineer to join a hybrid team in Miami, FL or Irving, TX on a contract-to-hire basis.

You will own transformation and modeling work across finance and land initiatives, rebuilding the financial reporting data stack and preparing consolidated data assets for internal agents. Day-to-day is about 80% dbt/transformation and data-modeling, with 20% collaboration with stakeholders.