Join to apply for the Data Engineer role at Ottomatik.io
Hi there! We are South and our client is looking for a Data Engineer !
Note To Applicants
- Eligibility : This position is open to candidates residing in Latin America.
- Application Language : Please submit your CV in English. Applications submitted in other languages will not be considered.
- Professional Presentation : We encourage you to showcase your professional experience by including a Loom video in the application form. While this is optional, candidates who provide a video presentation will be given priority.
Job Summary
Our client is a US-based B2B manufacturer and distributor specializing in hardware technology for the cannabis industry. They are seeking a motivated and skilled Data Engineer for an initial 6-month contract-to-hire role with the potential to transition into a permanent position based on performance and business needs. As a Data Engineer you’ll design, build, and maintain our SQL Server-based data warehouse in an Azure environment. This role is vital for ensuring our data infrastructure is reliable, performant, and scalable to support our growing business needs. You’ll collaborate closely with stakeholders across the business to transform raw data into clean, well-structured datasets for analytics and reporting.
Key Responsibilities
Design, develop, and maintain ETL pipelines using Azure Data Factory, SQL Server Integration Services (SSIS), and other tools as needed.Build and optimize data models in SQL Server, ensuring performance, scalability, and data integrity.Develop and maintain stored procedures, views, and advanced SQL queries for data transformation and reporting.Automate data workflows and monitor daily data loads, troubleshooting and resolving issues proactively.Support and maintain our Azure environment, including managing Azure Data Factory, Azure Storage, and other relevant resources.Collaborate with business analysts and Power BI developers to ensure that data is clean, well-documented, and accessible for reporting.Leverage Python scripting for custom data processing tasks and automation where necessary.Implement best practices for data governance, data quality, and security.Continuously identify opportunities to improve our data architecture and processes to better serve business needs.Required Qualifications
Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field (or equivalent experience).3+ years of experience in Data Engineering or ETL development roles.Proven experience managing and developing SQL Server databases, including performance tuning and query optimization.Strong expertise in Azure, especially Azure Data Factory, Azure Storage, and related data services.Proficiency with advanced SQL for complex data transformations.Experience using Python for scripting and automation in a data environment.Familiarity with Power BI, including understanding how data models feed into reports and dashboards.Solid understanding of data warehouse concepts, dimensional modeling, and ETL best practices.Excellent problem-solving skills and the ability to work independently in a small, fast-paced environment.Nice to Have
Experience with version control tools (e.g., Git) and CI / CD pipelines for data solutions.Exposure to other Azure data tools (e.g., Azure Synapse Analytics, Databricks).Understanding of data security best practices and compliance standards.Knowledge of business processes relevant to the consumer goods industry.What We Offer
An initial contract position with the potential to transition to a full-time, permanent position.A collaborative, supportive work environment where your ideas have an impact.Opportunities for professional development and learning.Remote work arrangement within US time zones (Pacific Time preferred).Competitive pay commensurate with experience.Work Hours & Remote Work
This is a remote-only, full-time, contract-to-hire position with a typical workload of 40+ hours per week during standard business hours. A consistent Monday-Friday schedule is expected and should align or overlap with US Pacific Time (PT) time zone to ensure smooth collaboration with the rest of our team. While project deadlines may require extra effort, we prioritize a sustainable work-life balance.
Perks : 10 PTO + 7 to 10 US holidays per year
If this opportunity sounds good to you, send us your resume!
Job Details
Seniority level : Mid-Senior levelEmployment type : Full-timeJob function : Engineering and Information TechnologyIndustries : Technology, Information and InternetReferrals increase your chances of interviewing at Ottomatik.io by 2x.
Get notified about new Data Engineer jobs in Santiago, Santiago Metropolitan Region, Chile .
#J-18808-Ljbffr