Key skills
SQLPythonSnowflakeMongoDBPostgreSQLData EngineeringData ModellingAI-powered toolsGovernance frameworksTechnical certificationNoSQLAILLMAnalyticsdbt
About this role
AddSource is seeking a highly skilled Sr. Data Modeler / Data Engineer at a lead level with expertise in SQL, Python, and cloud data platforms like Snowflake. The role involves designing and building high-performance data models, developing scalable data pipelines, and ensuring data governance and compliance.
Responsibilities:
- Analytical Data Modelling: Design and build clean, high‑performance data models by transforming raw and unstructured data from MongoDB and PostgreSQL into optimized, analytics‑ready tables
- Data Engineering & Development: Work extensively with SQL, Python, Snowflake, dbt, MongoDB, and PostgreSQL to develop scalable data pipelines and transformation workflows
- Data Integration: Integrate datasets from diverse environments, ensuring seamless ingestion, harmonization, and modelling of data originating from both SQL and NoSQL systems
- Governance, Security & Compliance: Handle sensitive and regulated datasets in environments requiring GDPR and SOC2 compliance. Implement strong MDM, maintain data lineage, and uphold best practices in data governance
- AI‑Driven Optimization: Leverage AI/LLM tools within the development lifecycle to enhance efficiency, automate repetitive tasks, and optimize system performance
Requirements:
- 10+ Years of experience
- Expert-level proficiency in SQL and Python
- Hands-on experience with Snowflake, dbt, MongoDB, and PostgreSQL
- Proven ability to convert raw, multi-source data into high-quality analytical assets
- Strong understanding of governance, privacy frameworks, and sensitive data controls
- Capability to apply AI-powered tools to improve development workflows
- Engineering Degree – BE/ME/BTech/MTech/BSc/MSc
- Technical certification in multiple technologies is desirable