PythonRole Overview
We are seeking a Senior SQL Developer & ETL Engineer with 5+ years of experience for a 100% remote opportunity.
Please Note: This is not a pure Data Engineering role. We are looking for a true SQL Specialist. Your core strength must lie in relational database development, schema design, and writing high-performance database logic with Python, ETL, Cloud. SQL mastery and database architecture are the absolute heart of this role.
If you are a database developer who loves diving into query execution plans, refactoring messy stored procedures for 10x performance, and building clean data models from scratch, this role is for you.
Key Responsibilities
1. Database Architecture & Schema Design
- Design, implement, and maintain robust relational database schemas.
- Architect optimal data models for both operational (OLTP) and analytical (OLAP/Data Warehousing) workloads.
- Implement Normalization (3NF) and dimensional modeling (Star/Snowflake schemas) as required.
2. Advanced Database Programmability
- Write, debug, and optimize highly complex Stored Procedures, Functions, Triggers, and Views to handle core business logic at the database level.
- Utilize advanced SQL techniques such as CTEs, Window Functions, and complex analytical queries to solve business problems.
3. Performance Tuning & Indexing
- Analyze query execution plans, identify performance bottlenecks, and implement advanced indexing strategies (B-Tree, Clustered/Non-Clustered, Partitioning).
- Refactor legacy SQL code and manage statistics, locking, and concurrency mechanisms to ensure sub-second response times.
4. Python & Cloud ETL/ELT Pipelines
- Develop, schedule, and maintain scalable data ingestion and transformation pipelines to connect disparate data sources.
- Leverage Cloud Data Platforms alongside modern Python libraries to build efficient data movement workflows.
5. Data Integrity & Governance
- Establish strict database constraints, data validation routines, and automated quality checks to guarantee absolute data accuracy.
Required Technical Skills
- Expert-Level SQL & DB Programmability (5+ Years): Mastery of writing server-side logic (Stored Procedures/Functions) and complex queries in enterprise platforms like PostgreSQL, SQL Server, Oracle, or MySQL.
- Advanced Database Optimization: Deep, under-the-hood understanding of database engines, execution plans, indexing strategies, and concurrency/locking control.
- Python for Data Engineering (3+ Years): Proficient in writing clean, modular Python scripts for API integration, data manipulation, and ETL processing (using libraries like Pandas, SQLAlchemy, or custom database connectors).
- Cloud Data Experience: Hands-on experience working with, migrating to, or developing within major cloud environments (AWS, Azure, GCP) and modern cloud data warehouses (Snowflake, BigQuery, or Redshift).
- Data Modeling Methodologies: Practical experience designing Star/Snowflake schemas, handling Slowly Changing Dimensions (SCD), and balancing normalization vs. denormalization.
Remote & Soft Skills
- Legacy Refactoring Mindset: You genuinely enjoy opening up a massive, poorly optimized 500-line legacy stored procedure and refactoring it for maximum efficiency.
- Autonomous Execution: Proven ability to manage your own time, architecture tasks, and deliverables without micromanagement in a fully remote setup.
- Asynchronous Communication: Exceptional written and verbal English communication skills to collaborate seamlessly across time zones.
Nice-to-Haves
- Experience migrating legacy on-premise infrastructure and stored procedures to modern cloud data warehouses.
- Familiarity with workflow orchestration tools like Apache Airflow or Prefect.
- Hands-on experience with dbt (data build tool) for in-warehouse transformations.
Shubham Vishwakarma
Full Stack Developer - Averlon
About Mango Sciences
About
Mango Sciences is a leading emerging market data science company connecting millions of underrepresented patients to precision medicine. The company’s Querent™ platform utilizes industry-leading AI analytics to transform deep clinical data into key insights that drive global health improvements. Mango Sciences is currently partnering with hospitals to understand the health data of individuals in India and other emerging markets to drive advancement in patient care and drug discovery for all populations.
Website- https://mangosciences.com/
Industry- Health Technology
Headquarters - Boston, Massachusetts
Tech stack
Data Science
Machine Learning (ML)Python
Amazon Web Services (AWS)Company social profiles
Similar jobs
Role & Responsibilities:
As a Business Analyst, we will require that you interact with a multitude of leaders and managers, from customers, prospects, AI suppliers, Internal stake-holders from technology and quality assurance as well as the entire research, analysis, development, delivery and support teams.
This requires maturity, empathy and an engaging personality. You must have excellent presentation and communication skills, written, spoken and creative. We seek candidates who are passionate, committed, innovative, self-driven and result focused.
Towards this end, you would be involved in the following:
- Shape new concepts and features
- Work with global QHSE leaders and AI/ML teams
- Bring your expertise and certifications into product strategy
- Engage with clients worldwide
- Support delivery teams in transforming safety performance
Ideal Candidate:
- Strong Business Analyst – HSE (Ports & Terminals) Profiles
- Must have 7+ years of experience as a Business Analyst, with 3+ years within the Ports, Container Terminals, Shipping, or Maritime industry OR with 3+ years in Health, Safety and Environment
- Must have strong domain expertise in Health, Safety & Environment (HSE / QHSE) specifically in Ports and Terminals operations
- Must have hands-on experience with HSE / QHSE software products (implementation, configuration, rollout, or functional ownership) used in Ports or Terminals
- Must have proven experience in requirements gathering, gap analysis, and writing detailed functional specifications / FRDs for enterprise or ERP-style applications
- Must have strong client-facing experience, including stakeholder interactions, UAT coordination, go-live support, and post-implementation functional support
- Must be comfortable with onsite client visits, product delivery, and training end-users on the HSE software product
- Excellent communication, presentation, and stakeholder management skills with the ability to independently own functional delivery
- Technical qualification is not mandatory; strong functional, process, and domain expertise is essential
- Experience working with ERP or large enterprise applications in Ports, Container Terminals, Logistics, or Maritime environments.
- Exposure to QHSE / Safety Management Systems, ISO standards (ISO 45001, ISO 9001, ISO 14001), or regulatory compliance frameworks.
- NEBOSH / IOSH / ISM Code or equivalent HSE certifications.
Role Overview
We are looking for an experienced Reinsurance Test Analyst with a strong understanding of reinsurance domain processes (treaty and facultative) and hands-on experience in functional and migration testing of reinsurance administration systems such as DXC SICS, Synergy 2, or Sapiens ReinsuranceMaster. The ideal candidate will work closely with business, QA, and implementation teams to validate treaty configurations, financial calculations, and claim recoverables with absolute precision.
Key Responsibilities
● Perform functional, migration, and regression testing for reinsurance platforms (DXC SICS, Synergy 2, etc.).
● Understand and validate treaty and facultative reinsurance workflows underwriting, claims, accounting, and reporting.
● Review retention, limit, and ceding ratio configurations and verify accuracy in financial outcomes.
● Conduct data reconciliation and validation during migration cycles (ETL and financial mapping).
● Support User Acceptance Testing (UAT) preparing business scenarios, logging defects, and coordinating with stakeholders.
● Work with automation engineers to convert manual scenarios into reusable automated tests (Playwright / Python preferred).
● Document test cases, results, and evidence for audit and IFRS 17 compliance.
● Collaborate with DXC, business analysts, and development teams to ensure quality deliverables within timelines.
Required Skills & Experience
● 5-10 years of experience in software testing, with at least 3+ years in the reinsurance domain testing.
● Strong understanding of treaty and facultative reinsurance, proportional and non-proportional treaties, and retrocession.
● Experience testing one or more reinsurance systems such as DXC SICS, Synergy 2, Sapiens, or similar.
● Proficiency in functional testing, data validation, and regression testing.
● Hands-on experience with SQL, Excel-based reconciliation, and defect-tracking tools (JIRA / Azure DevOps).
● Good understanding of IFRS 17, financial reconciliation, and reporting validations (added advantage).
● Exposure to automation testing using Playwright / Selenium / Python preferred.
● Excellent analytical skills and attention to detail ability to validate complex financial logic.
Qualifications
● Bachelors or Masters degree in Computer Science, Engineering, Finance, or related field.
● Domain certification in insurance or reinsurance will be an added advantage.
Preferred Background
● Experience working with insurance or reinsurance clients (life/non-life).
● Exposure to migration or transformation projects involving system replacement or data conversion.
● Familiarity with Agile / Scrum testing methodologies.
● Strong communication skills able to interact effectively with business and technical stakeholders.
PythonMachine Learning (ML)Data Science1+ years of proven experience in ML/AI with Python
Work with the manager through the entire analytical and machine learning model life cycle:
⮚ Define the problem statement
⮚ Build and clean datasets
⮚ Exploratory data analysis
⮚ Feature engineering
⮚ Apply ML algorithms and assess the performance
⮚ Codify for deployment
⮚ Test and troubleshoot the code
⮚ Communicate analysis to stakeholders
Technical Skills
⮚ Proven experience in usage of Python and SQL
⮚ Excellent in programming and statistics
⮚ Working knowledge of tools and utilities - AWS, DevOps with Git, Selenium, Postman, Airflow, PySpark
Duties:
• Embedded Software Development in C
•Design and development of software based on Autosar architecture
• Integration & verification of the developed SW components
•Debugging and error analysis
•Create design documents
•Participate in Design & Code reviews
Qualifications:
•University degree in electrical/electronics engineering, computer science or similar
•Minimum 5 years of experience in embedded software development
• Solid C programming skills
• Ideally with Autosar experience
•Knowledge on Functional Safety (ISO 26262)
• Familiar with Vector tools like DaVinci Configurator, Geny, CANoe, etc..
•Knowledge of scripting tools like Python, CAPL, etc.
NodeJS (Node.js)
MongoDB1. Work closely with the Founders to plan and develop the architecture and engineering vision for the product.
2. Roll out and advocate for new engineering principles and processes while supporting, maintaining, and updating existing ones.
3. With the help of your team members, educate and execute on Software Engineering best practices for testing, deploying, and developing code.
4. Be ready to roll up sleeves to assist your team when there are most urgent, difficult or critical developments to produce
5. Drive the apt technology choices (e.g. languages, libraries, frameworks)
6. Layout the technology architecture for both immediate and long term growth
7. Take appropriate risks for technical debt to develop prototypes in a short timescale
*Leadership responsibilities*
1. Mentor and guide the professional and technical development of your team members.
2. Hire and build a Software development team
3. Represent the Technology progress on the company vision to the Board/CXOs
4. Participate with Core-team in making key Product and tech roadmap related decisions
*Experience*
1. You have 7+ years of relevant engineering work experience.
2. You have significant experience working on a SAAS-based platform.
3. You have experience architecting enterprise Blockcahin applications (Any Blockchain framework is fine but Hyperledger will be preferred)
4. You have a strong technical background and are able to contribute to design and development across the software product lifecycle
5. You are familiar with our tech stack (Hyperledger/Nodejs / ReactJs / PostgreSQL / AWS / Linux)
6. You are familiar with implementing organizational processes using tools like Jira / Git / Slack etc.
7. You've worked on large-scale SaaS products and can rapidly familiarize yourself with complex products.
8. You have a strong focus on metrics and know how to measure the health of engineering teams.
9. Strong organizational skills and a focus on developing processes support the long term growth of the product engineering group.
10. You have experience running Agile teams.
Javascript
HTML/CSSThe Company is looking for a Front End Developer to join our growing team in our
Costa Rica office. Your experience here will give you the opportunity to improve the
fundamentals and learn about the top-notch technologies in front end development. If you are
someone who is passionate about building stellar user experiences and great products through elegant code this would be the job for you. You will play a key role in translating our customers and company needs into appealing and functional web pages while proving your ideas with testing. We all work closely together across teams so there's no red tape or
bureaucracy. We get things done!
What You Will Get to Do
● Work with your team to improve our conversion rates by coding out variations for A/B testing
● Build better user experiences
● Rigorously educate yourself with the latest development techniques and best practices
● Proactively anticipate issues and develop solutions
● Clearly communicate solutions to team members both verbally and in writing documentation
● Implement new digital technologies or development techniques that help to meet business
objectives
What You Bring to the Table
● 3+ years of front-end development experience
● Experience with responsive web design and the ability to deliver outstanding functionality
to the range of client devices from desktops and laptops to mobile platforms
● Familiarity with at least one JavaScript framework (MVW) and know when to do without
one when necessary.
● Understanding of HTTP and how clients interact with a web server.
● Solid understanding of best practices. You read the YDKJS books.
● Capable of coding in ES5 and ES6 and understand the difference between them
● Up-to-date on HTML5 and CSS3 features.
Vue.js
AngularJS (1.x)
React.js
Angular (2+)Javascript1. Candidate should be expert to design, develop, test and deploy solutions based on industry's best practices and client's business requirements. This position requires highly proficient knowledge of Shopify liquid code, PHP and its advance concepts.
3. Strong in PHP and it's framework like Laravel, must be competent in shopify app development and shopify apps architecture.
.NET
C#
jQueryWith the ever changing scenarios in the field of web and Information Technology, software developers have constantly reinvented and updated themselves in order to stay ahead of the competition and perform well in this line of work. For this one also should possess knowledge about a number of programming languages in order to carry out their tasks efficiently.
Major responsibilities of a Dot net Developer includes :
- Analysing and gathering requirements for the framework and creating a design for the final software output.
- Understanding the life cycle of software and determining any changes that may be needed as per the observations and feedback of software testing professionals.
- Developing the web based software using computer programming languages such as Asp.net, Sql Server, MVC, Entity framework,Jquery.
- Creating and maintaining the ASP.NET MVC based websites and their web applications as per the initial guidelines of the client.
- Making changes to existing web applications according to the feedback received from the end users or clients. In some cases, changes are also made in order to update the application's compatibility with the latest operating systems.
- Testing the applications and websites on different web browsers to ensure a standard user experience for the clients across all platforms.
- Deploying applications on client server.
- Training the end user or client on the final product as well as providing technical support whenever required.
- Finding information about latest technologies that aid in the development of core web applications and enhance their features in the long run.
- Ensuring the compatibility of the websites with newer software or operating system version.
C++- Prototype, design, implement, unit test, and maintain Windows-based software applications
- Participate in cross-functional project teams to develop medical device software
- Work with multi-discipline teams on new product introduction project while adhering to software development and source control processes
- Document software, write technical specifications for interfaces and testing
Qualifications
- Bachelor’s degree in Software Engineering, Computer Science or related field with no less than 9+ years of experience
- Experience designing and developing C++ based solutions and experience with any user interface development (MFC)
- Expert in Unit Testing, OOA/OOD development methodologies, and design principles
- Experience in Agile development processes and philosophies
- History of timely delivery while ensuring a quality focus
- Ability to work well with people and be both highly motivated and motivating
- Ability to work in a fast-paced, and often ambiguous environment where continuous improvement is a way of life
- Ability to work independently and proactively with minimal direction.
Nice to Have
- Experience in medical device design & development is a plus
- Experience in IVD instrumentation, such as clinical chemistry, immunoassay, hematology, urinalysis, molecular, microbiology, or flow cytometry systems is a plus
- Understanding of software development processes for a regulated environment (ISO9000/FDA) is a plus
- Experience in software code and build management is a plus
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon