Blog

About the Role

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.

Key Responsibilities

• View Creation and Optimization: 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.
• Data Modeling: Collaborate with data engineers, analysts, and other stakeholders to understand data requirements and structure Views that support business intelligence, analytics, and operational needs.
• Data Source Integration: Work with data from multiple sources including relational databases like SQL Server, Oracle, etc., data warehouses, and data lakes (Azure Data Lake).
• Query Performance Tuning: Analyze and enhance SQL queries to improve performance, ensuring that Views are efficient, scalable, and align with best practices.
• Documentation: Document the structure and logic of Views, including table relationships, transformations, and dependencies, to support maintainability and knowledge sharing.
• Data Mapping: 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.
• Data Quality Assurance: Validate data consistency, accuracy, and completeness within Views and troubleshoot issues related to data integrity across sources.
• Collaboration: 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.

Required Qualifications

• Experience: 5+ years as a SQL Developer, Data Engineer, or in a similar role focused on data integration and transformation.
• SQL Proficiency: Advanced knowledge of SQL and proven experience in writing complex queries, stored procedures, and Views.
• Data Source Familiarity: Experience working with various data platforms such as SQL Server, Oracle, and Azure Data Lake.
• Performance Tuning: Knowledge of query optimization and indexing strategies to enhance View performance.
• Data Integration: Familiarity with ETL/ELT processes, data pipelines, and tools for data integration, such as SSIS, ADF etc.
• Analytical Skills: Strong analytical and problem-solving skills with attention to detail in data quality and integrity.
• Communication: Ability to translate technical requirements into user-friendly, efficient Views and collaborate with cross-functional teams.

Preferred Qualifications

• Familiarity with Databricks
• Familiarity with Azure Cloud Services.
• Knowledge of data governance, security, and compliance principles.