Software Engineer

The Role: In this role, you will collaborate with Team Leader, Scrum Master, data analysts, and developers to build technology solutions for Morningstar platforms. You should have hands on experience on Core Java and Python. Also, you should have experience in component-based architectures and create scalable, flexible technical solutions. You would create new components, support existing systems, study their enterprise complexities and develop/implement better systems with modern software development practices. Developing good understanding of existing systems on other platforms and its database is a beginning step.

Responsibilities:

• Design, develop, and maintain scalable ETL pipelines for data extraction, transformation, and loading.
• Write efficient SQL queries and stored procedures to manage and manipulate large datasets in SQL Server.
• Implement data validation and integrity checks to ensure accuracy across all pipelines.
• Collaborate with business stakeholders and business analysts to deliver data solutions that support business goals.
• Work with Python to automate data workflows and integrate with third-party systems.
• Optimize data pipelines for performance, scalability, and cost-efficiency.
• Troubleshoot, debug, and resolve issues related to data processing.
• Leverage AWS services for cloud-based ETL processes (e.g., S3, Lambda, Glue) and storage solutions.
• Collaborate in an agile environment with product managers, data analysts, and engineering teams.

Must Have Skills: These are the most important skills, qualities, etc. that we’d like for this role.

• 3-5 years of experience in Data Engineering or related field.
• Proficiency in Python for building data pipelines and automation scripts.
• Strong experience with SQL Server including complex queries, stored procedures, and optimization techniques.
• Expertise in ETL processes and data modeling.
• Knowledge of version control and CI/CD pipelines for data projects.
• Good to have – Java, Spring and MongoDB

Qualifications:

• Bachelor’s degree in computer science, Information Technology, or a related field.
• Strong analytical and problem-solving skills.
• Good communication and teamwork abilities.

Morningstar’s hybrid work environment gives you the opportunity to work remotely and collaborate in-person each week. We’ve found that we’re at our best when we’re purposely together on a regular basis, at least three days each week. A range of other benefits are also available to enhance flexibility as needs change. No matter where you are, you’ll have tools and resources to engage meaningfully with your global colleagues.