10/13/2026 updated

**** ******** ****
100 % available

Senior Data Engineer

Dublin, Ireland
Only remote
B.Tech in Computer Science
Dublin, Ireland
Only remote
B.Tech in Computer Science

Profile attachments

Pavan_Dendukuri .pdf

Data WarehousingMicrosoft Power BIAzure Data LakeSQL DatabasesAzure Data FactoryPySparkDatabricks
Business & Data Analysis
Requirements gathering, functional and technical documentation, KPI definition, root-cause analysis, and data quality and governance across Healthcare, Insurance, and Payroll domains.

BI & Reporting with Power BI
Design and delivery of interactive Power BI dashboards, DAX-based data modeling, SSRS reporting suites, and ad-hoc as well as executive reporting solutions to support management decision-making.

Cloud & ETL Architecture
Design, build, and optimization of automated data pipelines and ETL workflows using Azure Data Factory, Azure Databricks, Azure Data Lake Storage Gen2, PySpark, and Spark SQL to ensure strict data integrity.

Microsoft SQL Server & T-SQL
Design, maintenance, and optimization of complex T-SQL queries, stored procedures, database architectures, and performance tuning to support critical business reporting systems.

Azure Databricks & PySpark
Authoring and scheduling of automated Databricks notebooks using PySpark and SQL to transform large datasets into actionable reporting models and stakeholder metrics.

Data Warehousing
Design and maintenance of centralized data warehouse structures, improving data accessibility and operational reporting turnaround across enterprise environments.

Agile & Project Methodologies
Application of Agile and Scrum methodologies, Jira for project tracking, Azure Repos and Git for version control, and data validation and testing practices.

Data Cleansing & Validation
Implementation of rigorous data cleansing, validation, and profiling frameworks to significantly improve data accuracy across enterprise payroll and healthcare systems.

SSRS Reporting
Development of operational and executive reporting suites using SSRS, including automated job scheduling, data subscriptions, and report distribution.

Experience

Professional experience10+ years
Freelancer since2026

Languages

EnglishNative speaker

Project history

Senior Business Information Analyst / Senior Data Engineer

Optum
Partnering with healthcare business stakeholders to elicit, define, and translate complex reporting needs and business logic into scalable data and analytical solutions. Leading the design and maintenance of centralized data warehouse structures. Designing, building, and optimizing automated data pipelines and ETL workflows using Azure Data Factory and Azure Databricks. Authoring and scheduling automated Databricks notebooks (PySpark/SQL) to transform healthcare datasets into actionable reporting models. Conducting root-cause analysis on data discrepancies, reporting variances, and pipeline performance bottlenecks.

Business Analyst / Data Engineer

ADP
Interfacing directly between business users and technical teams to gather business requirements, formulate technical specifications, and standardize reporting KPIs. Implementing rigorous data cleansing, validation, and profiling frameworks. Designing and deploying ETL pipelines via Azure Data Factory to extract and transform on-premises legacy data into Azure Data Lake Gen2. Utilizing PySpark and Spark SQL to analyze massive customer usage datasets. Delivering interactive Power BI dashboards and operational reporting solutions to support management decision-making.

Senior Member Technical (Database & Reporting Specialist)

ADP
Designing, maintaining, and optimizing database architectures, complex T-SQL queries, and stored procedures supporting critical business reporting systems. Developing operational and executive reporting suites using SSRS, managing automated job scheduling, data subscriptions, and report distribution. Performing deep-dive SQL query execution plan analysis and database indexing. Maintaining detailed documentation tracking data dictionaries, KPI definitions, and ETL mapping logic.

Member Technical

Broadridge Financial Solutions
Engaging with business clients to evaluate existing documentation and gather functional requirements for financial reporting systems. Creating, testing, and optimizing complex T-SQL queries, stored procedures, and triggers for database-backed reporting. Constructing comprehensive test cases and execution scripts for end-to-end database testing and data validation.

Data Engineer

Tripod Software Solutions
Collaborating with cross-functional teams to translate business requirements into relational database models and reporting views. Building optimized staging views and T-SQL routines to streamline ETL and analytical data processing.

Contact form

Log in to get in touch

You need to be logged in to use the contact form.

Sign upLog in