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 simi