Data Engineer

WHO WE ARE:

We think too much marketing isn’t us. It’s mass markets, not audiences of one. Homogenous groups to be targeted, not individuals to be inspired. Segments to reach, not people with their own ideas and ambitions. It’s one size fits all, and it’s dull.

When it comes to individuals, we’re fierce. We stand up for individuality. We speak up against bland, broad-brush generalizations. We fight for solutions that adapt to the individual’s needs, beliefs, behaviors and aspirations. And we commit to doing this in every aspect of our work for clients and their consumers.

We actively foster an inclusive workplace where diversity and individual difference are valued and leveraged to achieve the agency’s vision. And most importantly, we value every individual’s wellbeing.

We are Fiercely Individual.

HOW WE DO IT:

At RAPP, we are fiercely focused on the individual and how we can create value from every individual’s experience with a brand. We do this across three capability areas: customer-centric consulting, creativity that inspires action and customer experience management.

Our data analysts know who that person is. Our strategists understand what they want. And our award-winning technologists and creatives know how to get it to them.

RAPP is an integral part of Omnicom’s Precision Marketing Group, comprising 4,000 creatives, technologists, strategists, and data and marketing scientists across 40 global markets.

YOUR ROLE:

• Evaluate business needs, objectives and build algorithms and prototypes
• Responsible for designing, building, and supporting the components of data warehouse, such as ETL processes, databases, reports and reporting environments
• Conduct complex data analysis and report on results, analyze and organize raw data
• Identify opportunities for data acquisition by developing analytical tools and programs
• Collaborate with data scientists and architects on several projects
• Consolidate and optimize available data warehouse infrastructure
• Responsible for designing, building, and supporting the components of data warehouse, such as ETL processes, databases, reports and reporting environments
• Assembles performance statistics, analyzes them, and makes recommendations for improvements
• Establishes system documentation and ensures it is continually sustained
• Conceive analytics and business intelligence platform architecture for clients, including internal and third-party clients
• Collaborate with business and technology stakeholders in ensuring data warehouse architecture development and utilization
• Carry out monitoring, tuning, and database performance analysis
• Design, automate, build, and launch scalable, efficient and reliable data pipelines into production
• Perform root cause analysis and resolve production and data issues

YOUR RESPONSIBILITIES:

• Experience and expertise with data models, data mining, and segmentation techniques
• Experience with SQL database design
• SQL Server Integration Service (SSIS)
• Experience with programming languages (e.g. Java and Python)
• Experience in combining raw data from different sources and conducting complex data analysis
• Experience in building algorithms and prototypes and perform complex data analysis
• Experience in design and implement ETL procedures for intake of data from both internal and external sources, as well as ensure data is verified and quality is checked
• Experience in design and implement ETL processes and data architecture to ensure proper functioning of analytics, as well as client’s or third-party’s reporting environments and dashboard
• Carry out monitoring, tuning, and database performance analysis
• Minimum 4 years experience performing data warehouse architecture development and management
• Minimum 4 years experience with technologies such as SQL Server, SQL Server Integration Service (SSIS), and stored procedures
• Minimum 4 years experience developing code, testing for quality assurance, administering RDBMS, and monitoring databases
• High proficiency in dimensional modeling techniques and their applications
• Minimum 3 years experience in custom ETL design, implementation and maintenance
• Advanced SQL skills is a must

REQUIRED SKILLS:

• Bachelor or master's degree in Computer Science or related technical field
• Data engineering certification (preferable)
• Ideally Intermediate English Proficiency (B2 reading, writing, and conversation).

NOTE:  This job description is not intended to be all-inclusive. Employee may perform other related duties as negotiated to meet the ongoing needs of the organization.