Data Engineer - SQL, Python, ETL

Creative Circle, LLC • Mundelein, IL • 4h ago

This job was posted by https://illinoisjoblink.illinois.gov : For more information, please see: https://illinoisjoblink.illinois.gov/jobs/13524570

**Position: Creative Designer - Photography, Graphic Design & Social Media

Overview:**\ Our luxury hospitality client is seeking a talented Creative Designer with a strong focus on photography, graphic design, and social media content creation. This role is ideal for a visual storyteller who can bring our brand to life across multiple platforms.

This is ONSITE in NYC 4 days a week and remote on Fridays. There will be occasional travel to Washington DC.

Key Responsibilities

Photography & Visual Content - must have your own camera

Oversee and provide creative direction for photo shoots.

Capture high-quality imagery using hotel-provided equipment for

use on social media and the website.

Edit and optimize photos and videos for digital platforms.

Graphic Design

Conceptualize and design visuals for branding, social media

campaigns, and advertising.

Create marketing collateral such as brochures, brand books, and

sales materials.

Develop graphics and layouts for logos, websites, and

promotional assets.

Social Media & Digital

Collaborate with the Marketing Director to execute engaging

social media content.

Design ad assets for digital campaigns in partnership with

external agencies.

Ensure all creative aligns with brand identity and marketing

objectives.

Collaboration & Coordination

Work closely with outside agencies, printers, production

companies, and internal teams.

Manage design requests and maintain consistent quality across

all deliverables.

Occasional travel to the Washington, D.C. property (1-2 times

per month, seasonally).

Requirements

3+ years of experience in a design-focused role.

Strong portfolio showcasing photography and graphic design work.

Proficiency in Adobe Creative Suite (Photoshop, Illustrator,

InDesign).

Experience in photo and video capture, editing, and optimization.

Understanding of marketing principles, branding, and multimedia

design.

Excellent time management and communication skills.

Senior Data Engineer\ \ Position Overview\ We are seeking an experienced Data Engineer to design, build, and maintain scalable data platforms and pipelines that enable analytics, reporting, and machine learning. The ideal candidate will partner with data scientists, analysts, and engineers to deliver reliable batch and real-time data solutions, optimize performance, ensure data quality and governance, and drive best practices across the data stack.\ \ Key Responsibilities

Design, develop, and maintain robust ETL/ELT pipelines for batch and

streaming data processing using tools such as Apache Spark, Flink, Kafka, Airflow, and cloud-native services.

Implement and operate data ingestion solutions from diverse sources

using CDC, connectors, and integration tools (e.g., Airbyte, Fivetran, Kafka Connect).

Build and optimize data warehouses and lakehouse solutions on

Snowflake, Amazon Redshift, Google BigQuery, or Azure Synapse, including schema design, partitioning, clustering, and performance tuning.

Model and document data structures using dimensional and

transactional modeling techniques (star schema, OLAP), and implement data modeling best practices for BI and analytics.

Develop and maintain data storage using formats like Parquet, Avro,

and ORC, and manage large-scale storage on S3 or equivalent cloud object stores.

Implement monitoring, alerting, and observability for data pipelines

and infrastructure using Prometheus, Grafana, and logging tools; troubleshoot and resolve production issues.

Ensure data quality, lineage, and metadata management through

validation, testing (unit and integration), and governance practices; collaborate with data governance teams to enforce policies.

Automate deployment and infrastructure provisioning using Terraform,

Docker, Kubernetes, and CI/CD pipelines; apply infrastructure-as-code and reproducible build practices.

Optimize SQL and data access patterns, implement indexing,

partitioning strategies, and tune queries for large datasets.

Integrate and manage NoSQL and operational datastores where needed

(DynamoDB, MongoDB, Cassandra, HBase), and design appropriate data flows between OLTP and OLAP systems.

Collaborate across teams to define API contracts, REST interfaces,

and data contracts; work with JSON, XML, and other serialization formats as required.

