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