Senior Business Intelligence Programmer Analyst NF4

Quantico, Virginia
Feb 28, 2021
Mar 08, 2021
Full Time


Marine Corps Community Services (MCCS) is looking for the best and brightest to join our Team! MCCS is a comprehensive program that supports and enhances the quality of life for Marines, their families, and others in the Marine Corps Community. We offer a team oriented environment comprised of military personnel, civilian employees, contractors and volunteers who keep the organization functioning smoothly and effectively.
Learn more about this agency


Performs duties as Programmer/Analyst for Business Intelligence. Uses knowledge of software design principles, methods, approaches, and procedures to design, develop, optimize and integrate system components. Uses knowledge of pertinent government requirements and database management principles such as data structures, data modeling and data warehousing to design, debug and maintain software applications that meet technical and functional requirements. Designs and develops efficient and effective applications through use of reusable components. Ensures applications comply with requirements and are consistent with current and planned infrastructure and data environments. Determines the most appropriate principles, practices and methods to apply in assignments. Interprets regulations and applies new methods to difficult problems and resolves most conflicts that arise.

Develops and maintains solutions for business performance management and decision support to include: data mining, data query, reporting, analytics, dashboards, scorecards, etc. Develops metadata models, develops and tunes queries, designs and develops reports, creates analytical solutions and provides customized data delivery and presentation. Conducts application administration and database administration for data repositories to include data warehouse, data mart, data cubes, materialized views, etc. Conducts customer services for requirements collection; change control; project and task coordination and user assistance. Performs troubleshooting, problem solving and solution analysis duties. Conducts research of related products, methods and techniques as assigned. Performs programmer/analyst tasks to ensure decision support system reliability, availability and maintainability. Reports progress as required. Performs other related duties as assigned.

Plans, organizes work and manages internal resources to ensure maximum productivity and economies. Effectively supports the Marine Corps Equal Employment Opportunity policy. Maintains and enforces security for Marine Corps Community Services (MCCS) funds, merchandise, supplies, equipment, and property to preclude or minimize the potential for fraud, waste and abuse.

MCCS has a process that partners IT with Business Functions. This position in the organization could be part of the process therefore the individual could have the overall responsibility to serve as a strategic interface with particular areas of the business. During this process this individual would be responsible for Business Case Development, New Solution Research and Evaluation and collaboration across IT and business functions on research, initiatives and risk profiling, IT architecture, solutions roadmaps and other areas as designated.

Provides World Class Customer Service with an emphasis on courtesy. Assists customers and communicates positively in a friendly manner. Takes action to solve problems quickly. Alerts the higher-level supervisor, or proper point of contact for help when problems arise. Adheres to safety regulations and standards. Promptly reports any observed workplace hazards, and any injury, occupational illness, and/or property damage resulting from workplace mishaps to the immediate supervisor. Adheres to established standards of actively supporting the principles of the EEO program and prevention of sexual harassment

This is a white collar position where occasional lifting up to 20 lbs. may be required.

Travel Required

25% or less - Varies

Supervisory status

Promotion Potential


Conditions of Employment

  • See Duties and Qualifications



Bachelor's degree in Information Technology, Computer Science or a related field appropriate to the work of position AND three years of progressively technical experience in working with Business Intelligence or Decision Support solutions as a technical lead that demonstrates knowledge of software design principles, methods, approaches, and procedures to design, develop, optimize and integrate system components, OR an appropriate combination of education and experience that demonstrates possession of knowledge and skill equivalent to that gained in the above, OR appropriate experience that demonstrates that the applicant has acquired the knowledge, skills, and abilities equivalent to that gained in the above.

Knowledge of pertinent government requirements and database management principles such as data structures, data modeling and data warehousing to design, debug and maintain software applications that meet technical and functional requirements. Skill to design and develop efficient and effective applications through use of reusable components, and ensure applications comply with requirements and are consistent with current and planned infrastructure and data environments. Strong understanding of relational database management systems, data warehousing systems and states of data presented in various data repositories. Strong working knowledge of SQL, UNIX, and Windows. Experience with Oracle RDBMS, Oracle Warehouse Builder, Oracle Data Integrator and Oracle PL/SQL is preferred. Knowledge and experience with design, development, testing and deployment of Cognos reports and dashboards, metadata models using Framework Manager in Cognos Analytics 10/11 environment including configuration and administration experience is required. Working knowledge and experience applying BI solutions to business activities to include but not limited to: Finance, Procurement, Retail, Human Resources, Construction is preferred.

This position has been designated as a position of trust. The incumbent must be eligible for an Access National Agency Check and Inquiries (ANACI/ Tier 3) background investigation to satisfy IT Level II designation. Appointment and continued employment is subject to a favorable adjudication of the security investigation.

Eligible for incremental telework as determined by MR/MF policy.

Measures of Effectiveness: To ensure that all employees are working in a way that aligns with our mission and values, in addition to yearly goals, performance against the following critical elements will be reviewed during the Performance Management Process:
  • All employees: Work Quality, Customer Service, Interpersonal Skills.


Additional information

GENERAL INFORMATION: Applicants are assured of equal consideration regardless of race, age, color, religion, national origin, gender, GINA, political affiliation, membership or non-membership in an employee organization, marital status, physical handicap which has no bearing on the ability to perform the duties of the position. This agency provides reasonable accommodations to applicants with disabilities. If you need a reasonable accommodation for any part of the application and hiring process, please notify the agency. The decision on granting reasonable accommodation will be on a case-by-case basis.

It is Department of Navy (DON) policy to provide a workplace free of discrimination and retaliation. The DON No Fear Act policy link is provided for your review:

As part of the employment process, Human Resources Division may obtain a Criminal Record Check and/or an Investigative Consumer Report. Employment is contingent upon the successful completion of a National Agency Check and Inquiries (NACI). For all positions requiring access to firearms or ammunition, the Federal Government is prohibited from employing individuals in these positions who have ever been convicted of a misdemeanor crime of domestic violence, or a felony crime of domestic violence adjudged on or after 27 November 2002. Selectees for such positions must submit a completed DD Form 2760, Qualification to Possess Firearms or Ammunition, before a final job offer can be made.

Direct Deposit of total NET pay is mandatory as a condition of employment for all appointments to positions within MCCS.

Required Documents:

*Education/certification certificate(s), if applicable.

*If prior military, DD214 Member Copy

This activity is a Drug-free workplace. The use of illegal drugs by NAF employees, whether on or off duty, cannot and will not be tolerated. Federal employees have a right to a safe and secure workplace, and Marines, sailors, and their family members have a right to a reliable and productive Federal workforce.

Involuntarily separated members of the armed forces and eligible family members applying through the Transition Assistance Program must submit a written request/statement (may be obtained from the MCCS Human Resources Office) and present ID card with "TA" stamped in red on front of card.



How You Will Be Evaluated

You will be evaluated for this job based on how well you meet the qualifications above.

Your application/resume and supporting documentation will be used to determine whether you meet the job qualifications listed on this announcement. This vacancy will be filled by the best qualified applicant as determined by the selecting official.

Background checks and security clearance

Security clearance
Not Required

Drug test required

Required Documents


If you are relying on your education to meet qualification requirements:

Education must be accredited by an accrediting institution recognized by the U.S. Department of Education in order for it to be credited towards qualifications. Therefore, provide only the attendance and/or degrees from schools accredited by accrediting institutions recognized by the U.S. Department of Education .

Failure to provide all of the required information as stated in this vacancy announcement may result in an ineligible rating or may affect the overall rating.

Similar jobs