Optisol Business Solutions - Senior Data Engineer - Python/SQL/ETL

Description :

- Translate business requirements into technical solution designs that span ingestion, transformation, and consumption layers.

- Take ownership of squad leadership, ensuring delivery velocity, code quality, and alignment with architecture best practices.

- Mentor L0s and L1s, offering technical direction and career guidance.

- Collaborate with pre-sales or solutioning teams to support client-facing discussions when required.

- Deliver production-grade ETL/ELT pipelines and cloud-native data solutions using specific technologies such as Azure, AWS, GCP, Python, SQL, PySpark, etc.

- Own data pipeline lifecyclefrom development to deploymentensuring robustness, performance, and maintainability.

- Engage with clients during interviews to demonstrate deep expertise and suitability for specific roles in long-term ODC/T&M engagements.

- Act as a specialist for targeted technologies where the organization has proven market traction.

Required Skills :

- Cloud Expertise : Strong hands-on experience in one or more cloud ecosystems (Azure/AWS/GCP).

- Programming : Advanced knowledge of Python and experience with data engineering libraries and frameworks.

- SQL Mastery : Proficient in advanced SQL, including CTEs, window functions, and tuning.

- Big Data : Working experience with Spark/PySpark for distributed data processing.

- ETL/ELT Design : Ability to create scalable data workflows and manage data movement efficiently.

- Data Architecture : Knowledge of data modeling (dimensional/star/snowflake) and storage best practices.

- Generative AI : Familiarity with integrating GenAI or LLM tools for data transformation, enrichment, or automation.

- DevOps & Version Control : Experience with Git, CI/CD pipelines, and agile delivery frameworks.

Preferred Qualifications :

- Demonstrate experience in leading technical teams or squads.

- Prior exposure to solutioning and architectural design in large-scale data programs.

- Strong client communication and stakeholder management abilities.

- Certifications in cloud/data engineering platforms (e.g., Azure Data Engineer, AWS Data Analytics).

- Understanding of data governance, security, and compliance (e.g., GDPR, HIPAA).

What We Offer :

- Opportunity to work in both solution-oriented and delivery-focused environments.

- Leadership and architecture ownership in Data & AI initiatives.

- Exposure to cutting-edge technologies, including Generative AI, cloud platforms, and modern data stacks.

- A culture of innovation, mentorship, and continuous learning.

- Competitive compensation and fast-track career growth opportunities.