BI/ETL Developer Job at Systems Integration, Inc., Washington DC

K3k3ZGdDZTR2WU56YmRPWkVrd2s3SXNNRnc9PQ==
  • Systems Integration, Inc.
  • Washington DC

Job Description

BI/ETL Engineer

Systems Integration, Inc. (SII) is a leading provider of customer experience, data analytics and digital transformation solutions. We are seeking a highly skilled and self‑motivated BI/ETL Developer to support the FBI's ITBI (IT Business Intelligence) initiatives. The ideal candidate will possess strong business acumen and demonstrate the ability to work independently across multiple FBI Divisions, Sections, and Units. This role requires effective collaboration at all levels within the Bureau and demands excellent written and verbal communication skills.

Responsibilities:

  • Gather and analyze BI end‑user requirements; assess technical feasibility to inform software design and performance solutions.
  • Design, implement, execute, and debug manual and automated test cases using diverse testing techniques.
  • Perform detailed data analysis, tracing data elements from source through transformation to target.
  • Develop relational and multidimensional data models; optimize data‑mining performance using tools such as Erwin.
  • Build and deploy BI reporting and ETL solutions using best practices; identify and resolve data quality issues.
  • Design and code new software or enhance existing systems; integrate into operational environments.
  • Collaborate with reporting teams to optimize ETL/data pipeline processes aligned with business needs.
  • Ensure sensitive content is secured in compliance with regulatory and legal standards.
  • Document all phases of development including requirements gathering, database diagrams, source‑to‑target mappings, and technical specifications.
  • Mentor junior staff and provide guidance on BI/ETL best practices.
  • Participate in on‑call production support on a rotating basis.

Qualifications:

  • Must be US Citizen
  • Requires a Top‑Secret clearance (SCI/Poly may be required later).
  • Proficiency in Power BI
  • Expertise in writing complex SQL statements, stored procedures, triggers, and views
  • Experience extracting data from heterogeneous sources
  • Strong foundation in data warehousing and reporting platforms with ability to recommend and implement best practices
  • Familiarity with Oracle, SQL Server, Cognos, and Tableau (or similar tools)
  • Experience with cloud‑based data warehousing and data integration services
  • Advanced knowledge of Microsoft Office Suite
  • Experience working in Agile development and cloud environments is a plus
  • Bachelor's degree is required in information systems, computer science, or related field.
  • Minimum of 5 years' experience supporting projects of similar size and scope.
#J-18808-Ljbffr

Job Tags

Full time, Work at office,

Similar Jobs

Boss Search Group

Hotel Dishwasher - Travel Task Force Job at Boss Search Group

 ...throughout shift, making sure to removes full trashcans and boxes as needed and at the end of each shift. Qualifications Ability to travel out of state Ability yo live in employee housing Dishwashing experience Additional Information Travel Job... 

Darden Concepts, Inc.

Dishwasher Job at Darden Concepts, Inc.

For this position, pay will be variable by location - See additional job details and benefits below. Our Winning Family Starts With You! Check out these great benefits!~ Flexible schedules to help you balance other life commitments (school, childcare, family...

Vending Concepts

Bookkeeper Job at Vending Concepts

 ...Vending Concepts, LLC, located in Ft Worth, TX, is seeking a full-time experienced Bookkeeper to join our team. We offer a competitive salary between $40,000 and $65,000 annually. Please provide a salary history along with your work history. The ideal candidate will be... 

Infinity Quest UK

ODI ETL developer Job at Infinity Quest UK

 ...We are seeking a talented ODI Developer with IDMC knowledge to design, build, and optimize enterprise data integration solutions. The role involves migrating ODI-based ETL pipelines to Informatica IDMC for modern cloud-native data integration, governance, and quality... 

WellSpan Health Services

Orthopedic Hand Surgeon Job at WellSpan Health Services

 ...forefront to encourage personal and professional growth. We are currently seeking a board certified/board eligible Orthopedic (Hand) Surgeon to join our team in Lancaster , PA . What you can expect: ~ Employed position with WellSpan Medical Group...