SQL DBA , Tableau and Python developer 3-5 years of exp

About the Role

We are looking for a skilled Python Developer with hands-on experience in building and consuming API's, designing database schemas, and integrating data pipelines that support visualization in Tableau. The ideal candidate will have a strong foundation in Python development, database design and API integration, with an added advantage of working knowledge of Tableau for data visualization. 

Key Responsibilities

• API Development & Integration
  1. Design, develop, and maintain RESTful APIs using Python frameworks (e.g., FastAPI, Flask, or Django).
  2. Consume third-party APIs and integrate them with internal systems.
  3. Optimize data storage and retrieval mechanisms for performance and scalability.
  4. Ensure API performance, security, and scalability.
  5. Implement data validation and quality checks to ensure accuracy and consistency
• Database Modeling & Architecture 
  1. Design and implement relational database schemas (PostgreSQL, MySQL, or similar).
  2. Write optimized SQL queries, stored procedures, and triggers.
  3. Evaluate and implement data storage solutions, including relational databases, NoSQL databases, data lakes, and cloud storage services.
  4. Design, implement, and optimize end-to-end data pipelines for ingesting, processing, and transforming large volumes of structured and unstructured data.
  5. Manage ETL (Extract, Transform, Load) processes to store and prepare data for analytics.

• Data Deployment & Visualization
  1. Deploy API data into structured databases.
  2. Prepare datasets for visualization in Tableau. 
  3. Collaborate with data analysts/BI teams to ensure smooth integration between data and Tableau dashboards.
• Collaboration & Best Practices
  1. Work with cross-functional teams (Data, DevOps, BI) to deliver endt-to-end solutions.
  2. Follow coding standards, version control (Git), and CI/CD pipelines.
  3. Document technical designs, workflows, and best practices to facilitate knowledge sharing and maintain system documentation.

Required Skills & Qualifications

• Bachelor's degree in Computer Science, Engineering, Information Systems, or related field. Master's degree preferred.
• Proficiency in programming languages commonly used in data engineering (e.g., Python, Java, Scala, etc.).
• Strong knowledge of Python programming and frameworks for API development.
• Experience in API consumption and integration. 
• Hands-on experience in relational databases (PostgreSQL, MySQL, or similar) including schema design and query optimization.
• Understanding of ETL processes and data pipeline development.
• Familiarity with deployment best practices and Git-based workflows.

Good to Have

• Basic experience with Tableau (creating simple dashboards or understanding Tableau data sources). 
• Exposure to cloud platforms (AWS, GCP, or Azure).
• Knowledge of containerization (Docker, Kubernetes).
• Understanding of data security and API authentication standards (OAuth, JWT).
• Certification on any core product skills 

Soft Skills

• Strong problem-solving ability and attention to detail.
• Excellent communication skills to work with both technical and non-technical stakeholders.
• Ability to work independently as well as part of collaborative team.