Global Enterprise Services, LLC (GES) · 5 months ago
Data Analyst (Power BI / SQL Server / SharePoint)
Lovell Federal Health Care Cente, North Chicago, IL, US
Full-time
Onsite
Mid Level
$90K/yr - $110K/yr
3+ years expGlobal Enterprise Services, LLC (GES) is seeking a Data Analyst with strong experience in Microsoft Power BI, SQL Server, and PowerShell scripting. This role supports business intelligence and reporting functions in a federal healthcare environment, translating complex data into actionable insights for decision-makers.
Cyber SecurityInformation Technology
No H1B
Security Clearance RequiredU.S. Citizen Only
Responsibilities
Design, build, and maintain interactive Power BI dashboards and reports that provide real-time insights for stakeholders
Translate business and operational requirements into scalable data models and visualizations
Implement DAX measures, Power Query transformations, and performance tuning for optimal dashboard performance
Manage dataset refresh schedules, gateways, and user access within the Power BI service
Develop and execute SQL Server queries to extract, transform, and load (ETL) data from multiple enterprise systems
Create stored procedures, views, and functions to support reporting and analytics
Ensure data integrity, accuracy, and security while optimizing database performance
Develop PowerShell scripts to automate data processing, report distribution, and administrative tasks
Streamline recurring workflows and integrate automation into reporting pipelines
Support IT and BI teams with script-based monitoring, configuration, and deployments
Create, configure, and manage SharePoint sites, document libraries, and lists to support data sharing and team collaboration
Set permissions, versioning, and workflows that ensure secure and efficient content management
Embed Power BI reports and dashboards into SharePoint Online for organizational access
Coordinate with IT teams on site collection structure, storage quotas, and permissions management
Qualification
Required
Bachelor's degree is preferred but not required — relevant work experience will be considered
Minimum 3 years of experience in data analysis, business intelligence, or a related field
Demonstrated proficiency with Microsoft Power BI (data modeling, DAX, Power Query, dashboards, security, and publishing)
Strong working knowledge of Microsoft SQL Server for data querying and management
Experience with PowerShell scripting to automate tasks and streamline processes
Familiarity with SharePoint administration, including site creation, permissions, and content structure
Excellent analytical, problem-solving, and communication skills
Ability to work independently and collaboratively within a federal or enterprise environment
Must be able to obtain and maintain a Public Trust – Tier III clearance
Must be a US citizen
Preferred
Experience with Microsoft 365 ecosystem (Teams, OneDrive, Azure AD)
Familiarity with Power Automate or other workflow automation tools
Understanding of data governance, security, and compliance standards in a federal environment
Microsoft certifications (e.g., PL-300 Power BI Data Analyst, Azure Data Engineer, or Microsoft 365 Administrator) are preferred but not required
Prior experience supporting federal healthcare agencies or similar mission-driven organizations is a plus
Company
Global Enterprise Services, LLC (GES)
Global Enterprise Services (GES) is a SBA certified 8(a) and Service Disabled Veteran Owned Small Business (SDVOSB) that provides Information Technology (IT) and Telecommunications consulting and services.
11-50 employees
Funding
Current Stage
Early StageCompany data provided by crunchbase