ETL & DWH developer

You must Sign In before continuing to the company website to apply.

What You'll Do:

About this position: Building from scratch and upgrading our Master Data, Business Intelligence tools and Data Integration Framework around our processes.

Construct Master Data, Business Intelligence and other internal services

Construct Data Integration framework, keep it up-to-date and promote it to others

Communicate with stakeholders for collecting requirements, analyze requirements

Research the available 3rd parties technical solutions on the market that fit requirements and compare them to find the proper one

Develop data structure and processes, set up settings of 3rd party solutions, maintain them in actual state

Develop the integrations between different parts of the IT landscape

Test the results and making the corrections/prepare tasks for the corrections if necessary

Generate reports and create SQL queries, procedures that are required for such reports and data marts

Who You Are:

2+ years experience in design and development of Data Warehouses, ERP or BI systems

Experience in building web applications and APIs

Experience with relational DBMSs (Postgresql, MySQL/MariaDB)

Experience with non-relational DBMSs (Elasticsearch, Cassandra, Redis, etc.) is a nice to have

Experience in Python/Java or other programming language (ability to read code, understand general architecture, investigate a problems) as a big plus

Experience with message streaming platforms (Kafka, etc.) as a plus

Experience with Talend Open Studio as a plus

Intermediate level of spoken and written English.

Set alert for similar jobsETL & DWH developer role in Barcelona, Spain

Company

Criteo

Job Posted

a year ago

Job Type

Full-time

WorkMode

Hybrid

Experience Level

3-7 years

Related Jobs

ETL & DWH developer

Criteo

Barcelona, Barcelona, Spain

Posted: a year ago

What You'll Do: About this position: Building from scratch and upgrading our Master Data, Business Intelligence tools and Data Integration Framework around our processes. Construct Master Data, Business Intelligence and other internal services Construct Data Integration framework, keep it up-to-date and promote it to others Communicate with stakeholders for collecting requirements, analyze requirements Research the available 3rd parties technical solutions on the market that fit requirements and compare them to find the proper one Develop data structure and processes, set up settings of 3rd party solutions, maintain them in actual state Develop the integrations between different parts of the IT landscape Test the results and making the corrections/prepare tasks for the corrections if necessary Generate reports and create SQL queries, procedures that are required for such reports and data marts Who You Are: 2+ years experience in design and development of Data Warehouses, ERP or BI systems Experience in building web applications and APIs Experience with relational DBMSs (Postgresql, MySQL/MariaDB) Experience with non-relational DBMSs (Elasticsearch, Cassandra, Redis, etc.) is a nice to have Experience in Python/Java or other programming language (ability to read code, understand general architecture, investigate a problems) as a big plus Experience with message streaming platforms (Kafka, etc.) as a plus Experience with Talend Open Studio as a plus Intermediate level of spoken and written English. 

Global Sales Effectiveness Manager

Criteo

Barcelona, Barcelona, Spain

Posted: a year ago

