SQL Server Developer

<p>We are looking for a skilled SQL Developer with expertise in building and optimizing Views to support data integration efforts from multiple sources, including databases, data warehouses, and data lakes. You will play a critical role in ensuring seamless access to data for analytics and reporting by creating performant, well-organized Views that can be leveraged by downstream users and applications. </p><h3><b>Key Responsibilities </b> </h3><ol><li><b>View Creation and Optimization </b>: Design and develop SQL Views to integrate data from various sources, such as transactional databases, data warehouses, and data lakes. Optimize Views for performance and ensure they meet business requirements. </li><li><b>Data Modeling </b>: Collaborate with data engineers, analysts, and other stakeholders to understand data requirements and structure Views that support business intelligence, analytics, and operational needs. </li><li><b>Data Source Integration </b>: Work with data from multiple sources including relational databases like SQL Server, Oracle, etc., data warehouses, and data lakes (Azure Data Lake). </li><li><b>Query Performance Tuning </b>: Analyze and enhance SQL queries to improve performance, ensuring that Views are efficient, scalable, and align with best practices. </li><li><b>Documentation </b>: Document the structure and logic of Views, including table relationships, transformations, and dependencies, to support maintainability and knowledge sharing. </li><li><b>Data Mapping </b>: Try to establish the source and target data mappings, to ensure the support needed for building Data lineage and to support development of data transformation pipelines. </li><li><b>Data Quality Assurance </b>: Validate data consistency, accuracy, and completeness within Views and troubleshoot issues related to data integrity across sources. </li><li><b>Collaboration </b>: Work closely with data architects, data engineers, ETL developers, BI teams and Business Users to provide data accessibility while adhering to governance and data security policies. </li> </ol><h3><b>Required Qualifications </b> </h3><ol><li><b>Experience </b>: 5+ years as a SQL Developer, Data Engineer, or in a similar role focused on data integration and transformation. </li><li><b>SQL Proficiency </b>: Advanced knowledge of SQL and proven experience in writing complex queries, stored procedures, and Views. </li><li><b>Data Source Familiarity </b>: Experience working with various data platforms such as SQL Server, Oracle, and Azure Data Lake. </li><li><b>Performance Tuning </b>: Knowledge of query optimization and indexing strategies to enhance View performance. </li><li><b>Data Integration </b>: Familiarity with ETL/ELT processes, data pipelines, and tools for data integration, such as SSIS, ADF etc. </li><li><b>Analytical Skills </b>: Strong analytical and problem-solving skills with attention to detail in data quality and integrity. </li><li><b>Communication </b>: Ability to translate technical requirements into user-friendly, efficient Views and collaborate with cross-functional teams. </li> </ol><h3><b>Preferred Qualifications </b> </h3><ol><li>Familiarity with Databricks </li><li>Familiarity with Azure Cloud Services. </li><li>Knowledge of data governance, security, and compliance principles. </li> </ol> #J-18808-Ljbffr