Finisar Corporation
Website:
coherent.com
Job details:
Job Summary
JOB DESCRIPTION
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
- Bachelor's or master's degree in computer science engineering, MCA, or M.Sc. (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 company’s 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
Coherent Corp. is an equal opportunity/affirmative action employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law.
Finisar India (Subsidiary of Coherent Corp) is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to gender identity, sexual orientation, race, color, religion, national origin, disability, or any other characteristic protected by law.
Responsibilities
- 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.
Qualifications
- Bachelor's 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.
About Us
Coherent is a global leader in lasers, engineered materials and networking components. We are a vertically integrated manufacturing company that develops innovative products for diversified applications in the industrial, optical communications, military, life sciences, semiconductor equipment, and consumer markets. Coherent provides a comprehensive career development platform within an environment that challenges employees to perform at their best, while rewarding excellence and hard-work through a competitive compensation program. It's an exciting opportunity to work for a company that offers stability, longevity and growth. Come Join Us!
Note to recruiters and employment agencies: We will not pay for unsolicited resumes from recruiters and employment agencies unless we have a signed agreement and have required assistance, in writing, for a specific opening.
Click on Apply to know more.
