Data Warehouse Developer

Confíe Tijuana; Tijuana; Presencial; MXN 400,000 - 600,000; Jornada completa

Descripción de la vacante

Una empresa de datos en Tijuana busca un Desarrollador de Data Warehouse para construir soluciones que integren datos existentes. El candidato ideal debe tener al menos 5 años de experiencia en desarrollo de Data Warehouse, experiencia en SQL y conocimientos en herramientas ETL. Se requiere título universitario y se valoran certificaciones en Snowflake. Ofrecemos un puesto a tiempo completo con beneficios como seguro médico y un salario competitivo.

Servicios

Seguro de gastos médicos

Formación

• 5 años de experiencia como Desarrollador de Data Warehouse o Data Engineer.
• Conocimientos en C# y tecnologías ASP NET.
• Experiencia en procesos de Data Warehouse (ETL, OLTP, OLAP).

Responsabilidades

• Recopilar requisitos comerciales y especificaciones funcionales.
• Realizar análisis de datos y modelado.
• Diseñar, desarrollar y mantener pipelines de datos escalables.

Conocimientos

Desarrollo de soluciones centradas en datos

Análisis de datos

Modelado de datos

Optimización de SQL

Experiencia con herramientas ETL

Conocimientos de programación en C#

Experiencia en Snowflake

Educación

Licenciatura (BA o BS) o experiencia equivalente

Herramientas

SQL Server

Snowflake

ETL - SSIS

Tableau

Descripción del empleo

The Data Warehouse Developer will work under the guidance and supervision of the Data Warehouse Tech Manager to build Confie's next generation Enterprise Data Warehouse.

The Data Warehouse Developer will help develop data-centric solutions to meet the company's business needs - specifically, integrating existing silo data and providing data solutions that reflect the integrated landscape.

Summary of duties :

The Data Warehouse Developer core responsibilities will include, but are not limited to :

• Gather business requirements and functional specifications.
• Perform data analysis and data modeling as required to design tables and processes to fulfill the business requirements.
• Transform complex customer business requirements into effective, efficient, and maintainable enterprise-level solutions.
• Research, analyze, support, and implement database solutions and changes on MS SQL Server / Snowflake Cloud data warehouse platform.
• Write and code logical and physical database descriptions and specify identifiers of database creating a data dictionary.
• Design, develop and maintain scalable data pipelines.
• Develop data ingestion and integrations (REST, SOAP, SFTP, etc.) processes.
• Ability to work with multiple data sources and types (structured / semi-structured / unstructured).
• Modify existing data warehouse processes and objects as necessary to include best practice standards.
• Query optimization and Performance tuning of complex SQL stored procedures and queries.
• Mitigate existing disparate data sources into the enterprise data warehouse.
• Maintain data dictionary documentation.
• Implements processes and systems to monitor data quality, ensuring production data is always accurate and available for key stakeholders and business processes that depend on it.
• Monitor database jobs for timely and accurate completion.
• On Call Support.

Requirements :

• Bachelor's degree (BA or BS) and or equivalent work experience
• Snowflake Certification is a plus
• Additional certifications related to data processing are a plus.
• 5 years professional experience as a Data Warehouse Developer, SQL Developer or Data Engineer with knowledge of relational databases using Microsoft SQL Server, MySQL, or other RDBMS
• 4 years' experience with programming in C# and ASP NET technologies.
• SQL Developer experience is a must; able to write complex store procedures, user-defined functions, common table expressions, and correlated sub-queries; able to optimize indexes; understanding of atomicity and transaction isolation levels
• 4 years of experience in Data Warehouse processes (ETL, OLTP, OLAP, etc.) is required
• Good experience with ETL tools like SSIS; or experience with Wherescape, Talend, Informatica and other ETL tools is acceptable; experience with maintaining and enhancing load jobs
• Some experience with Reporting tools is desirable, like Tableau, SSRS, PowerBI and others
• Knowledge of best practices and principles for Data Warehousing, particularly the Kimball method
• Experience or knowledge in Cloud platforms like Snowflake, Azure or AWS is a plus
• Additional programming / scripting language knowledge is a plus : Windows Powershell, Python, R, JavaScript, Linux shells (ksh, bash)

Key Experience in the following is highly desirable or a strong willingness to learn in lieu of :

• Snowflake Cloud Warehouse
• Data Vault 2.0 Methodology
• WhereScape RED and / or 3D
• Tableau

Job details

Tipo de puesto : Tiempo completo, Por tiempo indeterminado

Salario : $30, al mes

Beneficios :

• Seguro de gastos médicos

Horario :

• Diurno

Educación :

• Licenciatura terminada (Deseable)

Experiência :

NET : 1 año (Deseable)

• JavaScript : 1 año (Deseable)
• Desarrolladores iOS : 1 año (Deseable)
• Desarrolladores Android : 1 año (Deseable)

Idioma :

• Inglés (Deseable)