Lead data architecture, modeling, and governance to optimize data flows in complex environments.Design and implement ETL processes with advanced techniques for data capture and performance.Develop and optimize SQL queries; extensive use of SSAS, SSIS, and SSRS within the MS SQL stack.Build and maintain data warehouses supporting BI and analytics solutions.Deploy data solutions on Azure, leveraging Azure Analysis Services (AAS) and DevOps pipelines for CI/CD.Create dynamic Power BI dashboards and reports for real-time insights.Troubleshoot and resolve technical issues, ensuring high data quality and performance.

Develop and optimize ETL pipelines using Azure Data Factory, SSIS, and integrate with Data Warehouse environments for efficient data flow.Assemble and manage large, complex data sets from multiple sources, ensuring alignment with business requirements.Automate workflows and optimize data infrastructure to enhance delivery and scalability.Build and maintain Power BI dashboards and SSRS reports, providing actionable insights.Partner with cross-functional teams to resolve data-related issues and support the data infrastructure, including the Data Warehouse.

Perform data cleansing and analysis using MS SQL and Hive HQL from primary and secondary data sources.Develop Power BI reports and dashboards for executive leadership to communicate trends, patterns, and predictions.Write complex Stored Procedures, scripts, and SQL queries for data processing and analysis.Work with business users and technical teams to evaluate new features and architecture, solving scalable problems with guidance from senior team members.Enhance data quality across pipelines and support the implementation of system controls.

Collaborate with business stakeholders to design and implement BI solutions. Design Data Warehouse architecture and data models (Star/Snowflake) from heterogeneous OLTP sources, including Slowly Changing Dimensions and incremental loading.Build and deploy ETL pipelines using SSIS to integrate data from sources like Excel, CSV, SAP-BW, MS Dynamics CRM, Salesforce, Oracle, Azure DB, and Web.Develop Power BI dashboards and SSRS reports to provide business insights.Write complex SQL queries, stored procedures, and DAX queries for advanced data analysis and business logic.Create and deploy SSAS Tabular models, optimizing queries and implementing Dynamic Row-Level Security in Power BI.

Use SQL and Datorama (Salesforce tool) for data processing and visualization. Extract insights from APIs and ad-servers using Datorama and SSIS.Create data visualizations and reports with Datorama and SSRS.Write complex SQL queries, stored procedures, and scripts for data analysis and integration.Work with internal and external BI teams to develop databases and dashboards.Build and maintain reports, dashboards, KPIs, and metrics to track campaign performance.

Develop and maintain robust Database Management Systems and ETL frameworks to streamline data integration and transformation.Design and implement ETL packages/pipelines in SSIS, integrating data from diverse sources.Build complex SQL queries, stored procedures, and scripts for optimized data retrieval and manipulation.Utilize VB and Python for web scraping and automation of data extraction workflows.Conduct data mining to uncover insights that drive strategic business decisions.Design tailored SSRS reports for actionable, data-driven insights.Automate recurring processes to improve efficiency and data quality.Document detailed process flows and technology interfaces to ensure seamless operations.