Drive data security and compliance by implementing access controls,

encryption, and secure data handling procedures.

Mentor junior engineers, conduct code reviews, and contribute to

technical design discussions and documentation.

Similar Jobs

Systems Engineer/Principal Systems Engineer (Integration & Test)

Northrop Grumman • Rolling Meadows, IL • 52min ago

IT & Engineering

RELOCATION ASSISTANCE: Relocation assistance may be available CLEARANCE REQUIRED FOR START: Yes CLEARANCE TYPE: SAP TRAVEL: Yes, 10% of the Time Description At Northrop Grumman, our employees have incredible opportunitie...

52min ago

Go to Apply

Data Scientists/Data Analyst

MG CLOUD TECHNOLOGIES LLC • Schaumburg, IL • 4h ago

IT & Engineering

This job was posted by https://illinoisjoblink.illinois.gov : For more information, please see: https://illinoisjoblink.illinois.gov/jobs/13526633 Collect, clean, and analyze large datasets to derive actionable insights...

4h ago

Go to Apply

Data Engineer - SQL, Python, ETL

Creative Circle, LLC • Mundelein, IL • 4h ago

IT & Engineering

This job was posted by https://illinoisjoblink.illinois.gov : For more information, please see: https://illinoisjoblink.illinois.gov/jobs/13524528 **Position: Creative Designer - Photography, Graphic Design & Social...

4h ago

Go to Apply

CNC Drehtechnik Experte (m/w/d)

HARTING Technology Group • Elgin, IL • 6h ago

IT & Engineering

Stellenbeschreibung CNC Drehtechnik Experte (m/w/d) Positionsart: Vollzeit Art des Vertrages: befristet HARTING stands for strong connections - across the globe. As one of the leading international suppliers of industria...

6h ago

Go to Apply

Embedded Software Engineer 3

Apex Systems • Rolling Meadows, IL • 10h ago

IT & Engineering

This job was posted by https://illinoisjoblink.illinois.gov : For more information, please see: https://illinoisjoblink.illinois.gov/jobs/13524495 Job Description: Embedded Software Engineer 3 Location:Rolling Meadows, I...

10h ago

Go to Apply

Lead Manufacturing Engineer

Dexter Magnetic Technologies • Elk Grove Village, IL • 10h ago

IT & Engineering

Dexter Magnetic Technologies supplies specialized magnetic solutions and components to demanding applications in the medical, aerospace, defense, semiconductor manufacturing, oil and gas, and industrial end markets. Dext...

10h ago

Go to Apply

Manufacturing Engineer

PENTAIR • Hanover Park, IL • 10h ago

IT & Engineering

Job Description: At Pentair, you will work alongside passionate problem-solvers who are committed to the future of our planet. We put our purpose into practice, helping people sustainably move, improve, and enjoy water,...

10h ago

Go to Apply

Electrical Worker

Chicago Transit Authority • Skokie, IL • 1d ago

IT & Engineering

Electrical Worker - ( 2600004Y ) Description SALARY $54.86 POSITION SUMMARY Performs various duties relative to the repair of electrical and electronic components in buses and rail vehicle equipment. Qualifications PRIMA...

1d ago

Go to Apply

Embedded Software Engineer

Actalent • Rolling Meadows, IL • 1d ago

IT & Engineering

Job Title: Embedded Software Engineer Job Description An exciting opportunity awaits an Embedded Software Engineer to join our mission-critical RF programs. This role involves developing and integrating C++ embedded soft...

1d ago

Go to Apply

Software Engineer

Tekassembly Corporation • Libertyville, IL • 1d ago

IT & Engineering

This job was posted by https://illinoisjoblink.illinois.gov : For more information, please see: https://illinoisjoblink.illinois.gov/jobs/13522506 Gather, analyze, design, write code, document, customize, maintain, test,...

1d ago

Go to Apply

Subscribe to get new jobs sent directly to you
(no charge, cancel anytime)