
Data Architect
3 weeks ago
3 days ago Be among the first 25 applicants
We are seeking an experienced Data Architect to join our team and lead the design, implementation, and maintenance of our enterprise data architecture. The ideal candidate will have extensive experience in creating robust data models, ensuring data integrity, and implementing scalable database solutions using SQL and Python. This role requires a strategic thinker who can translate business requirements into technical data solutions while maintaining the highest standards of data quality and governance.
- Design and develop conceptual, logical, and physical data models that support business objectives and ensure scalability
- Create and maintain enterprise data architecture blueprints, including data flow diagrams and entity-relationship diagrams
- Establish data modeling standards and best practices across the organization
- Develop dimensional models for data warehousing and business intelligence initiatives
We are seeking an experienced Data Architect to join our team and lead the design, implementation, and maintenance of our enterprise data architecture. The ideal candidate will have extensive experience in creating robust data models, ensuring data integrity, and implementing scalable database solutions using SQL and Python. This role requires a strategic thinker who can translate business requirements into technical data solutions while maintaining the highest standards of data quality and governance.
Data Architecture & Modeling
- Design and develop conceptual, logical, and physical data models that support business objectives and ensure scalability
- Create and maintain enterprise data architecture blueprints, including data flow diagrams and entity-relationship diagrams
- Establish data modeling standards and best practices across the organization
- Develop dimensional models for data warehousing and business intelligence initiatives
- Implement and maintain database integrity constraints, including primary keys, foreign keys, unique constraints, and check constraints
- Design and implement data validation rules and quality checks using SQL and Python
- Develop automated data quality monitoring systems and exception handling processes
- Create and maintain database performance optimization strategies, including indexing and partitioning schemes
- Write complex SQL queries, stored procedures, and functions for data transformation and analysis
- Develop Python scripts for data pipeline automation, ETL processes, and data quality validation
- Design and implement data integration solutions across multiple platforms and systems
- Build reusable Python libraries and SQL templates for common data operations
- Establish and enforce data governance policies and procedures
- Define data retention, archival, and purging strategies
- Implement data security measures and access controls
- Maintain comprehensive documentation of data models, dictionaries, and lineage
- Partner with business stakeholders to understand data requirements and translate them into technical solutions
- Mentor junior team members on data modeling techniques and best practices
- Collaborate with development teams to ensure proper implementation of data structures
- Lead data architecture review sessions and provide technical guidance
Experience
- Minimum 7-10 years of hands-on experience in data architecture, data modeling, and database design
- Proven track record of designing and implementing enterprise-scale data solutions
- Extensive experience with both transactional (OLTP) and analytical (OLAP) systems
- Demonstrated success in managing data integrity in complex, high-volume environments
- SQL Expertise : Advanced proficiency in SQL, including:
- Complex query optimization
- Stored procedures, functions, and triggers
- Performance tuning and query plan analysis
- Experience with multiple SQL databases (e.g., PostgreSQL, MySQL, Oracle, SQL Server)
- Python Proficiency : Strong programming skills in Python, including:
- Data manipulation libraries (pandas, NumPy)
- Database connectivity (SQLAlchemy, psycopg2, pymongo)
- ETL frameworks (Apache Airflow, Luigi)
- Data quality and validation frameworks
- Data Modeling : Expert-level knowledge of:
- Dimensional modeling (star schema, snowflake schema)
- 3NF and denormalization techniques
- Data vault methodology
- Modern data modeling tools (e.g., ERwin, PowerDesigner, dbdiagram.io )
- Bachelor's degree in Computer Science, Information Systems, or related field (Master's preferred)
- Experience with cloud data platforms (AWS, Azure, GCP)
- Strong understanding of data warehousing concepts and methodologies
- Knowledge of big data technologies (Hadoop, Spark) is a plus
- Excellent problem-solving and analytical skills
- Strong communication skills with ability to explain technical concepts to non-technical stakeholders
- Professional certifications (e.g., CDMP, AWS Certified Data Analytics, Azure Data Engineer)
- Experience with NoSQL databases (MongoDB, Cassandra, Redis)
- Knowledge of data streaming technologies (Kafka, Kinesis)
- Familiarity with data catalog and metadata management tools
- Experience with DataOps and MLOps practices
- Understanding of regulatory compliance requirements (GDPR, CCPA, HIPAA)
- Competitive salary commensurate with experience
- Comprehensive benefits package
- Opportunity to work on cutting-edge data architecture projects
- Professional development and certification support
- Collaborative and innovative work environment
To Apply : Please submit your resume highlighting your data modeling experience, along with examples of complex data architectures you've designed and implemented. Include specific examples of how you've used SQL and Python to ensure data integrity and solve challenging data problems.
Seniority level- Seniority levelNot Applicable
- Employment typeFull-time
- Job functionEngineering and Information Technology
- IndustriesSoftware Development
Referrals increase your chances of interviewing at 1 Sol Digital Services (SMC) Pvt Ltd. by 2x
Get notified about new Data Architect jobs in Karāchi, Sindh, Pakistan.
Karachi Division, Sindh, Pakistan 3 months ago
Karachi Division, Sindh, Pakistan 6 hours ago
Senior Data Scientist - GenAI & Agentic SystemsFull Stack Engineer – Data SaaS PlatformKarachi Division, Sindh, Pakistan 2 months ago
We're unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr-
Data Architect
2 weeks ago
Karachi, Sindh, Pakistan Remotiv Full timeData Architect (Snowflake & BI)At Remotiv, we're connecting people worldwide. We connect talented people with businesses.*Hiring for one of our clients -Workplace type: OnsiteData Architect (Snowflake & BI) (Pakistan) – Join Our Client TeamWe are seeking an experienced Data Architect (Snowflake & BI) to lead data modeling, transformation, and business...
-
Data Architect
3 weeks ago
Karachi, Sindh, Pakistan HR Ways - Hiring Tech Talent Full time2 days ago Be among the first 25 applicantsDirect message the job poster from HR Ways - Hiring Tech TalentTalent Acquisition Specialist | Technical Recruiter| Placement & Acquisition | Hiring Tech Talent for 300+ CompaniesAbout the job Data Architect (On-site)A Leading US-based web solutions company is hiring a Data Architect for its Karachi office.As a Data...
-
Data Architect
2 weeks ago
Karachi, Sindh, Pakistan 1 Sol Digital Services (SMC) Pvt Ltd. Full time3 days ago Be among the first 25 applicantsGet AI-powered advice on this job and more exclusive features.Timings: 6 PM – 3 AM PKTExperience: 8+ yearsSalary: PKR 400,000 – 700,000 (based on experience)Company: 1Sol Digital Services (SMC-Pvt) LtdPosition OverviewWe are seeking an experienced Data Architect to join our team and lead the design,...
-
Data Architect – Microsoft Fabric
22 hours ago
Karachi, Sindh, Pakistan Fineta Consulting Full timeData Architect – Microsoft Fabric (Remote, Full-Time)Data Architect – Microsoft Fabric (Remote, Full-Time)We are seeking a highly skilled and experienced Data Architect with expertise in Microsoft Fabric to join our team. This individual will play a pivotal role in the design, development, and management of modern data architectures, enabling us to...
-
Software Architect
2 weeks ago
Karachi, Sindh, Pakistan Astera Software, Inc. Full timeJob SummaryAs a Software Architect at Astera, you will play a crucial role in shaping the technical direction of our software solutions. Leveraging your deep knowledge of .NET and C#, you will lead the design and implementation of scalable and robust software architectures that align with our business objectives. This role involves collaborating with...
-
Solutions Architect
2 weeks ago
Karachi, Sindh, Pakistan Creative Chaos Full timeJob SummaryAs a Solutions Architect, you will be responsible for taking the business requirements and turning them into a software design that can become a blueprint for the implementation team to follow. You will also ensure that the implementation team follows the design and delivers the project as per the agreed designs.Duties and ResponsibilitiesA...
-
Enterprise Semantic Data Modeler
4 days ago
Karachi, Sindh, Pakistan beBeeData Full timeSenior Data ArchitectWe are seeking an experienced Senior Data Architect to play a critical role in designing, structuring, and maintaining enterprise-wide data models, ontologies, and semantic layers.The ideal candidate will have deep expertise in ontology modeling and hands-on experience with Palantir Foundry. They will be responsible for architecting...
-
Strategic Data Modeler
2 weeks ago
Karachi, Sindh, Pakistan beBeeDataArchitect Full timeJob TitleWe are seeking a skilled Data Architect to lead our enterprise data architecture initiative. The ideal candidate will have extensive experience in creating robust data models, ensuring data integrity, and implementing scalable database solutions using SQL and Python.Design and develop conceptual, logical, and physical data models that support...
-
Lead Cloud Data Solutions
15 hours ago
Karachi, Sindh, Pakistan beBeeData Full timeCloud Data ArchitectThe ideal candidate will possess a deep understanding of cloud data platforms, data engineering best practices, and strong architectural principles. This individual will play a pivotal role in the design, development, and management of modern data architectures.Key Responsibilities:
-
Senior Architect
2 weeks ago
Karachi, Sindh, Pakistan NorthBay Solutions LLC Full timeJob Title: Senior Architect (Application Development – AWS, Full Stack)Location: Lahore, Islamabad, Karachi (Hybrid)Company Overview:NorthBay Solutions (NBS) is a premier provider of cloud-native data and analytics solutions, committed to helping enterprises accelerate their digital transformation journeys. With a strong focus on AWS and modern...