Senior MSBI Developer (SQL & SSRS/SSIS Expert)

8 - 10 years

0 Lacs

Mulshi, Maharashtra, India

Posted:1 week ago| Platform: Linkedin logo

Apply

Skills Required

developer sql data analytics reporting integration support management efficiency software server query tuning reports power visualization azure reliability security compliance governance planning programming writing scripting automation relational database olap design development agile pipeline testing controls finance healthcare automate troubleshooting code scrum documentation maintenance scalability technology certifications engagement adaptability learning diversity mentoring mobility

Work Mode

On-site

Job Type

Full Time

Job Description

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 Show more Show less

Mock Interview

Practice Video Interview with JobPe AI

Start Developer Interview Now
Synechron
Synechron

Information Technology and Services

New York

1000+ Employees

330 Jobs

    Key People

  • Faisal Husain

    Co-Founder & CEO
  • Maqbool Kazi

    Managing Director

RecommendedJobs for You