Jr Client Data Engineer

Mosaic is a leading North American Integrated Agency, specialized in connecting with consumers through Experiential Marketing, Sales & Merchandising, and Shopper Marketing. At Mosaic, we are never satisfied with the status quo and are in constant search for new ideas and new ways to help our clients build their brands amidst the evolving dynamics of empowered consumers and leveraging new technologies.

 

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. This 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.

The incumbent(s) in this position should exhibit Acosta Group’s 8 Ways of Working:

1. Owner’s Mindset – We think, act, and make decisions like we own the company.
2. Progressive and Disruptive – We look to the future and proactively launch solutions to help our clients prepare for it.
3. Deliver Results, and on our Commitments – We are performance-based, equitable, and inclusive culture; we deliver what we promise.
4. Talent Obsessed – We believe we need to transform in order to grow, we help associates adjust and thrive with the change.
5. Client and Customer Focused- We are strategic advisors who act in our clients’ and customers’ best interests.
6. Embrace Change- We believe we need to transform in order to grow; we help associates adjust and thrive with the change.
7. Collaborate internally and with Clients – We find ways to work inclusively to elevate solutions and help clients benefit from our broad capabilities.
8. Debate in huddle, all-in on running the play – We encourage diverse and inclusive viewpoints in planning but expect alignment once a decision has been made.

• 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 the 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 tool.
• 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 in a plus.
• 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.

 

Mosaic North America is an Equal Opportunity Employer

DISCLAIMER: The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. Mosaic reserves the right to modify all or part of any job descriptions at its discretion in order to meet and or exceed the needs of the business.

By submitting your application you agree with and accept the Acosta Privacy Statement and Terms of Conditions.
US: http://acosta.jobs/privacy-policy-us/    
Canada: http://acosta.jobs/privacy-policy-ca/

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.
We empower you to Discover Your Path and fully embrace BEING YOU as you shape your journey with us. At Acosta Group, we value equal opportunity in employment practices and career progression. Employment decisions are based on business needs, job requirements, and individual qualifications without regard to race/ethnicity, gender/gender identity, disability, veteran status, or any other basis protected by federal, state, and local laws. Acosta Group will provide reasonable accommodations for applicants with physical or mental disabilities to complete applications or interviews for employment. If reasonable accommodation is needed to participate in the job application or interview process, please contact EmployeeServices@acosta.com
Acosta Group and its subsidiaries believe the posted compensation range accurately reflects this role at the time of posting. Final pay may vary based on qualifications and location, and the range may be updated in the future.
Acosta Group is an E-Verify employer. By applying, you agree to our Privacy Statement and Terms of Conditions.
US: http://acosta.jobs/privacy-policy-us/  Canada: http://acosta.jobs/privacy-policy-ca/
Mosaic is part of Acosta Group. To learn more about Mosaic click here: https://acosta.jobs/agency/mosaic