• Business Intelligence (BI) ETL Developer- Mid

    Posted Date 1 month ago(3/6/2019 3:42 PM)
    Job ID
    # of Openings
    Information Technology
    Job Location
    Washington, DC
  • Job Description

    DHA is looking for a Business Intelligence (BI) / Extract, Transform, Load (ETL) Developer, Mid to support a dynamic customer located in Washington, DC. This position requires an active Top Secret Clearance.

    Job Description:

    The BI ETL candidate will possess a strong business acumen working independently and across different Divisions/Sections/Units of the FBI in support to the ECSS data analytics projects. Individual will be a self-starter who is able to collaborate across all levels within the FBI. Effective written and oral communication is a must. Advanced knowledge of Microsoft Office suite and experience working in an Agile development and Cloud environment a plus. Responsibilities include, but are not limited to:

    • Collects and analyzes BI end-user requirements and evaluates the feasibility of these requirements from a technical perspective to derive software designs and performance solutions.
    • Design, implement, execute and debug manual test cases and automated test scripts using a variety of testing techniques.
    • Strong data analysis skills and the ability to track a data element from source to transformation to target.
    • Designs and develops relational and multidimensional data models and optimizes the data-mining performance function including the use of data modeling tools, preferably Erwin.
    • Creates and implements BI reporting solutions, ETL solutions using best practices and methodologies; identifies root causes of issues with data quality and other related issues.
    • Designs and codes new software or enhances existing software and integrates into new or modified systems and/or operational environments.
    • Works with a reporting team optimizing the ETL/data pipeline process to ensure that business requirements are met.
    • Secure sensitive content to align with regulatory and legal requirements.
    • Documents all phases of work including gathering requirements, database diagrams, source to target mappings and other program technical specifications using current specified design standards for new or revised solutions.
    • Mentors junior staff.
    • Provide on-call production support on a rotating basis.

    Required Skills:

    • Active TS Security Clearance
    • Experienced in writing complex statements, scripts, stored procedures, triggers and views implement business intelligence and data warehousing solutions.
    • Experience in extracting data from heterogeneous data sources.
    • Solid foundation in, and application of, data warehousing and reporting platform concepts with ability to recommend solutions and drive best practices.
    • Familiarity with Oracle, SQL Server, Cognos & Tableau (or similar) environments is a must.
    • Experience with cloud data warehousing or data integration as a service                                          

    DHA has been a trusted partner to the US Federal Government for 20 years.  We are a vibrant, energized and fast growing company serving the agencies which protect our freedom and way of life.  Our mission focuses on the intelligence, law enforcement and defense communities.  DHA adds value to every customer we serve by providing the best solution, talent, expertise and experience specifically tailored to each customer’s need.  We are proud of the company’s culture which is results-oriented and based on kindness, caring and compassion for everyone we serve as a customer, employee or teaming partner.


    Why DHA? Over the years, DHA has proven its ability to provide cost-effective, forward-thinking solutions, and exceptional service for customers. The trust our clients, teaming partners, and employees have in DHA is directly related to how we cultivate and value relationships. Our diverse clients include the Federal Bureau of Investigation (FBI) and Department of Justice (DOJ), Veteran’s Administration, Department of State, U.S. Marshalls, Defense Logistics Agency (DLA), and the Department of Defense (DoD).  DHA is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, or national origin.


    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed