Data Engineer II / AWS Data Engineer

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

Job Title: DataEngineer II / AWS Data Engineer
Location: Miami, Florida or Irving, Texas (Hybrid)
Duration: Contract to Hire

Manager: Finance and land domain Analyticsengineer in practice

What theperson will do. Own transformation and modeling work across finance and landinitiatives. The team is rebuilding the client's financial reporting data stackand preparing consolidated data assets for internal agentic and MCP-basedaccess.

Day-to-daysplit. Approximately 80% dbt/transformation and data-modeling work and 20%collaboration with business stakeholders. This is not a ticket-taking role; someonewho can receive a project, think critically, and run with it.

Must Haves

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

Helpful butFlexible

• AWS Glue and AWS data-lake experience.Azure is acceptable if the candidate understands data-flow and lakeconcepts.
  
• Finance, accounting, cash, P&L, orland-data experience shortens the learning curve.
  
• Iceberg and experience exposing orloading transformed data into Snowflake.
  
• Power BI awareness, although Rob isintentionally moving away from producing many custom reports.
  
• Interest in agentic data products and MCPservers.
  

Reject orProbe Carefully

• Traditional ETL engineers who are strongin ingestion but light on dbt, dimensional/semantic modeling, or businesscontext.
  
• BI-only candidates whose main strength isPower BI report development.
  
• Candidates who depend on scripted orAI-fed interview answers and cannot reason through a new scenario.
  

Your Responsibilities on the Team

• Design,implement, and support an analytical data infrastructure and workingknowledge of Modern Data Warehouse concepts.
  
• Design,build, and maintain efficient and scalable data pipelines and ETLprocesses to process large volumes of structured and unstructured data.
  
• Optimizedata storage and retrieval methods to ensure performance, scalability, andcost-efficiency.
  
• ManageAWS resources including EC2, S3, Glue, Lambda, API’s, IAM, CloudWatch,etc.
  
• Interfacewith other technology teams to extract, transform, and load data from awide variety of data sources using SQL and AWS big data technologies
  
• Exploreand learn the latest AWS technologies to provide new capabilities andincrease efficiency
  
• Collaboratewith Data Scientists and Business Intelligence Engineers (BIEs) torecognize and help adopt best practices in reporting and analysis
  
• Helpcontinually improve ongoing reporting and analysis processes, automatingor simplifying self-service support for customers
  
• Maintaininternal reporting platforms/tools, including troubleshooting anddevelopment. Interact with internal users to establish and clarifyrequirements in order to develop report specifications.
  
• Workwith Engineering partners to help shape and implement the development ofBI infrastructure including Data Warehousing, reporting and analyticsplatforms.
  
• Contributeto the development of the BItools, skills, culture, and impact.
  
• Writeadvanced SQL queries and Python code to develop solutions.
  
• WorkingKnowledge of Snowflake.
  
• Collaborateacross teams to align AI initiatives with organizational goals and an understandingof AI concepts
  
• Knowledgeofcontinuous integration/continuous delivery (CI/CD) pipelines and workingon deployments when necessary.
  

Requirements

• Bachelor's degree in Computer Science,Information Technology, or a related field.
  
• 3-5 years of experience in data engineering or arelated role, with demonstrated success in delivering data solutions.
  
• Dbt, Snowflake, SQL, Python, Qlik.
  
• Proficient in SQL, with the ability to writecomplex queries, perform query optimization, and conduct performancetuning.
  
• Experience with NoSQL databases, such asMongoDB, Cassandra, or DynamoDB, and an understanding of their appropriateuse cases.
  
• Strong programming skills in Python, Java, orScala, with experience in data processing frameworks (e.g., Apache Spark,Hadoop).
  
• Experience with cloud platforms (AWS, Azure, GCP)and data services, such as AWS Redshift, Azure Synapse, or GoogleBigQuery.
  
• Knowledge of big data technologies, includingHadoop, Spark, Kafka, and HBase, with experience in distributed dataprocessing.
  
• Familiarity with data orchestration tools,suchas Apache Airflow for scheduling and managing data workflows.
  
• Experience with data versioning and testingtools, such as DVC (Data Version Control) and dbt (data build tool).
  
• Understanding of data security practices,including encryption, access controls, and data masking.
  

Skill set

3-5 years of experience in data engineering or a related role, with demonstrated success in delivering data solutions.AWS Glue, Lambda, S3, EC2, CloudWatch, Cloud Trail.Dbt, Snowflake, SQL, Python, Qlik.