Senior MSBI Developer (SQL & SSRS/SSIS Expert)
Senior MSBI Developer (SQL & SSRS/SSIS Expert)
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Job Summary
Synechron is seeking an experienced and detail-oriented Senior MSBI Developerexpertise 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
- Bachelors 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
SYNECHRONS 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 applicants gender gender identity sexual orientation race ethnicity disabled or veteran status or any other characteristic protected by law.
Required Experience:
Senior IC
Employment Type
Full-Time
