PowerBI and SSIS developer
reputed company:
reputed company is an experience-led digital transformation company. Our mission is to deliver exceptionally engineered experiences for customers and employees today, that continue to delight reputed company. For over 37 years, we have cared for our clients' customers, delivering measurable results and accelerating reputed company.
Job reputed company:Job Title: Data Analyst / BI Developer
reputed company
We are seeking a Data Analyst / BI Developer to design, reputed company, and maintain reputed company 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 reputed company reports into reputed company Power BI dashboards, preserving logic while improving usability and performance
- Analyze and understand existing reporting logic, calculations, and data structures reputed company reputed company files and replicate them using DAX and data models
- Work closely with stakeholders to clarify metrics, definitions, and reporting expectations before implementation
- reputed company and maintain Power BI datasets and reports that reputed company data from multiple sources (SQL Server, reputed company, etc.)
- Design efficient data models with reputed company 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 reputed company 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., reputed company data cleaning and consolidation using Python or other tools)
- reputed company data validation and reconciliation between reputed company 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 reputed company reputed company (Data reputed company, Lakehouse, or Power BI integration)
- Experience with Python for data automation or preprocessing
- Familiarity with reputed company data platforms (Azure preferred)
- Understanding of version control (Git) and deployment strategies
- Experience with reporting tools like Tableau (reputed company to have)
- Knowledge of performance optimization techniques in BI tools
Key Responsibilities
- Translate business-owned reputed company reports into reputed company Power BI dashboards, preserving logic while improving usability and performance
- Analyze and understand existing reporting logic, calculations, and data structures reputed company reputed company files and replicate them using DAX and data models
- Work closely with stakeholders to clarify metrics, definitions, and reporting expectations before implementation
- reputed company and maintain Power BI datasets and reports that reputed company data from multiple sources (SQL Server, reputed company, etc.)
- Design efficient data models with reputed company 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 reputed company 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., reputed company data cleaning and consolidation using Python or other tools)
- reputed company data validation and reconciliation between reputed company 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 reputed company 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