Job DetailsSummary:
The Lead Engineer, Data & Analytics Systems & Application Administration is a member of the Data & Analytics team, working alongside operational engineers, platform engineers and BI administrators. You will own the reliability and performance the enterprise BI and analytics platform, with Power BI at its core, so that business users receive timely, dependable analytics and data provisioning.
This is a hands-on, technical role. You will combine deep platform administration skills with automation, vendor management and cross-team collaboration to deliver a best-in-class experience for everyone who uses IT D&A-owned services.
Key Responsibilities:Platform administration & operations- Install, configure and maintain BI and analytics tools, including Power BI gateways and related server components.
- Design, deploy and upgrade highly available Power BI gateway clusters, and lead the global gateway rollout.
- Monitor server and service performance proactively and configure alerts for usage spikes and capacity issues.
- Review and interpret Capacity Metrics to plan and scale Power BI Premium capacity.
- Manage the BI & Analytics Active Directory OU, including groups and access.
- Power Automate expertise.
- Troubleshoot applications and analyze logs to resolve complex issues quickly and identify root causes.
Governance, security & compliance- Administer license provisioning and chargebacks.
- Apply data residency policies and lead Multi-Geo rollout of Power BI capacities.
- Register Azure apps and configure API permissions for Power BI.
- Write PowerShell scripts to extract and report on audit data (essential).
- Apply firewall rule knowledge and network log analysis (e.g. Wireshark) to diagnose connectivity and security issues.
Integration & enablement- Work with business units to integrate Power BI with Salesforce and in-house .NET portals.
- Configure and map OneDrive and SharePoint Online to Power BI workspaces.
- Use GitHub Copilot and other AI-assisted tools to speed up scripting, automation and troubleshooting.
- Keep pace with Microsoft Fabric and Copilot developments and advise on adoption.
Collaboration & vendor management- Partner with other operational groups to deliver consistent customer experience.
- Manage vendor relationships and work with vendors to resolve application issues.
- Participate in the 24/7 On-Call support rotation.
Minimum Qualifications:- Bachelor's degree in computer science, Electronics or a related field (master's degree in computer science preferred).
- 7+ years of IT experience, including at least 5 years of hands-on Power BI experience.
- Strong customer focus and attention to detail.
- Eagerness to learn new technologies
Required Technical Skills:- Power BI: Power BI Desktop and Power BI gateways, including integration with Salesforce and .NET portals.
- Scripting & automation: PowerShell (including audit data extraction) and Power Automate.
- Data platform: Databricks.
- AI-assisted development: GitHub Copilot and Claude
- Infrastructure: Windows Server 2019/2022/Linux and Active Directory.
- Support model: Willingness and ability to take part in on-call support.
Preferred Skills:- Knowledge of Microsoft Fabric and Microsoft Copilot.
- Experience with Multi-Geo Power BI deployments and data residency requirements.
- Wireshark and firewall rule analysis.
What Cencora offersWe provide compensation, benefits, and resources that enable a highly inclusive culture and support our team members' ability to live with purpose every day. In addition to traditional offerings like medical, dental, and vision care, we also provide a comprehensive suite of benefits that focus on the physical, emotional, financial, and social aspects of wellness. This encompasses support for working families, which may include backup dependent care, adoption assistance, infertility coverage, family building support, behavioral health solutions, paid parental leave, and paid caregiver leave. To encourage your personal growth, we also offer a variety of training programs, professional development resources, and opportunities to participate in mentorship programs, employee resource groups, volunteer activities, and much more. For details, visit https://www.virtualfairhub.com/cencora
Full time
