> Markdown version of [/jobs/ext/1507255-data-warehouse-integrations-architect](https://www.wearedevelopers.com/jobs/ext/1507255-data-warehouse-integrations-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Warehouse & Integrations Architect - **Company:** Crayola Llc - **Location:** Easton, PA, United States - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Unit Testing, Information Systems, Data Architecture, Data Validation, Information Engineering, Data Integration, Data Integrity, Extract Transform Load (ETL), Data Warehousing, Microsoft Office, Power BI, SAP (Applications), Systems Integration, Enterprise Software Applications, Snowflake, Semi-structured Data, Information Technology, Enterprise Integration, Integration Frameworks, Data Delivery, Api Design, Data Pipelines, Api Management - **Published:** July 30, 2026 - **Apply:** https://diversityjobs.com/main/sendform/8/8/28176/1/17756321?backUrl=%2Fcareer%2F17756321%2FData-Warehouse-Integrations-Architect-Pennsylvania-Easton ## About the Role * Bachelor's degree in Computer Science, Information Systems, Engineering, or Business Administration, OR 5+ years of relevant professional experience relevant to the requirements below. * Minimum 3 years of experience in data engineering, ETL/ELT development, or data warehousing * Experience with integration platforms and tooling, including API integrations, platform integrations, and tools such as Informatica ICDM or comparable solutions. Experience with Snowflake a strongly preferred. Experience with MS Fabric Lakehouse a plus. * Understanding of source systems and enterprise applications, including but not limited to SAP, and the associated extraction and integration considerations. * Comprehensive working knowledge of BI and analytics delivery tools; Power BI experience is required. * Familiarity with Lakehouse concepts and architectures is beneficial. * Strong business partnership, communication, facilitation, and presentation skills, with the ability to translate technical topics into user-friendly language. * Strong analytical, problem-solving, organizational, and prioritization skills, with the ability to lead multiple simultaneous efforts in a high-pressure environment. * Strong customer service orientation and the ability to collaborate effectively with internal and external stakeholders. * Proficiency with Microsoft Office Suite. * Must have excellent problem solving and analytical skills. * High initiative and ability to prioritize in a high-pressure environment. * Must be able to work on simultaneous projects. ## Description Experienced technical resource responsible for supporting the development, execution, and maintenance of enterprise data warehouse and integration solutions. This role works within established ELT frameworks, integration patterns, and data architecture standards defined by leadership to ensure reliable and scalable data movement and transformation. The position contributes to global data delivery by supporting ingestion, transformation, and validation of structured and semi-structured data across enterprise platforms. The role focuses on execution, operational support, and continuous improvement of data pipelines while developing foundational expertise in data engineering and enterprise data ecosystems., Develop and maintain ELT pipelines using established frameworks to support ingestion, transformation, and loading of enterprise data * Execute data integration processes across platforms, including API-based, file-based, and system-to-system data movement patterns * Support the ongoing operation of the global data warehouse environment by monitoring data pipelines, identifying failures, and resolving routine issues * Perform data validation and reconciliation activities to ensure data accuracy, completeness, and consistency across staging, warehouse, and downstream systems * Assist in implementing transformation logic aligned with defined dimensional models, schemas, and enterprise data structures * Contribute to documentation of data pipelines, integration flows, and transformation logic to support knowledge transfer and operational resiliency * Participate in testing activities including unit testing, regression validation, and support for release and deployment processes * Support modernization and migration efforts by assisting in transitioning legacy integration processes to standardized ELT and cloud-based frameworks * Collaborate with senior engineers and leadership to apply established standards related to metadata, naming conventions, error handling, and data quality controls * Escalate issues related to data integrity, system dependencies, or performance that impact global data availability or reliability, Search firms are essential to the recruitment and staffing efforts at Crayola LLC, and we value the partnerships we have built with our vendors. For this reason, Crayola LLC has established and regularly maintains a preferred vendor list. Please note that even preferred vendors need to have a written search agreement signed by Human Resources at Crayola LLC in place for the specific position in order for a fee to be paid for any candidate referrals. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [API Design - Getting Started](https://www.wearedevelopers.com/videos/33-api-design-getting-started) - [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [The 12 Best Jobs for Software Engineers](https://www.wearedevelopers.com/magazine/401-the-12-best-jobs-for-software-engineers) - [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs)