Senior Software Engineer (Data Factory, Data Pipelines, Synapse, Microsoft Fabric)

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.

What is a Data Engineering team responsible for?

• Collaborate with data analysts, data scientists, and other stakeholders to understand data requirements and ensure data accuracy, quality, and availability.
• Optimize data architectures and pipelines for performance and cost-efficiency.

What is a Senior Software Engineer responsible for?

• Design, build, and maintain efficient, reliable, and scalable data pipelines using Microsoft Fabric, Synapse Analytics, Data Factory, and Azure.
• Develop and maintain complex SQL queries and scripts to transform, aggregate, and manipulate data.
• Work closely with the business and technical teams to gather and analyze requirements and provide technical expertise in data engineering and data warehouse design.
• Troubleshoot and resolve data-related issues, ensuring high availability and reliability of data systems.
• Implement data governance and data management best practices.
• Build Semantic models.
• Participate in code reviews, testing, and documentation processes.

What ideal qualifications, skills & experience would help someone to be successful?

• Bachelor’s degree in computer science, Information Technology, or a related field.
• 5-8 years of experience in data engineering, with a strong focus on Microsoft Fabric, Synapse Analytics, Data Factory, Azure, data pipelines and Power BI.
• Proficient in SQL, with the ability to write and optimize complex queries.
• Experience in building and managing data pipelines and ETL processes.
• Knowledge of data modeling, data warehousing.
• Strong problem-solving skills, with the ability to troubleshoot and resolve complex data issues.
• Excellent communication and collaboration skills, with the ability to work effectively in a team environment.
• Experience with other cloud data platforms and tools.
• Familiarity with programming languages including Python and C#.
• Knowledge of data governance and data security best practices.
• Real estate assets management domain knowledge is a plus.

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 a diverse and inclusive environment. We provide employees with the tools, resources, and learning opportunities to help them excel in their career and personal life.