Data Engineer - SQL, Python, ETL

Career ResourcesCandidate Experience Sign Up Join Our Talent Network Data Engineer•SQL, Python, ETL Mundelein, IL FreelanceHybrid$1,000•$1,500 /hr Posted May 20, 2026 testing 1

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. Qualifications Bachelor's or Master's degree in Computer Science, Engineering, or a related field, or equivalent practical experience. 5+ years of professional experience building and operating data platforms and pipelines in production environments. Strong proficiency in SQL and experience with query optimization, indexing, and partitioning strategies. Proficient in Python and experience with Java or Scala for distributed processing workloads. Hands-on experience with ETL/ELT frameworks and orchestration tools such as Airflow, AWS Glue, or equivalent. Experience with big data ecosystems including Apache Spark, Hadoop, Kafka, and Flink for batch and stream processing. Working knowledge of cloud data services such as Snowflake, Amazon Redshift, Google BigQuery, or Azure Synapse. Familiarity with data storage formats (Parquet, Avro, ORC) and object stores like S3. Experience with NoSQL databases (DynamoDB, MongoDB, Cassandra, HBase) and designing data movement between systems. Experience with infrastructure automation and containerization tools like Terraform, Docker, and Kubernetes, and CI/CD practices and Git. Experience implementing CDC, real-time data pipelines, Kinesis or Kafka-based streaming, and event messaging (RabbitMQ). Comfortable with Linux environments and shell scripting; experience with monitoring tools (Prometheus/Grafana). Knowledge of data governance, data quality frameworks, metadata management, and lineage tracking. Experience writing unit and integration tests for data code and pipelines; strong attention to observability and testing practices. Excellent communication skills, experience collaborating with cross-functional teams, and a track record of mentoring or leading engineering efforts. In this position, you may have access to client or customer systems, confidential and/or proprietary information or data. This position is onsite and requires you to work closely with other individuals in a collaborative team environment. Benefits Creative Circle's Freelance Employee benefits package includes eligibility for Minimum Essential Coverage (MEC) medical plan, dental/vision/term life package, discount prescription program, critical illness, accident, tele-behavioral health, and 401(k) plan. Sick leave is provided to Candidates whose assignment work location is in a state or city subject to sick leave laws. A Minimum Value (MV) PPO medical plan, Employee Stock Purchase Plan, and paid holiday eligibility are based on length and dates of service. For Everforth Creative Circle to represent you for this opportunity, you must be currently authorized to work in the United States without the need of employer sponsorship for a non-immigrant visa such as a H-1B, TN, or O visa. We do not support or provide training for

STEM/OPT

programs. Additionally, you must be physically located in and perform the work for our client in the United States. Vasudha Jammalamadaka is recruiting for this position Email me your resume to apply for this job Refer a Friend This job was posted on May 20, 2026 and last updated on May 20, 2026. EEO Employer Everforth Creative Circle is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, creed, religion, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity or expression, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, or any other characteristic protected by law. Our hiring process includes AI screening for keywords and minimum qualifications. Recruiters review all results. Everforth Creative Circle will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable state and local law, including but not limited to the Los Angeles County Fair Chance Ordinance, the San Francisco Fair Chance Ordinance, and the California Fair Chance Act. If you need a reasonable accommodation in the application process, please contact your Recruiter (the person you'll be interviewing with) or a member of our Human Resources team to make arrangements.

Anthem / Blue

Cross Blue Shield creates and publishes the Transparency in Coverage Machine-Readable Files on behalf of Everforth Creative Circle. About Everforth Creative Circle Everforth Creative Circle matches creative and marketing professionals with hiring managers looking for talent. The above listing is for a position with one of our clients. If you're a good fit for this role or another we're currently working on, a recruiter will reach out to you directly. We only contact the applicants who are the best fit for the position, so if you do not hear back, please take a look at the other roles we have available. Thank you for your interest!

Job ID:

VJ3-1987588

Want to be in the know? Contact Us Our Services Staffing & Recruiting Consulting & Agency Services Embedded Studios MarTech Our Work Brand Strategy Creative Design Digital Marketing Content Creation MarTech Solutions Social Media Management Web Design & Development Analytics & Reporting Our Insights Blog White Papers Resources & Reports Events About Us Leadership Team Corporate Social Responsibility Join Our Team Candidate Hub Start Your Search Candidate Experience Career Resources 6300 Wilshire Blvd, Suite 930 Los Angeles, CA 90048 Everforth Creative Circle is part of the Commercial Segment of Everforth, Inc.

NYSE EFOR.

Privacy PolicyAccessibilityTerms of Use Copyright © 2026 Everforth, Inc. All rights reserved. Everforth Creative Circle is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, creed, religion, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity or expression, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, or any other characteristic protected by law. Our hiring process includes AI screening for keywords and minimum qualifications. Recruiters review all results. Everforth Creative Circle will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable state and local law, including but not limited to the Los Angeles County Fair Chance Ordinance, the San Francisco Fair Chance Ordinance, and the California Fair Chance Act. If you need a reasonable accommodation in the application process, please contact your Recruiter (the person you'll be interviewing with) or a member of our Human Resources team to make arrangements.

Anthem / Blue

Cross Blue Shield creates and publishes the Transparency in Coverage Machine-Readable Files on behalf of Everforth Creative Circle.