Data Engineer - SQL, Python, ETL

Illinois Employer • Mundelein, IL • 1h ago

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

**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

Data Engineer - SQL, Python, ETL

Illinois Employer • Mundelein, IL • 1h ago

IT & Engineering

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

1h ago

Go to Apply

Electrical Engineer Control Systems

Illinois Employer • Waukegan, IL • 2h ago

IT & Engineering

This job was posted by https://illinoisjoblink.illinois.gov : For more information, please see: https://illinoisjoblink.illinois.gov/jobs/13548202 Join UCC Environmental, a leader in sustainable technology solutions: Loo...

2h ago

Go to Apply

Jr. Software Engineer

Insight Global • Lincolnshire, IL • 6h ago

IT & Engineering

Job Description A large retail company is investing in a growing AI Center of Excellence to drive meaningful improvements across our retail platforms, operations, and customer experiences. As a Junior Software Engineer o...

6h ago

Go to Apply

Software Engineer, Backend

Cisco • Elk Grove Village, IL • 6h ago

IT & Engineering

The application window is expected to close on: 07/28/2026 Job posting may be removed earlier if the position is filled or if a sufficient number of applications are received . Meet the Team The Time Series Data (TSD) te...

6h ago

Go to Apply

Automation Manufacturing Engineer

HARTING Technology Group • Elgin, IL • 7h ago

IT & Engineering

Automation Manufacturing Engineer Position @type: Full-time Type of contract: Permanent HARTING stands for strong connections - across the globe. As one of the leading international suppliers of industrial connectivity,...

7h ago

Go to Apply

Design Engineer - Machine Layout

Kelly Services • Hoffman Estates, IL • 1d ago

IT & Engineering

Kelly® Engineering is seeking a Layout Engineer for a long-term contract position at an automation/industrial machinery manufacturing client in Hoffman Estates. If you are passionate about shaping the world we live in an...

1d ago

Go to Apply

CNC Programmer

Dexter Magnetic Technologies • Elk Grove Village, IL • 1d 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...

1d ago

Go to Apply

Principal/Sr. Principal Business Process Analyst

Northrop Grumman • Rolling Meadows, IL • 1d ago

IT & Engineering

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

1d ago

Go to Apply

Senior Software Engineer

UnitedHealth Group • Schaumburg, IL • 2d ago

IT & Engineering

Requisition number: 2369597 Job category: Technology Optum is a global organization that delivers care, aided by technology, to help millions of people live healthier lives. The work you do with our team will directly im...

2d ago

Go to Apply

Agile Practitioner 1

UnitedHealth Group • Schaumburg, IL • 2d ago

IT & Engineering

Requisition number: 2361824 Job category: Technology Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly imp...

2d ago

Go to Apply

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