> Markdown version of [/jobs/ext/1884420-data-architect-corporate-services](https://www.wearedevelopers.com/jobs/ext/1884420-data-architect-corporate-services). 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 Architect, Corporate Services - **Company:** Resourcesoft, Inc. - **Location:** New York, NY, United States - **Experience:** Expert - **Salary:** $100,000.0 - $120,000.0 - **Contract:** Permanent contract - **Skills:** Artificial Intelligence, Amazon Web Services, Automation of Tests, Cloud Computing, Information Technology Consulting, Continuous Integration, Data Architecture, Data Warehousing, Graph Database, Python (Programming Language), Power BI, SQL Databases, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services, Data Ingestion, Snowflake, Change Data Capture, Data Layers, Data Lakes, Data Pipelines - **Published:** August 1, 2026 - **Apply:** https://www.careerjet.com/jobad/usef0e38a0afcf3cb3f16e020a5d69ec60 ## About the Role 10+ years of professional experience in enterprise data architecture and high-scale Snowflake implementations. Proficiency in dbt for engineering complex transformation frameworks and defining unified semantic layers. Experience with AWS cloud infrastructure, specifically architecting data lakes and presentation layers. Experience with Fivetran for data ingestion, Change Data Capture (CDC), and schema drift management. Experience in migrating legacy Microsoft BI stacks (SSIS, SSRS, and SSAS) to modern cloud architectures. Experience with Python and SQL for building production-grade data products and automation scripts. Excellent verbal and written communication skills for directing cross-functional teams and executive stakeholders. ## Description Architect the end-to-end Corporate Finance Data Warehouse utilizing Snowflake, dbt, and AWS. Orchestrate data ingestion pipelines with Fivetran to integrate diverse financial source systems. Lead the comprehensive migration and retirement of legacy SSIS, SSRS, and SSAS reporting environments. Build a governed semantic layer in dbt to serve as the single source of truth for Sigma and Power BI. Deploy AI-driven data quality monitoring and column-level lineage to satisfy SOX and audit requirements. Develop reusable data products and knowledge graphs that capture complex financial entity relationships. Direct internal engineers and offshore vendors while establishing best practices for CI/CD and observability. Founded in 1999, Resourcesoft, Inc. is a leading Technology Consulting and Professional Services organization. Headquartered in Marlborough, MA, the company serves the technology needs of its clients nationwide. Resourcesoft has often been recognized by prominent rating agencies for its exemplary growth and stability. With over two decades of industry experience, the Company has evolved as a front runner in enabling project optimization. We partner with leading organizations to provide technology solutions within the financial, insurance, education, government, publishing, healthcare and pharmaceutical domains. We take pride in mentoring a workforce that is well positioned to respond to the emerging IT trends and needs. With the employees at the crux of every business endeavor, our success is driven by our expertise in pairing the right talent with the best jobs in the technology sector. We forge long term, personalized relationships with our employees to advance their career to the next level. We engage them in technology centric client projects that provide opportunities for them to evolve, innovate and deliver world class products and services. Our career opportunities offer challenging assignments and exposure to emerging and cutting edge technologies. We are committed to providing our employees with the tools necessary to accelerate their career progression, while maintaining a healthy, work-life balance. We are deeply committed to providing a workplace ambience that is both challenging and fulfilling. ## 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) - [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) - [Empowering Retail Through Applied Machine Learning](https://www.wearedevelopers.com/videos/976-empowering-retail-through-applied-machine-learning) - [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) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [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) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Graph and AI Trends 2026: Why Is AI Running but Not Yet Delivering?](https://www.wearedevelopers.com/magazine/680-graph-and-ai-trends-2026-why-is-ai-running-but-not-yet-delivering)