Data Solutions Architect

INSTITUTE OF MNGT

2h

About The Position

The Data Solutions Architect will have deep expertise in modern data platforms, system integrations, and large-scale data migrations. This role blends hands-on engineering with architectural leadership, requiring someone who can design, modernize, and optimize enterprise data ecosystems while partnering closely with business and technical stakeholders.

The ideal candidate has extensive experience building medallion-style data platforms, leading migrations to cloud-native analytics solutions, and creating reusable, meta-driven frameworks that accelerate delivery and standardization.

Requirements

• 8+ years of experience in data engineering, software engineering, or analytics platforms
• Strong expertise with Databricks, PySpark, SQL Server, and Microsoft Fabric
• Proven experience designing data warehouses and implementing Medallion Architecture
• Hands-on experience with API development and integration (OData, GraphQL, REST)
• Experience leading data migration and platform modernization initiatives
• Proficiency with SSIS, Jupyter Notebooks, Power BI, and SQL performance tuning
• Background in building internal tools or frameworks using Python and/or .NET
• Ability to translate business needs into scalable technical solutions

Nice To Haves

• Consulting or client-facing experience, including technical workshops and architecture reviews
• Strong documentation and communication skills, with the ability to explain complex systems clearly

Responsibilities

• Design, build, and maintain scalable ELT/ETL pipelines using PySpark, SQL, and modern data platforms such as Databricks and Microsoft Fabric
• Implement and evolve Medallion Architecture (Bronze/Silver/Gold layers) to support both raw and curated data use cases
• Develop reusable notebooks, libraries, and common functions to improve performance, consistency, and developer velocity
• Perform performance tuning and optimization across pipelines, data models, and storage layers
• Design and implement data sharing APIs for internal and external consumption using OData, GraphQL, and REST
• Build dynamic, metadata-driven frameworks capable of consuming diverse API sources with varying authentication, schemas, and response formats
• Integrate data from heterogeneous sources including APIs, SQL Server, file systems, and third-party vendors
• Analyze legacy systems to understand existing business processes and data flows
• Lead and execute data and system migration initiatives, including platform modernization efforts
• Produce migration strategies, architectural artifacts, and technical documentation to support transformation programs
• Provide recommendations on platform selection and future-state architecture
• Design and maintain enterprise data warehouses, including star schemas, fact tables, and dimension tables
• Implement data mastering, curation, and transformation processes to support analytics and reporting
• Support BI and analytics use cases using tools such as Power BI
• Lead architectural design and requirements-gathering sessions with technical teams and business stakeholders
• Mentor and coach data engineers on best practices, coding standards, and emerging technologies
• Collaborate cross-functionally to improve development workflows, standards, and delivery processes
• Contribute to roadmap planning, technical estimates, and risk assessment

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level