Data Engineer (T-SQL & SSIS)
Rosario, Santa Fe Province, Argentina - Remote
OZ
Trusted in Florida for 25+ years, OZ provides Microsoft solutions and expert digital consulting. Drive your business to its next great success with us.A qualified Data Analytics Consultant with substantial experience and a proven track record in the development of comprehensive data integration solutions. The ideal candidate will possess a strong proficiency in SQL, coupled with a solid understanding of various Data Integration techniques, including but not limited to ETL (Extract, Transform, Load), Data Replication, and Data Profiling. These skills are essential to effectively address and support the diverse analytical needs of our business, ensuring that data flows seamlessly across systems and is utilized to its fullest potential.
JOB RESPONSIBILITIES:
The following responsibilities will be integral to your role, ensuring that our data management systems operate efficiently and effectively:
- Develop and maintain SQL code and SSIS packages, ensuring robust and scalable solutions that can handle our ever-evolving data needs. This includes writing efficient SQL scripts for data extraction, transformation, and loading processes, as well as regularly updating and enhancing SSIS packages to improve performance and functionality.
- Analyze data meticulously to address both new and existing business issues. This involves identifying trends, interpreting complex data sets, and collaborating with stakeholders to deliver actionable insights that drive decision-making and foster business growth.
- Review query performance regularly and optimize SQL code as needed. This responsibility entails monitoring execution times, analyzing execution plans, and applying best practices to enhance overall performance, ensuring that queries run efficiently and effectively to support business operations.
- Provide production-level support to ensure the ongoing reliability and availability of data systems. This includes troubleshooting issues, resolving bugs, and implementing fixes promptly to minimize disruptions and maintain service continuity for our internal clients.
- Fully document all processes that are being created to maintain a clear and comprehensive record of the methodologies and practices used. This documentation is essential for promoting knowledge sharing, ensuring compliance with standards, and enabling future enhancements by providing a clear reference for both current and future team members.
Requirements
· +5 years of proven experience in Microsoft (MS) Transact-SQL (T-SQL).
· +2 Analytical - Synthesizes complex or diverse information; Collects and researches data; Uses intuition and
experience to create solutions. Be able to present insights to stakeholders
· Working experience with Microsoft BI Tool Suite (SQL Server, SSIS, SSAS, SSRS)
· Understanding of SQL Server Agent, Integration Services Catalogs, SSISDB Projects and Environments, SSMS, Visual
Studio.
· Proficiency in data modeling, data transformation, and ETL/ELT processes.
· Experience with data warehousing.
· Identify and resolve data quality issues
· Familiarity with data governance best practices and tools.
· Fluent in English.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Data Analytics Data governance Data management Data quality Data Warehousing ELT ETL SQL SSIS T-SQL
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.