Data Warehouse Architect

Syracuse, NY 13209

Posted: 04/27/25 Employment Type: Direct Hire Job Category: IT - Data Analyst Job Number: 6910 Pay Rate: 120,000

Job Description

Please no 3rd parties or C2C.
Must be a US Permanent Resident or Citizen.
We are unable to sponsor currently.

Job Title: Data Warehouse Architect
Location: Syracuse, NY – Hybrid
Job Type: Full-time, direct hire
Salary Range: $120,000 - $140,000 annually depending on experience

About the Role:
Join a growing technology team as a Data Warehouse Architect in a strategic and high-impact role. This position offers the opportunity to design and lead the development of a scalable data warehouse solution from the ground up. Reporting to the Director of Software Engineering, you will work cross-functionally to consolidate data from multiple systems into a centralized platform that empowers data-driven decision-making and enables self-service analytics.

Key Responsibilities:
  • Stakeholder Collaboration: Partner with business leaders to translate strategic objectives into technical data requirements.
  • Architectural Design: Develop robust architecture integrating data from relational databases and legacy systems.
  • Metadata and Data Labeling: Create standardized data labeling systems and maintain metadata repositories.
  • ETL and Integration: Lead the design and implementation of ETL processes for accurate, timely data flow.
  • Data Modeling: Design logical and physical data models, including data cubes, for efficient querying and analytics.
  • Data Governance: Define and enforce data quality standards and governance policies.
  • Enable Business Intelligence: Support BI tools deployment to promote self-service analytics and reporting.
  • Cross-Functional Collaboration: Align data strategies with business goals across departments.
  • Technical Leadership: Mentor teams and share best practices to strengthen data architecture capabilities.

Qualifications:
Education:
  • Bachelor’s degree in Computer Science, Information Systems, or equivalent experience.
Experience:
  • 7+ years in data architecture, data modeling, and data warehouse development.
  • Proven experience with enterprise-scale data warehousing.
  • Hands-on experience with ETL processes and tools.
  • Experience with IBM iSeries (DB2), Microsoft SQL Server, and data integration from diverse sources.
Technical Skills:
  • Expertise in logical/physical data modeling.
  • Proficiency in metadata management and standardized data labeling.
  • Strong knowledge of data governance and quality assurance.
  • Experience with BI tools such as Power BI, Tableau, or Cognos.
  • Understanding of time-series and temporal data management.
Certifications:
  • Professional certifications in data management, warehousing, or analytics are a plus.
Soft Skills:
  • Excellent communication and problem-solving abilities.
  • Collaborative and proactive team player.
  • Self-driven and innovative.

Preferred Qualifications:
  • Experience in distribution or supply chain industries.
  • Familiarity with RPG programming (preferred but not required).
  • Experience with cloud-based warehousing platforms (e.g., AWS Redshift, Azure Synapse).
  • Exposure to big data frameworks (e.g., Hadoop, Spark).

Why Join Us?
Be a part of a forward-thinking team where your expertise will directly shape how data empowers business success. You'll have the opportunity to architect innovative solutions, work with modern technologies, and influence strategic decisions that drive growth and efficiency across the organization.

ISSI Technology Professionals celebrates diversity. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status.
Please no 3rd parties or C2C.
Must be a US Permanent Resident or Citizen.
We are unable to sponsor currently.

Job Title: Data Warehouse Architect
Location: Syracuse, NY – Hybrid
Job Type: Full-time, direct hire
Salary Range: $120,000 - $140,000 annually depending on experience

About the Role:
Join a growing technology team as a Data Warehouse Architect in a strategic and high-impact role. This position offers the opportunity to design and lead the development of a scalable data warehouse solution from the ground up. Reporting to the Director of Software Engineering, you will work cross-functionally to consolidate data from multiple systems into a centralized platform that empowers data-driven decision-making and enables self-service analytics.

Key Responsibilities:
  • Stakeholder Collaboration: Partner with business leaders to translate strategic objectives into technical data requirements.
  • Architectural Design: Develop robust architecture integrating data from relational databases and legacy systems.
  • Metadata and Data Labeling: Create standardized data labeling systems and maintain metadata repositories.
  • ETL and Integration: Lead the design and implementation of ETL processes for accurate, timely data flow.
  • Data Modeling: Design logical and physical data models, including data cubes, for efficient querying and analytics.
  • Data Governance: Define and enforce data quality standards and governance policies.
  • Enable Business Intelligence: Support BI tools deployment to promote self-service analytics and reporting.
  • Cross-Functional Collaboration: Align data strategies with business goals across departments.
  • Technical Leadership: Mentor teams and share best practices to strengthen data architecture capabilities.

Qualifications:
Education:
  • Bachelor’s degree in Computer Science, Information Systems, or equivalent experience.
Experience:
  • 7+ years in data architecture, data modeling, and data warehouse development.
  • Proven experience with enterprise-scale data warehousing.
  • Hands-on experience with ETL processes and tools.
  • Experience with IBM iSeries (DB2), Microsoft SQL Server, and data integration from diverse sources.
Technical Skills:
  • Expertise in logical/physical data modeling.
  • Proficiency in metadata management and standardized data labeling.
  • Strong knowledge of data governance and quality assurance.
  • Experience with BI tools such as Power BI, Tableau, or Cognos.
  • Understanding of time-series and temporal data management.
Certifications:
  • Professional certifications in data management, warehousing, or analytics are a plus.
Soft Skills:
  • Excellent communication and problem-solving abilities.
  • Collaborative and proactive team player.
  • Self-driven and innovative.

Preferred Qualifications:
  • Experience in distribution or supply chain industries.
  • Familiarity with RPG programming (preferred but not required).
  • Experience with cloud-based warehousing platforms (e.g., AWS Redshift, Azure Synapse).
  • Exposure to big data frameworks (e.g., Hadoop, Spark).

Why Join Us?
Be a part of a forward-thinking team where your expertise will directly shape how data empowers business success. You'll have the opportunity to architect innovative solutions, work with modern technologies, and influence strategic decisions that drive growth and efficiency across the organization.

ISSI Technology Professionals celebrates diversity. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status.
 

Meet Your Recruiter

John Berardi
Recruiter

John joined ISSI in 2014. He is a graduate of Le Moyne College with a Bachelor's degree in Business Administration. John has 8 years of experience in telecommunications and IT services with his most recent role being Senior Account Executive. John brings extensive IT knowledge in network and infrastructure to ISSI and specializes in recruiting professionals in those disciplines, as well as IT Security Professionals.

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.

About Syracuse, NY

Discover your next career opportunity in the vibrant city of Syracuse, New York! Nestled in the heart of Upstate New York, Syracuse offers a perfect blend of bustling city life and scenic beauty. Known for its rich history, diverse culture, and thriving job market, Syracuse presents a myriad of growth possibilities for job seekers. From the renowned Syracuse University campus to the picturesque Onondaga Lake Park, this area boasts landmarks like the historic Erie Canal Museum and exciting events at the Syracuse Stage theater. Indulge in local delicacies like salt potatoes and half-moon cookies while experiencing the lively arts scene at the Everson Museum of Art. Explore our job listings today and take a step towards a fulfilling career in this captivating region!