Business Intelligence/Data Reporting Analyst with Security Clearance

Cornerstone Defense LLC; Reston (VA); On-site; USD 110,000 - 150,000; Full time

Job summary

Cornerstone Defense LLC seeks a Business Intelligence/Data Reporting Analyst to provide business analysis, report creation, and dashboard design for the AEON BPMS platform. You will gather requirements, translate them into actionable reports, and collaborate with client teams to deliver timely, accurate insights.

Responsibilities include designing dashboards in Power BI/SSRS/Tableau, producing executive-ready data visuals, and documenting processes for end-user training.

Qualifications

• Active TS/SCI with polygraph required.
• 5+ years of business analyst experience.
• Experience with BI/reporting tools.
• Proficient in Power BI, SSRS, Tableau.
• Knowledge of SDLC and Agile methodologies.
• Excellent verbal and written communication skills.

Responsibilities

• Collaborate with client teams to design reports and dashboards.
• Gather, analyze, and document business reporting requirements.
• Deliver reports and dashboards for the AEON BPMS platform.
• Test reports following QA processes and track defects.
• Document changes and train end-users.

Skills

Analytical thinking

Effective communication

Team collaboration

Agile/SCRUM

SQL knowledge

Education

Bachelor's degree or relevant experience

Tools

Power BI

SSRS

Tableau

SQL

Job description

Business Intelligence/Data Reporting Analyst

• Clearance:
• Active TS/SCI w/ Polygraph needed to apply
• Location: Reston, Virginia Company Overview: Cornerstone Defense is the Employer of Choice within the Intelligence, Defense, and Space communities of the U.S. Government. Realizing early on that our most prized assets are our employees, we continually focus our attention on improving the overall work/life experience they have supporting the mission. Our Team is pushed every day to use their industry leading knowledge to provide end-to-end solutions to combat our nation's toughest and most secure problems. If you are looking for a place to not only be professionally challenged, but encouraged and supported by a company that cares, don't look any further than Cornerstone Defense. ------ Seeking a Business Intelligence/Data Reporting Analyst responsible for working closely with Client Customer Engagement project teams to provide the customer with business analysis expertise, report creation, and dashboard design in a tactical capacity, evaluate internal and external client requirements, and implement effective solutions in a timely manner. The selected candidate will gather, analyze, and document functional/reporting requirements (e.g., user stories using interviews, documentation analysis, site visits, use cases, and scenarios) and design, assemble, and deliver reports and dashboards for Client's AEON Business Process Management platform in a manner consistent with client expectations. Job Requirements:
• Must have an Active TS/SCI with polygraph ONLY, all others need not apply.
• Ability to consolidate, interpret, and present data in reports/dashboards for Executives, Team Leads, and Individual End Users focused on Acquisition and Financial Information.
• Analytical mindset that allows you to look at the data available and drive into meaningful insights for the end user(s).
• Ability to produce reports and dashboards using Microsoft Power BI, SSRS, and other data tools.
• Experience using SQL to create queries and general knowledge of SQL database structure/relational databases
• Ability to define and document customer business processes and report/dashboard content needs, including business process diagrams, data maps, and data modeling.
• Consult with project team members and customer stakeholders to identify, define, and document business needs and objectives, current reporting capabilities, and challenges related to the business functions, such as those supporting the Federal Acquisition Lifecycle.
• Collaborate with theproject manager, technical analysts, and customer end-users in the analysis, design, configuration, testing, and maintenance of the Business Intelligence module of AEON Business Process Management Platform to ensure desired operational performance and capabilities.
• Track and document changes for functional and business specifications; write detailed universally understood procedures for testing use cases, knowledge capture, and training purposes.
• Achieve proficiency in all major Reporting/Analytic products, including the AEON software suite: through internal staffing training, self-guided tutorials, and daily exposure to individual product feature sets.
• Provide support for various meetings, demonstrations, and program activities related to Business Intelligence.
• Test reports/dashboard projects following business and functional design following best practices for quality assurance.
• Record and track defects uncovered during test execution and assist in defect resolution (troubleshooting and researching).
• Comprehension of change management processes.
• Other duties as assigned. Experience and Skills Required Experience.
• 5+ years prior business analyst experience.
• Ability to work in a team-oriented environment for a matrixed organization.
• Strong knowledge and experience with data reporting tools, including Microsoft Power BI, SSRS, Tableau, etc.
• Strong knowledge of productivity tools like Microsoft Office (Word, Excel, Outlook).
• Experience with Agile and SCRUM processes and methodologies.
• Knowledge of software development life cycle (SDLC) practices, principles, and techniques as they apply to the Agile development process.
• Excellent verbal and written communication skills, proven ability to listen and relate to customers.
• Ability to effectively collaborate with internal and external customers.
• Demonstrated analytical and problem-solving capabilities.
• Proven ability to communicate technical details to a non-technical audience.
• Excellent organizational and time management skills.
• Strong team player willing to help other team members at all times. Desired Experience:
• Bachelor's degree or relevant experience.
• Knowledge of SQL Databases and Query Creation
• Knowledge of the Federal Acquisition Lifecycle or commercial contracting.
• Knowledge of Federal financial systems or commercial accounting.
• Ability to develop training materials and conduct end-user training sessions.
• Experience with Federal government contracting and/or program office organizations business processes.