What You'll Do: Overview:   Sales Effectiveness is a global team within Criteo that aims to drive sales growth and productivity by strengthening sales processes, managing sales tools and driving change within Criteo’s Client Solutions organization to increase the Client Solutions teams’ productivity and effectiveness. Sales Effectiveness team sits under the Global Sales and Customer Excellence team. As the Sales Effectiveness Senior Manager, you will be an integral part of a Criteo’s fast growing business, leading a team of young, innovative and a high profile individuals. We have a vibrant culture, and we truly believe in team spirit and collaboration. You will partner very closely with the rest of the Sales and Customer Excellence team and the Client Solutions teams to boost sales efficiency through sales process improvement, tools selection, implementation, reporting & training.   You are someone who has ideally worked in sales, revenue operations or sales operations in the past and knows what drives commercial success. You know how to engage with the senior sales leaders about sales processes and metrics that move the needle for them and their teams. You have an excellent knowledge of what good looks like in the usage of Salesforce and you are able to articulate it and bring people along. You have experience in coaching and upskilling a team to drive business outcomes. Your goals will be: Drive Salesforce Transformation: Achieve seamless change management, adoption and support of the Criteo’s CRM transformation by the end of 2025 with multiple milestones until then. Optimize the Sales Process Continuously: Contribute to a reduction in sales cycle time and an increase in conversion rates. Drive Tool Adoption and Satisfaction: Drive increase and/or maintain high adoption (+95%) and satisfaction in the tools you oversee. Provide Data-Driven Insights: Set-up the framework to define, report and track KPIs aligned with business goals. Elevate this further by providing regular insights to the Client Solutions team. Enable the Client Solutions Team: Elevate Client Solutions team knowledge on processes & tools via trainings and robust self-service knowledge center, resulting in decreased volume on support queries and increased training satisfaction rates. Support the Users: Drive increased user satisfaction on the user queries, reduce response times, and optimize query resolution volumes. Cultivate Knowledge Sharing and Innovation: Bring the “Process and Tools Champions” community to the next level by continuing to strengthen their position and mission within the Client Solutions organization. Happy Team: Maintain a high employee engagement score and nurture & retain the top talent. How will achieve those goals: Driving CRM Transformation: Play a pivotal role in our CRM transformation journey, spearheading the change management efforts and ensuring seamless adoption and support. Strategic Execution for Target CRM: Collaborate closely with the rest of the Sales Excellence team to ensure successful implementation of the target CRM. Your role encompasses being an expert in the existing processes and overseeing change management efforts. This includes launching communication, delivering training, collecting feedback, and providing user support post launch. Optimize Sales Processes for Impact: Collaborate with the rest of the Sales Excellence team to identify and rectify sales process bottlenecks, leading initiatives that accelerate the sales cycle. This contributes to an increase in conversion rates.   Maximizing Value from Tools and External Data: Drive Adoption and Efficiency: Increase operational efficiency by driving the adoption of current tools that enable our processes and fundamentally boost overall sales team performance. Innovate with New Solutions: Continuously align tool and external data landscape with evolving business needs to enhance sales effectiveness. Proactively research new / emerging tools and data, collaborating with sales leadership to identify and recommend solutions aligned with business goals.   Empowering Decision-Making with Data Insights: Strategic KPI Definition and Tracking: Define and track KPIs aligned with business goals, providing valuable insights to sales leadership for informed decision-making and strategic alignment. Additionally, perform data-driven trend analysis, sharing findings with Sales Strategy and Sales Leadership teams to steer optimized outcomes. Impactful Reporting: Create and manage essential Salesforce reports tailored to the sales organization's requirements, offering actionable insights.   Enabling Client Solutions Team’s Success: Empower Users Through Trainings and Self-Service Knowledge: Enhance the newly established knowledge base, ensuring comprehensive coverage of processes and tools for all Criteo’s Client Solutions teams, and equipping teams with the information they require to excel in their roles. Develop impactful sales training materials on sales processes and tools. Establish an annual training calendar that captures sales teams' needs and captures Sales Excellence project launches. Support Users: Provide dedicated support to users, addressing their inquiries promptly and effectively. Oversee the external support provider, driving continuous enhancement of user support services. Regularly share insights gleaned from user support queries with relevant teams, fostering targeted improvements to processes and tools. Strive for heightened support satisfaction, reduced response times, and optimized query resolution volumes. Cultivate Knowledge Sharing and Innovation: Lead the "processes and tools community," comprising champions across the Client Solutions team on a regular basis. Cultivate a culture that embraces innovation and learning, and best practice sharing.   Leading the Team Effectively: Manage a team of 5 Field Sales Effectiveness Analysts. Coach the team around a common framework with tools and techniques on how to effectively drive change management. Upskilling the team to transform/enable them to become trusted advisors capable of driving change and leading conversations with internal senior stakeholders Who You Are: Proven track record of driving outcomes in sales, sales operations, sales enablement, or a related role. Proven track record of driving operational excellence, process improvement, and digital transformation initiatives in different markets and/or across multiple functions Proficiency in CRM systems (preferably Salesforce) and other sales tools. Strong leadership and communication skills, with the ability to influence and collaborate with stakeholders at all levels. Strong organizational and project management abilities. Customer-centric mindset to understand needs and constantly improve our internal customer (Client Solutions team) outcomes. Experience in leading and managing teams. Experience in driving change within an organization. Excellent analytical and problem-solving skills, with the ability to make data-driven decisions and drive results. Proactive and self-motivated with the ability to work independently and thrive in a fast-paced, entrepreneurial environment.

Senior IT Engineer

Criteo

Barcelona, Barcelona, Spain

Posted: a year ago

