Jr Client Data Engineer

Jr Client Data Engineer Join to apply for the Jr Client Data Engineer role at Mosaic North America. The Jr Client Data Engineer position will assist in developing and managing the ingestion, storage, modeling, and consumption of data for Mosaic and our clients. The role involves transforming raw data into usable formats, ensuring efficient data storage and processing, and supporting the back end of our data environment. The Jr Client Data Engineer will work closely with senior engineers and other teams to create and monitor data solutions, resolve incidents, optimize workloads, and explore emerging technologies. Responsibilities Work with the broader team and Client Service to understand and implement solutions based on high level designs and requirements. Help create datasets for analytics by designing logical data models and turning them into physical data structures. Support the integration of data from disparate sources and systems, including databases, APIs, files, and streaming platforms. Assist in ensuring analytics-ready data is of sufficient quality to make critical operational, tactical, and business decisions. Participate in the software development lifecycle, including requirements gathering, design, development, testing, deployment, and maintenance of data solutions. Develop resources which aid data platform users such as data catalogues, lineage documentation, and user guides. Support the development and maintenance of infrastructure on Google Cloud Platform and/or Azure. Develop understanding of all areas of Mosaic business to find new opportunities for optimization. Stay current with technology trends to continually develop ingestion, ETL/ELT, and general data/software skills, and evangelize within the team. Ensure data security and compliance with company policies. Minimum Qualifications A bachelor’s degree in computer science, Engineering, Information Technology, or equivalent. Proficiency in SQL and familiarity with programming languages such as Python. Experience with software version control with Git and Git management platforms such as GitHub or GitLab. Basic understanding of Cloud Computing platforms such as GCP/AWS/Azure and their services. Understanding of data warehousing and data modeling concepts. Familiarity with data orchestration and workflow management tools such as Airflow. Ability to handle data processing tasks and support the development of scalable data applications. Preferred Qualifications Excellent communication skills, with the ability to interact comfortably with peers and leadership both internally and externally. Hands‑on experience with data manipulation libraries and frameworks like Polars, Pandas, Spark, or similar tools. Familiarity with data warehousing concepts and technologies, such as Google BigQuery, Amazon Redshift, or Snowflake, and basic experience in writing and optimizing SQL queries for these platforms. Knowledge of ETL/ELT processes and tools, with basic understanding of how to build and manage data pipelines. Exposure to containerized tools like Docker or Kubernetes. Basic knowledge or experience with Infrastructure as Code (IaC) tools like Terraform or Pulumi. Some experience with data visualization tools such as Tableau, Power BI, or Looker. Proven ability to manage and complete projects within deadlines, even in an ambiguous or rapidly changing environment. About Mosaic Mosaic is a part of Acosta Group – a collective of the industry’s most trusted retail, marketing and foodservice agencies reimagining the way people connect with brands at every point in their shopping journey. As a leading North American integrated marketing agency, Mosaic specializes in everything from experiential marketing, commerce + retail media and field marketing, to design and production. With a 35+ year history, Mosaic has office hubs in Chicago, Dallas, and Toronto and full reach across North America. We focus on creating brand experiences that connect brands with consumers in creative and relevant ways. Mosaic’s ultimate mission is to propel our client’s business, culture, and communities forward to make the human experience better. We are diverse, yet like-minded individuals, and we believe in taking risks and creating shared experiences, not just for our clients, but for each other. Every associate is given the keys to charter new ground as they collectively live in the moment of building memorable experiences together. Equal Opportunity and EEO Statement Acosta Group is an equal opportunity employer and will provide reasonable accommodations for applicants with disabilities. If reasonable accommodation is needed, please contact and include “Applicant Accommodation” in the subject of your email to expedite the request. Acosta Group believes in good faith that the minimum and maximum annual salary or hourly compensation range for this opportunity is accurate and reasonable at the time of posting. The Acosta Group utilizes E‑Verify for validating the ability to work in the United States for all job candidates. By applying, you agree to our Privacy Policy and Terms and Conditions of Use. #J-18808-Ljbffr