Senior Business Intelligence Analyst (MS Excel)

Pay Status: Salary, W2 of Idea Entity

Position: Senior Business Intelligence Analyst (MS Excel)

Job Family: Exempt

Client: Defense Health Agency (DHA)

Work Location: Hybrid, San Antonio, TX – JBSA Fort Sam Houston

Daily schedule: 40 hours per week, standard business hours

Expected Pay Rate: $55/hr to $65hr, negotiable

Duration: Contract through September 2024, likely extension

Notes: No C2C, must be W2 employee of Idea Entity, must be US Citizen

Idea Entity, a Microsoft Gold Partner, is a global change management consulting firm committed to delivering customer outcomes that change the way business is done. We are looking for an experienced Senior Business Intelligence Analyst who will assume a key role on our team. This role will support the objectives of the DHA principles within Resource Management. The RM office has been tasked to provide enduring and adaptable internal business solutions in various areas within the DHA.

This role will be operating on a hybrid schedule with one to two (1-2) telework days a week on-site out of San Antonio, TX (Ft. Sam Houston). Due to the nature of this role, US Citizenship is required and is not eligible for sponsorship.

Responsibilities:

• Provides analysis of quantitative and qualitative data from internal and external data sources in support of business decisions.
• Uses standard or ad hoc queries or reports to extract data from disparate databases or data sources.
• Analyzes data to produce dashboards, metrics, or insights and identify trends or anomalies.
• Consults with users or decision makers to identify data sources, required data elements, or data validation standards.
• Collaborates with development teams to design business intelligence solutions to facilitate data gathering, storage, and retrieval.
• Performs work with a high degree of latitude. Handles the most complex issues.
• Excellent verbal and written communication skills.
• Proven problem/situation analysis.
• Ability to identify and seek needed information and has proven research skills.
• Excellent analytical thinking skills and previous statistical knowledge.

Requirements

• 7-10+ years of experience is Microsoft Office Excel
• Must be able to interface with Microsoft .NET developers and web development protocols
• Must understand advanced level MS Excel tools and techniques to generate highly complex spreadsheets and templates
• Must have experience with data visualization tools such as Tableau, SAS, QlikView, QlikSense, and PowerBI
• Obtain Security+ certification within 6 number of months of hire.

Preferred Qualifications:

• Prior experience with DoD and experience with Electronic Health Records/Electronic Medical Records (EHR/EMR).
• Demonstrated ability to self-direct, prioritize, and manage multiple tasks and priorities.
• Exceptional communicator with both technical and non-technical audiences.
• Strong interpersonal skills with ability to collaborate effectively in cross-functional teams.
• Demonstrated ability to solve challenging technical problems with innovative solutions.
• Customer service oriented and approachable.

Benefits

• Competitive Health Care Plan (Medical, Dental & Vision)
• Health Savings Account (HSA)/Flexible Spending Account (FSA)
• Retirement Plan (401K, IRA) with employer match
• Paid Time Off (Vacation, Sick and Federal Holidays)
• Paid Training & Development opportunities
• Hybrid work environment

At Idea Entity, our culture is centered around diversity and inclusion where our employees are valued and empowered. We are an Equal Opportunity Employer and employment decisions are made without regard to race, color, religion, national origin, gender, sexual orientation, gender identity, age, physical or mental disability, genetic factors, military/veteran status or other characteristics protected by law.