What are the responsibilities and job description for the Data Engineer III position at PMG, Inc.?
We are PMG Named Ad Age Best Places to Work for 9 years in a row and Fast Company Best Workplaces for Innovators since 2022, PMG is a global independent marketing services and technology company that seeks to inspire people and brands that anything is possible. Driven by shared success, PMG utilizes business strategy and transformation, creative, media, and insights-as well as its proprietary marketing intelligence platform, Alli-to deliver cutting-edge digital solutions and innovative media strategies. Our team comprises over 900 employees globally, and our work for ambitious brands like Apple, Best Western Hotels & Resorts, CKE Restaurants, Experian, Intuit, Kohler, Nike, Sephora, Therabody, and Whole Foods spans 85 countries.
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 :
What We Offer
What Sets Us Apart
Being part of PMG means joining a company culture that's unmatched in digital. We're dedicated to working hard to serve our employees and clients, delivering value, results, and innovation-which often requires true grit and agility. We believe in taking care of ourselves and each other to continuously improve in every way.
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 that we only change for the better by bringing diverse perspectives 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.