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 well-being.

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.

We're looking for someone with hands-on, business-oriented strategic and technical consulting to our clients for cloud infrastructure, automation solutions and solution architecture.

In this role you will

• 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.

What are we looking for? Besides a great attitude,

You should have:

• 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 1+ years of 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 1+ years experience developing code, testing for quality assurance, administering RDBMS, and monitoring databases
• High proficiency in dimensional modeling techniques and their applications
• Minimum 1 + years experience in custom ETL design, implementation and maintenance
• Advanced SQL skills is a must

Requirements / Qualifications:

• Desirable: 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).