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.

Required Qualifications:

• Cloud Expertise: GCP or AWS (Data Engineering or ML focus) experience.

• Programming Skills: Strong proficiency in Python and experience with its data science libraries.

• Database Management: Experience with SQL (Teradata BigQuery etc.) and NoSQL databases.

• Data Visualization: Hands-on experience with Google Looker and Tableau for reporting and dashboards.

• CRM & Marketing Data: Experience working with CRM marketing platforms and analytics tools.

• Machine Learning Knowledge: working GCP/Azure/AWS Services with ML workflows model training AI Models and deployment.

• Data Automation & Transformation: Knowledge with Alteryx for workflow automation and data preparation.

Preferred Qualifications:

• Experience with data warehousing solutions (Snowflake Redshift etc.).

• GCP Certified focused on Data Engineering.

• Exposure to Apache Spark Airflow or other data orchestration tools.

• Strong understanding of data governance security and compliance.

• Health and Life Insurance for employees and family access to Vision benefits Telemedicine services Psychology support and others.
• On the job training and career growth opportunities.
• Access to LinkedIn courses.
• Fully remote job.
• Talented team environment collaborative offices fun company culture with a great balance of work and play.
• Vacations are granted by day or weeks according to employee approved request.
• Salary with yearly review and competitive benefits.
• Competitive compensation based on experience and skill set.

When asked what they love about working at Mod Op we hear:

• I feel I can be myself at work and its fun! -MV
• The caliber of the clients/brands we work with knowing your work is seen by thousands of people in many cases across the world. -JC

• We actually create videogames! -AC
• We have an all-star team and its like playing in the pro-bowl every day! -MW
• Opportunities to always learn from and work with the best and the brightest. HW
• Mentors and opportunities for growth. -KB

Mod Op LLC provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race color religion age sex national origin disability status genetics protected veteran status sexual orientation gender identity or expression or any other characteristic protected by federal state or local laws. This policy applies to all terms and conditions of employment including recruiting hiring placement promotion termination layoff recall transfer leaves of absence compensation and training.

Required Experience:

Junior IC