Junior Data Engineer

Data Engineer Job Description

Mod Op is a full-service advertising agency with offices across several US locations, Panama City, Panama, and Canada. With continued growth and a dynamic leadership team, we offer a generous time-off package, access to high-quality healthcare options, and a collaborative team dedicated to career and personal development. We believe in teamwork, client collaboration, storytelling, stunning design, and solving complex problems with innovative solutions. We are a 360 agency providing strategy, design, and production across all channels, with clients representing a variety of industries, offering diverse and exciting challenges. We are committed to working smart and enjoying the work we do.

About You :

As a Data Engineer with (1-2) years of experience, you will be responsible for designing and implementing robust data pipelines, optimizing data workflows, and supporting analytics initiatives. You will work with AWS and GCP cloud services, integrate with CRM and marketing platforms, and enable data-driven decision-making through visualization tools like Google Looker and Tableau.

Key Responsibilities :

• Data Pipeline Development : Design, develop, and maintain scalable ETL / ELT pipelines in GCP, Azure & AWS using various services including Data Flow, Composer, Azure Synapse, AWS Data Pipelines and etc
• Data Integration : Work with structured and unstructured data sources, including CRM and marketing data platforms.
• Database Management : Develop and optimize queries for SQL & NoSQL databases (Teradata, BigQuery, Cassandra, etc.).
• Data Science & ML : Implementing Models using GCP Vertex ai and utilizing Python and its data science libraries (Pandas, NumPy, Scikit-learn, etc.) for data analysis and ML model deployment.
• Data Visualization : Build and manage dashboards using Google Looker and Tableau to provide business insights.
• Collaboration : Work closely with data analysts, marketing teams, and other stakeholders to understand business needs and implement effective data solutions.
• The position operates under a hybrid work model, requiring in-office presence at the Grapevine, Texas location two days per week, with the remaining days worked remotely.