Data Architect

Fusion Enterprise Solutions is in search for a Data Architect for an open position in Washington DC.

• Job Title: Data Architect
• Location: Washington DC (4 days on-site and 1 day remote)
• Pay: $120,000 - $130,000
• Benefits: growth opportunity, 401K, insurances, acquirements of certifications

Job Description:

You will support the execution of IT management and execution functions across units and systems, to build on the efficiencies gained through centralization over the last several years in order to deliver improved quality, usability and utility. With a requirement to continuously expand, enhance, and maintain enterprise business intelligence, analytical, warehousing, technological, and user support capabilities.

Requirements:

• Candidate shall at least 5 years of experience with architecting, designing, and developing enterprise data warehouse components, including data marts, operational data stores, staging, and archival databases.
• Candidate shall have extensive experience building star schemas, Type I and Type II dimensions, facts to dimensions matrices, and working with large enterprise data warehousing, reporting, and Business Intelligence (BI) projects.
• Candidate shall have extensive knowledge in dimensional modeling concepts.
• Candidate shall have extensive experience in building conceptual, logical, and physical data models.
• Candidate shall have extensive experience in developing and maintaining a metadata repository.
• Candidate shall have extensive experience in at least one major RDBMS platform (DB2, PostgreSQL, or SQL Server).
• Candidate shall possess excellent oral and written communication skills and effectively communicate details with all levels of management.
• Candidate shall possess the necessary people skills to identify requirements and deliver results.
• Top Secret Clearance mandatory.

Preferred Qualifications:

• Experience using data modeling tools, preferably ERWin and/or TOAD Data Modeler.
• Candidate having an understanding of ETL tools, preferably Informatica.
• Prior work experience with the Federal Bureau of Investigation is preferred.

Job Type: Full-time

Pay: $120,000.00 - $130,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Health insurance
• Life insurance
• Paid time off
• Vision insurance

Schedule:

• 8 hour shift
• Monday to Friday

Application Question(s):

• Have you ever worked for or have experience working with the FBI?

Experience:

• Data Architect: 4 years (Required)
• SQL: 2 years (Required)
• Star Schemas: 2 years (Required)
• Demensional Modeling: 2 years (Required)
• DB2: 2 years (Preferred)
• Metadata Repository: 2 years (Preferred)
• ETL Tools (Informatica): 1 year (Preferred)

Security clearance:

• Top Secret (Required)

Work Location: In person