MCA Career Center

• For Job Seekers
• For Employers

• Getting Started
• Create Professional Profile

Browse Jobs • View All Jobs • Saved Jobs • Advanced Search

Not Logged In [Log In]

Job Detail

Job Summary

Data Architect/Analyst-Business Intelligence IT Sp		POSTED: Nov 03
Salary:	85,000.00 - 95,000.00	Location:	Quantico, Virginia
Employer:	MCCS	Type:	Full Time - Experienced
Categories:	Database Management, Information Technology, Planning	Required Education:	4 Year Degree

Employer Information

About MCCS

The Personal and Family Readiness Division (MR) under the staff cognizance of the Deputy Commandant for Manpower and Reserve Affairs is responsible for providing policy, plans, resources, and direct support to Marine Corps Community Services (MCCS) field activities for certain nonappropriated fund management and oversight functions, such as accounting, information technology, and construction. MR is also responsible for a number of military personnel services programs, such as: Casualty Assistan....more info

View all our jobs

Job Description

Position: Open: 30 Oct 2009 Close: 27 Nov 2009 Location: Personal and Family Readiness Division, HQMC Information Technology Branch (MRI) 3044 Catlin Avenue Quantico, VA 22134-5099

Who May Apply: All Sources

Type of Appointment: Regular Full-Time (35-40 hours per week)

Tour of Duty: Monday through Friday **Tour of duty may change based upon work requirements**

DUTIES AND RESPONSIBILITIES: Performs and lead Data Architect/ Analyst for all data repositories for Business Intelligence (BI) solutions for the Personal and Family Readiness Division, MCCS worldwide mission. Performs and leads solution design and development for data models, schemas and mappings. Designs and develops dimension and fact tables for all data repositories to include but not limited to data warehouse, data mart or data cubes. Develop data migration plans and test validate. Plan, organize and develop data dictionary for all systems required. Define and establish data quality and data flow rules for required data transactions. Define and establish data conversion plans. Develop interface mapping solutions to optimize source column targeting with metadata definitions. Create application design document for interface developers. Conduct task planning and coordination with developers, database administrators and required technical staff members. Perform logic and code-reviews to insure compliance with proven standards. Maintain high level of proficiency with prescribed development tools, methods and techniques. Documents solutions and troubleshooting procedures. Conduct research and makes recommendations for tools and technologies. Collaborate with team members and other related technical staff as appropriate to deliver required solutions and services.

Use expert knowledge acquired through formal training or extensive on the job experience to work with, understand and evaluate technical information related to accomplishing specific task that support development, modification or enhancement of information technology products, services or systems. Advises the supervisor and other specialist on technical issues. Leads IT Specialist in accomplishing specific task that support the project.

May develop, modify or provide input to project plans. Demonstrates methods and provided technical guidance to advance completion of work. Develop various testing strategies.

Requirements

QUALIFICATIONS REQUIREMENTS: Four years of progressive experience as a Data Architect and Data Analyst. Bachelor’s Degree is preferred. Must have extensive knowledge building and maintaining repositories to include data warehouses, data marts and data cube solutions. Must have experience designing and developing solutions from data sources for Finance and Accounting, retail, Human Resources and Morale Welfare & Recreational Programs. High level proficiency and experience as an Oracle Relational Database Management System (RDBMS), Oracle Warehouse Builder, PL/SQL, ETL and OLAP is required. Experience with Cognos Framework Manager is a plus. Hands on proficiency with UNIX and Linux preferred. Must have strong oral and written communication skills.

As an authorized and privileged user of Department of Defense Information Systems must possess or receive Information Assurance awareness by completing the Security+ Certification as a condition of access within six months of employment, and thereafter must complete annual Information Assurance awareness training.

As a condition of employment applicants are required to successfully complete required background check and screening. Applicants are assured of equal consideration regardless of race, age, color, religion, national origin, gender, political affiliation, physical handicap, marital status, membership or non-membership in an employee organization.

Personal and Family Readiness Division (MR) provides reasonable accommodation to applicants with disabilities. Applicants with disabilities who believe they require reasonable accommodation should contact MR at (703) 432-0434. The decision to grant an accommodation will be made on a case-by-case basis.

As a condition of employment candidates are required to participate in direct deposit under all appointments to positions within Personal and Family Readiness Division, HQMC.

MCCS is a Drug-free workplace. The use of illegal drugs by MCCS 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.

FILING INSTRUCTIONS: Visit our website (preferred) at www.usmc-mccs.org, employment, job vacancies, MCCS Headquarters for this position and submit resume/cover letter (as a Word attachment) or mail resume to Headquarters, Marine Corps (Personal & Family Readiness Div., (HR Branch) 3044 Catlin Ave., Quantico, VA 22134-5099 (Attn: Kathleen Rudy, Code 122-09).

Location