Data Engineer III

PMG is a digital company that helps marketers connect people with their brand. Focused on people and grounded in data, our award-winning culture fosters meaningful careers. Partnering with the most iconic brands in the world, we put people at the center of everything we do to deliver value, innovation, and business transformation.

Job Summary:

We are seeking a highly skilled Data Engineer III to join our team. The ideal candidate will design, develop, and maintain scalable data pipelines and architectures. You will work closely with analytics teams, data engineers to ensure the proper collection, transformation, and storage of data to meet business needs. The candidate will have a strong foundation in data warehousing and data modeling, with a deep understanding of dbt and its best practices.

Key Responsibilities:

• Develop and maintain complex data transformations and aggregations using SQL and DBT's Jinja templating language
• Develop and optimize data architecture to support analytics and business intelligence.
• Develop tableau dashboards
• Collaborate with cross-functional teams to gather requirements and deliver data solutions.
• Ensure data quality, integrity, and security across various platforms.
• Build and maintain data warehouse systems and ensure data accessibility for internal stakeholders.
• Monitor and troubleshoot data workflows, ensuring high availability and performance.
• Stay up-to-date with the latest DBT and data engineering trends and technologies.
• Work with both structured and unstructured data from a variety of sources.

Qualifications:

• Bachelor's degree in Computer Science, Engineering, or a related field (or equivalent experience).
• 3+ years of experience in data engineering
• Proficiency in SQL, Python, Jinja in dbt environment
• Proficiency in Tableau or other data visualization tools
• Experience with cloud platforms (AWS/Redshift, Snowflake)
• Strong understanding of database design, data warehousing.
• Experience with CI/CD pipelines and DevOps practices
• Excellent problem-solving skills and attention to detail.

About PMG:

PMG is a global independent digital company that seeks to inspire people and brands that anything is possible. Driven by shared success, PMG uses business strategy and transformation, creative, media, and insights, as well as its proprietary marketing intelligence platform Alli, to deliver Digital Made for Humans™. Our team is made up of over 500 employees globally, and our work for brands like Apple, Best Western Hotels & Resorts, CKE Restaurants, Experian, Intuit, Kohler, Nike, Sephora, Therabody, and Whole Foods runs across 85+ countries and has received top industry recognition from Cannes Lions to Adweek Media Plan of the Year.

Named to Ad Age’s 2023 A-List, MediaPost’s 2023 Independent Agency of the Year, and Adweek’s 2021 Breakthrough Media Agency of the Year, PMG has grown through commitments to continuous improvement, business integrity, and cultivating dynamic relationships. We are proud to be named among Fast Company’s Best Workplaces for Innovators and Fortune's Best Workplaces in Advertising & Marketing (ranked #1), and to be the only company named to Ad Age’s Best Places to Work nine years in a row.

Being part of PMG means being part of a company culture that’s unmatched in digital. We’re willing to work hard to serve our clients and deliver value, results, and innovation -- which often requires true grit and remaining agile. We believe in taking care of ourselves and each other so that we continuously improve in every way.

We’d love to get to know you and share more about why we love PMG and the work we do.

In alignment with our core values to be inclusive and always change for the better, PMG is committed to creating a more diverse and inclusive culture, and we are proud to be an equal opportunity employer. We believe we only change for the better by bringing different people to our company. PMG recruits, employs, trains, compensates, and promotes regardless of race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. Learn more about our commitment to Diversity and Inclusion and our action plan for change here.