ETL Principal Software Engineer

About MyComplianceOffice (MCO)

MyComplianceOffice (MCO) is a global leader in conduct-risk compliance management. From our modest beginnings as a startup, we’ve grown over the last 15 years into a dominant force in compliance technology, serving hundreds of marquee clients around the world. Our SaaS platform continues to evolve rapidly - fuelled by innovation, acquisitions, and unmet market needs. With impressive growth and profitability metrics, MCO is poised for the next phase of its expansion. We're looking for smart, driven professionals to help shape our future.

The MCO SaaS Platform

MCO’s cloud-based compliance platform empowers organizations to reduce conduct risk by proactively managing the regulated activities of employees, vendors, and other third parties. Designed for flexibility and speed, our suite of modular, easy-to-deploy solutions ensures compliance teams can act quickly, demonstrate accountability, and reduce risk—all while keeping costs low. With compliance automation at its core, the MCO platform helps clients of all sizes stay ahead in a fast-changing regulatory landscape.

About the Role

We are seeking a highly skilled and experienced ETL/Python Developer to join our multinational team. The ideal candidate will be proficient in developing ETL applications using variety of RDBMSs. The candidate is expected to clearly demonstrate experience dealing with issues of performance, cost & reliability with ETLs. Knowledge in Python programming is a must. The role is a Lead role and hence the candidate is expected to be a self-starter, and to lead the development efforts from the front with minimum supervision. Also, the candidate must be technically adaptable to new technologies, should be adept to learn, design and implement any technology on the go. Additionally, the candidate should have strong expertise in design patterns, latest data warehousing/ETL trends and in fixing performance issues. This role requires a developer who is adaptable, innovative, and capable of working in a fast-paced environment.

Key Responsibilities

• Design, develop, build and maintain ETL/ELT application components, multiple projects building/designing ETLs with a variety of RDBMS's

• Strong preference for Python experience (must have skill)

• 
  Can clearly demonstrate experience dealing with issues of performance, cost & reliability with ETLs

• Write clean, SOLID code in PL/SQL Packages/Unix Shell scripts and Python, ensuring application performance and responsiveness. Implement back-end interfaces using Snowflake, adhering to modern design patterns and best practices.
• Collaborate with cross-functional teams to define, design, and ship new features and enhancements within an agile workflow.
• Troubleshoot, debug, and upgrade existing systems, ensuring high performance and responsiveness. Participate in code reviews to maintain high-quality code standards and promote knowledge sharing.

Experience and Skills Required

• 10-15 Years of Proven experience as an ETL/Python Developer or similar role.
• Strong proficiency in Python Programming, who knows how to write clean and organized Python code within a modern context.
• Basic knowhow of Cloud based ETL offerings such as (not limited to) Snowflake or Si-Sense and their architecture and implementation.
• In-depth knowledge of Relational database and how it could be migrated to a file based or any other format better suited for AI needs.
• Experience with databases and should have clear understanding of RDBMS vs non-RDBMS, their strengths, weaknesses, migrations techniques. Proficient understanding of code versioning tools, such as Git.
• Excellent problem-solving skills and the ability to work in a fast-paced environment.
• Strong communication and teamwork skills, with the ability to collaborate effectively with other developers, POs, and product managers.
• Be open to any solution proposed which would suit MCO future architectural needs in lieu of its AI centric approach.

We are seeking a highly skilled and experienced ETL/Python Developer to join our multinational team. The ideal candidate should have ideally involved in multiple ETL implementations and data migration projects. Additionally, the candidate should have strong expertise in design patterns, this role requires a developer who is adaptable, innovative, and capable of working in a fast-paced environment.

• Seniority Level
• Associate
• Industry
• Software Development
• Employment Type
• Full-time
• Job Functions
• Product Management
• Skills
• Python Programming
• ETL Design and Implementation
• RDBMS Core Concepts
• Unix Shell Scripting