Consensus Solutions, LLC is a small 8(a) certified business headquartered in the Washington, DC Metropolitan Region. We are committed to providing innovative, industry leading solutions that are right sized to meet our clients’ unique challenges and needs, particularly in the delivery of healthcare services, Information Technology (IT), and business process design and re-engineering. Our work is guided by a dedication to integrity, excellence, and reliable client service and we pride ourselves on the reputation we are building as a premier solutions provider to the Federal Government. Our continued success is dependent on building a team of employees who are creative, dedicated, collaborative, and take pride in their work. We are currently seeking highly motivated and skilled individuals to join our team and engage in exciting new opportunities with a growing company.
About the Role
Consensus Solutions, LLC is looking for a Data Analyst - IT Audits to support a federal government client’s IT audit program and audit cycle processes.
Responsibilities:
Conduct and report on trend analysis of audit findings throughout the audit cycle.
Leverage data collected throughout the audit cycle (findings, responses, FISMA metrics, lessons learned, material weakness, etc.) to identify trends.
Draft scheduled and ad-hoc Audit Trend Reports to include data view and graphical view of the data, displayed in PowerBI Dashboard(s).
Analyze data gathered from all -supported audits to generate meaningful/actionable information, including but not limited to predictive analysis, correlation of findings, performance metrics, audit trends/emerging trends.
Normalize data to provide meaningful visualization of data.
Support the identification of relationships between various databases and linkage through data tables/relational DB.
Use SharePoint Online Development; Microsoft Power Platform (Power Apps, Power Automate, Power BI and AI Builder; relational database creation and administration; business and data analysis methodologies to optimize business process and system workflow to help improve Business Processes.
Requirements
Education and Experience:
Minimum 5 years of relevant experience.
Bachelor's Degree or higher in related field.
Knowledge of and experience with reporting packages (such as Power BI, Business Objects, Crystal Reports, and others)
Strong analytical, problem-solving, facilitation, and communication skills, including written, verbal, and interpersonal, with the ability to explain technical concepts to variety of audiences.
Strong attention to detail.
Self-starter able to work independently and within a team.
Flexibility and the ability to react to rapidly changing requirements.
Proficient in MS Office Applications: Word, Excel, PowerPoint, Project, Visio, and SharePoint/Power Apps.
Preference for candidates to be local to the Washington DC Metropolitan area with the ability to commute locally for meetings, as needed (post-pandemic).
Ability to pass a government clearance.
Required Skills:
Fluency in developing queries, report writing and presenting findings.
Ability to showcase data in context with stunning interactive data visualizations in applications, websites, portals, SharePoint, and Microsoft Teams.
Strong communication skills – with the ability to manage, facilitate, and lead meetings with senior executives and subject matter experts
Strong attention to detail with the ability to review own work and the work of others for accuracy
Demonstrated leadership, analytical, organization, interpersonal, project management, and communication skills
Experience in task management; organizing, directing, and coordinating the planning and production of all activities associated with assigned tasks
Ability to provide exceptional client service, research and resolve issues, and demonstrate a commitment to continuous learning
Ability to work collaboratively and effectively in a team environment with all levels of client and Consensus Solutions staff
Preferred Additional Qualifications (not required):
General knowledge of internal control concepts, principles, risk analysis, FISMA, PCI Compliance, FMFIA, FISCAM, ITSI, process improvement and techniques, including frameworks such as NIST.
Working knowledge of compliance practices and IT audit operations.
Working knowledge of operating systems, application development, change management, operations, networking and telecommunications, databases, business continuity, disaster recovery, and physical and logical security.
Federal experience. VA experience strongly preferred.
Consensus Solutions is an Equal Opportunity Employer with a strong commitment to supporting and retaining a diverse and talented workforce. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against on the basis of disability.
Consensus Solutions offers competitive compensation and benefits (e.g., Paid Time Off; health, dental, and vision insurance; and retirement plans) as well as great long-term career opportunities.