Solutions Architect

The Solutions Architect, Data & Analytics will provide technical thought leadership and hands-on solutions design and direction for enterprise data solutions and products.

This includes medallion data architecture and dimensional modeling, near real time, streaming, and batch data ingestion and transformation pipelines / ELT, EDW and BI semantic layer design, orchestration, designing to enable advanced analytics (AI / ML).

Will have broad experience and deep understanding of data engineering with SQL and Python, DataOps / CICD practices, and Cloud platforms.

Extract, load, and transform technologies (dbt, Coalesce), enterprise data analytical compute and storage (e.g. Snowflake, Databricks), master data management (e.g. Boomi MDH), BI / reporting (e.g. Power BI), AI / ML (e.g. Snowflake, DataRobot), enterprise data catalog and governance are common technologies this role will architect within day to day.Responsibilities : Architecture and solutions design, blueprinting, and technical roadmap utilizing on-premise and Cloud technologies such as Microsoft, Azure Data Lake, Azure Data Factory, SSIS, SSRS, Power BI, Snowflake, and others as / when needed.Data integration, batch and near-real time, with Salesforce, Boomi, OutSystems, ERP, BPM, Azure RPA, and .

NET custom applications and systems.Ability to quickly grasp Business initiative, understand business process, and determine technical solution options that meet objectives.Collaborates with Enterprise Architecture to ensure solutions design supports overall enterprise architecture direction.Establishes best practices for the design, build, and support of on-premises and cloud applications.Researches and establishes technical, design, patterns, and tools best practices and standardizes across software engineering teams.Creates and reviews architecture, solution design, data and integration documents for delivery teams and Architecture Review Board.Brings modern concepts to the team such as data product thinking and strives for data delivery processes designed for agilityBuilds prototypes and / or assists software engineers with coding and troubleshooting both on-premises and cloud-based applications.Identifies / matures best practices Cloud and API-led designs, microservices, CI / CD, automated testing (regression and load), SCM / Release strategies, and critical operational support.Designs cloud cost optimization, forecasting, and monitoring and alertingRequirements : Minimum 12+ years of overall data & analytics experience, 5+ years of technical architecture, solution architecture and design, and dimensional data modeling.Minimum 7+ years of hands-on Data Management, Big Data, Master Data governance, and analytics solution design, development, and implementation experience that include Azure Data Lake, Azure Data Factory, Snowflake, SSIS, SSRS, and Power BI.2+ years of application architecture and development preferred.Minimum 5+ years of experience providing enterprise data warehouse / lakehouse development frameworks, methodologies, templates, tools, etc.

Technology experience and preference given to Microsoft Azure and Power BI, Snowflake, dbt, Coalesce, Boomi MDH.Hands-on experience with creating and executing data & analytics architecture solutions and design for enterprise initiatives, both on-premises and cloud sources, that include network, data & analytics platforms, and security.Understand and document business requirements, assess data needs, and define data strategies; analyze data assets, ensuring data integrity, security, and optimal performance.Comprehensive knowledge of IS / IT concepts across a broad spectrum which includes application development, service-oriented and event-driven architecture, and application integration.Lead the design and development of enterprise data models optimized for analytics including but not limited to dimensional modeling and ensuring the data is analytic ready, has integrity, scalability, and performance.Develop and maintain data standards, guidelines, and best practices for data architecture and governance.Hands on expert in writing and optimizing SQL and strong proficiency in PythonStrong understanding and experience executing data & analytics delivery lifecycle with methodologies such as Waterfall, Agile, DataOps, DevOps, etc.Experience with Enterprise Architecture or Data Modeling toolsets like Orbus and ER / Studio.Experience with Identity and Access Management (Active Directory, Active Directory Federation Services (ADFS), Lightweight Directory Access Protocol (LDAP), OpenID, OAuth, and Security Assertion Markup Language (SAML)) as well as RBAC design and implementation within enterprise data & analytics ecosystem.Extensive experience in designing, implementing, and deploying solutions on Cloud-based platforms, preference given to Azure, Snowflake, and Power BI.In-depth knowledge of architectural best practices, design patterns, governance and security principles.Deep understanding of networking concepts, such as virtual networks, subnets, network security groups, firewall, and load balancer.Solid experience with performance management, monitoring, logging, error-handling frameworks, and diagnostics / RCA.Proficient in Microsoft Azure Services such as Kubernetes, CI / CD, DevOps, App Services, Functions, Storage, SQL Database, Virtual Machines, CLI, PowerShell, Key Vault, and Power Automate.