The role involves designing and implementing scalable data models using Data Vault techniques on Azure. Responsibilities include collaborating with stakeholders, optimizing data vault models, ensuring data security, and documenting data processes.
Job Description:
We are seeking a skilled Sr. Data Modeler to join our team and contribute to the design and implementation of scalable and efficient data models. The ideal candidate will have experience with Data Vault techniques, proficiency in Cloud Azure, and good to have working knowledge with Databricks.
Responsibilities:
- Data Modeling:
- Design and develop data models using Data Vault methodologies to ensure robust, scalable, and flexible data architectures.
- Create and maintain conceptual, logical, and physical data models to support business requirements.
- Collaborate with stakeholders to understand data requirements and translate them into effective data models.
- Implement best practices for data modeling, including normalization, denormalization, and data integration.
- Data Vault Implementation:
- Utilize Data Vault techniques to build enterprise data lake and lake house and integrate disparate data sources.
- Design and implement Hubs, Links, and Satellites to ensure comprehensive data capture and historical tracking.
- Optimize data vault models for performance and scalability.
- Cloud Azure:
- Design and deploy data models on Azure Data Services, including Azure SQL Database, Azure Data Lake, and Azure Synapse Analytics.
- Ensure data security, compliance, and best practices in Azure environments.
- Collaboration and Communication:
- Work closely with data engineers, data scientists, and business analysts to understand data needs and ensure data model alignment.
- Provide technical guidance and support on data modeling best practices and Data Vault principles.
- Document data models, data flows, and integration processes clearly and comprehensively.
- Data Modelling tools Azure:
- Data analysis and modeling tools (e.g. Power Designer, ERWin, ER/Studio)
Requirements:
- Bachelor’s degree in Computer Science, Information Systems, or a related field (Master’s degree preferred).
- Proven experience in data modeling, with a strong focus on Data Vault techniques.
- Proficiency in Cloud Azure services, including Azure Data Lake, Azure SQL Database, and Azure Synapse Analytics.
- Understand/Knowledge with Databricks and its ecosystem.
- Strong understanding of data warehousing concepts, Data Lake house, ETL processes, and data integration techniques.
- Excellent analytical and problem-solving skills with attention to detail.
- Strong communication and collaboration skills to work effectively with cross-functional teams.
- Relevant certifications in Azure and Databricks are a plus.
Preferred Qualifications:
- Experience with additional cloud platforms (e.g., AWS, Google Cloud) is a plus.
- Knowledge of data governance and data quality principles.
- Experience with BI tools such as Power BI, Tableau, or Looker
Similar Jobs
Fintech • Software • Financial Services
Lead initiatives in data integration, engineering data solutions, building ML model pipelines, and coaching junior resources while ensuring high standards and best practices.
Top Skills:
Azure Data FactoryDatabricksPythonRSQLSynapse
Blockchain • Fintech • Mobile • Payments • Software • Financial Services
Lead the global Technical Account Management team for Cash App Pay, Afterpay, and Clearpay, driving merchant growth and retention through technical partnerships and strategic initiatives.
Top Skills:
APIsE-Commerce PlatformsPayments Infrastructure
Blockchain • Fintech • Mobile • Payments • Software • Financial Services
The role involves supporting integration and sales of Square's Developer Platform, collaborating with partners, and advising on solutions for sellers.
Top Skills:
Full-Stack DevelopmentRestful ApisSaaS
What you need to know about the Ottawa Tech Scene
The capital city of Canada and the nation's fourth-largest urban area, Ottawa has proven a rapidly growing global tech hub. With over 1,800 tech companies, many of which are leaders in their sectors, the city's tech talent now makes up more than 13 percent of its total workforce. This growth is driven not only by the big players like UL Solutions and Dropbox, but also by a thriving startup ecosystem, as new businesses emerge to follow in the footsteps of those that came before them.
