Azure Database Developer

We are looking for

• Collaborate with internal customers, prospects, and stakeholders, understand, and translates business use cases and/or requirements into data analysis and data mapping and consequently data integration routines which involves moving, cleansing, and transforming a large amount of data between multiple systems.
• Identifies data sources, provides data flow diagrams, and documents sources to target mapping and process.
• Collaborate with the Data Architect to recommend optimal data models for data ingestion and BI developer for analytic reports.
• Provide technical enablement to team members developing database applications on a cloud platform.
• Facilitate the development of data integration efforts by leading small teams of 1-2 junior developers in addition to Knowledge of ETL Design Patterns, Error Handling and Configurations.
• Design, implement, and maintain database objects (tables, views, indexes, etc.) and database security.
• Collaborate with data stewards, data owners, and domain experts to recognize and help adopt best practices in reporting and analysis: data integrity, test design, validation, and documentation.
• Maintain the data warehouse performance by optimizing batch processing through parallelization, performance tuning etc.
• Work with the Data Architect to establish processes for governing the identification, collection, and use of educational metadata to assure metadata is accurate and valid in the business intelligence environments.
• Ensure data quality through the creation of audit controls, proactive monitoring, and data cleansing techniques.
• Troubleshoot performance and reliability issues and investigate anomalous behavior in the Azure environment.
• Responsible for scheduled data processes integrity checks, performing deployments, and coordinating for releases.
• Experience with Source Version Control software like GitHub and CICD pipelines
• Provide on-call support after hours as and when needed.

• 7+ years of experience in Data Warehousing and Business Intelligence.
• 5+ Years in BI development leveraging the Microsoft SQL Server.
• Needs to be an expert in T-SQL.
• 5+ Years in SSIS and use of Stored Procedures.
• 1-2 Years in Azure Data Factory, SQL VMs, building and maintaining ETL.
• Ingest and aggregate data from both internal and external data sources to build our data lake.
• Strong understanding of data modeling (i.e., conceptual, logical, and physical model design, experience with Operation Data Stores, Enterprise Data warehouses and Data Marts).
• Deep understanding of relational database design concepts and SQL programming.
• Experience guiding/mentoring developers with lesser experience.
• Requires strong analytical, conceptual, and problem-solving abilities.
• Strong experience with business intelligence and data warehousing design principles and industry best practices.

• 1-2 Years in Azure Data Warehouse (Synapse).
• 1-2 Years of knowledge of utilizing Python, PySpark, and SparkSQL On Azure Cloud.

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