Data Warehouse Architect

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.