PMG, Inc.
Data Engineer III
PMG, Inc., Dallas, Texas, United States, 75215
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 languageDevelop and optimize data architecture to support analytics and business intelligence.Develop tableau dashboardsCollaborate 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 engineeringProficiency in SQL, Python, Jinja in dbt environmentProficiency in Tableau or other data visualization toolsExperience with cloud platforms (AWS/Redshift, Snowflake)Strong understanding of database design, data warehousing.Experience with CI/CD pipelines and DevOps practicesExcellent problem-solving skills and attention to detail.What We Will Bring
Professional Development:
Take advantage of our learning and development programs, mentorship opportunities, and career advancement support.Generous PTO:
Benefit from our generous paid time off policy to recharge and spend time with loved ones.Parental Leave:
We provide paid parental leave to support your family during important life events.Retirement Plans:
Plan for your future with our competitive 401(k) matching program.Fertility and Family Support:
Access fertility benefits for all team members and their spouses.Pet Insurance:
Protect your pet's health and your finances.Lifestyle Spending Accounts:
Enjoy 100% company-funded accounts to promote healthy habits and well-being.Annual Bonus:
All employees are eligible for an annual bonus.Volunteering Opportunities:
Receive 8 give-back hours to volunteer in your local communities.AI Enterprise License:
Access AI Enterprise accounts and participate in weekly AI training sessions to empower and ensure AI safety.
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.
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 languageDevelop and optimize data architecture to support analytics and business intelligence.Develop tableau dashboardsCollaborate 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 engineeringProficiency in SQL, Python, Jinja in dbt environmentProficiency in Tableau or other data visualization toolsExperience with cloud platforms (AWS/Redshift, Snowflake)Strong understanding of database design, data warehousing.Experience with CI/CD pipelines and DevOps practicesExcellent problem-solving skills and attention to detail.What We Will Bring
Professional Development:
Take advantage of our learning and development programs, mentorship opportunities, and career advancement support.Generous PTO:
Benefit from our generous paid time off policy to recharge and spend time with loved ones.Parental Leave:
We provide paid parental leave to support your family during important life events.Retirement Plans:
Plan for your future with our competitive 401(k) matching program.Fertility and Family Support:
Access fertility benefits for all team members and their spouses.Pet Insurance:
Protect your pet's health and your finances.Lifestyle Spending Accounts:
Enjoy 100% company-funded accounts to promote healthy habits and well-being.Annual Bonus:
All employees are eligible for an annual bonus.Volunteering Opportunities:
Receive 8 give-back hours to volunteer in your local communities.AI Enterprise License:
Access AI Enterprise accounts and participate in weekly AI training sessions to empower and ensure AI safety.
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.