BI Architect

International Permanente MXN65,000 - MXN75,000
  • Responsible to architect ECOM's new BI landscape with Qlik and or PowerBI
  • Responsible for designing, maintaining and developing the ETL tasks

Sobre nuestro cliente

Global leading commodity merchant


  • Responsible for current and new structure/design of the ECOM Data Lake (MS-SQL Server Technology) depending on Business requirements
  • Responsible to architect ECOM's new BI landscape with Qlik and or PowerBI, making it real time and fast processing
  • Responsible to architect easy to operate self-service reporting for business users
  • Responsible for designing, maintaining and developing the ETL (Extraction, Transformation and Load) tasks, including SSIS (SQL Server Integration Services) packages, T-SQL stored procedures and functions that are part of the process
  • Ensure that Data Lake scalability to accommodate future developments roadmap
  • Develop and maintain Qlik Sense and/or PowerBI related objects, such as reports and dashboards and Qlik NPrinting reports, tasks and schedules
  • Responsible for taking strategic decisions to maintain and/or develop the solutions required by the Business.
  • Provide technical guidance and knowledge transfer to other team members
  • Monitor Data Lake processes and apply performance tuning/technical improvements whenever needed
  • Create and maintain the necessary documentation for new developments and changes done in current ETL (SSIS) and SQL Server objects (tables, stored procedures, functions, jobs, etc.)
  • Become well versed with common problem inquiries and be able to provide immediate solutions
  • Plan new releases and rollouts to anticipate customer inquiries
  • Follow Software Development Methodology to deliver project on time, within scope and good quality.
  • Ability to work independently on the daily tasks with minimal supervision
  • Report status and escalate issues on a promptly manner to management level
  • Ability to work collaboratively with Software Development Engineers, other IT staff, and business stakeholders in a compliant, regulated environment

Perfil buscado (Hombre / Mujer)

  • 7+ years of experience working with SQL Server Development tools and T-SQL (Transact Programing language), delivering business intelligence solutions
  • 4+ year of experience with Qlik Sense or PowerBI (preferably both), developing and maintaining reports, dashboards, NPrinting tasks and business intelligence related objects
  • Experience with DDL, DML, DQL and DCL scripts
  • Experience working with software version control tools such as MS Source Safe and DevOps
  • Strong experience developing sophisticated/complex SQL queries, stored procedures, functions and cursors
  • Strong experience diagnosing and resolving errors in SQL Server 2008 R2 (or newer) TSQL
  • Solid experience in SSIS (SQL Server Integration Services) tools is required
  • Experience in T-SQL Tuning is required
  • Working experience with SSAS (SQL Server Analysis Services) and SSRS (SQL Server Reporting Services) tools
  • Experience working closely with Business Users to get business requirements, do follow ups and manage expectations, working on the end-to-end solution
  • Experience handling large datasets and multiple MS SQL servers/instances, concurrently jobs and complex ETL processes

Qué Ofrecemos

Base Salary PLUS benefits above the law

Santiago Sanchez
Ingresar referencia para vacante

Descripción de la vacante

Tecnologías de la información
Sub Sector
Big Data
Transport & Distribution
Tipo de contrato
Nombre del consultor
Santiago Sanchez
Referencia de la vacante

En Michael Page creemos en la diversidad e inclusión. Defendemos la igualdad de oportunidades sin discriminar por género, raza, edad, religión ni orientación sexual o por cualquier otro aspecto que pudiera ser considerado excluyente.