What are the responsibilities and job description for the Cloud Data Engineer - Azure, SQL Server position at System One?
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
System One, and its subsidiaries including Joulé, ALTA IT Services, CM Access, TPGS, and MOUNTAIN, LTD., are leaders in delivering workforce solutions and integrated services across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible full-time employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.
System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.
Salary : $120,000
