Business Intelligence Developer

San Antonio, TX 78150

Active Secret clearance Required

@Orchard LLC has been retained by a growing Federal contractor with a great culture to identify an experienced BI Developer to support a US Air Force program in Randolph AFB, TX. The Data Analytics & BI Developer will be responsible for using Microsoft technologies to develop new capabilities for decision support, expanding the functionality of existing solutions to meet the needs of new requirements, and identifying data sources to integrate using modern and legacy systems.

As the BI Developer, you will.

• Maintain, enhance, and scale an existing Power BI solution that currently leverages Dataflow
• Convert all data sources to interface/link with Microsoft Access, Excel or SQL database
• Transform data using Power BI into meaningful insights through interactive dashboards and reports
• Integrate all data sources into one or multiple tables in a customized analytical format in Access or SQL
• Link MS Access and/or SQL data sources to MS Excel Pivot Tables for multiple users
• Create advanced charts in Excel
• Develop VBA code in MS Office to automate data collection and integration processes
• Lead specialized analysis and development efforts for analysts and leaders
• Conduct research to investigate client problems and work collaboratively with your team to formulate and recommend solutions
• Support clients in collecting and analyzing data, producing models and visualizations, and draw conclusions from the data to improve decision-making
• Produce a variety of communications from informal email interactions with clients to formal memos, presentations, executive briefings, and others
• Perform other duties as assigned from time to time by the manager.

Your background will likely include the following.

• Must hold an active DOD Secret Clearance.
• Bachelor's degree with at least 6 years of experience in data analysis and integration of Business Intelligence (BI) technologies. In lieu of a degree, an additional 4 years of related experience or relevant professional certification may be substituted.
• Advanced experience and skills with Microsoft Power BI, Excel, Access, and SQL.
• Experience linking data between multiple sources, including but not limited to Microsoft Access, Excel, PowerPoint, SharePoint, Word, and Outlook.
• Working knowledge of Databricks.
• Basic understanding of Visual Basic for Applications.
• Proficient in other Microsoft Office applications – MS Word, PowerPoint, & SharePoint.
• Outstanding interpersonal communication with analysts and senior leaders (Colonels, Generals, and Executives).
• Possess a demonstrated ability to work collaboratively across a large organization, managing diverse tasks, requirements, and commitments.
• Available to work under tight deadlines and work during evenings and weekends when necessary.
• Demonstrate active listening skills to gain an understanding of key customer issues.
• Creative problem-solving ability and a consultancy mindset.
• Ability to view problems from multiple angles and apply a variety of solutions to solve them.
• Minimum 2 years of experience with a DOD environment is preferred.

If you can meet the criteria above, we want to hear from you. Please apply.

Established in 2010, @Orchard LLC has an exceptional reputation, providing staffing solutions to time-sensitive, talent scarcity issues to deliver better talent management ROI.  Our specialty lies in the critical area of program talent acquisition and resource management, not in one narrow skillset, but across many areas of technical and functional delivery. To learn more about our other exciting opportunities, visit our Jobs Page at www.atOrchard.com.