This role is part of Alcons Information Technology function, a team delivering cutting-edge technology solutions to Alcon associates and customers. The Sr. Associate I, Software Engineering is responsible for designing, developing, and maintaining software solutions, with a focus on Power BI, data analytics, and collaboration with cross-functional teams. The role also ensures compliance with GxP regulations and contributes to continuous improvement in software and data solutions.
Key Responsibilities:
Software Design and Development
- Design and implement software solutions based on business and technical requirements.
- Develop and maintain Power BI dashboards and reports, translating business needs into data models and visual insights.
- Build Power BI paginated reports using Report Builder for pixel-perfect, printable reporting.
- Troubleshoot and resolve software and data issues promptly.
- Participate in code reviews and maintain high-quality code standards.
Data Analytics and Modeling
- Expertise in DAX, Power Query, and SQL for data modeling and transformation.
- Utilize current processes and tools to monitor and analyze model performance and data accuracy.
- Optimize large datasets and ensure high performance for enterprise reporting.
- Translate business needs into visual insights and actionable data models.
Project Management and Collaboration
- Collaborate with business and IT stakeholders to implement data-driven solutions.
- Participate in design reviews, provide input to design recommendations, and incorporate security requirements.
- Document application specifications (URS, FS, SDS) and translate requirements into functional software modules.
- Follow Agile Project Life Cycle methodology in all planning and execution steps.
DevOps and Version Control
- Manage Power BI projects and artifacts using Git repositories.
- Set up and maintain CI/CD pipelines in Azure DevOps for Power BI deployment.
- Oversee deployment and release management, including p