SQL and Power BI Developer

Job Summary

We are looking for a talented Power BI/Fabric and SQL Developer to join our BI Analytics and Reporting team. The ideal candidate will have strong expertise in Microsoft SQL Server Power BI/Fabric SSRS and SSIS with experience in designing and developing interactive dashboards reports KPIs and ETL solutions. The role involves developing and optimizing complex T-SQL queries designing efficient data models and delivering scalable high-performance reporting solutions that support business intelligence and data-driven decision-making. Experience with MES Opcenter/Camstar or manufacturing systems is an added advantage.

Primary Duties and Responsibilities

• Design develop and maintain interactive dashboards reports and KPIs using Power BI/Fabric and SSRS.
• Develop optimize and troubleshoot complex T-SQL queries stored procedures views and database objects in Microsoft SQL Server.
• Design develop and maintain SSIS ETL packages for data integration and transformation.
• Collaborate with business users to gather reporting requirements and translate them into scalable BI solutions.
• Design and optimize data models to improve report performance and ensure efficient data retrieval.
• Monitor and optimize the performance of reports dashboards SQL queries and ETL processes.
• Perform data validation and ensure data accuracy consistency and integrity across reporting solutions.
• Troubleshoot production issues provide timely resolutions and support ongoing reporting and ETL operations.
• Follow established development standards coding best practices and documentation requirements.
• Work closely with cross-functional teams to deliver high-quality business intelligence solutions.
• Participate in code reviews testing deployment and continuous improvement initiatives.

Education & Experience

• Bachelors or masters degree in computer science engineering MCA or . (IT/Computer Science) or related fields.
• 3 to 5 years of hands-on experience in Microsoft SQL Server Power BI SSIS and SSRS.

Skills & Other Requirements

• Strong proficiency in Power BI/ Fabric including DAX Power Query (M) and data visualization best practices.
• Expertise in developing and optimizing complex T-SQL queries stored procedures functions views and database objects.
• Ability to write optimize and troubleshoot complex SQL queries and index analysis.
• Experience in designing data models and developing ETL solutions using SSIS.
• Good understanding of relational database design data warehousing concepts and BI best practices.
• Strong analytical troubleshooting and problem-solving skills with the ability to work independently and collaboratively.
• Programming experience in C# Python is an added advantage.
• Strong analytical and problem-solving skills with keen attention to detail.
• Experience in developing interactive dashboards reports and KPIs for business users.
• Familiarity with source control systems such as Git is an added advantage.
• Exposure to cloud data platforms (e.g. Snowflake Azure) is a plus.
• Strong verbal and written communication skills with the ability to interact effectively with technical and business stakeholders.
• Ability to work independently as well as collaboratively in a fast-paced team-oriented environment.
• Eagerness to learn new technologies and adapt to evolving business requirements.

Preferred Skills

• Experience or knowledge of Siemens Opcenter (MES/Camstar) is an added advantage.
• Exposure to manufacturing business processes and MES reporting is preferred.
• Experience with data warehousing concepts and BI best practices is a plus.

Working Conditions

• Must be flexible to work and provide support across different Coherent global time zones as business needs require.
• May be required to participate in off-hours support production deployments and critical issue resolution to ensure business continuity.
• Will collaborate with global teams across multiple geographic locations in a hybrid and cross-functional work environment.

Culture Commitment

Ensure adherence to companys values (ICARE) in all aspects of your position at Coherent:

Integrity Create an Environment of Trust

Collaboration Innovate Through the Sharing of Ideas

Accountability Own the Process and the Outcome

Respect Recognize the Value in Everyone

Enthusiasm Find a Sense of Purpose in Work

• Design and develop software solutions using MS SQL Server Power BI SSRS and SSIS.
• Collaborate with cross-functional teams to understand requirements and deliver effective solutions.
• Write clean efficient and well-documented code adhering to coding standards.
• Conduct thorough testing and debugging to ensure software reliability and performance.
• Implement and maintain data-driven applications ensuring data integrity and security.
• Stay updated with the latest technologies and industry trends suggesting improvements.
• Provide technical support and troubleshooting for existing systems.
• Document and communicate technical specifications and changes effectively.
• Assist in the deployment and integration of software solutions.
• Contribute to a positive and collaborative team environment.

• Bachelors degree in Computer Science Engineering or a related field.
• 3 to 5 years of experience in software development with a focus on MS SQL Server.
• Proficiency in Power BI SSRS and SSIS is a must.
• Knowledge of MES Opcenter is an added advantage.
• Strong problem-solving and analytical skills.
• Excellent communication and collaboration abilities.
• Ability to work independently and manage multiple tasks.
• Familiarity with software development methodologies and best practices.
• Willingness to learn and adapt to new technologies.
• A passion for software engineering and a desire to contribute to innovative solutions.