Database Engineer

Job Offer

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!

Location: Must be based in Mexico or LatAm

vacante-Database-web-letra

Key Responsibilities:

N

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

N

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.

N
Designing, reengineering, and troubleshooting advanced MS SQL queries, Power BI dashboards, and SSIS (SQL Server Integration Services) packages.
N

Creating/updating ETL (Extract, Transform, Load) specifications and supporting documentation.

N
Collaborate on the design & build of a reporting data infrastructure.
N

Interface with product owners and key stakeholders in Project Management, Business, QA, and Technology Operations to ensure high quality delivery of software projects.

N
Work with business analysts to understand business requirements and use cases.

Required Qualifications:

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
N
5+ 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.
N
5+ years’ hands-on experience in MS T-SQL and SSIS
N
5+ years’ experience in data warehouse, data modeling, ETL, BI projects
N
5+ years’ SQL experience with the ability to develop, tune and debug complex SQL applications is required
N
3+ years’ hands-on experience in Power BI
N
Knowledge in schema design, developing data models and proven ability to work with complex data is required
N
Understanding of best practices for building different data architectures including a Data Mesh, Data Fabric, Data Lake, Data Warehouse and supporting analytical architectures.

Must-have for DB Engineer:

N

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
N

Strong and recent experience in Power BI

  • Handling multiple data sources
  • Data transformation (Power Query, M Language)
  • DAX (Data Analysis Expressions)

The journey:

We know your time is valuable, so know the whole process will take about 2 weeks. There will be 4 interviews total (an initial one with Human Capital, a technical skill one, one with an Account Manager, and probably one with the client at the end), possibly with a technical test, if necessary.

We will keep you regularly updated about your application, but you can also get in touch with us to ask about its status or anything else you might want to know. Just have fun! If you are a good match for Scio, we will give you a formal job offer and ask you to get the pre-hiring requirements to us within 5 days at most, so preparedness is key.

How to Apply:

If this is the perfect fit for you, send your resume in English to humancapital@sciodev.com. We’ll keep you updated throughout the process.

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