Senior Azure Platform Developer

03 Dec 2024

Vacancy expired!

Performance Tuning of Stored Procedures in Synapse/Azure Data WarehouseEvaluation of stored procedure logic, table distributions, etc.Update Azure Data Factory (ADF) pipelines to allow for automated deploymentsUtilize Azure DevOps and GitDevelop control structures (tables, stored procedures, etc.) to determine whether to execute or notAdd control mechanisms to ADF to control flowUpdate ADF pipeline execution and Synapse resource classes to make better use of available resourcesEvaluation of how resource classes are assigned, the order in which stored procedures are called, update to use new resource class allocation structuresExpertise in configuring Octopus deploymentsAbility to configure, manage, and own responsibilities to do it for team/organization

Job description

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 large amount of data between multiple systems.Identifies data sources, provides data flow diagrams and documents source to target mapping and process.Collaborate with the Data and Solution Architects to recommend optimal data models for data ingestion and BI developer for analytic reportsDesign and development of large and complex ETL jobs including error handling and disaster recovery.Design, implement and maintain database objects (tables, views, indexes, stored procedures, etc.) and database security.Validate data integration routines by developing and executing test plans and scenarios including data design, tool design, data extract/transform, networks, and hardware.

Maintain the data warehouse performance by optimizing batch processing through parallelization, performance tuning etc. Work with the Solution Architect to establish processes for governing the identification, collection, and use of corporate 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 techniquesBuild Octopus configurations to successfully deploy database objects to environmentsCreate logging and control structures to monitor and direct batch activitiesWill be on-call once a month during evenings and weekends also. The on-call is once a week and typically averages one call a month for the candidate.Requirements:10+ years of experience in Data Warehousing and Business Intelligence5+ Years in BI development leveraging the Microsoft SQL Server. Needs to be an expert in T-SQL3+ Years of working in a parallel data warehouse environment such as APS/PDW, Azure Synapse, or ADW.5+ Years in SSIS and use of Stored Procedures.2 Years in Azure Data Warehouse (Synapse), usage of Log Analytics, Azure Data Factory, SQL VMs, workload managementStrong 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 programmingStrong experience with performance tuning options in an MPP environment and SQL Server environmentExposure to Change Data Capture methodologies, custom and packagedExperience with Azure DevOps and configuring Release PipelinesRequires strong analytical, conceptual and problem-solving abilities

.Strong experience with business intelligence and data warehousing design principles and industry best practices.Bachelor’s degree – preference in computer/information sciences or business/commerce.Work Traits:Strong communications skills - oral and writtenSelf-starter with strong work ethic Flexible and resilient, handle various demands planned and unplanned Proven ability to handle multiple tasks and projects simultaneously.Problem solver and desire to close issues, pragmatic and realistic with solutions Professional demeanor, working with senior level managers and vendors Ability to work independently under minimal supervision and meet deadlines.Strong sense of accountability, adaptability, flexibility and a sense of urgency.Demonstrated ability to establish priorities, organize and plan work to satisfy established timeframes.Passionate about continuously improving organizational practices.Ability to learn and apply new technologies quickly and self-directed.Ability to prioritize and multi-task across numerous work streams