PowerBI and SSIS developer at Sutherland Global Services UK Ltd

Hyderabad, Telangana, India -

Full Time

Start Date

Immediate

Expiry Date

28 Jun, 26

Salary

0.0

Posted On

30 Mar, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Power BI, SSIS, SQL, DAX, ETL, Data Modeling, SQL Server Agent, Data Warehousing, Python, Data Validation, Performance Optimization, Report Development, Troubleshooting, Data Cleansing, Transformation, Loading

Industry

IT Services and IT Consulting

Description

Company Description Sutherland is an experience-led digital transformation company. Our mission is to deliver exceptionally engineered experiences for customers and employees today, that continue to delight tomorrow. For over 37 years, we have cared for our clients' customers, delivering measurable results and accelerating growth. Job Description Job Title: Data Analyst / BI Developer Role Overview We are seeking a Data Analyst / BI Developer to design, develop, and maintain scalable reporting and data solutions. The ideal candidate will have strong expertise in Power BI, SQL, and ETL processes, with experience in automating workflows and optimizing data models for performance and reliability. Key Responsibilities Translate business-owned Excel reports into scalable Power BI dashboards, preserving logic while improving usability and performance Analyze and understand existing reporting logic, calculations, and data structures within Excel files and replicate them using DAX and data models Work closely with stakeholders to clarify metrics, definitions, and reporting expectations before implementation Develop and maintain Power BI datasets and reports that integrate data from multiple sources (SQL Server, Excel, etc.) Design efficient data models with proper relationships, measures, and performance optimization techniques Write and optimize SQL queries for data extraction, validation, and troubleshooting across data warehouse tables Demonstrate a strong understanding of data warehouse structures (fact/dimension tables) to ensure accurate reporting Build, modify, and maintain SSIS packages for ETL processes, including data cleansing, transformation, and loading Handle production support tasks such as debugging ETL failures, fixing data issues, and ensuring data consistency Configure and manage SQL Server Agent jobs for scheduling ETL pipelines and monitoring job execution Proactively identify and resolve failures or delays in scheduled jobs Set up and manage Power BI Service components, including: Scheduled refresh configurations On-premises data gateways setup and troubleshooting Managing data source connections and credentials Workspace and dataset administration Ensure reports and datasets refresh reliably by diagnosing and resolving gateway, credential, and connectivity issues Automate recurring data processing tasks (e.g., Excel data cleaning and consolidation using Python or other tools) Perform data validation and reconciliation between source systems, ETL outputs, and final reports Continuously optimize report performance, refresh times, and data pipeline efficiency Must-Have Skills Strong experience in Power BI (data modeling, DAX, report development) Advanced SQL skills (joins, CTEs, window functions, performance tuning) Hands-on experience with SSIS for ETL development Experience with SQL Server Agent for job scheduling and monitoring Solid understanding of data warehousing concepts (fact/dimension models) Ability to troubleshoot and optimize existing reports and ETL processes Good-to-Have Skills Exposure to Microsoft Fabric (Data Factory, Lakehouse, or Power BI integration) Experience with Python for data automation or preprocessing Familiarity with cloud data platforms (Azure preferred) Understanding of version control (Git) and deployment strategies Experience with reporting tools like Tableau (nice to have) Knowledge of performance optimization techniques in BI tools Qualifications Key Responsibilities Translate business-owned Excel reports into scalable Power BI dashboards, preserving logic while improving usability and performance Analyze and understand existing reporting logic, calculations, and data structures within Excel files and replicate them using DAX and data models Work closely with stakeholders to clarify metrics, definitions, and reporting expectations before implementation Develop and maintain Power BI datasets and reports that integrate data from multiple sources (SQL Server, Excel, etc.) Design efficient data models with proper relationships, measures, and performance optimization techniques Write and optimize SQL queries for data extraction, validation, and troubleshooting across data warehouse tables Demonstrate a strong understanding of data warehouse structures (fact/dimension tables) to ensure accurate reporting Build, modify, and maintain SSIS packages for ETL processes, including data cleansing, transformation, and loading Handle production support tasks such as debugging ETL failures, fixing data issues, and ensuring data consistency Configure and manage SQL Server Agent jobs for scheduling ETL pipelines and monitoring job execution Proactively identify and resolve failures or delays in scheduled jobs Set up and manage Power BI Service components, including: Scheduled refresh configurations On-premises data gateways setup and troubleshooting Managing data source connections and credentials Workspace and dataset administration Ensure reports and datasets refresh reliably by diagnosing and resolving gateway, credential, and connectivity issues Automate recurring data processing tasks (e.g., Excel data cleaning and consolidation using Python or other tools) Perform data validation and reconciliation between source systems, ETL outputs, and final reports Continuously optimize report performance, refresh times, and data pipeline efficiency Must-Have Skills Strong experience in Power BI (data modeling, DAX, report development) Advanced SQL skills (joins, CTEs, window functions, performance tuning) Hands-on experience with SSIS for ETL development Experience with SQL Server Agent for job scheduling and monitoring Solid understanding of data warehousing concepts (fact/dimension models) Ability to troubleshoot and optimize existing reports and ETL processes Preferred Experience Experience working in reporting-heavy environments (finance, operations, or analytics) Exposure to production support and handling live data pipelines Experience implementing automation solutions to reduce manual work Soft Skills Strong problem-solving and analytical thinking Ability to communicate insights to non-technical stakeholders Attention to detail and data accuracy Ability to manage multiple tasks and deadlines

Responsibilities

The role involves designing, developing, and maintaining scalable reporting and data solutions, primarily by translating complex Excel reports into Power BI dashboards and optimizing data models. Key tasks include building and maintaining Power BI datasets, writing optimized SQL queries, and developing SSIS packages for ETL processes.