SQL Server Developer

TechDigital Group; Houston (TX); On-site; USD 80,000 - 110,000; Full time

Job summary

An established industry player is seeking a skilled SQL Developer to enhance data integration efforts. In this pivotal role, you will design and optimize SQL Views, ensuring seamless access to data for analytics and reporting. Collaborating with data engineers and analysts, you will create efficient Views that meet business needs while maintaining data quality and integrity. This position offers a dynamic environment where your expertise in SQL and data platforms will be valued. If you are passionate about data and eager to make a significant impact, this opportunity is perfect for you.

Qualifications

• 5+ years as a SQL Developer or Data Engineer focused on data integration.
• Advanced knowledge of SQL with experience in writing complex queries.

Responsibilities

• Design and develop SQL Views to integrate data from various sources.
• Collaborate with teams to ensure data accessibility and quality.

Skills

SQL Proficiency

Performance Tuning

Analytical Skills

Communication

Tools

SQL Server

Oracle

Azure Data Lake

SSIS

ADF

Databricks

Job description

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

1. 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.
2. 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.
3. 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).
4. Query Performance Tuning: Analyze and enhance SQL queries to improve performance, ensuring that Views are efficient, scalable, and align with best practices.
5. Documentation: Document the structure and logic of Views, including table relationships, transformations, and dependencies, to support maintainability and knowledge sharing.
6. 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.
7. Data Quality Assurance: Validate data consistency, accuracy, and completeness within Views and troubleshoot issues related to data integrity across sources.
8. 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

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

Preferred Qualifications

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