Senior Database Engineer

Scio; Morelia; Presencial; MXN 40.000 - 80.000; Jornada completa

Descripción de la vacante

An innovative company in Mexico is seeking a Senior Database Engineer to join their dynamic team. This role involves designing and developing efficient databases, writing optimized SQL scripts, and collaborating with stakeholders to ensure high-quality software delivery. The ideal candidate will have extensive experience in SQL, MS SQL Server, and data warehousing, as well as a passion for clean code and problem-solving. Join this exciting opportunity to work in a collaborative environment where your contributions will make a significant impact on the organization’s data infrastructure.

Formación

• 4+ years of experience in database design and management.
• Strong knowledge of SQL and database management systems.

Responsabilidades

• Design and develop efficient, secure, and scalable databases.
• Write optimized SQL scripts and queries for data management.
• Collaborate with stakeholders for high-quality software delivery.

Conocimientos

SQL

MS SQL Server

T-SQL

Power BI

Data Modeling

ETL

Data Warehouse

DAX

Data Transformation

Performance Optimization

Descripción del empleo

2 days ago Be among the first 25 applicants

Get AI-powered advice on this job and more exclusive features.

We’re a dynamic team at one of the Best Places to Code companies based in Mexico. Our mission? To create fully-fledged platforms using a wide range of tools and technologies.

Keep reading if you’re passionate about clean, elegant code and love collaborating with experts!

What We’re Looking For: Senior Database Engineer

• 4+ years’ experience in database design, development, and management, including knowledge of SQL and one or more database management systems such as Oracle, SQL Server, or MySQL.
• Strong and recent experience in MS SQL Server with a focus on:

T-SQL (stored procedures development and maintenance)

Performance optimization: index fragmentation, interpreting execution plans, query optimization

SSIS, creating packages, troubleshooting, and performance optimization

• 4+ years’ experience in data warehouse, data modeling, ETL, BI projects
• Strong and recent experience in Power BI

Handling multiple data sources

Data transformation (Power Query, M Language)

DAX (Data Analysis Expressions)

• 4+ years’ SQL experience with the ability to develop, tune and debug complex SQL applications is required
• Knowledge in schema design, developing data models and proven ability to work with complex data is required
• Understanding of best practices for building different data architectures including a Data Mesh, Data Fabric, Data Lake, Data Warehouse and supporting analytical architectures.
• Good interpersonal, analytical, problem-solving, and organizational skills

Responsibilities

• Designing and developing databases: The senior database developer is responsible for designing and developing efficient, secure, and scalable databases/marts to meet the organization's needs. This involves creating data models, tables, indexes, and other database objects.
• Writing database scripts and queries: A database developer is responsible for writing SQL scripts and queries to extract, manipulate, and manage data. They must ensure that the queries are optimized for performance and security.
• Designing, reengineering, and troubleshooting advanced MS SQL queries, Power BI dashboards, and SSIS (SQL Server Integration Services) packages.
• Creating/updating ETL (Extract, Transform, Load) specifications and supporting documentation
• Collaborate on the design & build of a reporting data infrastructure
• Interface with product owners and key stakeholders in Project Management, Business, QA, and Technology Operations to ensure high quality delivery of software projects
• Work with business analysts to understand business requirements and use cases

How to Apply: If this sounds like the perfect fit for you, send your resume in English to [e-mail]. We’ll keep you updated throughout the process.

Feel free to reach out if you have any questions or need further details!

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at Scio by 2x

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.