Business Intelligence Analyst (Power BI)

JCS Solutions LLC (JCS) is seeking a highly skilled and motivated Business Intelligence Analyst to support our Army National Guard client. The candidate will be expected to report onsite in the National Capital Region. The ideal candidate will have strong technical skills, specifically in Power BI, Excel, and Microsoft Access Macros, and a strong foundation in cost accounting principles, particularly as they relate to the federal government. In addition, the candidate must have a deep understanding of data analysis, process management, and business logic.

In this role, you will be responsible for analyzing and reporting on the large datasets, conducting appropriate data validation and implementing data analyses and other strategies that optimize statistical efficiency and quality. This will include analyzing and understanding complex data sets, identifying trends and variances, and providing insights to management to inform decision making. You will work closely with various branches and divisions to understand and support the client's cost analysis and review cycles, and you will also be responsible for developing and maintaining cost accounting reports and dashboards using tools such as Power BI, Excel, and Microsoft Access Macros

Key Responsibilities:

• Consolidate, interpret and present data in reports/dashboards for internal and external stakeholders focused on budget and financial Information.
• Produce reports and dashboard using Microsoft Power BI and other data tools.
• Analyze and develop monthly and other periodic reports to support the client's cost analysis and review cycle at the appropriation level and for required cost elements.
• Identify trends and variances in cost data and provide insights to management
• Develop and maintain cost accounting reports and dashboards using Power BI, Excel, and Microsoft Access Macros
• Write and maintain macros in Microsoft Access to automate data analysis and reporting
• Utilize a deep understanding of data analysis, process management, and business logic to inform decision making and drive continuous improvement
• Ensure compliance with federal cost accounting standards and regulations

Key Skills:

• Strong technical skills, specifically in Power BI, Excel, and Microsoft Access Macros
• Knowledge of the Planning, Programming, Budget, Execution (PPBE) process
• Knowledge of the cost accounting principles, particularly as they relate to the federal government
• Excellent analytical and problem-solving skills, with a deep understanding of data analysis, process management, and business logic
• Proficiency in Microsoft Office, with advanced skills in Excel and Microsoft Access
• Experience writing and maintaining macros in Microsoft Access
• Strong communication and presentation skills
• Ability to work independently and as part of a team
• Familiarity with federal cost accounting standards and regulations

Key Requirements:

• United States citizenship is required
• All successful candidates must be COVID-19 vaccinated
• Active DoD Secret Security Clearance is required
• Bachelor's or Master's Degree from an accredited US College or University
• 8+ years in related field and relevant experience
• Must have experience with Microsoft Power BI

If you are a highly skilled and motivated individual with a strong background in federal cost accounting, experience with Power BI, Excel, and Microsoft Access Macros, and a deep understanding of data analysis, process management, and business logic, we encourage you to apply for this exciting opportunity.

About JCS Solutions LLC:

JCS Solutions LLC is (JCS) is a premier technology firm specializing in enterprise-wide capabilities including cloud and infrastructure solutions, cyber security, digital modernization, next generation technologies enablement, software solutions, and mission support services dedicated to providing the highest quality of services and solutions. Our employees enjoy a work culture that promotes upskilling, innovation, and we've been certified as a Great Place to Work three years in a row!

JCS benefits include 401k retirement plans, paid time off, health insurance, dental insurance, vision insurance, life insurance, long term disability, short term disability, and opportunities for professional development.

It is JCS's policy to promote equal employment opportunities. All qualified applicants will receive consideration for employment without regard to sex, race, color, ethnicity, age, national origin, citizenship, religion, physical or mental disability, medical condition, genetic information, pregnancy, family structure, marital status, ancestry, domestic partner status, sexual orientation, gender identity or expression, veteran or military status, or any other basis prohibited by law.

All successful candidates must be COVID-19 vaccinated.

If you require additional accommodation, please contact us at Careers@jcssolutions.com or (703) 972-9115.