Enterprise Data Architect & Integration Lead

About the position We are seeking an experienced Enterprise Data Architect & Integration Lead to own and drive our organization’s data architecture strategy while leading development and integration practices. This role combines hands-on architecture with team leadership, serving as a key bridge between data strategy, application development, and enterprise integration. The successful candidate will act as a player-coach, guiding a distributed team of developers while defining and implementing scalable, secure, and governed data and integration solutions. This individual will build upon an established SDLC and development framework to ensure continued maturity, adoption, and alignment with enterprise architecture standards. This is a high-impact role responsible for shaping the firm’s data and integration landscape. The Enterprise Data Architect & Integration Lead will play a central role in enabling scalable systems, improving data accessibility and quality, and driving long-term technology strategy. Responsibilities • Own and drive the firm’s enterprise data architecture strategy, including data modeling, data flows, and platform design • Define and implement a data architecture roadmap aligned with business goals and system integration needs • Establish standards for data modeling, data storage, and data lifecycle management • Design and oversee data pipelines, ETL/ELT processes, and real-time data integrations • Define and enforce data governance practices, including data quality, lineage, security, and access controls • Partner with stakeholders to ensure data architecture supports reporting, analytics, and operational use cases • Align application and integration design with enterprise data architecture principles • Define and lead the enterprise integration strategy, including APIs, workflows, and system connectivity • Design and oversee API architectures and integration patterns (REST, GraphQL, event-driven, etc.) • Guide the development of automation solutions and workflows to streamline business processes • Ensure integrations are scalable, secure, and aligned with enterprise standards • Collaborate with business teams and vendors to deliver robust integration solutions • Own and evolve the firm-wide Software Development Lifecycle (SDLC) to ensure consistency, quality, and scalability • Ensure adoption of development standards including code quality, testing, documentation, and deployment practices • Define and maintain the development toolchain and platforms (e.g., GitHub, CI/CD pipelines, environments) • Promote best practices across version control, branching strategies, and release management • Lead and mentor a distributed team of early-career developers focused on automation and integration • Provide coaching, career development, and technical guidance to grow team capabilities • Foster a collaborative, high-performing, and accountable team culture • Act as a technical leader and escalation point for complex development and integration challenges Requirements • Bachelor’s or Master’s degree in Computer Science, Information Technology, or a related field • 10+ years of experience in data architecture, software development, or system integration, including leadership experience • Proven experience designing and implementing enterprise data architectures and integration solutions • Strong experience with data modeling, database design, and data pipeline architecture • Experience with ETL/ELT tools and modern data platforms (e.g., Databricks, Snowflake, Microsoft Fabric) • Hands-on experience with API design and integration technologies (REST, GraphQL, SOAP, Webhooks) • Strong knowledge of software development best practices and SDLC frameworks • Experience with development tools and CI/CD pipelines (e.g., GitHub, automated testing frameworks) • Proficiency in technologies such as Power Apps, Power Automate, PowerShell, Python, JSON, Node.js • Familiarity with cloud platforms (Azure, AWS, or Google Cloud) • Understanding of data governance, security, and compliance best practices • Experience working with Active Directory and enterprise application environments • Demonstrated success leading and mentoring distributed or global teams • Strong communication, stakeholder management, and problem-solving skills Nice-to-haves • Experience with Azure Logic Apps and Microsoft Fabric • Experience implementing data governance frameworks or tools (e.g., cataloging, lineage, quality monitoring) • Exposure to modern data architectures (data lakehouse, data mesh, event-driven systems) • Relevant certifications in cloud platforms, data architecture, or software development Benefits • Medical, Dental, and Vision plans • Basic Life, AD&D, and Voluntary Life Insurance • 401(k) plan and Profit-Sharing program • Flexible Spending & Health Saving accounts • Employee Assistance, Wellness, and Work-life programs • Commuter & Parking benefits programs • Inclusive Parental Leave Benefits • Generous Paid Time Off (PTO) • Paid Firm Holidays • Community & Volunteering programs • Recognition & Rewards programs • Training & Certification programs • Discretionary Performance Bonus