The Senior Cognos BI Analyst will be responsible for creating and maintaining 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 office. More than half of the work for this position will involve verifying the accuracy of 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

• Follow established procedures for developing reports and alerts off one or more of our databases, including accounting, time keeping, cost planning, and HR/Payroll.
• Work closely with business users in different departments to understand requirements and analyze data for desired analysis and report functionality
• Apply defined best practices for using Report Studio to develop reports and Event Studio agents for workflow emails and alerts
• Properly join queries on data from different data sources
• Effectively use customer support and various online resources to assist with troubleshooting report problems
• 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
• Creative problem-solving with the ability to identify and utilize various online resources
• Inquisitive nature with demonstrated interest in exploring regular improvements and new capabilities in our business intelligence software
• Other duties as assigned

Minimum Qualifications

• Bachelors or higher degree with 5 years of experience using Cognos Analytics software
• Strong analytic and logical reasoning skills, demonstrated ability to “think outside of the box” and provide careful attention to detail
• Detailed understanding of Structured Query Language (SQL) and database objects (Oracle or SQL Server)
• Use of Cognos Framework Manager for development of framework models
• In-depth experience with using Cognos Report Studio and Event Studio
• 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’s Costpoint ERP for other functional areas (including understanding of their respective database structures)
• Experience creating Data Modules and Dashboards in Cognos Analytics
• Accounting and financial reporting knowledge
• Knowledge of Microsoft Excel
• Ability to mentor junior BI analysts

Location: This is a hybrid position of telework and on-site work in Rockville, MD 20850, USA

• Telework options are available with a requirement to be in the office at least three (3) days a week, based on the level of in-person meetings and office needs.

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
· Hybrid remote/office work environment.
· Employer-paid employee Medical, Dental and Vision Care.
· Low-Cost Family Health Care offered.
· Federal Holidays and three (3) weeks’ vacation
· 401(k) with Employer Match
· Cross-training opportunities
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.