Data Scientist

Job description:

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 standard Big Data / Infra-heavy Data Engineering role. We are specifically looking for a SQL Specialist. Your core strength must lie in relational database development, schema design, and writing high-performance database logic. Python will be your primary tool for moving and orchestrating data, but SQL and database architecture are the heart of this role.

Key Responsibilities

• Database Architecture & Schema Design: Design, implement, and maintain robust relational database schemas, ensuring optimal data modeling (OLTP and OLAP/Data Warehousing).
• Advanced Database Programmability: Write, debug, and optimize complex Stored Procedures, Functions, Triggers, and Views to handle core business logic at the database level.
• Performance Tuning & Indexing: Analyze query execution plans, identify bottlenecks, and implement advanced indexing strategies, partitioning, and query refactoring to ensure sub-second response times.
• Python ETL/ELT Pipelines: Develop, schedule, and maintain scalable data ingestion and transformation pipelines using Python to connect disparate data sources.
• Data Integrity & Governance: Establish 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 complex queries (CTEs, Window Functions, Analytical queries) and server-side logic (Stored Procedures/Functions) in platforms like PostgreSQL, SQL Server, Oracle, or MySQL.
• Advanced Database Optimization: Deep understanding of how databases work under the hood—specifically indexing (B-Tree, Hash, Clustered/Non-Clustered), execution plans, statistics, and locking/concurrency mechanisms.
• Python for Data Ingestion (3+ Years): Proficient in writing clean, modular Python scripts for data manipulation, API integration, and ETL processing (using libraries like Pandas, SQLAlchemy, or custom database connectors).
• Data Modeling Methodologies: Practical experience designing Star/Snowflake schemas, Normalization (3NF), and handling Slowly Changing Dimensions (SCD).

Remote & Soft Skills

• Autonomous Execution: Proven ability to manage your own time, architecture tasks, and deliverables without micromanagement.
• Asynchronous Communication: Exceptional written and verbal English communication skills to collaborate seamlessly across time zones.
• Legacy Refactoring Mindset: You enjoy opening up a massive, poorly optimized 500-line stored procedure and refactoring it for 10x performance.

Nice-to-Haves

• Experience migrating legacy on-premise stored procedures to modern cloud data warehouses (Snowflake, BigQuery, Redshift).
• Familiarity with workflow orchestration tools like Apache Airflow or Prefect.
• Experience with dbt (data build tool).

Work Location: Remote

Company Overview:  

At Codvo, software and people transformations go hand-in-hand. We are a global empathy-led technology services company. Product innovation and mature software engineering are part of our core DNA. Respect, Fairness, Growth, Agility, and Inclusiveness are the core values that we aspire to live by each day.  

We continue to expand our digital strategy, design, architecture, and product management capabilities to offer expertise, outside-the-box thinking, and measurable results. 

• Design and solution new integrations/APIs and update existing API functionalities (enhancements or bugfixes) on Integration Services like Logic Apps, BizTalk, SSIS, Stream Sets etc.
• Identify opportunities, propose & implement solutions to improve integrations/middleware solution delivery process efficiency, KPI performance, customer experience and deliver value.
• Ability to guide and train developers on Integration/API tools as required and provide coaching and mentoring.
• Ability to lead design, development, testing, deployment of integrations using Azure Services.
• Ability to lead the Integration solutions for various SaaS/Market standard programs and complex project delivery with the help of Integration developers.
• Ability to design & develop integration frameworks considering all relevant artefacts including, security, governance, error handling, requirement traceability and access management.
• Strong analysis and communication skills. Able to manage conflict and misalignment within the team and with the business.
• Dedicated to project or product work for the majority of the year working in business and functional natural teams and establish Cross-Org performance management including effective participation in natural teams
• Presenting the changes to the Integration CoE and landscape managers during the Design review, Code review, Delivery Review and Pre-CAB/CAB meetings to receive required approvals.
• Strong engagement skills, working with stakeholders at all levels on regular basis; Ability to pro-actively engender a strong sense of community and team working.
• Expected to play a pivotal role in onboarding and building new cloud-based integration/API solutions, streamline and standardize the interfaces.
• Should be able to take ownership of deliverables and conduct reviews review board and seek signoffs

• Desired Skills and Experience.
• University degree or college diploma in Computer Sciences or related major Excellent communication skills – both verbal and written University degree or college                                                            diploma in Computer Sciences or related major.
• 8+ years programming and software development experience 6+ years .NET programming experience 4+ years BizTalk development experience
• Strong understanding of EAI, SOA, and ESB architecture Strong understanding of and experience with Object Oriented design and development Solid understanding of enterprise integration patterns
• Solid understanding of software development patterns.

Experience: 4+ Years

Job Location: Remote 

Work timings : 2.30 pm -11.30 pm

Role Overview:

The SEO Analyst is responsible for optimizing the organization’s online presence by improving search engine rankings, driving organic traffic, and enhancing user engagement. This role requires expertise in SEO strategies, analytics, and a strong understanding of mental health-related content to ensure alignment with the organization’s mission.

