Azure Databas Developer

Job Summary: The ideal candidate must demonstrate indepth knowledge and understanding of database concepts and be experienced in writing SQL and TSQL. They need to support applications with24/7 availability and have experience handling large volumes of data in Oracle SQL Server and Azure SQL platforms.

Essential Duties and Responsibilities:

• Collaborate with internal customers prospects and stakeholders to understand and translate business use cases and requirements into data analysis and data mapping.
• Develop data integration routines that involve moving cleansing and transforming large amounts of data between multiple systems.
• Identify data sources provide data flow diagrams and document sourcetotarget mapping and processes.
• Work with the Data Architect to recommend optimal data models for data ingestion and collaborate with the BI developer for analytic reports.
• Provide technical enablement to team members developing database applications on a cloud platform.
• Lead small teams of 12 junior developers in data integration efforts utilizing ETL design patterns error handling and configurations.
• Design implement and maintain database objects (tables views indexes etc. and database security.
• Utilize Azure database tools and technologies including Azure Data Studio and Azure Analytics Studioto develop maintain and optimize database applications and solutions1.
• Collaborate with data stewards data owners and domain experts to adopt best practices in reporting and analysis ensuring data integrity test design validation and documentation.
• Optimize batch processing through parallelization and performance tuning to maintain data warehouse performance.
• Establish processes for governing the identification collection and use of educational metadata to ensure accuracy and validity in business intelligence environments.
• Ensure data quality through audit controls proactive monitoring and data cleansing techniques.
• Troubleshoot performance and reliability issues and investigate anomalous behavior in the Azure environment.
• Perform scheduled data process integrity checks deployments and coordinate releases.
• Utilize source version control software like GitHub and CICD pipelines.
• Provide oncall support after hours as needed.

Requirements:

• 7 years of experience in data warehousing and business intelligence.
• 5 years in BI development leveraging Microsoft SQL Server with expertise in TSQL.
• 5 years in SSIS and use of stored procedures.
• 35 years in Azure Data Factory SQL VMs and ETL development.
• Experience in ingesting and aggregating data from internal and external sources to build a data lake.
• Strong understanding of data modeling (conceptual logical and physical model design) and experience with operational data stores enterprise data warehouses and data marts.
• Deep understanding of relational database design concepts and SQL programming.

Experience in guiding and mentoring developers with less experience.

• Strong analytical conceptual and problemsolving abilities.
• Experience with business intelligence and data warehousing design principles and industry best practices.

Good to Have:

• 12 years in Azure Data Warehouse (Synapse).
• 12 years of experience utilizing Python PySpark and SparkSQL on Azure Cloud.

Qualifications:

• Bachelors degree from an accredited college or university with coursework in computer science or management information systems AND 5 years of related experience.

• Skill

Required / Desired

Data Modelling

Required

Data Warehousing and Business Intelligence

Required

Microsoft SQL Server TSQL PL/SQL

Required

SQL Server Integration Services

Required

Azure Data Factory Azure Data Studio Azure Analytics Studio

Required

O Auth2.0 JWT

Required

Python PySpark Spark SQL and Azure Cloud

Required

SQL Procedures. Triggers Functions

Required