Data/Warehouse Architect

DATA/WAREHOUSE ARCHITECT – SQL SERVER, AZURE, COGNOS ALTA is looking for a Data Warehouse Architect with at least 12 years of experience in designing and developing database and data warehouse systems, both on-premises and in the cloud. 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 should have strong skills in SQL Server and Azure, along with expertise in ETL processes and data governance. Excellent communication skills are essential for collaboration across the organization. EXPERIENCE / QUALIFICATIONS Minimum 12 years of relevant experience in architecting, designing, and developing databases or Datawarehouse systems on-prem as well as in the cloud using industry best practices. Experience in building end-to-end data warehouse and analytical systems using SQL Server family of products, Analysis Services Power BI, etc. Maintain complex Data Warehouse models to ensure data integrity, including the development, enhancement, and administration of appropriate ETL functions in support of Cognos TM1 and Cognos BI frameworks and reports. Experience in Data platform development using Azure SQL database, Azure Data Factory, Azure Storage, Azure Pipelines, and Azure IaaS/PaaS related to databases. Experience in data governance, data management, data modeling, data cleansing, data extraction and transformation, data analysis, data migration, data integration and data mapping. Strong experience using SQL Server Integration Services (SSIS), SSAS, and SSRS for analysis and report generation. Proficient in writing complex T-SQL Queries, Store Procedures, Views, and ETL in re-designing Databases/Data warehouses using SQL server, SSIS, and any custom scripts. Knowledge or working experience with Cognos BI environment or other business Intelligence toolsets such as Power BI or Tableau preferred. Must be hands-on, deeply technical, and exposed to the latest features within data platform development, able to do both coding and guide junior database engineers. Excellent communication, and presentation skills with the ability to interact at all levels of the organization regularly. Ability to act independently to resolve issues, excellent communication and interpersonal skills, strong critical & analytic thinking. 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 to $130,000 annually plus benefits. For consideration, please send an updated resume to Melissa McNally via mmcnallyaltaits.com System One, and its subsidiaries are leaders in delivering outsourced services and workforce solutions 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 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 M2