Data Engineer

Clarion Partners has been a leading real estate investment manager for over 40 years. Headquartered in New York, the firm maintains strategically located offices across the United States and Europe. Clarion Partners offers a broad range of real estate strategies across the risk/return spectrum to approximately 500 institutional investors across the globe. Clarion Partners operates independently as a Specialist Investment Manager owned by Franklin Templeton (FT), a diversified firm that spans asset management, wealth management, and fintech, giving us many ways to help investors make progress toward their goals.

Clarion is seeking a skilled and motivated Data Engineer with strong hands-on experience in Microsoft Fabric, Data Pipelines, and PySpark notebook development. The ideal candidate is a fast learner, an excellent problem solver, and a self-driven individual contributor who thrives in a collaborative environment.

The role requires an understanding of financial data and the ability to independently design, develop, and support scalable data solutions.

Key Responsibilities

• Design, develop, and maintain scalable Microsoft Fabric Data Pipelines and Lakehouse solutions.
• Develop and optimize PySpark notebooks for data ingestion, transformation, and processing.
• Build integrations with REST APIs, SFTP servers, SQL databases, and other enterprise data sources.
• Develop reusable, parameterized pipeline activities and notebook components to improve efficiency and maintainability.
• Implement data validation, reconciliation, error handling, and audit logging.
• Monitor Fabric pipelines, notebooks, and workloads to ensure performance and reliability.
• Troubleshoot complex data processing issues, perform root-cause analysis, and implement sustainable solutions.
• Understand financial data and translate business requirements into reliable data transformations.
• Collaborate with business users, developers, and other stakeholders to deliver data solutions.
• Take ownership of assigned deliverables from development through deployment and production support.
• Leverage approved AI-assisted development tools to accelerate the design, development, documentation, testing, debugging, and optimization of data pipelines, PySpark notebooks, fabric pipelines and related data-engineering solutions.
• Apply appropriate engineering judgment and validation procedures to ensure all AI-assisted work meets requirements for accuracy, security, maintainability, performance, and data governance.

Required Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• 5–8 years of experience in data engineering.
• Strong hands-on experience with Microsoft Fabric, Data Pipelines, Lakehouse, and PySpark notebooks.
• Expert-level proficiency in Python and commonly used Python libraries for data processing, automation, and integration.
• Proficiency in SQL.
• Experience with REST API integrations, SFTP-based data ingestion, and ETL/ELT processes.
• Experience developing reusable and configurable data processing components.
• Knowledge of data modeling, Delta Lake, and data warehousing concepts.
• Experience with Fabric monitoring, logging, and performance optimization.
• Familiarity with Power BI and semantic models.
• Knowledge of Microsoft Fabric security, governance, and workspace administration.
• Excellent debugging, analytical, and problem-solving skills.
• Ability to understand financial data and business requirements.
• Strong communication skills and experience working in a collaborative team environment.
• Self-motivated, quick to learn, and capable of working independently with minimal supervision.

Preferred Qualifications

• Experience in financial services, investment management, or real estate asset management.
• Exposure to Azure Databricks.
• Experience with Azure Data Factory, Synapse Analytics, and other Azure services.
• Experience with Azure DevOps, CI/CD, and Git integration.
• Microsoft Fabric certification (DP-700).
• Experience using AI-assisted development tools to develop, test, debug, document, and optimize data-engineering solutions.

Work Shift Timings - 11:00 AM - 8:00 PM IST

Clarion Partners is an Equal Opportunity Employer. We are committed to providing equal employment opportunities to all applicants and existing employees, and we evaluate qualified applicants without regard to ancestry, age, color, disability, genetic information, gender, gender identity, or gender expression, marital status, medical condition, military or veteran status, national origin, race, religion, sex, sexual orientation, and any other basis protected by federal, state, or local law, ordinance, or regulation.

By joining us, you will become part of a culture that focuses on employee well-being and provides multidimensional support for a positive and healthy lifestyle. Clarion Partners offers generous benefits designed with the health and financial welfare of our employees and their families in mind, including highly competitive and expansive health care coverage, a comprehensive 401K, company-sponsored volunteer opportunities, individual volunteer time off, parental leave and childcare programs, as well as other benefits and discount purchase programs.

Clarion Partners is committed to fostering an inclusive environment. We provide employees with the tools, resources, and learning opportunities to help them excel in their career and personal life.

Artificial intelligence or automated tools may be used to assist in the screening, assessment, or selection of applicants for this position.