What You'll Do: The Senior IT Engineer, as part of the Internal IT Iponweb IT Systems operations  team, should enable processes of IT systems engineering, operations and  support. Main Responsibilities: ● Operate IT systems and Iponweb Office IT infrastructure ● Administer internal IT part of IPONWEB infrastructure ● Introduce new information systems, support and enhance existing ones ● Research possible solutions based on end user needs ● Ensure good monitoring/replication/backup/security, i.e. service reliability ● Automate recurring tasks, develop scripts/patches ● Integrate different information systems with each other ● Act as the 2nd line support for IT systems and Office IT infrastructure ● Project work related to IT systems and Office IT infrastructure  improvement and introduction of new ones ● Write technical documentation Who You Are: ● You have a Bac +5 (MS or equivalent) and at least 3 years of experience ● You have: ● Strong knowledge of Linux internals and TCP/IP stack networking,  web servers ● Experience with one of the major cloud providers (AWS, Azure, GCP) ● Strong knowledge of Docker, knowledge of Kubernetes ● Extensive experience shipping containerized applications with CI/CD pipelines using GitLab CI or similar ● Experience with databases in SQL and NoSQL  ● Strong shell scripting skills or at least one programming language ● Knowledge of IAC (Terraform) ● Experience with monitoring and APM tools like Prometheus, Grafana, Elastic stack, ● You are fluent in English, written and spoken ● You have excellent organizational and time management skills ●You have a problem solving mindset ● You have a “team first” and customer oriented mindset ● You have experiences working in an international environment

Campaign Manager, DACH

Criteo

Barcelona, Barcelona, Spain

Posted: a year ago

What You'll Do: The Campaign Manager is responsible for ensuring the successful implementation and execution of digital advertising campaigns across the group over several brands. You will work closely with stakeholders both internally (Senior Account Strategists) and externally (some of our highest spending core clients) to see campaigns through from planning stages, to post-campaign reporting and analysis of performance. Custom Support for Growth Accounts highest spending clients in collaboration with the Senior AS for the account. You develop your knowledge on an ongoing basis of the Books of Business of the Senior AS’s that you support and contribute to the growth of accounts. Proactive client communication & you will join weekly calls and QBRs which will be led by the Senior Account Strategist. Provide operational, efficient & accurate campaign delivery recommendations and be the lead point on execution. Lead on first-level client response for reporting and short-term optimizations Monitoring performance, often on 3rd party attribution End-to-end optimisation of campaign budgets, targeting, tactics, creative to meet and exceed clients objectives. Offer strategic recommendations to drive revenue & product expansion Technical implementation of ad campaigns with clients’ KPI’s in mind. Inventory management and custom reporting for clients Lead execution on new campaign launches Proactively evaluate, analyse & troubleshoot campaigns, anticipate main seasonality trends, identify and follow up on any ongoing issues. Ability to take insights from various data sources to inform campaign recommendations and contribute to whole strategy House updates: opportunities on new solutions & contacts Internal administrative tasks: submit, request & follow up with support teams (Finance, AX, TS, Products) Attend wide range of trainings to develop skills Who You Are: Fluent in English and German Ability to build strategies and action plans with both a “1 to many” and “1to1” approach Ability to work with different stakeholders (internally & externally) Great understanding of client’s and team’s needs. Will need to stay in touch with industry evolutions and standards as well. Strong influencing skills required Strong communication skills Project management skills as it will require a lot of co-ordination Always looking at creative ways to get to our objectives and beyond You are a force for bringing proposals forward. You show proactivity in your approach. Strong creative skills to come up with innovative ideas and prepare adapted decks for Senior AS calls Detail-oriented with a solutions-oriented mindset. Organized, structured & deductive skills You show self-leadership and of course, 100% aligned with our values and team culture Team player / Proactively shares beyond Core EU. 

Data Analyst (French or German Speaker)

Criteo

Barcelona, Barcelona, Spain

Posted: a year ago

