onsite
Data Architect / Data Modeler - ascentt
Software Engineer
Lead the design and implementation of enterprise data architecture, crafting robust data models and pipelines using SQL, NoSQL, ETL tools, Python, and AWS services to enable scalable analytics and reporting.
About the role
Key Responsibilities
- Design, develop, and maintain enterprise data models and schemas across relational and NoSQL databases.
- Architect and optimize ETL pipelines to ingest, transform, and load data into data warehouses and lakes.
- Collaborate with data engineers, analysts, and business stakeholders to translate business requirements into technical specifications.
- Ensure data quality, consistency, and governance through validation rules, lineage tracking, and metadata management.
- Leverage AWS services (Redshift, S3, Glue, Athena) to build scalable, cost‑effective data solutions.
- Document architecture, processes, and best practices for future maintenance and onboarding.
Requirements
- 5+ years of experience in data architecture, modeling, and ETL development.
- Proficiency in SQL, Python, and experience with both relational (PostgreSQL, MySQL) and NoSQL (MongoDB, DynamoDB) databases.
- Hands‑on experience building data pipelines on AWS (Glue, Redshift, S3, Athena).
- Strong understanding of data warehousing concepts, dimensional modeling, and performance tuning.
- Excellent communication skills and ability to work cross‑functionally in a fast‑paced environment.