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

Descripción

  • 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

Contacto
Santiago Sanchez
Ingresar referencia para vacante
JN-072022-5680073

Descripción de la vacante

Sector
Tecnologías de la información
Sub Sector
Big Data
Industria
Transport & Distribution
Localización
International
Tipo de contrato
Permanente
Nombre del consultor
Santiago Sanchez
Referencia de la vacante
JN-072022-5680073
 

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.