Cloud Data Engineer - Azure, SQL Server

CLOUD DATA ENGINEER – AZURE, SQL SERVER Contract to Hire Work Location: Hybrid work in Jersey City, NJ Hourly Rate: $60/hr. W2 for the contract period. Benefits available Annual Salary Range: $120,000 range annually plus benefits. ALTA IT Services has a contract-to-hire opening for a Cloud Data Engineer with at least 12 years of experience architecting, designing, and developing enterprise-scale data warehouse systems using SQL Server on cloud and on-premise platforms. The role will support an IT engineering and consulting company on a large transportation program in Jersey City, NJ. Work is expected to begin in mid-January 2025. Sponsorship is not offered for this position. The ideal candidate will have expertise in Azure data platforms, including Azure SQL, Data Factory, Synapse, Data Lake, and Pipelines, along with strong knowledge of data pipelines, API ingestion, and DevOps processes. Experience with Azure Cosmos DB, cloud infrastructure (Azure/AWS), and data warehouse modeling principles is required. EXPERIENCE / 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 in Jersey City, NJ Hourly Rate: $60/hr. W2 for the contract period. Benefits available Annual Salary Range: $120,000 range annually plus benefits. For consideration, please contact Melissa McNally via mmcnally@altaits.com #M2