Skip to Main Content

Enterprise Data Warehouse Architect

Marathon TS
Arlington, VA
  • Expired: over a month ago. Applications are no longer accepted.
Job Description

Enterprise Data Warehouse (EDW) Consultant
Merrifield VA – REMOTE
Marathon TS is seeking an  EDW Consultant  to provide Enterprise Data Warehouse (EDW) support to the Office of Information Systems (SI) within a Federal Law Enforcement Customer.  The  EDW Consultant  will serve as the lead for Data Modeling and Dimensional Analysis to support the design, development, and maintenance of the SQL Server-based EDW.
Essential Duties and Responsibilities:  (Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this position)
EDW development and operational support may include, at a minimum:
·        Follow Agile Scrum methodology to maintain the databases and generate scripts to load and retrieve data content.
·        Develop scripts.
·        Perform database support activities.
·        Conduct performance tuning and database design, dimensional analysis, and modeling.
·        Maintain and add to an extensive set of SSIS packages for ETL data manipulation.
·        Maintain, enhance, and create enterprise and application level reports using SSRS and other BI tools.
Minimum Qualifications:  (To perform this job successfully, an individual must be able to perform each essential duty satisfactorily.)
·         Minimum of 15 years of experience in Dimensional Analysis in a Kimball Style Enterprise Data Warehouse of not less than 500 total tables and 100 million rows of data.
·         Minimum of 10 years of experience in the design, development, and implementation of SQL Server databases creating and maintaining T-SQL Procedures, functions, packages, and triggers.
·         Minimum of 3 years of experience with SSIS packages for data manipulation and loading.
·         Minimum of 2 years of experience with the SQL Server 2012 environment.
·         Active Secret Clearance is required.
Knowledge, Skills and Abilities:
·         Ability to work independently and part of a team.
·         Excellent oral and written communication skills.
·         Shows respect and sensitivity for cultural differences; Educates others on the value of diversity; Promotes a harassment-free environment; Builds a diverse workforce.
·         Treats people with respect; Keeps commitments; Inspires the trust of others; Works with integrity and ethically; Upholds organizational values.
Physical Demands:
·         The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
·         While performing the duties of this Job, the employee is regularly required to sit and talk or hear. The employee is frequently required to walk; use hands to finger, handle, or feel and reach with hands and arms. The employee is occasionally required to stand; climb or balance and stoop, kneel, crouch, or crawl. The employee must occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision.
Work Environment :
·         The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.
·         The employee will normally work in a temperature-controlled office environment, with frequent exposure to electronic office equipment.
·         During visits to areas of operations, may be exposed to extreme cold or hot weather conditions.  Is occasionally exposed to fumes or airborne particles, toxic or caustic chemicals, and loud noise.

Marathon TS

Why Work Here?
We deliver quality services in a professional manner to the client’s full satisfaction.

Marathon TS provides a full range of professional services for clients that require support from professionals with specialized skills and experience in a specific technical area or subject matter. Marathon TS also provides IT solutions, including strategy, operations, transformation and mission support.


Arlington, VA



View all jobs at Marathon TS