Senior Software Engineer (Data Warehouse Developer/Architect, Data Modelling)

Posted:
8/21/2024, 4:20:39 PM

Location(s):
Telangana, India ⋅ Hyderabad, Telangana, India

Experience Level(s):
Senior

Field(s):
Data & Analytics ⋅ Software Engineering

Alcentra is owned by Franklin Templeton, a diversified firm that spans asset management, wealth management, and fintech, giving us many ways to help investors make progress toward their goals. With clients in over 150 countries and offices on six continents, you’ll get exposed to different cultures, people, and business development happening around the world.

Alcentra operates independently as a Specialist Investment Manager and is headquartered in London, with offices in New York, Boston, Tokyo and Hong Kong. We are a leading, global asset management firm specializing in the sub-investment grade debt markets, experts in credit management, private credit, and structured credit strategies.  Our investors include pension funds, insurance companies, government agencies, banks, wealth managers and high net worth individuals.

Visit www.alcentra.com to learn more who we are. 

What are the ongoing responsibilities of Senior Software Engineer?

  • Benefit Steet Partners/Alcentra is seeking to hire an experienced Data Engineer, whose focus will be supporting the design, development, implementation and integration of data, platforms, processes, and reporting efforts across the Firm.  This individual will work with the technology team as part of the data engineering initiative. The ideal candidate will have solid technology/development experience within Financial Services, along with strong project management, analytical, and communication skills.

Responsibilities include but are not limited to:

  • Delivery of the core data warehousing infrastructure and data processing pipelines.

  • Assist in a firmwide effort to update, streamline, and optimize current dataflows and reporting capabilities.

  • Take ownership of assigned tasks and support the development of an automated, dynamic, and self-service reporting platform.

  • Assist in the implementation of new platforms, processes, and reporting.

    • Organize and participate in creative design sessions.

    • Gather and track business requirements for initiatives.

    • Analyze output to ensure data integrity and accuracy.

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

The successful candidate will ideally possess following:

Essential:

  • A degree in Computer Science or Software Engineering from a top university.

  • Minimum 9+ years of demonstrable experience as Data Warehouse Developer/Architect

  • Experience in Data Warehouse schema design, data modelling, and data warehouse systems

  • Strong proficiency in SQL

  • Experience in data warehouse modelling designed for future scalability

  • Proficiency in leading schema development

  • Expanding the data warehouse by integrating new data sources and applying best-practice design principles

  • Strong SQL coding ability (stored procedures / CTEs / subqueries etc.)

  • Self-starter, able to work independently and as part of a team.

  • Demonstrate a proactive approach to problem-solving.

  • Strong communication skills both written and oral.

  • Team player with the ability to build strong relationships at all levels within the Firm.

Desirable:

  • Python ETL

  • SQL Server Analysis Services (SSAS)

  • ETL tools: Airflow / SSIS 

  • Project management experience

  • Experience with cloud architecture, AWS, Azure.

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

Experience our welcoming culture and reach your professional and personal potential!

Our culture is shaped by our diverse global workforce and strongly held core values. Regardless of your interests, lifestyle, or background, there’s a place for you at Franklin Templeton. We provide employees with the tools, resources, and learning opportunities to help them excel in their career and personal life. 

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. We understand that benefits are at the core of employee well-being and may vary depending on individual needs. Whether you need support for maintaining your physical and mental health, saving for life’s adventures, taking care of your family members, or making a positive impact in your community, we aim to have them covered.

Learn more about the wide range of benefits we offer at Franklin Templeton

*Most benefits vary by location. Ask your recruiter about benefits in your country.

Franklin Templeton 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. 

Franklin Templeton is committed to fostering a diverse and inclusive environment. If you believe that you need an accommodation to search for or apply for one of our positions, please send an email to [email protected]. In your email, please include the accommodation you are requesting, the job title, and the job number you are applying for. It may take up to three business days to receive a response to your request. Please note that only accommodation requests will receive a response.