Database Engineer

Database Engineer

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

Database-Engineer-Web

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!

React / .NET Developer

React / .NET Developer

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 Web-React

What we’re looking for:

N
Excellent communication skills in both written and spoken English as our work is highly collaborative.
N
Bachelor’s degree in computer science, or equivalent experience.
N
A minimum of 3 years of professional software development experience in React and one or more programming languages (ex: C++, C#, VB).
N
Knowledge of API and communication protocols and integrations.
N
Demonstrate knowledge of React, .Net Core Web API, ASP.Net, and other technologies used by the company.
And feel free to tell us anything else we might find interesting! We like to collaborate with people with all kinds of experience and backgrounds.

Preferred Qualifications:

N
Experience developing in .Net Core API and ASP.Net.
N
Experience developing libraries, APIs and SDKs for use by other developers.
N
Experience developing accessible technologies.
N
Experience with unit testing.

Responsibilities:

N
Contribute to the development of software solutions, across the full stack.
N
Take ownership of changes throughout the entirety of the SSLC.
N
Manage project priorities, deadlines, and deliverables.
N
Review code developed by others and give feedback to ensure best practices.
N
Communicates, contributes to, and enforces coding standards.
N
Understands the benefits of the various design methodologies and object-oriented environments.
N
Work with the company’s application life cycle management system to document programming tasks.
N
Unit testing of code to ensure it meets specification.
N
Use secure programming methodologies to reduce risk to company and clients.
N
Follow the company’s Software Development Cycle for development activities.
N
Participate in various meetings and planning sessions.

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!

Ruby Developer

Ruby Developer

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

Ruby Developer

What we’re looking for:

N
Excellent communication skills in both written and spoken English as our work is highly collaborative.
N
Senior level developers – 7+ years of experience.
N
Must have strong Ruby skills, some Ruby on Rails.
N
Desirable experience with: MongoDB, AWS, Docker, Kafka, Terraform, JavaScript, SCSS, React, and Webpack.
N
Experience with tools like: Slack, Zoom, Google Suite, Jira, Github, Backstage, CoPilot.
And feel free to tell us anything else we might find interesting! We like to collaborate with people with all kinds of experience and backgrounds.

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!

Senior .NET Developer

Senior .NET Developer

If you are a builder, capable of creating fully-fledged platforms with a wide range of tools and technologies, and you like to be involved in the design, development, and implementation of every new feature needed. Your code is clean and elegant, and you love to collaborate with a team of experts and with US-based clients at one of the Best Place to Code companies based in Mexico. Is this you? Because we have a position that might be just perfect.

Location: Must be based in Mexico or LatAm

Senior Python Developer job offer

What you have:

You are a documentation-oriented person who values collaboration and teamwork, able to communicate with developers and report roadblocks. Also, you master both English and Spanish (written and spoken) and are always eager to learn. On a more technical side, you also have:

N

6+ years of experience designing, developing and testing with C# and .Net

N

6+ years of experience in building distributed applications in the .Net environment

N

Application development experience using .Net data access technologies such as Entity frameworks, Object-relational mappings, ADO.Net

N

A strong understanding of Best Practices within any .Net technology

N

Motivation to discover and experiment with newer technologies and ability to analyze the merits/demerits of newer technologies

N

Fully bilingual English/Spanish.

Desired Skills:

N

C#.NET

N

Windows Presentation Foundation (WPF) / XAML

N

ASP.NET

N

MySQL Server / SQL Server

N

Experience working with various Web API technologies (SOAP, REST, OAUTH)

N

Amazon Web Services APIs

N

eBay Trading APIs

Responsabilities include:

N
Engineer capable of designing solutions, writing code, testing code, automating test and deployment.
N
Develop and maintain high-quality software code and automated tests (including Unit, Functional, Performance, and Acceptance).
N

Production resilience: the system must be highly available with minimal downtime.

And feel free to tell us anything else we might find interesting! We like to collaborate with people with all kinds of experience and backgrounds.

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.

Does this seem like a position designed just for you? We’d love to check your resume.

Please send it in English to humancapital@sciodev.com and we’ll get back ASAP.
Thanks for reading!