What You'll Do: Analytics at Criteo is about transforming business problems into solutions using data. You will provide actionable insights and recommendations that empower our stakeholders to make informed business decisions, generating more revenue for our clients and for Criteo. Partnering closely with commercial and technical teams in our respective markets, we provide recommendations based on high quality data analysis and strong understanding of our industry in order to meet the objectives set by our advertisers. We also focus on delivering insights, improvements, and recommendations that will have immediate and measurable impacts. We get to play with exciting technologies such as Hadoop, Vertica, Tableau, Git and Python to grow the portfolio of analyses that we offer to internal and external stakeholders. We are always excited to take initiatives and enjoy the process of starting from an idea, then carrying out a complex data analysis, developing the results with the commercial teams and presenting it with them to our clients. We rely on each other’ strengths, experiences & ideas, and work collaboratively as a team to constantly innovate in an open, fun and inclusive environment. What you´ll do : Client insights: you will analyse complex data from multiple sources to understand the performance of our advertisers campaigns and generate innovative and impactful insights Business strategy: you will partner with the commercial team to help drive client strategy and direction Reporting tools and metrics: you will develop and scale reports and metrics that will present actionable insights to teams across the business and strategic leadership teams Testing: you will design, monitor and analyse A/B tests to understand better how our products work for our clients Collaborative projects: you will work on ad hoc projects with different teams to automate analyses globally, improve our internal processes and our way of working and scale knowledge across the company Strategic Big Data Synergies: this doesn’t actually mean anything, but we’re happy you read this description until here. If you’re open to play Among Us with us, we’ll be happy to have you! Who You Are: You are a logical thinker and are interested in analytics You have previous experience in problem solving You are business-minded and want to drive business strategy using data You are a strong team player and feel comfortable in a highly collaborative environment Some experience in SQL, Python, Tableau would be a plus. If not, a willingness to learn it! You are fluent in English and French/German and are able to communicate about complex subjects to non-technical stakeholders Must be eligible to work in Spain full-time with no restriction. (you’re a data wizard Harry)! Why you'll love us : Competitive compensation Career advancement and global mobility opportunities Medical and dental insurance to maintain your client-facing smile Generous vacation policy Video and sports games area when you need a break Daily lunch vouchers to keep you going How you’ll be working : Office: open space Teleworking/work-from-home Nearly exclusively on-screen work (laptop) Job may require travel for client meetings (once/twice per quarter) Special ergonomic advice possible Semi flexible-working hours If you need special working hour flexibility, we’re open to discussing it We value teamwork, openness, technical innovation, and results-oriented thinking. Join us to contribute to one of the leading-edge technologies in the online industry, in a multicultural and open environment!

Growth Account Executive (NO&BE), New Business (Dutch speaker)

Criteo

Barcelona, Barcelona, Spain

Posted: a year ago

What You'll Do: As an Account Executive Nordics and Benelux, your role is to convert leads and create new opportunities leveraging the most advanced technology tools and sales techniques. You mainly drive business directly, but you also play a role in enabling indirect channel business development in your market. In our New Business NOBE team we want our current and future team members to have a real curiosity about the technology industry, and to be excited about enabling their clients reach their marketing goals with trusted and impactful advertising. Your target clients will largely consist of (but will not be limited to) mid-sized business. You are autonomous and independent in your role as Account Executive, yet also a team player. Your main activity will be planning and execution of strategies and tactics to consistently hit Revenue and margin targets (RexT). This is mainly a volume-sales that requires anyway the capacity of Nurture relationships. You are comfortable in cold-calling and Video-calls, and ready to use tools such as Salesforce CRM, LinkedIn Sales Navigator and Outreach to increase volume and maximize your conversion rate. In this role, we expect you to build great relationships with all the internal stakeholders that will operate with you: marketing, legal, technical, account managers, product specialists and more. The understanding of the AdTech world is a plus, while a proven track record of working in technology sales, complex and multi-product is a must. You are able to build relationships with clients through both remote work. You are fluent in English – and in addition if applicable speak the language of the market of your focus. Who You Are: You have consultative selling and closing skills that you’re actively working on developing. You’re able to pitch multiple technology products and able to understand client goals. You’re able to adapt your pitch to the client using multiple technology products. You are used to running discovery questions and have some knowledge of Sales models. You are able to accurately forecast and are able to proactively manage your pipeline. You may be managing a high number of mid-sized prospects at any given time for the full sales cycle, from prospecting to closure. You keep this all up to date in our Customer Relationship Management Tool. You love achieving and have a track record of high performance of achieving sales quotas. You can’t wait to bring that impactful focus to Criteo! You have a strong focus on your business goals, and are able to approach to achieve them, with coaching on sales skills from your Manager, and may receive mentoring from other peers who have more experience in achieving their business goals. Fluent in ENGLISH AND DUTCH as a must. You have good analytical skills and you are a data-driven decision maker, able to use data and numbers to formulate and sustain business proposals/plans. You are able to provide an account plan for accounts for the upcoming quarter.