Senior MSBI Developer (SQL & SSRS/SSIS Expert)

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