Data Solutions Designer
Job Location:
Monthly Salary:
Posted:
Application Deadline:
Vacancies:
Job Summary
CoreFactor is searching for a Data Solutions Designer on full-time/permanent basis for a client in the GTA.
This role is hybrid and will require the successful incumbent to go into the office four (4) times per week in downtown Toronto.
Our client is seeking a Data Solutions Designer to join their Data Analytics & AI team in shaping data-driven solutions that enable investment insights operational efficiency and client reporting across our asset management business.
In this role you will help design and guide the implementation of end-to-end data flowsfrom source systems through to final consumption by business intelligence platforms data science models and third-party consumers. This includes contributing to platform architecture data modeling and solution review across a modern stack.
Youll collaborate with data engineers analysts quants and business stakeholders to ensure that data solutions are well-architected secure scalable and aligned with the needs of a fast-paced regulated industry.
Key Responsibilities:
- Design End-to-End Data Solutions
- Design robust data solutions supporting business intelligence data processes analytics and AI/ML initiatives.
- Develop technical flowcharts data flow diagrams (DFDs) and system interaction models to visualize and validate proposed data solution designs.
- Define data flows from ingestion through transformation storage and deliveryincluding real-time and batch patterns.
- Ensure solutions support both operational and analytical use cases (e.g. dashboards APIs external data delivery).
Collaborate Across Teams
- Partner with data engineering analytics and AI teams to evaluate and enhance solution designs.
- Provide guidance on architectural decisions platform capabilities and technology choices within our AWS and Snowflake-based ecosystem.
Modeling & Metadata
- Design logical and physical data models to support various levels of reporting and analysis.
- Partner with Data Governance to help promote standards for metadata documentation and lineage tracking using tools like Alation DBT and Tableau Data Catalogs.
Platform & Governance Alignment
- Ensure all designs align with platform standards data governance policies and regulatory requirements relevant to asset management.
- Contribute to improving data product delivery patterns reusability and performance optimization.
Review & Influence
- Review proposed solution designs and challenge approaches to ensure strategic alignment maintainability and fit-for-purpose outcomes.
- Act as a thought partner in refining how we deliver data analytics and AI capabilities to the business.
- Bachelors degree in Computer Science Information Systems Data Science Engineering or a related field (required).
- Masters degree in Data Analytics Information Systems or Financial Engineering (preferred).
- Relevant certifications (e.g. Snowflake AWS dbt TOGAF) are a plus.
- 5 years of experience in data architecture/data solution design or data engineeringpreferably within financial services or asset management
- Strong understanding of data platforms and architecture including experience with:
- Snowflake for cloud data warehousing
- AWS for cloud services and data pipelines
- dbt for transformation and documentation
- Demonstrated experience designing data flows and models to support BI reporting and/or AI/ML use cases.
Required Skills:
Do you have the skills that will enable you to succeed in this role You have 10 or more years of software development experience (conceptualization design development and debugging) with at least two years of experience as a technical lead providing hands-on architectural design for software applications with an understanding of design patterns such as MVVM MVC Clean Architecture Sound technical knowledge with: Java J2EE Web Services (REST & SOAP) Angular 8() Java Script Spring Boot (Micro Services) You have experience with unit-testing code for robustness security usability and improving performance of the overall application You have a proficient understanding of code versioning tools such as Git Strong command in Computer Science concepts (SOLID etc.) Experience in integrating Third Party libraries and SDKs Experience building applications that consume web services and HTTP REST interaction with JSON Strong problem solving abilities Evaluate new technologies and participate in the continuous improvement of applications and systems Youre passionate about well-designed products and not afraid to sit with our Design Team to prototype wireframe and white-board your ideas
