Lead Engineer - Data & Analytics Systems & App Administration

Summary:

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 offers

We 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

Equal Employment Opportunity

Cencora is committed to providing equal employment opportunity without regard to race, color, religion, sex, sexual orientation, gender identity, genetic information, national origin, age, disability, veteran status or membership in any other class protected by federal, state or local law.

The company’s continued success depends on the full and effective utilization of qualified individuals. Therefore, harassment is prohibited and all matters related to recruiting, training, compensation, benefits, promotions and transfers comply with equal opportunity principles and are non-discriminatory.

Cencora is committed to providing reasonable accommodations to individuals with disabilities during the employment process which are consistent with legal requirements. If you wish to request an accommodation while seeking employment, please call 888.692.2272 or email [email protected]. We will make accommodation determinations on a request-by-request basis. Messages and emails regarding anything other than accommodations requests will not be returned

Affiliated Companies

Affiliated Companies: AmerisourceBergen Services Corporation