The Data Analyst / BI Developer will design and develop scalable reporting solutions using Power BI and SQL, optimize ETL processes with SSIS, and ensure efficient data management and validation.
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 DescriptionJob 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
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
Top Skills
Power BI
Python
SQL
SQL Server
Ssis
Sutherland Chennai, Tamil Nadu, IND Office
Gateway office Parks,, A6, 6th Floor, A1, GF, 5th,6th & 7th , B2 block, # 16, GST Road, Perungalathur,, , Chennai, TN , India, 600063
Sutherland Tambaram, Tamil Nadu, IND Office
GST Road, Tambaram, Tamil Nadu, India, 600045
Similar Jobs
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
The Corporate Account Executive will drive new business opportunities in AP & Telangana, engage customers, manage sales processes, and collaborate with teams to meet targets.
Top Skills:
Cloud-Native Security PlatformsCybersecurityEndpoint Detection And Response (Edr)SaaS
Cloud • Security • Software • Cybersecurity • Automation
Lead regional marketing initiatives for GitLab in India, focusing on integrated campaigns, data analysis, budget management, and collaboration with sales and cross-functional teams.
Top Skills:
Crm ToolsMarketing AutomationMarketoSalesforce
Artificial Intelligence • Edtech • Mobile • Natural Language Processing • Productivity • Software
The Software Development Engineer III will lead projects, mentor engineers, and drive engineering excellence focusing on web technologies and AI integrations.
Top Skills:
Node.jsPythonReactTypescript
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
