Synergistic Systems, LLC
Azure Synapse Developer Remote
Synergistic Systems, LLC, New York, New York, us, 10261
Our client, a prominent NY public sector organization, is seeking an Azure Synapse Developer for a FULLY REMOTE contract position. This is a short term contract assignment (3 months) that can be extended. You can onboard as our W2 employee or independent contractor. This is an excellent opportunity to join a project with a critical impact on vertical transportation data and reporting, using cutting-edge Microsoft Azure data technologies and Power Platform!
The successful candidate will support the backend data and reporting for Chief Operating Office on Vertical transportation using Microsoft Azure data technologies and Power Platform. The successful candidate may work independently as well as with both consultant and staff resources of different Units and Departments throughout the Agency under the direction of project manager to deliver work products including but not limited to:
JOB RESPONSIBILITIES:
Designing Synapse tables and implementing data solutions within the Azure ecosystem.
Design, develop and implement Synapse tables to support data ingestion, transformation and storage processes.
Utilize Spark Scala / SQL to build scalable and efficient data pipelines within Azure Synapse.
Design and develop Power BI dashboards by understanding user requirements.
Optimize data storage, ensuring high performance and reliability in Synapse environment.
Provide expertise in troubleshooting and resolving data related issues within Azure Synapse.
Collaborate with cross-functional teams to understand data requirements and translate them into technical solutions.
Strong understanding of data modelling concepts and database design principles within Synapse.
Ability to optimize and tune Synapse tables for performance and scalability.
Excellent communication skills and the ability to work collaboratively in a team environment.
MINIMUM EXPERIENCE AND QUALIFICATIONS:
Minimum 10 years of relevant experience in architecting, design, and development of data warehouse systems (SQL Server based on Cloud/on premise and Analytics) at enterprise scale.
Experience in building end to end data warehouse and analytical systems using SQL Server family of products, Analysis Services Power BI, etc.
Experience with Azure Data Services, such as Azure Data Factory, Azure Databricks, Azure Synapse Analytics, and Azure Data Lake Storage.
Proficient in Python and SQL.
Proficiency in Spark Scala/SQL for data processing and transformation.
Designing and building of data pipelines using API ingestion and Streaming ingestion methods.
Knowledge of Dev-Ops processes (including CI/CD) and Infrastructure as code is essential.
Experience in developing NO SQL solutions using Azure Cosmos DB is essential.
Thorough understanding of Azure and AWS Cloud Infrastructure offerings.
Strong experience in common data warehouse modelling principles including Kimball, Inmon.
Knowledge of Microsoft BI Stack (SSRS/SSAS (Tabular with DAX & OLAP with MDX) SSIS) is desirable.
Bachelor’s degree in information technology, computer science or business administration required.
This is a remote position.
The successful candidate will support the backend data and reporting for Chief Operating Office on Vertical transportation using Microsoft Azure data technologies and Power Platform. The successful candidate may work independently as well as with both consultant and staff resources of different Units and Departments throughout the Agency under the direction of project manager to deliver work products including but not limited to:
JOB RESPONSIBILITIES:
Designing Synapse tables and implementing data solutions within the Azure ecosystem.
Design, develop and implement Synapse tables to support data ingestion, transformation and storage processes.
Utilize Spark Scala / SQL to build scalable and efficient data pipelines within Azure Synapse.
Design and develop Power BI dashboards by understanding user requirements.
Optimize data storage, ensuring high performance and reliability in Synapse environment.
Provide expertise in troubleshooting and resolving data related issues within Azure Synapse.
Collaborate with cross-functional teams to understand data requirements and translate them into technical solutions.
Strong understanding of data modelling concepts and database design principles within Synapse.
Ability to optimize and tune Synapse tables for performance and scalability.
Excellent communication skills and the ability to work collaboratively in a team environment.
MINIMUM EXPERIENCE AND QUALIFICATIONS:
Minimum 10 years of relevant experience in architecting, design, and development of data warehouse systems (SQL Server based on Cloud/on premise and Analytics) at enterprise scale.
Experience in building end to end data warehouse and analytical systems using SQL Server family of products, Analysis Services Power BI, etc.
Experience with Azure Data Services, such as Azure Data Factory, Azure Databricks, Azure Synapse Analytics, and Azure Data Lake Storage.
Proficient in Python and SQL.
Proficiency in Spark Scala/SQL for data processing and transformation.
Designing and building of data pipelines using API ingestion and Streaming ingestion methods.
Knowledge of Dev-Ops processes (including CI/CD) and Infrastructure as code is essential.
Experience in developing NO SQL solutions using Azure Cosmos DB is essential.
Thorough understanding of Azure and AWS Cloud Infrastructure offerings.
Strong experience in common data warehouse modelling principles including Kimball, Inmon.
Knowledge of Microsoft BI Stack (SSRS/SSAS (Tabular with DAX & OLAP with MDX) SSIS) is desirable.
Bachelor’s degree in information technology, computer science or business administration required.
This is a remote position.