Jr Client Data Engineer

Acosta Group • Lewisville, TX

312d

About The Position

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.

Requirements

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

Nice To Haves

• 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 is 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.

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.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Education Level: Bachelor's degree