Senior Data Engineer at ipgmediabrands

New York, New York, United States -

Full Time

Start Date

Immediate

Expiry Date

16 Jan, 26

Salary

165000.0

Posted On

18 Oct, 25

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data Architecture, Pipeline Design, Python, SQL, Snowflake, Data Quality, ETL, Cloud Computing, RESTful APIs, Git, Problem Solving, Attention to Detail, Team Player, Agile Development, Data Orchestration, JSON, XML

Industry

Advertising Services

Description

Business Overview KINESSO is the technology-driven performance marketing agency that sits at the very heart of IPG Mediabrands, providing actionable growth for both our agency partners and clients. We turn 'action' into 'outcome' for our clients, leveraging our unique capabilities in optimization, analytics, AI, and experimentation. KINESSO has brought together the collective power of what was formerly Matterkind, Reprise, P3, and Kinesso under one collective entity that will serve as the most powerful delivery engine in the industry. We have extensive offerings spanning across performance marketing and data and technology. Fueled by a deep understanding of consumer behavior, we offer an end-to-end engine of planning and optimization while also delivering on data-driven strategy for social platforms, actionable growth in e-commerce, and creating curated marketplaces specific to each client's function and needs. The company has more than 6,000 employees operating in more than 60 countries. Learn more at www.KINESSO.com. Position Summary As we architect the next wave of data solutions in the AdTech and MarTech sectors, we're on the lookout for a Senior Data Engineer—a maestro in data architecture and pipeline design. If you're a seasoned expert, eager to lead, innovate, and craft state-of-the-art data solutions, we're keen to embark on this journey with you. Responsibilities Develop, test, and maintain data architectures in Snowflake using Python, SQL, and modern data orchestration frameworks to deliver on business requirements. Uphold data quality standards, implementing tools and frameworks to detect and rectify data inconsistencies and inaccuracies. Optimize pipelines and data structures to ensure peak performance. Identify resolve bottlenecks by refactoring code and/or modifying flows. Drive initiatives for new data collection while refining existing data sources. Ensuring the highest standards of data integrity, accuracy, and reliability. Troubleshoot existing ETL pipelines and work with partners to resolve them in a timely manner. Develop and update technical documentation. Manage conflicting priorities and multiple projects concurrently. Required Skills & Experience 4+ years of intensive experience as a Data Engineer or in a similar role, with a demonstrable track record of leading large-scale projects. Familiarity with Airflow, Dagster or similar data orchestration frameworks Strong understanding of RESTful APIs as well as experience working with both synchronous and asynchronous endpoints Experience with Snowflake or Redshift with a strong understanding of SQL. Proficient in Python and Pandas Experience working with JSON and XML Strong understanding of cloud computing concepts and services (AWS preferably) Experience with Git or equivalent version control systems and CI/CD pipelines. Highly analytical with strong problem-solving skills: ability to apply solutions forward, not just completing the task at hand. Ability to investigate, analyze and solve problems as well as clearly communicate results. Strong attention to detail, well organized, and can prioritize tasks under pressure. Must be a team player but also can work independently. Desired Skills & Experience Bachelor’s degree in Computer Science, Information Systems, or a related discipline. A Master's degree or higher is a distinct preference. Familiarity with dbt a plus Experience working in an agile product development environment. Is positive and motivating in a team environment. We See You At IPG Mediabrands, we are unified behind a commitment to fostering a culture of inclusion and belonging. Together, we shine through a set of shared values and behaviors. We take pride in our responsibility to our clients, communities, and to each other. We embrace differences and recognize the unique value that each of us brings to our community. We encourage you to apply, as unique backgrounds, perspectives, and lived experiences are welcomed. We See You at IPG Mediabrands. Wage and Benefits We offer a Total Rewards package that includes medical and dental coverage, 401(k) plans, flex spending, life insurance, disability, employee discount program, employee stock purchase program and paid family benefits to support you and your family. To give you the ability to better meet your personal needs, and in support of your physical and emotional well-being, you will receive discretionary time off days and company-wide Appreciation Weeks and Wellness Days. We also offer a competitive Total Compensation package, including a competitive salary and eligibility for an annual discretionary incentive award or a relevant incentive award. The salary range for this position is posted below. Where an employee or prospective employee is paid within this range will depend on, among other factors, actual ranges for current/former employees in the subject position, market considerations, budgetary considerations, tenure and standing with the Company (applicable to current employees), as well as the employee’s/applicant’s skill set, level of experience, and qualifications. Employment Transparency It is the policy of Mediabrands, division of the Interpublic group, to provide equal employment opportunities to all employees and applicants for employment without regard to race, color, ethnicity, gender, age, religion, creed, national origin, sexual orientation, gender identity, marital status, citizenship, genetic information, veteran status, disability, or any other basis prohibited by applicable federal, state, or local law. Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice. The employer will make reasonable accommodations in compliance with the American with Disabilities Act of 1990. The job description will be reviewed periodically as duties and responsibilities change with business necessity. Essential and other job functions are subject to modification. Reasonable accommodations may be provided to enable individuals with disabilities to perform the essential functions. For applicants to jobs in the United States: In compliance with the current Americans with Disabilities Act and state and local laws, if you have a disability and would like to request an accommodation to apply for a position with Mediabrands, please email accommodation@mbww.com. About IPG Mediabrands IPG Mediabrands is the media and marketing solutions division of Interpublic Group (NYSE: IPG). IPG Mediabrands manages over $47 billion in marketing investment globally on behalf of its clients across its full-service agency networks UM, Initiative and Mediahub and through its award-winning specialty business units Healix, Kinesso, MAGNA, Mediabrands Content Studio, Orion Holdings, Rapport, and the IPG Media Lab. IPG Mediabrands clients include many of the world’s most recognizable and iconic brands from a broad portfolio of industry sectors including automotive, personal finance, consumer product goods (CPG), pharma, health and wellness, entertainment, financial services, energy, toys and gaming, direct to consumer and e-commerce, retail, hospitality, food and beverage, fashion and beauty. The company employs more than 18,000 diverse marketing communication professionals in more than 130 countries. Learn more at www.ipgmediabrands.com. Salary Range $160,000—$165,000 USD

How To Apply:

Incase you would like to apply to this job directly from the source, please click here

Responsibilities

Develop, test, and maintain data architectures in Snowflake using Python and SQL. Optimize pipelines and ensure data integrity while troubleshooting existing ETL pipelines.