BTVK Advisory is a leading advisory firm whose specialized professionals guide clients through an ever-changing business world helping them win now and anticipate tomorrow. BTVK Advisory and its affiliated entities have operations in North America South America Europe Asia and Australia. BTVK Advisorys ultimate parent entity Baker Tilly US LLP is an independent member of Baker Tilly International a worldwide network of independent accounting and business advisory firms in 141 territories with 43000 professionals and a combined worldwide revenue of $5.2 billion.
Baker Tilly is an equal opportunity/affirmative action employer. All qualified applicants will receive consideration for employment without regard to race color religion sex national origin disability or protected veteran status gender identity sexual orientation or any other legally protected basis in accordance with applicable federal state or local law.
To be added to all ET through Experienced requisitions Any unsolicited resumes submitted through our website or to Baker Tilly Advisory Group LP employee e-mail accounts are considered property of Baker Tilly Advisory Group LP and are not subject to payment of agency order to be an authorized recruitment agency (search firm) for Baker Tilly Advisory Group LP there must be a formal written agreement in place and the agency must be invited by Baker Tillys Talent Attraction team to submit candidates for review via our applicant tracking system.
Job Description:
Responsibilities:
- Design and maintain conceptual logical and physical data models canonical models and reusable architecture patterns across core business domains including Client Project Engagement People and Finance.
- Translate business requirements into scalable data architecture solutions applying reference architectures for data lakehouses warehouses MDM Golden Records streaming and API-based services while evaluating design alternatives risks and dependencies.
- Define and implement Master Data Management (MDM)
Golden Records reference data matching survivorship synchronization and distribution patterns ensuring consistent enterprise data definitions and authoritative sources.
- Design enterprise integration architectures using ETL/ELT APIs batch processing event-driven integration and streaming ensuring seamless data movement reuse scalability and interoperability across platforms.
- Establish data ingestion transformation and promotion standards across landing curated and consumer layers incorporating data quality observability metadata lineage security and operational requirements.
- Define and enforce enterprise data architecture standards covering modeling naming metadata classification lineage data quality and data products while conducting design reviews and ensuring governance compliance.
- Architect and optimize data flows across Workday Salesforce analytics platforms and service line applications supporting system-of-record decisions source-of-truth alignment and application/data deprecation strategies.
- Collaborate with Data Governance Enterprise Architecture Security and Privacy teams to incorporate data access retention classification privacy and security controls into solution designs ensuring policy compliance risk mitigation and escalation of architecture exceptions.
- Develop and maintain data models architecture diagrams data dictionaries lineage records integration designs data flows and architecture decision records ensuring documentation remains accurate accessible and updated throughout the solution lifecycle.
- Serve as the Data Architecture point of contact for assigned initiatives partnering with business stakeholders engineering analytics application teams and the Senior Manager Data Architecture to guide solution design validate technical feasibility resolve cross-functional dependencies and advance enterprise architecture standards and strategic initiatives.
Qualifications
- Bachelors degree in Computer Science Information Systems Data Management Engineering or a related field.
- Minimum 3 years of experience in Data Architecture Data Engineering Data Modeling Analytics Architecture or Enterprise Integration with proven experience designing solutions across multiple systems domains and platforms.
- Strong expertise in conceptual logical physical dimensional domain and canonical data modeling including enterprise data structures and reusable architecture patterns.
- Hands-on experience designing enterprise data integration solutions using ETL/ELT APIs batch processing event-driven integration and streaming technologies.
- Experience architecting modern cloud-based data and analytics platforms including data lakehouses and enterprise data warehouses; exposure to Databricks and/or Snowflake preferred.
- Solid understanding of Master Data Management (MDM) Golden Records reference data authoritative data domains and system-of-record/source-of-truth architecture.
- Experience with Data Governance metadata management data catalogs lineage classification data quality observability ownership and data lifecycle management including enterprise standards and frameworks.
- Knowledge of data privacy security retention classification compliance and Data Loss Prevention (DLP) with the ability to incorporate governance and risk controls into architecture designs.
- Experience evaluating architecture alternatives technical trade-offs risks and recommendations and maintaining architecture diagrams data models integration designs data flows and decision records; familiarity with Workday Salesforce reusable data products and domain-oriented architectures preferred.
- Strong technical problem-solving analytical stakeholder management communication and influencing skills with the ability to collaborate across business and technology teams explain complex architectural concepts and guide cross-functional solution delivery.