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 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!
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