Job Description
About the Role:
We are seeking an experienced SQL/ETL Production Support Analyst with 5 years of hands-on experience with SSIS, SQL Server, and T-SQL.
Requirements
- Strong understanding of relational database concepts and data modeling.
- Experience with SQL query optimization and performance tuning.
- Familiarity with data warehousing concepts and data integration techniques.
- Proficiency in writing and debugging complex SQL queries and stored procedures.
- Experience working with large datasets and data migration projects.
- Excellent problem-solving skills and attention to detail.
- Ability to work independently and in a team-oriented environment.
Responsibilities
- Design, develop, and deploy SSIS packages to extract, transform, and load (ETL) data from various sources into target databases.
- Write complex SQL queries, stored procedures, views, and functions to support application development and reporting requirements.
- Optimize existing SQL queries for performance improvements and troubleshoot any data-related issues.
- Collaborate with business analysts and other developers to understand data needs and deliver appropriate solutions.
- Perform data analysis to identify trends, discrepancies, and areas for improvement.
- Maintain documentation of database designs, ETL processes, and data models.
- Implement best practices for database design, development, and maintenance.
- Ensure data quality, integrity, and security across all databases and ETL processes.
- Participate in code reviews and provide constructive feedback to other developers.
- Assist in the design and development of data warehouses and data marts.
- Monitor and maintain data integration processes to ensure consistent and reliable data flow.
- Provide production support for data-related issues and troubleshoot as necessary.
