Data Engineer

Hogarth is the Global Content Experience Company. Part of WPP, Hogarth partners with one in every two of the world's top 100 brands including Coca-Cola, Ford, Rolex, Nestlé, Mondelez and Dyson. With a breadth of experience across an extensive range of sectors, Hogarth offers the unrivaled ability to deliver relevant, engaging, and measurable content across all channels and media - both established and emerging.

Our global team of over 6,000 craft and technology experts brings together creative, production and innovation to help clients navigate this exciting and ever-changing world of today's content experience.

The
Data Engineer
is responsible for the successful delivery of business intelligence information to the entire organization and is experienced in BI development and implementations, and data warehousing.

WHAT YOU'LL DO:

• Creating data models, performing ETLs and validating results with business representatives
• Manage data for BI solutions and automate data collection and management.
• Builds SQL ETL routines to move, cleanse and prepare data for reporting
• Create and manage Data pipeline in Azure and GCP environment.
• Setup data warehouse in Azure or Google cloud
• Design and develop databases and perform data extraction
• Analyze existing SQL queries for performance improvements.
• Develop, implement and optimize stored procedures and functions using SQL
• Review and interpret ongoing business report requirements
• Assemble reporting insights and develop executive summaries and trend reports
• Spot trends and data anomalies
• Provide insights and suggested ways to improve performance
• Develop forecasts and suggest testing strategies.
• Develop and prepare a schedule for a new data warehouse
• Analyze large databases and recommend appropriate optimization for the same
• Administer all requirements and design various functional specifications for data
• Evaluate all codes and ensure the quality of all project deliverables
• Monitor data warehouse work and provide subject matter expertise
• Work across various international clients, from different countries, industries, and participate in the entire BI lifecycle, focusing on reporting, data migration and dashboards.
• Work cross functionally across the project in an Agile methodology to complete user stories within the assigned sprint.

WHAT YOU'LL NEED:

Technical skills

• 2+ years of experience with SQL and can write complex queries
• 1+ years of experience in Azure / GCP or anyother cloud data Technology.
• Expert knowledge of Relational Database and SQL Language (Data Warehouse modelling)
• Expert knowledge of Extraction, Transformation and Loading
• Good knowledge of Dimensional Modelling and development with BI tools
• Writing stored procedures/function/triggers and optimizing database queries
• Intermediate or better proficiency in Power Query
• Experience with any of the various computer languages, programs, and scripting languages such as Python, R, Bash etc would be a plus.
• Experience working with any database systems such as SQL Server, PostgreSQL, any cloud database etc.

Soft skills required for all positions:

• A master at transferring data into insights as well as telling a compelling story
• A curious mindset with critical thinking, keep yourself on top of industry changes before they impact our clients
• Great presentation and delivery of insights through client-servicing, excellent verbal and written communication
• A self-starter, proactive, who identifies milestones and potential blockers and is able to solve them with minimum supervision
• Be a data ambassador, foster knowledge sharing across team members regionally as well as locally for more junior / interns
• A self-starter, proactive, who identifies milestones and potential blockers and is able to solve them with minimum supervision

Hogarth Values

Heart and Soul:
We love what we do. We bring energy and enthusiasm to all our work. We push boundaries, we are never satisfied and always want to find a better way.

Hands on:
We don't wait for things to happen; we get on with it. We are pragmatic and don't have an ego. We do what it takes to get the job done to the highest standards.

Honest:
We are straightforward; we speak openly and clearly. We operate with integrity and live up to our promises.

Happy family:
We enjoy working together. We look out for our colleagues. We are an eclectic bunch. We want to work with people from many cultures and demand great things of each other. Even when things get tough, we don't lose perspective or our sense of humor.

Hungry:
We are an inquisitive community. We want to create an environment which inspires ourselves and others to be better. It is important to continuously challenge ourselves and our ways of working. We aim to provide staff with the opportunities to develop and learn.

Find out more at

Diversity & Inclusion

Hogarth is an equal-opportunity employer. That means we believe in creating a truly inclusive culture that values diversity, equity and inclusion for everyone through our ideas, our people, how we behave and how we conduct ourselves. We strive to recruit people from diverse backgrounds and support them to achieve long-term success. This not only makes Hogarth a better company and place to work, but an environment where everyone can give their point of view, experience connection, enjoy opportunity and feel a sense of belonging.

We welcome applications from everyone, regardless of race, ethnicity, religion or belief, gender, gender identity, age, national origin, marital status, military veteran status, genetic information, sexual orientation, or physical or mental disability. As part of our commitment to making our hiring processes as equitable as possible, we are currently rolling out a policy which ensures that hiring managers review CVs only after they have been processed through an automated anonymization system. This aims to ensure that all candidates are considered for interview based solely on their experience and what they can bring to the role. The solution, provided by MeVitae, scans and redacts CVs to reduce potential reviewer bias.

Data

We rely on legitimate interest as a legal basis for processing personal information under the GDPR for purposes of recruitment and applications for employment.

DISCLAIMER: The above information on this description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications required of employees assigned to the job. As an Equal Opportunity Employer, GTB Agency, LLC. does not discriminate against applicants or employees because of age, race, color, religion, gender, sexual orientation, genetics, pregnancy-related status, veteran status, physical or mental disability where the individual is otherwise qualified, national or ethnic origin, or on any other basis were protected by local, state, or federal law.