Synechron Logo

Synechron

Senior MSBI Developer (SQL & SSRS/SSIS Expert)

Posted 7 Days Ago
Be an Early Applicant
In-Office
2 Locations
Senior level
In-Office
2 Locations
Senior level
Senior MSBI Developer required to design and maintain reporting solutions, optimize data pipelines, and collaborate with stakeholders to align data solutions with business needs.
The summary above was generated by AI
Job Summary

Synechron is seeking an experienced and detail-oriented Senior MSBI Developer expertise in MSBI (Microsoft Business Intelligence) to join our data and analytics team. In this role, you will contribute to designing, developing, and maintaining robust reporting and data integration solutions that support our business objectives. Your expertise will help deliver actionable insights, improve decision-making processes, and enhance overall data management efficiency within the organization.

Software Requirements

Required Skills:

  • MSBI Suite (including SSIS, SSRS, SSAS)
  • SQL Server (including SQL Server Management Studio and Query Performance Tuning)
  • Versions: Recent versions of SQL Server (2016 or later preferred)
  • Proven experience in creating complex reports, data transformation, and integration workflows

Preferred Skills:

  • Power BI or other visualization tools
  • Experience with cloud-based data solutions (e.g., Azure SQL, Synapse Analytics)
Overall Responsibilities
  • Develop, implement, and maintain MSBI solutions such as SSIS packages, SSRS reports, and data models to meet business requirements
  • Collaborate with business stakeholders and data teams to gather reporting needs and translate them into scalable solutions
  • Optimize and troubleshoot existing reports and data pipelines to improve performance and reliability
  • Ensure data accuracy, security, and compliance within reporting processes
  • Document solution architectures, workflows, and processes for ongoing support and knowledge sharing
  • Participate in team initiatives to enhance data governance and best practices
  • Contribute to strategic planning for data platform evolution and modernization
Technical Skills (By Category)

Programming Languages:

  • Required: SQL (Advanced proficiency in query writing, stored procedures, and performance tuning)
  • Preferred: T-SQL scripting for data transformations and automation

Databases / Data Management:

  • Required: Deep knowledge of relational database concepts with extensive experience in SQL Server databases
  • Preferred: Familiarity with data warehouse concepts, OLAP cubes, and data mart design

Cloud Technologies:

  • Desired: Basic understanding of cloud-based data platforms like Azure Data Factory, Azure Synapse

Frameworks and Libraries:

  • Not directly applicable, focus on MSBI tools

Development Tools and Methodologies:

  • Experience working within Agile development environments
  • Data pipeline development and testing best practices

Security Protocols:

  • Implement data security measures, role-based access controls, and ensure compliance with data privacy policies
Experience Requirements
  • 8 to 10 years of professional experience in software development with substantial hands-on MSBI expertise
  • Demonstrated experience in designing and deploying enterprise-level BI solutions
  • Domain experience in finance, healthcare, retail, or similar industries is preferred
  • Alternative candidacy: Extensive prior experience with BI tools and proven success in similar roles may be considered in lieu of exact industry background
Day-to-Day Activities
  • Design and develop SSIS data integration workflows to automate data loading processes
  • Create and optimize SSRS reports and dashboards for various organizational units
  • Engage in troubleshooting and resolving technical issues in existing BI solutions
  • Collaborate with data architects, developers, and business analysts to align data solutions with business needs
  • Conduct code reviews, testing, and validation of reports and data pipelines
  • Participate in scrum meetings, planning sessions, and stakeholder discussions
  • Ensure documentation of solutions, processes, and workflows for ease of maintenance and scalability
Qualifications
  • Bachelor’s degree or equivalent in Computer Science, Information Technology, or related field
  • Relevant certifications in Microsoft BI or SQL Server (e.g., Microsoft Certified Data Engineer Associate) preferred
  • Ongoing engagement in professional development related to BI, data management, and analytics tools
Professional Competencies
  • Analytical mindset with strong problem-solving abilities in data solution development
  • Capable of working collaboratively across diverse teams and communicating technical concepts effectively
  • Stakeholder management skills to interpret and prioritize reporting needs
  • Adaptability to evolving technologies and continuous learning mindset
  • Focus on delivering high-quality, sustainable data solutions with attention to detail
  • Effective time management, prioritizing tasks to meet project deadlines

S​YNECHRON’S DIVERSITY & INCLUSION STATEMENT
 

Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.

All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.

Candidate Application Notice

Top Skills

Azure Data Factory
Azure Sql
Msbi Suite
Power BI
SQL
SQL Server
Ssas
Ssis
Ssrs
Synapse Analytics
T-Sql

Similar Jobs

9 Hours Ago
Hybrid
3 Locations
Senior level
Senior level
Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
Design, develop, and implement customized Salesforce solutions, manage complex projects, provide mentorship, and ensure quality through testing and code reviews.
Top Skills: ApexCopadoCSSDevOpsHTMLJavaScriptLwcMulesoftRestSalesforceService CloudSoapSOQLVisual Force
9 Hours Ago
Hybrid
3 Locations
Senior level
Senior level
Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
The Senior MuleSoft Developer will design, develop, and implement integration solutions using the MuleSoft platform, collaborating with various teams to optimize APIs and improve system integration standards.
Top Skills: APIsArtifactoryConfluenceCore JavaGitJenkinsMavenMulesoftSonarqube
9 Hours Ago
Hybrid
Pune, Mahārāshtra, IND
Senior level
Senior level
Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
The Lead Database Engineer manages Oracle database operations, leads upgrades, optimizes performance, mentors teams, and drives modernization initiatives.
Top Skills: AnsibleBashOraclePerlPostgresPythonTerraform

What you need to know about the Pune Tech Scene

Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account