Skip to content
Sr. Specialist – Data Architecture
| Company | MSD |
|---|
| Location | Linden, NJ, USA |
|---|
| Salary | $114700 – $180500 |
|---|
| Type | Full-Time |
|---|
| Degrees | Bachelor’s |
|---|
| Experience Level | Senior |
|---|
Requirements
- Bachelor’s degree in computer science or equivalent experience
- 5+ years of experience in data architecture, data modelling or related roles
- Proven experience as a Data Architect or in similar role
- Proficiency in data modelling, metadata management and database design
- Strong understanding of database systems (SQL, NoSQL, Open format – Delta tables, Hudi, Iceberg)
- Experience with cloud platforms – AWS, Azure
- Hands-on experience with modern Data Lake technologies (Databricks, Redshift)
- Hands-on experience with ETL/ELT Tools (Matillion, dbt, Informatica IDMC and Databricks – pyspark, SQL)
- Strong Analytics and problem-solving skills
- Experience with data warehousing concepts and technologies
- Knowledge on data governance, data quality and data lineage
- Excellent analytics and problem-solving skills
- Effective communication, collaboration, and documentation skills
- Growth mindset – thrive on experimenting with emerging AI technologies, continuous learning, innovation and derive best practices
- Proven expertise in designing and implementing scalable Data Mesh and Data Fabric Architectures across modern data ecosystem
- Expertise in leveraging storytelling techniques to transform data insights into compelling narratives that drive decision making and strategic actions
Responsibilities
- Design and maintain robust scalable, and efficient data models and architecture
- Develop and document data flows and integration strategies
- Develop, implement and maintain conceptual, logical and physical data models
- Optimize database designs for performance, scalability and flexibility
- Validate data Architecture to ensure they meet all functional and non-functional requirements
- Design ETL/ETL process to enable seamless integration of diverse data sources
- Collaborate with developers to integrate data architecture with applications and systems
- Work with cross-functional team to understand the business needs and translate them into technical requirements
- Partner with data engineers, analysts, and business stakeholders to optimize data solutions
- Educate staff members through training and individual support
- Publish and present technical papers to external audiences and participate in significant internal publications, sharing new ideas and knowledge
- Evaluate and recommend technologies, tools, and platform to enhance the organization data capabilities
- Stay updated on Industry Trends and emerging technologies
- Establish and enforce data architecture best practice and standards
- Ensure data Architecture, data Models, Data Integration comply with Data governance & standards
- Monitor and optimize performance of data storage layer, scalability
- Implement strategies for improving data accessibility and query efficiency
Preferred Qualifications
- Relevant certifications such as AWS , TOGAF, Certified data management/Architect professional are a plus and will be considered a strong advantage
- Knowledge in Machine Learning – Lifecycle management, feature engineering , data processing, pipelines, and Operations
- Knowledge in using next Gen – AI techniques in Data Architecture and Data modelling
