Director Of Engineering

Role 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.

• Delivering a complete front end application
• Ensuring high performance on mobile and desktop
• Writing tested, idiomatic, and documented JavaScript, HTML and CSS
• Coordinating the workflow between the graphic designer, the HTML coder, and yourself
• Cooperating with the back-end developer in the process of building the RESTful API
• Communicating with external web services
• Integration of client-side elements developed by a frontend developers with server side logic
• Develop back-end components to improve responsiveness and overall performance
• Building reusable code and libraries for future use
• Test and debug programs
• Improve functionality of existing systems
• Implement security and data protection solutions
• Assess and prioritize feature requests
• Coordinate with other team members to understand user requirements and provide technical solutions
• Ability to lead a team

Skills and Competencies:

• Proficiency with JavaScript, TypeScript, HTML and CSS
• Fundamental Knowledge of an SPA (Single page application)
• Deep knowledge of AngularJS practices and commonly used modules based on extensive work experience
• Creating self-contained, reusable, and testable modules and components
• Ensuring a clear dependency chain, in regard to the app logic as well as the file system
• Ability to provide SEO solutions for single page apps
• Thorough understanding of the responsibilities of the platform, database, API, caching layer, proxies, and other web services used in the system
• Validating user actions on the client side and providing responsive feedback
• Writing non-blocking, optimized, reusable and scalable code
•  Creating custom, general use modules and components which extend the elements and modules of core Angular
•  Experience with building the infrastructure for serving the front-end app and assets
•  Architecting and automating the build process for production, using task runners or scripts
• Documenting the code inline using JSDoc or other conventions
• Creating e2e test suites for all components, and running them with Protractor (or a well reasoned alternative)
• Creating configuration, build, and test scripts for Continuous Integration environments
• Professional, precise communication skills
• Proficient understanding of code versioning tools such as git is required
• Excellent presentation, problem-solving and team working skills
• Understanding of modern development methodologies and tools including Agile (XP and Scrum), Rapid Application Development, etc.
• Proficient knowledge of Python with a backend server framework like Flask or Django
• Implementing user authentication and authorization between multiple systems, servers, and environments
• Understanding accessibility and security compliance from the Business statement & implement them accordingly
• Building API services from scratch - Project structuring, setting up environment objects, build reusable components, etc
• Integration of multiple data sources and databases into the application code
• Management of hosting environment, including database administration and scaling an application to support load changes
• Creating database schemas that represent and support the business use case
• Experience with scripting for task automation and data analysis
• Implementing automated testing and unit tests cases using tools like Postman or any other libraries
• Basic understanding of front-end technologies and platforms, such as JavaScript, HTML, and CSS would be a value-add
• Professional, precise communication skills

Qualification and Experience:

• B.E. / B. Tech. / MCA / PGDCA / M.Sc. (CS) /M.E. / M. Tech
• 4+ years of experience in Web Application and Backend Development
• Proven expertise in testing of application software to assure accuracy, integrity, completeness to achieve desired results
• Experience with AngularJS (v1.x.x) would be a value-add
• Proficient knowledge of Python or any other back-end programming language
• Demonstrated experience with Object Oriented design and development
• Proven expertise in testing of application software to assure accuracy, integrity, completeness to achieve desired results
• Experience in working with MongoDB or other NoSQL databases would be a value-add
• Knowledge of Microservices, Dockers, Kubernetes
• Exposure to Google Cloud Platform and/or Amazon Web Services

Job Title: Tableau BI Developer

Years of Experience: 4-8Yrs

12$ per hour fte engagement

8 hrs. working

Required Skills & Experience:

✅ 4–8 years of experience in BI development and data engineering

✅ Expertise in BigQuery and/or Snowflake for large-scale data processing

✅ Strong SQL skills with experience writing complex analytical queries

✅ Experience in creating dashboards in tools like Power BI, Looker, or similar

✅ Hands-on experience with ETL/ELT tools and data pipeline orchestration

✅ Familiarity with cloud platforms (GCP, AWS, or Azure)

✅ Strong understanding of data modeling, data warehousing, and analytics best practices

✅ Excellent communication skills with the ability to explain technical concepts to non-technical stakeholders

• Preparing product information and research reports for critical care segment products
• Providing clinical research data, trial information, latest medical trend to team and customers.
• Preparing presentations, MIS, product information brochures, and any other related responsibilities
• Meeting super specialty doctors and providing product information, studies, engaging and discussion on segment related trends and advancements.
• Engaging with business team and planning development activities
• Active engagement with management for expansion of business activities and providing inputs for company development.
• Any other responsibilities required on ongoing growth of the company.

Requirements:

• Proven experience in product management within the pharmaceutical industry.
• Loves to travel and meet customers.
• Strong analytical and research skills.
• Excellent presentation and communication abilities.
• Ability to engage with super specialty doctors and the business team effectively.
• Strategic mindset for contributing to the company's growth.

Key Areas of Responsibility:

● Growth

○ Consumer:

■ Understand the core consumer needs, and collaborate with product and design to build the right consumer experience and optimise conversion funnels.

■ Lead the development and execution of comprehensive growth strategies, focusing on user acquisition, activation, and retention.

■ Oversee and optimise performance marketing channels, including paid advertising, SEO, SEM, and partnerships.

■ Utilise data analytics to identify trends, insights, and areas for improvement in the user journey.

■ Develop and implement strategies to increase customer retention and lifetime value.

○ Partnerships

■ Define the partnerships and spiritual leader outreach strategy to align with the consumer need and company vision.

■ Build a high quality curated leader community by developing a deep understanding of the ecosystem and nurturing leader relationships.

■ Work closely with the content team to align leader onboarding strategy with the overall content strategy.

● Strategic Support:

○ Collaborate closely with the founding team to drive and execute key strategic initiatives.

○ Conduct market research, prepare reports, and provide insights to support decision-making.

● Problem Solving:

● Anticipate challenges and proactively identify solutions to address them.

● Assist in resolving operational issues and roadblocks.

Qualifications

● Bachelor's degree in Engineering; MBA is a plus.

● Previous experience in a Product or Chief of Staff or similar role, preferably in a startup environment.

● Exceptional organisational and project management skills.

● Ability to work independently and collaboratively in a fast-paced environment.

● Flexibility and adaptability to handle evolving responsibilities.

The primary purpose of this internship is to provide freshers with knowledge in web development. We conduct weekly communication classes to enhance communication skills. Additionally, special orientation classes covering topics such as customer satisfaction and work ethics. You will be given training on interview preparation. Our training method simulates the corporate training approach, where students report to their mentors. By the end of this internship, you will have a strong foundation in web development.

 JD / Skills Sets

1. Good knowledge on Python

2. Good knowledge on My-Sql, mongodb 

3. Design Pattern

4. OOPs

5. Automation

6. Web scraping

7. Redis queue

8. Basic idea of Finance Domain will be beneficial.

9. Git10. AWS (EC2, RDS, S3)