Baron Capital
Vice President, Senior Data Architect
New York, New York · Exec
Sponsorship not specified$225k-$235kDetected 8 days ago
PythonSQLSnowflakeAzureCI/CDDevOpsData EngineeringData ScienceData VisualizationCommunicationCollaborationProblem SolvingSharePoint
About the role
- Establish and enforce data governance standards, including data ownership, stewardship, metadata, lineage, definitions, classification, access controls, retention, and usage standards.
- Assess current-state data platforms, databases, reports, and data processes; recommend improvements, migration paths, and modernization opportunities.
Responsibilities
- Define and implement the enterprise data architecture and roadmap for a modern Microsoft data platform, aligned to the firm's business strategy and asset management data needs.
- Design and build a single source of truth across critical domains such as security master, funds, portfolios, holdings, transactions, performance, clients, reference data, and reporting data sets.
- design and integrate Snowflake data warehouse capabilities where used by the firm.
- Lead data modeling efforts across conceptual, logical, and physical models, including dimensional, normalized, and semantic models for analytics and reporting.
- Design scalable ingestion, transformation, validation, and orchestration patterns for internal and external data sources, including APIs, files, databases, vendor feeds, operational systems, Microsoft Fabric, and Snowflake.
- Implement data quality frameworks, profiling, validation rules, monitoring, exception management, and remediation workflows to improve trust in enterprise reporting and analytics.
- Evaluate, implement, and administer data governance and cataloging tools such as Microsoft Purview, Atlan, or similar platforms.
- Partner with business teams to define KPIs, reporting requirements, data definitions, and reusable Power BI semantic models that support consistent reporting across the firm.
- Collaborate with application, infrastructure, cybersecurity, and business teams to ensure the data platform is secure, resilient, performant, compliant, and supportable.
- Document data architecture, data flows, lineage, data dictionaries, standards, integration patterns, and operational procedures.
Requirements
- At least 10 years of experience in data architecture, data engineering, business intelligence, or enterprise data platform delivery.
- Hands-on experience with Microsoft Fabric, including Lakehouse/Warehouse architecture, OneLake, pipelines, data engineering, and integration patterns.
- Strong SQL skills and experience with SQL Server or Azure SQL
- Strong Python skills and hands on experience with visualization packages such as Plotly, Matplotlib
- ability to write reusable components for reporting within the Dash framework.
- Experience implementing data governance, data catalog, lineage, and data quality capabilities using Microsoft Purview, Atlan, or comparable tools.
- Strong understanding of data security, privacy, entitlements, role-based access, compliance, and audit requirements in a regulated environment.
- Excellent communication skills with the ability to translate business needs into technical architecture and explain technical concepts to non-technical stakeholders.
- Microsoft Fabric, Snowflake, and Power BI are required.
- Required:
- Bachelor's degree in Computer Science, Information Systems, Data Science, Engineering, or a related field
- Master's degree preferred.
- 5+ years of experience in financial services
- asset management, investment management, wealth management, or capital markets experience strongly preferred.
- Hands-on Snowflake experience, including warehouse design, schemas, secure data sharing, ingestion/ELT, performance optimization, and integration with Microsoft Fabric and Power BI.
- Strong Power BI experience, including semantic models, DAX, dataflows, governance, deployment practices, and enterprise reporting standards.
- ability to write, optimize, and troubleshoot complex queries and stored procedures.
- Deep understanding of data warehousing, lakehouse architecture, data modeling, ETL/ELT, metadata management, lineage, and master/reference data management.
Nice to have
- Experience with investment or asset management data, including securities, benchmarks, portfolios, holdings, trades, performance, risk, compliance, and client reporting.
- Experience with data quality tools, MDM/reference data platforms, workflow automation, and issue management processes.
- Experience with SSIS, SSRS, legacy SQL Server reporting, or other data warehouse platforms is helpful for migration and modernization efforts.
- Experience with Power Apps, Power Automate, SharePoint, APIs and orchestration tools is a plus.
- Knowledge, Skills, and Abilities:
- Note to third parties: Baron Capital is not seeking or accepting any unsolicited assistance from search and selection firms or employment agencies at this time.
Skills
- Enterprise architecture mindset with the ability to define standards, patterns, and roadmaps while also delivering hands-on solutions.
- Strong analytical and problem-solving skills with a focus on data trust, quality, and usability.
- Strong documentation discipline, including architecture diagrams, data dictionaries, lineage, standards, and operating procedures.
Compensation
- $225,000 - $235,000 USD
Apply directly at Baron Capital →Create a free account for alerts like thisView Baron Capital immigration profile
This listing is sourced directly from Baron Capital's careers page and normalized into a canonical job model.