What are the responsibilities and job description for the Senior SQL Developer position at Gestión Humana LATAM?
The ideal candidate will have extensive experience with SQL Server, Azure Data Factory, and SQL Server Integration Services (SSIS). This position involves designing, developing, and maintaining robust SQL databases, ETL processes, and data integration solutions to meet the business needs of a growing healthcare startup.
Key Responsibilities:
- Design, develop, and maintain SQL databases, ensuring data integrity, performance, and security.
- Create, optimize, and manage complex SQL queries, stored procedures, triggers, and functions.
- Develop and implement ETL processes using Azure Data Factory and SSIS to support data integration and transformation.
- Collaborate with data architects, business analysts, and other stakeholders to gather and understand business requirements.
- Design and implement data models, data warehouses, and data marts to support business intelligence and reporting needs.
- Monitor and troubleshoot database performance, optimizing for efficiency and scalability.
- Ensure data quality and consistency across diverse sources and destinations.
- Develop and maintain technical documentation related to databases and ETL processes.
- Provide technical support and guidance to other team members and stakeholders as needed.
- Stay up-to-date with industry trends and best practices in database development, ETL, and data integration.
Qualifications:
- Bachelor's degree in Computer Science, Information Technology, or related field.
- Must have a green card (Required)
- Minimum of 5 years of experience in SQL development, database design, and data integration.
- Proven experience with Azure Data Factory and SSIS.
- Strong knowledge of SQL Server, including T-SQL programming and performance tuning.
- Experience with data modeling, data warehousing, and data marts.
- Familiarity with cloud-based data solutions, particularly within the Azure ecosystem.
- Excellent analytical and problem-solving skills.
- Strong communication and collaboration skills, with the ability to work effectively in a remote team environment.
- Self-motivated with a strong sense of ownership and responsibility.
Preferred Qualifications:
- Experience with other ETL tools and technologies.
- Knowledge of data governance and data quality best practices.
- Experience with Agile development methodologies.
- Relevant certifications in SQL Server, Azure, or related technologies.