Key Responsibilities:

1. SEO Strategy Development and Execution:

• Develop and implement effective SEO strategies to improve website rankings and increase organic traffic.
• Conduct keyword research to identify high-value terms relevant to mental health services and integrate them into the content strategy.

1. Content Optimization:

• Collaborate with content teams to optimize on-page elements, including meta tags, headers, and keywords.
• Ensure that content adheres to SEO best practices while maintaining accuracy and sensitivity in mental health-related topics.

1. Performance Monitoring and Reporting:

• Monitor website performance using tools such as Google Analytics, Google Search Console, and other SEO software.
• Analyze data to evaluate the effectiveness of SEO efforts and provide regular reports to the marketing team.

1. Technical SEO Management:

• Conduct technical audits to identify and resolve issues affecting website performance, such as page speed, mobile usability, and broken links.
• Ensure the website is optimized for search engine crawlers and adheres to the latest algorithm updates.

1. Competitor and Market Analysis:

• Conduct competitive analysis to identify trends, opportunities, and gaps in the market.
• Research emerging SEO techniques and tools to maintain a competitive edge in the mental health sector.

1. Local SEO:

• Develop and manage local SEO strategies to enhance visibility in specific geographic areas.
• Optimize Google My Business profiles and manage location-based search strategies.

1. Collaboration and Training:

• Work closely with content creators, developers, and social media teams to align SEO initiatives with broader marketing goals.
• Provide training and guidance to team members on SEO best practices.

Qualifications and Requirements:

Education:

• Bachelor’s degree in Marketing, Computer Science, or a related field.

Experience:

• 2–5 years of experience as an SEO Analyst or in a similar role.
• Proven experience in optimizing content for the mental health or healthcare sector is mandatory.

Skills and Knowledge:

• Proficiency in SEO tools such as Google Analytics, Google Search Console, SEMrush, and Ahrefs.
• Strong understanding of technical SEO, keyword research, and link-building strategies.
• Familiarity with content management systems (e.g., WordPress).
• Knowledge of HTML, CSS, and basic coding practices is a plus.
• Excellent analytical and problem-solving skills.

Personal Attributes:

• Strong attention to detail with the ability to manage multiple projects simultaneously.
• Excellent communication and collaboration skills.
• Sensitivity and awareness when working with mental health-related content.

Key Competencies:

• Expertise in SEO strategies and best practices.
• Data-driven decision-making and performance analysis.
• Ability to adapt strategies to the unique needs of mental health-related audiences.
• Strong alignment with the organization’s mission to promote mental health awareness.

• Excellent mobile app development experience
• Strong CS fundamentals OOPS concepts, algorithms data structures Core Java
• Deep knowledge of basic React Native components and Android Studio
• Ability to write well-documented, clean Java and Javascript code
• In-Depth knowledge of building tools like XCode, and Android Studio
• Knowledge of Android Studio and React Native Lifecycle and publishing cycles on Google and Apple app stores.
• Experience with Git and ES6
• Experience in the kotlin  and flutter  

🏆 Benefits

• Remote Possible - Work from anywhere in India though we promote Work From Office like revered Narayan Murthy is appealing. https://trak.in/tags/business/2022/03/14/infosys-founder-narayan-murthy-wants-all-employees-back-to-office-says-work-from-home-is-bad-for-productivity/">Read it
• Flexible work hours
• Annual Appraisal Cycles
• Healthcare plans are on the way
• Free e-learning courses and external training plus certifications
• Fewer deductions so In Hand, Salary is more
• Special Guidance on Financial Investment planning to help you save more
• Healthcare sessions with our Doctors
• We promote employees to take timely leaves and take care of family

Job Profile: SEO Specialist

Department: Marketing

Location: Goregaon, Mumbai

Overview:

The SEO specialist is responsible for driving organic and overall traffic and improving search engine

visibility for the brand. The role requires deep expertise in search engine optimisation, a data-driven

approach, and the ability to execute a comprehensive SEO strategy across all digital channels.

Key Responsibilities:

Develop and execute a comprehensive SEO strategy that aligns with the brand's marketing and

business objectives

Conduct keyword research and analysis to inform content creation and optimisation efforts

Optimise website structure, content, and metadata to improve search engine visibility and drive

organic traffic

Monitor and analyse search engine rankings, traffic patterns, and conversion data to inform and refine

SEO efforts

Stay up-to-date on industry trends and best practices, and incorporate them into SEO strategies

Collaborate with the Marketing Manager, content writers, and designers to ensure all digital assets

are optimised for search engines

Communicate the value of SEO to internal stakeholders and educate them on best practices

Measure and report on the success of SEO initiatives and use data to inform future optimisation

efforts

Key Performance Indicators (KPIs):

Organic and overall traffic growth

Search engine rankings for target keywords

Bounce rate and time on site metrics

Conversion rate and lead generation metrics

Return on investment (ROI) of SEO initiatives

