General information

Agency: Reprise

Job Function: Data & Analytics

Location: Los Angeles, United States

Job Ref#: 12510

Description & Requirements

Position Summary

As a data engineer on the Reprise Data Solutions & Governance team, you will working with data from Fortune 500 companies in just about every industry. You’ll have the opportunity to write advanced SQL queries using T-SQL, create aggregate views for Tableau visualizations, and work within the AWS ecosystem. To succeed in this role, you have a few years of hands-on experience with relational databases, writing SQL statements, and have a good understanding of how and where to process data efficiently. You should be able to consider data from the perspective of an end user to derive actionable insights that tell a functional story. You also have or are interested in gaining experience in the AWS ecosystem. 

 

Any addition to our team would be comfortable driving their own work, communicating with cross-functional teams of diverse backgrounds, and have the confidence to share their opinions and insights. The best candidate would be curious and think critically before implementing a possible solution.

Key Responsibilities

  • Write T-SQL to execute queries and create aggregate views for reporting
  • Analyze existing SQL statements to improve performance and validate business requirements
  • Work with our DBA to update the schemas and improve performance
  • Perform data quality checks to validate ETL processes
  • Document code and processes
  • Use Jira and Kanban methods to plan and deliver work

Desired Skills & Experience

  • Strong SQL/T-SQL skills such as subqueries, CTEs, window functions, or complex joins
  • Familiarity with ETL jobs and writing scripts
  • Tableau or other visualization experience
  • Ability to translate between functional business users and technical requirements for developers
  • (Bonus) Media/Ad experience
  • (Bonus) AWS experience with RDS, EC2, Glue, S3, Athena, and related services
  • (Bonus) Using git and versioning to collaborate with the team and manage code

 

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 Us

Why join us: You’ll work hard, grow and recharge. Our diverse business offers various opportunities to grow your career across Paid Search, Paid Social, SEO, eCommerce, and Strategy, amongst others. We provide tools to support your career ambitions that include mentorship programs, learning modules and professional skills trainings. You’ll have the opportunity to drive social impact with our Diversity, Equity, and Inclusion Council to create meaningful change in our communities.

In addition to working with some of the world’s most dynamic and recognized brands, you will enjoy incredible benefits such as unlimited time off, multiple health/wellness days, extra-long holiday weekends, various perks, discounts, and benefits provided by our clients and an incredible office culture.

All U.S. Mediabrands employees must be fully vaccinated against COVID-19 or have an approved accommodation.