Support and maintain end-to-end data processing and reporting.
This role involves overseeing Power BI refreshes, SSRS reports, ADF jobs, SQL and Python workflows, Snowflake integration, and ETL processes, with a strong focus on data validation, error resolution, and continuous improvement.
The ideal candidate should have excellent troubleshooting skills.
Skills:
Work closely with stakeholders, such as data analysts, BI teams, and business users
Azure Cloud ADF, Power Automate, LogicApps, Power BI, SSRS, ADF, SQL, Python, and Snowflake
Experience with data validation, quality control, and troubleshooting data errors
Strong analytical and problem-solving skills
As this is a client facing role, should have excellent verbal and written communication skills, with the ability to convey technical information to stakeholders effectively
Key responsibilities.
ADF Pipeline Management and Support: Troubleshoot Azure Data Factory (ADF) jobs, addressing pipeline failures and optimizing performance
SQL Job and ETL Process: Support SQL job execution and ETL processes, ensuring data transformations and loading activities run smoothly and meet business needs.
Power BI Refresh and SSRS Report Support: Manage and monitor Power BI refreshes and SSRS reports. Troubleshooting refresh or report generation issues to maintain data accuracy in reporting.
Python Process Execution and Monitoring: Execute and monitor Python scripts process, addressing errors, optimizing performance, and ensuring data flows accurately through the pipeline
Snowflake Data Integration and Maintenance: Manage Snowflake data loads, maintain data consistency and troubleshoot availability or performance issues.
Error Detection and Preventive Actions: Proactively identify, diagnose, and resolve data errors or issues; implement preventive measures and improvements to enhance operational efficiency.