Search engine visibility and website performance, as measured by tools such as Google Analytics and

Search Console

Qualifications:

Bachelor's or master s degree in Marketing, Communications, Computer Science, or a related field

3+ years of experience in SEO, with a proven track record of success

Deep expertise in search engine optimisation, including keyword research, on-page optimisation, link

building, and analytics

Experience with website architecture and development and the ability to collaborate with developers

and designers to implement SEO recommendations

Strong analytical skills, with the ability to use data to inform and refine SEO strategies

Excellent project management skills, with the ability to manage multiple projects and deadlines

Marketing - Hiring

Strong written and verbal communication skills, with the ability to educate and communicate the

value of SEO to internal stakeholders

Ability to work independently and as part of a team

We are looking for a Ruby on Rails developer responsible for managing the interchange of data between the server and the users. Your primary focus will be development of all server-side logic, definition and maintenance of the central database, and ensuring high performance and responsiveness to requests from the front-end. You will also be responsible for integrating the front-end elements built by your co-workers into the application. Therefore, a basic understanding of front-end technologies is necessary as well.

Responsibilities:

• Design, build, and maintain efficient, reusable, and reliable Ruby code.
• Integration of data storage solutions (may include databases, key-value stores, blob stores, etc. )
• Integration of user-facing elements developed by front-end developers with server side logic.
• Identify bottlenecks and bugs, and devise solutions to these problems.

Requirements:

• Bachelor's Degree or Master's in Computer Science, Engineering, Software Engineering or a relevant field.
• More than 3 years of experience in a ROR Developer (or similar role); experience in software development and infrastructure development is a plus
• Experience with Ruby on Rails, along with other common libraries such as RSpec and Resque.
• Good understanding of the syntax of Ruby and its nuances.
• Solid understanding of object-oriented programming.
• Good understanding of server-side templating languages (such as Liquid, Slim, etc depending on your technology stack).
• Good understanding of server-side CSS preprocessors (such as Sass, based on project requirements).
• Basic understanding of front-end technologies, such as JavaScript, HTML5 and CSS3
• Familiarity with concepts of MVC, Mocking, ORM, and RESTful.
• A knack for writing clean, readable Ruby code.

Role Overview

1. As a Pre-Sales Engineer, you will be responsible for designing and drafting systems for Technical Proposals brought in by the sales team, ensuring that quotes are technically correct before submitting to clients.
2. Preparation of proposal based on the RFP / RFQ docs and Understand the CAD drawing.
3. Generate BOQ, Compliance Statement, system descriptions, schematic drawings, material / technical submittal, system programming such as Crestron, Extron, Bose and other OEM products etc.
4. Provide sales and technical staff with technical support on both a pre- and post-sales basis
5. Communicate and interact with internal employees, clients and colleagues in a professional and timely manner.
6. Conduct or attend a Site visit and Site surveys when needed.
7. Develop and maintain knowledge of current and new technologies that company offers.

Key Skills

• 2+ years of experience required in AV.
• Experience in developing cost-effective solutions around customer needs.
• Good skill for Vendor Management, OEM interaction.
• Proficient in the use of Microsoft Office Suite
• Good Communication skill

1.Demonstrating the product features to new customer (Online or Onsite)

2.Product show cases to client team during Implementation or after GoLive (after releasing the feature in Live).

3.Preparation of Business Case Document & coordinating with client or vendor team to understand the business objective or business need

4.Preparation of Business Requirement Document (BRD), Functional Specification Document (FSD) and Software Requirement Specification (SRS) along with sign-off from client team.

5.Designing Wire Frames & Prototype Documents along with sign-off from client team.

6.Regular follow-ups on any pending sign-off’s from stakeholders.

7.Regular follow-ups with Dev Team to complete the pending requirements.

8.Responsible for preparation of Use Case Document in collaboration with Testing team

9.Follow-up with client on further clarifications on requirements along with any additional information.

10.Scheduling the meetings with Client & Dev team for any technical clarifications

11.Responsible to maintain Requirements Tracker & ensure updating the same on daily basis or Weekly basis for project status reporting to Management

12.Responsible to maintain Work Tracker on BRD, FSD, Prototype or any other document & ensure updating the same on daily basis or Weekly basis for status reporting to Management

13.Validating the requirements as per BRD, SRS, FSD or Prototype or any other business document & ensure the readiness of the system.

14.Responsible for requirements verification – Functional or Regression Testing (if necessary)

15.Preparation of Release Notes & sharing the same with Client.

16.Handing over the user manuals

17.Regular follow-ups with Dev Team on pending tickets or issues raised by Client team.

18.Answering Request for Proposal (RFP) & Request for Information (RFI).

19.Preparation of Solution Approaches (applicable for New & Maintenance projects), Proposal Document (Applicable for Maintenance projects).

20.Preparation of Business Presentations (Power-Point Presentations) or Project Status Meeting presentations.

21.Preparation of Brochures

22.Responsible to answer Magazine or Interview Questions shared by Media