Data Architect/Technical Consultant Data & Analytics who can work with customers and teams (local/remote), lead technical or business discussions, provide technical guidance to clients and team members delivering initiatives. Must have been in an Architect/Consultant/Engineer role, led the design/implementation of several complex data-oriented solutions on Azure Data Platform with multiple integrations and reporting needs. Experience in On Prem and other Cloud Data technologies will be helpful. This role is a combination of solutioning, consulting, hands-on experience. Envision, design, and implement the technical solution working with customer and internal technical team. Lead multiple Data, analytics projects providing design/implementation guidance to teams. 15 years of IT experience, 10 years of experience in architecture and design of highly scalable, performance, resilient data and analytical solutions.
Modern Data Platform:
- Must have worked on several (5+) projects building solutions for Data Pipelines, Data warehousing, Data Modelling on Azure Data Platform (AWS, GCP - good to have)
- Expertise in design and development of Data pipelines and ETL using ADF, Databricks to move data from relational/structured/unstructured data from source to data lake to data warehouse, on Azure
- Creating Pipelines and integrations of multiple data sources
- Data processing and transformation using Databricks (Scala/Python)
- Expertise in optimizing cost and performance of data pipelines
- Experience working with Data Lake, Synapse on Azure
- Designing Data Lake storage layer (Landing/staging, raw, trusted/curated zones)
- Designing data storage DB schema, data models and processing on Azure Synapse DW
- Experience with Synapse Spark Pool
- Experience in Data Modelling
- Building Data Models from structured and semi-structured data (Data Model, Common Data Model etc.)
- Performance optimization of data model for high performance analytical and reporting workloads
- Expertise with SQL Server and extensive experience with SQL programming
- Programming and optimizing DB objects Views, Stored Procs, Functions
- Good experience in defining data access policy and security for Azure Data services
- Experience with Oracle EDW, knowledge/experience migrating from Oracle EDW to any Cloud DW
- Experience integrating AI skills/Client models with Data and reporting solutions
- Experience in building API layer for downstream consumption
- Expertise in building scalable high performance reporting solution using Power BI, in both shared and dedicated capacity
- Designing Reports against Cloud and On-Prem data sources
- Performance analysis and optimization of slow performing reports/visuals
- Import models and Direct Query; Experience working with Power BI Paginated reports
- Expertise in integrating Power BI reports with custom applications using Power BI Embedded or Premium
- Building data models in Power BI, Hands-on with DAX
- Migrating reports from Tableau to Power BI