Job Description
- Primarily responsible for creating database tables, structures, views, functions, stored procedures, schemas, and dictionaries to facilitate the ETL of data within Microsoft SQL Server.
- Responsible for developing and maintaining Microsoft SQL Server databases whilst also ensuring their performance and stability.
- Create and implement changes to databases based on the requirements of the end user
- Ensure data quality and integrity.
- Work on problems of complex scope where analysis of situations or data requires a review of a variety of factors.
Benefits
- Monday to Friday
- Weekends off!
- All benefits by law
- Altia SmartCity
- Discounts to Gym, Restaurants, and Stores
- Office / Hybrid opportunities
- Meal subsidy (80 LPS) and transportation
- Private health, life, and dental insurance
- PriceSmart, Prescription Glasses, Birthday benefits and more
- Wellness events, activities, and soccer team
- Compensation days
- Career growth opportunities
- Monthly employee engagement events
- Sponsored lunch, snacks, and coffee events
- Professional Training & Development opportunities
Additional information:
- Please, submit your CV in English.
- Employment Type: Full-time.
- Schedule Monday to Friday 8AM to 6PM CT
- After six months eligible for hybrid work based on meeting performance expectations.
- At Zventus, employee benefits vary by team, job activity and individual performance. Please refer to specific details during the interview process.
Job Qualifications/Requirements
- Bachelor's degree in Computer Science, or IT related field, or equivalent work experience.
- 3+ years of related experience.
- Experience working with Microsoft SQL Server (2012+ ).
- Solid coding techniques to develop complex views, stored procedures and functions using T-SQL.
- Experience importing data from text file formats, linked server connections, APIs and web services.
- Experience creating mapping document/s between source and target data structures.
- Excellent knowledge of data transformations of all types including calling custom scripts, applying complex logic etc.
- Solid knowledge of database design to produce sound logical and physical data models.
- Ability to understand and analyze system interdependencies, data structures, and data models.
- Experience with varied forms of data design, such as online transaction processing, online analytical processing, data warehousing, operational data stores, and decision support systems.
- Knowledge of one or more database management systems to install, upgrade, configure, design, develop, implement, secure, tune, monitor and maintain required database objects.
- Experience in troubleshooting all types of ETL issues.
- Ability to write custom scripts using shell scripts such as PowerShell.
- Good verbal and written communication skills are a must.
- Analytical and problem management skills and the ability to resolve complex data issues.
- Ability to immediately adapt to changing requirements and conditions.
- Ability to work in fast paced environment essential.
- Familiarity with real estate concepts a plus.
Job Type: Full-time
Language:
Location:
- Ensenada, B.C. (Required)
Work Location: In person
