Diverse Lynx
SQL Developer
Diverse Lynx, Raleigh, North Carolina, United States, 27601
Position : SQL Developer
Location : Raleigh, NC (Onsite)
Job Description :
Position Overview
-
We are seeking a skilled SQL and ETL Developer to join our dynamic team.
The ideal candidate will be responsible for developing, implementing, and optimizing data processes and workflows to ensure the smooth operation of our data infrastructure.
This role requires a strong understanding of SQL, ETL tools, and data warehousing concepts.
Responsibilities
Data Integration and ETL Development:- Design, develop, and maintain ETL processes to extract, transform, and load data from various sources into data warehouses and other storage solutions. - Ensure data integrity and quality through thorough testing and validation.
SQL Development:- Write complex SQL queries to retrieve, manipulate, and analyze data from relational databases. - Optimize SQL queries for performance and efficiency.
Data Warehousing:- Design and implement data models and schemas to support business intelligence and analytics needs. - Manage and maintain data warehouse solutions, ensuring data consistency and availability.
Performance Tuning:- Monitor and optimize the performance of ETL processes and SQL queries. - Identify and resolve performance bottlenecks and issues.
Collaboration and Communication:- Work closely with business analysts, data scientists, and other stakeholders to understand data requirements and deliver solutions. - Provide support and troubleshooting for data-related issues and queries.
Documentation and Best Practices:- Document ETL processes, data flows, and database designs. - Adhere to industry best practices and standards for data management and security.
Technical Skills :
SQL Server, SSIS, and SSRS
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.
Location : Raleigh, NC (Onsite)
Job Description :
Position Overview
-
We are seeking a skilled SQL and ETL Developer to join our dynamic team.
The ideal candidate will be responsible for developing, implementing, and optimizing data processes and workflows to ensure the smooth operation of our data infrastructure.
This role requires a strong understanding of SQL, ETL tools, and data warehousing concepts.
Responsibilities
Data Integration and ETL Development:- Design, develop, and maintain ETL processes to extract, transform, and load data from various sources into data warehouses and other storage solutions. - Ensure data integrity and quality through thorough testing and validation.
SQL Development:- Write complex SQL queries to retrieve, manipulate, and analyze data from relational databases. - Optimize SQL queries for performance and efficiency.
Data Warehousing:- Design and implement data models and schemas to support business intelligence and analytics needs. - Manage and maintain data warehouse solutions, ensuring data consistency and availability.
Performance Tuning:- Monitor and optimize the performance of ETL processes and SQL queries. - Identify and resolve performance bottlenecks and issues.
Collaboration and Communication:- Work closely with business analysts, data scientists, and other stakeholders to understand data requirements and deliver solutions. - Provide support and troubleshooting for data-related issues and queries.
Documentation and Best Practices:- Document ETL processes, data flows, and database designs. - Adhere to industry best practices and standards for data management and security.
Technical Skills :
SQL Server, SSIS, and SSRS
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.