Business Intelligence Developer
October 16, 2024Microsoft Power Platform Architect
October 16, 2024Experience / Qualifications
- Minimum 12 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 in Data platforms development using Azure SQL database, Azure Data Factory, Azure Storage, Azure Pipelines, Azure IaaS/PaaS related to database.
- Expert level understanding on Azure Data Factory, Azure Synapse, Azure SQL, Azure Data Lake, and Azure App Service is required.
- 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 in Azure Databricks, Azure IoT, Azure HDInsight + Spark, Azure Stream Analytics, Power BI is desirable.
- Knowledge of Microsoft BI Stack (SSRS/SSAS (Tabular with DAX & OLAP with MDX) SSIS) is desirable.
- Knowledge of C# and Hands-on with PowerShell scripting is desirable.
- Working knowledge of Python is desirable.
- Experience developing security models.
Education
- Bachelor’s degree in computer science/engineering or related fields.
Work Location
- Hybrid work at 2 Montgomery Street Jersey City, NJ 07302