Data Engineer

Company Description

We are Dentsu International. We innovate the way brands are built. That means we do things differently so they’re better than before. In this way, we make our clients’ most important marketing assets—their brands—win in a changing world.

Dentsu International is a modern marketing solutions company. Our mission is to help clients navigate, progress, and thrive in a world of change. Businesses rely on our integrated network of agencies and specialized practices to champion meaningful progress through creative, media, commerce, data, and technology. Part of Dentsu Group, our global network comprises 66,000 diverse people in 143 countries, who are dedicated to teaming for growth and good. Follow us on Twitter @DentsuUSA and visit dentsu.com/us.

We are champions for meaningful progress and we strive to be a force for good—for our people, for our clients, for the industry and for our society. We keep our people at the center, creating space for growth, understanding and learning so they can thrive. We embed diversity, in our mindset, in our solutions and in our teams to empower an inclusive, equitable and culturally fluent environment. Building this culture within our teams makes us better collaborators with each other and with our clients, driving better outcomes for all.

Job Description

• Develop onboarding process to receive and process information related to onboarding a new subscriber
• Convert Snowflake Stored Procedures to Python Scripts directly in Airflow
• Develop metadata driven solutions for managing data processing and cadence
• End to end automation development and testing

• Building and maintaining stored procedures and scripts in Snowflake Data Cloud
• Building and maintaining complex SQL queries for ETL/ELT processing
• Develop Dashboard for data processed for audit and governance needs
• Follow Agile methodologies to deliver iterative feature sets rapidly
• Maintain codebase using source control methodologies, Git
• Collaborate with business analysts, data analysts, and other developers to deliver powerful new features
• Coordinate with teams as part of a larger data-sharing system
• Contribute to a collaborative, positive, and enjoyable environment for your operations team
• Performing quality assurance and testing

Writing user and technical documentation such as runbooks

Qualifications

• Strong communication skills both verbal and written
• Strong understanding of conditional programming logic
• Knowledge of software engineering and development methodologies, techniques, and tools; includes Issue Tracking (JIRA) Software Development Lifecycle SDLC), and Continuous Integration / Continuous Development (CI/CD)
• Experience working with large databases and data warehouses utilizing both relational and dimensional design concepts
• Eagerness to learn new technologies, programming languages and platforms to solve complex data challenges
• Experience with Python required
• Experience with SQL required
• Experience with Snowflake Data Cloud is highly desirable
• Experience with Amazon Web Services (AWS) a plus
• Experience with Airflow (or other orchestration) a plus
• Experience in database marketing is a plus

Additional Information

Perks:

• Great compensation package
• Comprehensive healthcare plans
• 401(k) with employer match
• Flexible time-off
• 16 weeks paid parental leave

Additional Information

The anticipated salary range for this position is $94,000-$146,000. Salary is based on a range of factors that include relevant experience, knowledge, skills, other job-related qualifications, and geography.  A range of medical, dental, vision, 401(k) matching, paid time off, and/or other benefits also are available. For more information regarding dentsu benefits, please visit dentsubenefitsplus.com  

Employees from diverse or underrepresented backgrounds encouraged to apply.
Dentsu (the "Company") is committed to a policy of Equal Employment Opportunity and will not discriminate against an applicant or employee of the Company, on the basis of age, sex, sexual orientation, race, color, creed, religion, ethnicity, national origin, alienage or citizenship, disability, marital status, veteran or military status, genetic information, or any other legally-recognized protected basis under federal, state or local laws, regulations or ordinances. Applicants with disabilities may be entitled to reasonable accommodation under the terms of the Americans with Disabilities Act and/or certain state or local laws. A reasonable accommodation is a change in the