Data Analytics & Insights, Data Engineer

Company Description

Somos un consultora digital, internacional y ágil. En la era de la post-transformación digital, nos esforzamos para que cada uno de nuestros 28.000 profesionales pueda renovarse continuamente viviendo positivamente su propio flow digital.

Cada uno de ellos puede diseñar su itinerario profesional de acuerdo a sus preferencias, emprender junto a sus clientes para construir en la práctica un mundo más positivo, innovar en cada uno de los 27 países y conciliar su carrera profesional con su bienestar personal.

Nuestros 28.000 atletas digitales están orgullosos de haberse certificado Top Employer Europe 2024.

Job Description

The DAI Data Engineer [DE – Backend] is a direct report to the head of Data Analytics & Insights (DAI). The DE will focus on overseeing the full lifecycle of back end development, implementation and deployment of the Operational Data Hub, Data Marts, Data Lake and DAI Reporting environments, and the support of the integration of those systems with other related applications.

The DE works closely with the Data Architect, Enterprise Solution Architect(s), functional analysts, data analysts/owners, data scientists, and data engineering teams in order to power insight and avail meaningful data products for the business and enable consistently informed management decisions.

The DE understands how data is turned into information and knowledge and how the knowledge supports and enables key business processes within the organization. The DE also has a thorough understanding of the enabling Information Technology, DWH.

The key responsibilities and duties of this position are:

• Designs, develops, implements and maintains data pipelines to ensure efficient data processing and storage.
• Ensures data quality and integrity by implementing data validation and cleansing processes.
• Develops and maintains ETL/ELT processes to migrate and deploy data across systems.
• Collaborates with cross-functional teams to understand data requirements and design appropriate solutions.
• Work with other teams to design, develop, test, implement, and support technical solutions in full-stack development tools and technologies
• Perform unit tests and conduct reviews with other team members to make sure code is rigorously designed, elegantly coded, and effectively tuned for performance
• Support problem solving

Qualifications

Key accountabilities:

1. Project/Work Planning:

• Participates in work stream planning process including initiation, technical design, development and prototyping, testing, and delivery of BI/Analytical solutions.
• May participate in project management estimation process.
• May participate in the development of business cases to support BI/Analytical projects.

1. Business/BI Requirements:

• Works with Stakeholders, Business Analysts, Data Architect, Data Engineers, Data Integration Specialists to understand customer needs.
• Analyzes business and functional requirements and translates these requirements into robust, scalable, operable data solutions/frameworks.

1. Development and Implementation/Deployment

• Defines, promotes and implements the department’s best practices and design principles for data warehousing and/or Data Lake techniques and architecture.
• Designs, implements and supports the business’s database and table schemas for new and existent data sources for the data warehouse.
• Creates and supports the ETL/ELT in order to facilitate the accommodation of data into the warehouse and or data Lake using e.g. SSIS and/or other technologies. In this capacity, the DE designs, develops and implements systems for the maintenance of the business’s Data Lake and/or data warehouse, ETL processes, and business intelligence.
• Documents new and existing models, solutions, and implementations for all BI processes.

1. Production Support:

• Provides day-to-day support of the data warehouse and data lake and troubleshoots existing procedures and processes.
• Strives to improve data organization and accuracy: monitoring and troubleshooting performance issues on data warehouse servers and assisting in the development of business intelligence, business data standards, and processes.
• Support Database Administrators and Developers to build data warehousing systems, data lakes for business intelligence, reporting and analytics.
• Supports and helps manage external resources, such as service providers and vendor support.

1. Quality Assurance:

• Ensures the collected data is within required quality standards [Accuracy, Completeness, Consistency, Uniqueness, Timeliness, Relevance and Validity].
• Maintains the quality of Metadata Repository by adding, modifying, and deleting data.

1. Processes, Policies & Standards:

• Creates scalable, efficient, automated processes for large scale data analyses, model development, model validation, and model implementation.
• Documents standards and policies for the form, structure, and attributes of the BI platform, tools and systems.
• Ensures adherence to processes, policies, and standards.

1. Research and evaluation:

• Gathering and maintaining best practices that can be adopted in big data stacking and sharing across the business.

1. Coaching/Mentoring:

• Provides guidance, training, and problem solving assistance to other team members.
• Provides coaching to less-experienced individuals.
• Provides expertise to the business in the areas of data analysis, reporting, data warehousing, and business intelligence.
• Provides technical expertise to the business on business intelligence data architecture and also on structured approaches for transitioning manual applications and reports to the business.

Minimum Qualifications:

• Bachelor's degree in Computer Science, Information Systems, Business Management, Mathematics or specialized training/certification. Or equivalent work experience.
• A deep passion for data analytics technologies as well as analytical and dimensional modeling
• Extensively familiar with ETL/ELT, data warehousing, and business intelligence tools
• Experience developing new and enhancing existing data processing (Data Ingest, Data Transformation, Data Store, Data Management, Data Quality) components [at least 5 years]
• Advanced programming experience and big data experience [at least 5 years]
• Extensive experience with modeling, designing, and building star schema database structures.
• Experience with non-relational & relational models
• Data processing/data transformation using ETL/ELT tools [Informatica, MS Data Factory, DBT (Data Build Tool), Databricks, IBM InfoPshere DataStage]
• Strong working knowledge of SQL and the ability to write, debug and optimize SQL queries and ETL jobs to reduce the execution window or reduce resource utilization
• Experience with version control systems such as GIT
• Experience with load testing and load testing tools
• Experience with CI/CD deployment and test automation.
• Advanced understanding of monitoring concepts and tooling
• The ability to handle tight deadlines and time sensitive pressures well and remain even tempered.
• Willingness to challenge the status quo in order to enhance productivity, processes and procedures
• Experience/knowledge with Azure DEVOPS and working Agile
• Fluent in English language

Desired Qualifications/Experience:

• Engineering in Information Technology, BI, CBIP certified [TDWI, Certified Business Intelligence Professional] or MCSE: Data Management and Analytics [or equivalent].
• Experience/knowledge with/of BI Cloud solutions/foundations [AWS, MS Azure, SnowFlake, etc.]
• Experience/knowledge with/of BI Tools [PowerBI, Tableau, Cognos, etc.]
• Experience working with streaming applications (Spark Streaming, Flink, Kafka or equivalent)
• Experience with Power Designer or other Data Modeling Tools
• Experience with Visual Studio, Powershell, DAX, SQL, C#, Python, R, XML, JSON

Additional Information

¿Qué podemos ofrecerte?

• 🙋‍♀️💻 Formarás parte de un gran equipo de profesionales con inquietud y motivación por el desarrollo y la programación.
• ⏱ Trabajarás a jornada completa con un horario flexible bajo un modelo de trabajo remoto.
• 🏖️🧳 22 días de vacaciones + 2 de asuntos propios.
• 👩🏼‍🎓 Formación por parte de la empresa para que puedas seguir desarrollándote y promocionar dentro del plan de carrera que existe para ti.
• 🎮 Podrás asistir a eventos y conferencias relevantes del sector.
• ✍🏼 Contrato indefinido.
• 😄 Estabilidad y buen clima laboral.
• 💰 Salario Competitivo.
• 🆓 Acceso a ventajas del grupo de empresa
• 💵 Retribución flexible y más beneficios