Reporting platform SQL Developer

Job Description

You will be responsible for the following tasks in the role:- **Database Development**: - Design and develop SQL scripts, stored procedures, functions, and triggers for data extraction, transformation, and loading (ETL) processes. - Collaborate with cross-functional teams to analyze and understand data requirements, and translate them into effective database structures and queries.- **Business Intelligence (BI) Tools**: - Utilize PowerBI and Tableau to understand the requirements for business users. - Collaborate with stakeholders to understand their reporting needs, and develop solutions that provide meaningful insights.- **Data Integration**: - Work with external data sources, APIs, and data connectors to import and integrate data from various systems into our SQL Server databases. - Ensure data accuracy and consistency across different data sources.- **Performance Optimization**: - Identify and resolve performance bottlenecks in SQL queries and database operations. - Optimize database schemas, query performance, and indexing strategies to improve overall system performance.- **Data Security and Compliance**: - Implement and enforce data security best practices to protect sensitive information. - Ensure compliance with relevant data protection regulations, such as GDPR or HIPAA.- **Documentation and Training**: - Create and maintain technical documentation, including data models, schema diagrams, and ETL workflows. - Train and support end-users on how to effectively use PowerBI and Tableau for data analysis and reporting.**Qualifications Required**:- Bachelors degree in Computer Science, Information Systems, or a related field.- Proven experience as a SQL Server Specialist, with in-depth knowledge of SQL Server administration, database design, and performance tuning.- 6 years of relevant experience in SQL Based systems.- Solid understanding of data warehousing concepts, ETL processes, and data integration techniques.- Strong SQL scripting and query optimization skills.- Familiarity with data modeling and database design principles.- Experience with data visualization best practices and storytelling techniques.- Excellent problem-solving and analytical skills.- Strong attention to detail and ability to prioritize and manage multiple tasks.*Note: The job posting may come down early due to the volume of applicants.* You will be responsible for the following tasks in the role:- **Database Development**: - Design and develop SQL scripts, stored procedures, functions, and triggers for data extraction, transformation, and loading (ETL) processes. - Collaborate with cross-functional teams to analyze and understand data requirements, and translate them into effective database structures and queries.- **Business Intelligence (BI) Tools**: - Utilize PowerBI and Tableau to understand the requirements for business users. - Collaborate with stakeholders to understand their reporting needs, and develop solutions that provide meaningful insights.- **Data Integration**: - Work with external data sources, APIs, and data connectors to import and integrate data from various systems into our SQL Server databases. - Ensure data accuracy and consistency across different data sources.- **Performance Optimization**: - Identify and resolve performance bottlenecks in SQL queries and database operations. - Optimize database schemas, query performance, and indexing strategies to improve overall system performance.- **Data Security and Compliance**: - Implement and enforce data security best practices to protect sensitive information. - Ensure compliance with relevant data protection regulations, such as GDPR or HIPAA.- **Documentation and Training**: - Create and maintain technical documentation, including data models, schema diagrams, and ETL workflows. - Train and support end-users on how to effectively use PowerBI and Tableau for data analysis and reporting.**Qualifications Required**:- Bachelors degree in Computer Science, Information Systems, or a related field.- Proven experience as a SQL Server Specialist, with in-depth knowledge of SQL Server administration, database design, and performance tuning.- 6 years of relevant experience in SQL Based systems.- Solid understanding of data warehousing concepts, ETL processes, and data integration techniques.- Strong SQL scripting and query optimization skills.- Familiarity with data modeling and database design principles.- Experience with data visualization best practices and storytelling techniques.- Excellent problem-solving and analytical skills.- Strong attention to detail and ability to prioritize and manage multiple tasks.*Note: The job posting may come down early due to the volume of applicants.*

Keyskills :
SQLDatabase DevelopmentTableauData IntegrationPerformance OptimizationData SecurityComplianceDocumentationTrainingData WarehousingData ModelingData VisualizationAnalytical SkillsETL processesBusiness Intelligence BI ToolsPowerBI