Resonaite
3 days ago Be among the first 25 applicants
Get AI-powered advice on this job and more exclusive features.
Our client is looking for a
Database/Warehouse Architect
with expertise in architecting, designing, and developing complex database and data warehouse systems. This role involves working on both on-premise and cloud environments using industry best practices. The ideal candidate will have a deep technical background in SQL Server family products, Cognos TM1, Cognos BI frameworks, Azure data platforms, and ETL functions, and will be responsible for ensuring data integrity and performance optimization in large-scale data systems. Duration: 12 months Location: Hybrid 2d/week NYC Key Responsibilities: Architect, design, and develop end-to-end database and data warehouse systems in both on-premise and cloud environments. Build and maintain complex data warehouse models to ensure data integrity for Cognos TM1 and Cognos BI frameworks and reports. Develop, enhance, and administer ETL functions in support of data warehouse environments using tools such as SQL Server, SSIS, SSAS, SSRS, and custom scripts. Implement and maintain data governance, data modeling, data cleansing, extraction, transformation, and migration processes. Perform data analysis, data integration, and data mapping to ensure seamless data flow across systems. Write complex T-SQL queries, stored procedures, views, and ETL processes to support database re-design and optimization. Collaborate with business users and developers to design and implement data solutions, including BI tools like Cognos, Power BI, or Tableau. Ensure data platform scalability and optimize performance through technical leadership and hands-on development. Act as a mentor to junior database engineers, guiding them on best practices and coding techniques. Troubleshoot, resolve, and optimize data-related issues independently while ensuring alignment with business objectives. Required Qualifications: 12+ years of relevant experience in architecting, designing, and developing databases or data warehouses. Proven experience in building end-to-end data warehouse and analytical systems using SQL Server products, SSIS, SSAS, SSRS, and Power BI. Expertise in writing complex T-SQL queries, stored procedures, views, and ETL processes. Experience with data governance, data management, data migration, and data integration. Excellent communication, presentation, and interpersonal skills with the ability to work across all organizational levels. Experience with Cognos BI, Power BI, or Tableau for reporting and business intelligence. Hands-on expertise with Cognos TM1 and Cognos BI frameworks. Experience with cloud data platforms such as Azure and other PaaS/IaaS offerings. Seniority level
Seniority level Mid-Senior level Employment type
Employment type Contract Job function
Job function Information Technology Industries Government Administration Referrals increase your chances of interviewing at Resonaite by 2x Sign in to set job alerts for “Data Warehouse Architect” roles.
Technical Data Architect at New York, NY / Tampa, FL - Onsite - Fulltime
Azure Cloud Data Architect - Purchase NY, Morristown NJ, Charlotte NC (Hybrid)
Data Warehouse Architect – Port Authority of NY & NJ Project
Azure Cloud Data Architect - Purchase NY, Morristown NJ, Charlotte NC (Hybrid)
Azure Cloud Data Architect - Purchase NY, Morristown NJ, Charlotte NC (Hybrid)
New York, NY $175,000.00-$215,000.00 2 weeks ago Danbury, CT $130,000.00-$150,000.00 1 week ago Central Operations Enterprise Data Architect - NEW YORK, Hybrid
New York, NY $170,000.00-$300,000.00 4 days ago Enterprise Data Architect, Central Operations
New York, NY $142,320.00-$213,480.00 1 week ago New York, NY $176,720.00-$265,080.00 1 week ago Edison, NJ $75,000.00-$165,000.00 5 days ago Jersey City, NJ $142,320.00-$213,480.00 4 days ago New York, NY $180,000.00-$230,000.00 2 weeks ago SAP Cloud Data Solutions Architect (Datasphere)
Edison, NJ $122,000.00-$200,000.00 1 hour ago New York, NY $140,000.00-$160,000.00 6 days ago Jersey City, NJ $131,000.00-$171,000.00 1 month ago Data Solutions Architect – Insurance(P&C) - Hybrid
Jersey City, NJ $124,000.00-$171,000.00 1 month ago Madison, NJ $112,000.00-$145,000.00 2 weeks ago Data Architect with Reinsurance or P&C Insurance Experience - Hybrid
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr
Database/Warehouse Architect
with expertise in architecting, designing, and developing complex database and data warehouse systems. This role involves working on both on-premise and cloud environments using industry best practices. The ideal candidate will have a deep technical background in SQL Server family products, Cognos TM1, Cognos BI frameworks, Azure data platforms, and ETL functions, and will be responsible for ensuring data integrity and performance optimization in large-scale data systems. Duration: 12 months Location: Hybrid 2d/week NYC Key Responsibilities: Architect, design, and develop end-to-end database and data warehouse systems in both on-premise and cloud environments. Build and maintain complex data warehouse models to ensure data integrity for Cognos TM1 and Cognos BI frameworks and reports. Develop, enhance, and administer ETL functions in support of data warehouse environments using tools such as SQL Server, SSIS, SSAS, SSRS, and custom scripts. Implement and maintain data governance, data modeling, data cleansing, extraction, transformation, and migration processes. Perform data analysis, data integration, and data mapping to ensure seamless data flow across systems. Write complex T-SQL queries, stored procedures, views, and ETL processes to support database re-design and optimization. Collaborate with business users and developers to design and implement data solutions, including BI tools like Cognos, Power BI, or Tableau. Ensure data platform scalability and optimize performance through technical leadership and hands-on development. Act as a mentor to junior database engineers, guiding them on best practices and coding techniques. Troubleshoot, resolve, and optimize data-related issues independently while ensuring alignment with business objectives. Required Qualifications: 12+ years of relevant experience in architecting, designing, and developing databases or data warehouses. Proven experience in building end-to-end data warehouse and analytical systems using SQL Server products, SSIS, SSAS, SSRS, and Power BI. Expertise in writing complex T-SQL queries, stored procedures, views, and ETL processes. Experience with data governance, data management, data migration, and data integration. Excellent communication, presentation, and interpersonal skills with the ability to work across all organizational levels. Experience with Cognos BI, Power BI, or Tableau for reporting and business intelligence. Hands-on expertise with Cognos TM1 and Cognos BI frameworks. Experience with cloud data platforms such as Azure and other PaaS/IaaS offerings. Seniority level
Seniority level Mid-Senior level Employment type
Employment type Contract Job function
Job function Information Technology Industries Government Administration Referrals increase your chances of interviewing at Resonaite by 2x Sign in to set job alerts for “Data Warehouse Architect” roles.
Technical Data Architect at New York, NY / Tampa, FL - Onsite - Fulltime
Azure Cloud Data Architect - Purchase NY, Morristown NJ, Charlotte NC (Hybrid)
Data Warehouse Architect – Port Authority of NY & NJ Project
Azure Cloud Data Architect - Purchase NY, Morristown NJ, Charlotte NC (Hybrid)
Azure Cloud Data Architect - Purchase NY, Morristown NJ, Charlotte NC (Hybrid)
New York, NY $175,000.00-$215,000.00 2 weeks ago Danbury, CT $130,000.00-$150,000.00 1 week ago Central Operations Enterprise Data Architect - NEW YORK, Hybrid
New York, NY $170,000.00-$300,000.00 4 days ago Enterprise Data Architect, Central Operations
New York, NY $142,320.00-$213,480.00 1 week ago New York, NY $176,720.00-$265,080.00 1 week ago Edison, NJ $75,000.00-$165,000.00 5 days ago Jersey City, NJ $142,320.00-$213,480.00 4 days ago New York, NY $180,000.00-$230,000.00 2 weeks ago SAP Cloud Data Solutions Architect (Datasphere)
Edison, NJ $122,000.00-$200,000.00 1 hour ago New York, NY $140,000.00-$160,000.00 6 days ago Jersey City, NJ $131,000.00-$171,000.00 1 month ago Data Solutions Architect – Insurance(P&C) - Hybrid
Jersey City, NJ $124,000.00-$171,000.00 1 month ago Madison, NJ $112,000.00-$145,000.00 2 weeks ago Data Architect with Reinsurance or P&C Insurance Experience - Hybrid
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr