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 [email protected]. 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.

#J-18808-Ljbffr

📌 Senior Database Engineer (Morelia)
🏢 Scio
📍 Morelia