Job Description
The Senior Business Analyst will be responsible for helping to manage impact of changes in software and business processes on our business systems, as well as creating and maintaining BI reports, alerts and charts or visualizations for dashboards with IBM Cognos Analytics software.This individual will work with their supervisor, subject matter experts and members of different levels of management in various functional areas in our corporate headquarters.More than half of the work for this position will involve verifying the accuracy of BI output against existing reports, resolving discrepancies, as well as ensuring that all business requirements are met and all report assumptions are valid for all historical and potential future data.
Essential Functions - Work closely with business users in different departments to understand requirements and analyze data for desired insights as well as application and report functionality
- Follow established procedures for developing BI reports and alerts off one or more of our databases, including accounting, timekeeping, cost planning, and HR/Payroll.
- Apply defined best practices for using Cognos Report Studio to develop reports and Event Studio agents for workflow emails and alerts
- Properly join queries that pull data from different data sources
- Creative problem-solving with the ability to identify and effectively use customer support and various online resources for troubleshooting applications, database integrations, plus BI reports and alerts
- Demonstrate high ethical standards with proper handling of sensitive and confidential data
- Provide Ad Hoc data queries for department managers, program managers and VPs
- Assist with troubleshooting functional and data-level security issues
- Inquisitive nature with demonstrated interest in exploring regular improvements and new capabilities in our business systems and business intelligence software
- Other duties as assigned
Minimum Qualifications - Bachelor or higher degree with 7+ years of experience supporting a major ERP system and Cognos Analytics software (specifically with Report Studio and Event Studio)
- Strong understanding of key business concepts and terminology for functional areas like accounting, human resources and contracts.
- Strong analytic and logical reasoning skills, demonstrated ability to "think outside of the box" and provide careful attention to detail
- Accounting and financial reporting knowledge
- Knowledge of Microsoft Excel
- Understanding of Structured Query Language (SQL) and database objects (Oracle or SQL Server)
- Demonstrated excellent oral and written communication skills with the ability to work in a team environment as well as with members of senior management
- Demonstrated organizational skills and ability to manage multiple simultaneous priorities
Desirable Qualifications - Experience with using UKG Pro for Human Capital Management and Deltek Costpoint ERP for other functional areas (including understanding of their respective database structures)
- Experience with IBM Cognos Framework Manager for the development of framework models
- Experience creating Data Modules and Dashboards in Cognos Analytics
- Ability to mentor junior BI analysts
Salary: - Salaries are determined based on several factors including external market data, internal equity, and the candidate's related knowledge, skills, and abilities for the position.
Benefits MELE Offers Our Team - Hybrid remote/office work environment - must work at MELE's headquarters office in Rockville, MD three days a week (two days working from home)
- Employer-paid employee Medical, Dental and Vision Care
- Low-Cost Family Health Care offered.
- 11 Paid Federal Holidays
- Paid time off (PTO)
- 401(k) with Employer Match
About MELE Associates, Inc. With over 250 employees and offices in Rockville, MD, Washington, DC, and Albuquerque, NM, MELE is a veteran-owned (VOSB), minority-owned small business empowering its customers with innovative solutions for more than three decades. MELE has team members located across the U.S. and has served more than a hundred countries across hundreds of project locations. The company offers technical, engineering, and programmatic support expertise to a host of U.S. federal and international agencies, including, but not limited to, the Department of Energy, the Department of Defense, the Department of Homeland Security, the Department of Justice, INTERPOL, and the International Atomic Energy Agency. MELE's services include national security, intelligence, law enforcement and emergency response training, IT/cybersecurity, facility management and engineering, CBRNE defense and nuclear security, and mission and program support.
MELE Associates, Inc. is an Equal Opportunity/Affirmative Action employer.All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law. MELE Associates, Inc. is an E-Verify employer.
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)
Job Tags
Holiday work, For contractors, 3 days per week,