Senior Data Engineer Investments Data Platform (Snowflake)

Role: Senior Data Engineer Investments Data Platform (Snowflake)Location: New York, NY (Hybrid). No remoteNote:Expertise on data engineering with focus on DB and ETL/ELT.Data modelling, data governance.Data quality/reconciliation.Who are we looking for?20+ years of experience building enterprise scale data platforms, preferably within asset management, capital markets, or financial services , who will play a critical role in shaping the architecture, development standards, and long term scalability of this strategic investments data platform.Key ResponsibilitiesData Platform & Pipeline EngineeringDesign, build, and maintain robust, scalable ELT pipelines on Snowflake to ingest data from IBOR/ABOR systems, custodians, market data providers, and internal platforms.Implement end to end ingestion, standardization, and transformation logic using Airflow, dbt, Python, and Snowflake stored procedures.Manage schema evolution, metadata, and versioning to support changing upstream data structures without disrupting downstream consumers.Data Modeling & Analytics EnablementDesign and implement investment focused data models to support holdings, transactions, cash flows, exposure analytics, and performance reporting.Build analytics ready, well documented data structures optimized for portfolio management, finance, risk, and regulatory use cases.Partner with reporting, analytics, and investment operations teams to translate business reporting requirements into scalable technical designs.Data Quality, Governance & ControlsEstablish and enforce data quality checks, reconciliation controls, and validation frameworks to ensure accuracy and completeness of financial data.Implement governance standards including lineage, auditability, and data certification aligned with regulatory and internal control expectations.Support operational readiness by enabling monitoring, alerting, and issue resolution across data pipelines.Performance & ScalabilityOptimize Snowflake performance and cost efficiency for large scale financial datasets through clustering, partitioning, and query tuning.Contribute to platform architecture decisions , development standards, and best practices to ensure long term scalability and maintainability.Collaboration & LeadershipWork closely with investment operations, finance, reporting, and analytics stakeholders to ensure platform alignment with business needs.Act as a senior technical contributor in a lean, high impact environment, influencing design decisions and mentoring junior engineers as needed.Required Qualifications10 15 years of experience building enterprise scale data platforms, preferably within asset management, capital markets, or financial services .Deep hands on experience with Snowflake , including performance optimization and advanced SQL development.Strong experience with modern ELT frameworks such as dbt and orchestration tools like Airflow .Advanced proficiency in SQL and Python for data transformation, automation, and control frameworks.Proven experience designing complex financial data models supporting holdings, transactions, cash flows, and exposure analytics.Solid understanding of IBOR/ABOR concepts , investment operations, and downstream reporting requirements.Experience implementing data quality, reconciliation, and governance controls in regulated environments.Preferred QualificationsExperience working with custodian data feeds , market data, and investment accounting platforms.Familiarity with regulatory reporting and audit requirements in investment management.Exposure to cloud native data architectures and cost optimization strategies.Strong documentation and stakeholder communication skills.Behavioral & Leadership CompetenciesStrong analytical problem solving; able to resolve complex technical and operational issues.Executive level communication and stakeholder management.Self motivated, outcome oriented, with a strong transformation and delivery focus.Collaborates effectively across matrixed teams; drives client satisfaction and trust.Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.