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

SVZLMFpWWm9KNWZXYTRHMnkzM00yMjNmZUE9PQ==
  • 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

SchooLinks

New Grad Software Engineer, Data Job at SchooLinks

 ...such as OneRoster, Ed-Fi, and others Experience with modern software development and project management tools such as Git and JIRA...  ...work time as possible Remote- we have a small number of engineers on-site, but many distributed as well as much of our... 

Classic Auto Group

Automotive Sales Representatives Honda - Streetsboro Job at Classic Auto Group

 ...Sales Representative Classic Honda (Streetsboro, OH) No Experience Needed Paid Training Weekly Pay Classic Honda , part of the respected Classic Auto...  ...~ Paid, in-depth sales training ~ Competitive, high-potential pay plans ~ Medical, dental, vision, and life... 

TechDigital Group

Senior ETL Test Lead - Data Quality & Migration Job at TechDigital Group

 ...An established industry player is seeking a Test Lead with extensive experience in ETL testing and data quality assurance within the banking sector. This role involves developing and executing test strategies to ensure data integrity and compliance with regulatory standards... 

Mayo Clinic

Security Behavior Specialist Job at Mayo Clinic

 ...Retirement: Competitive retirement package to secure your future. Responsibilities...  ...flight risk. The Security Behavior Specialist demonstrates professionalism, effective...  ...activity and alert patient care staff to physical and emotional changes, escalations in behavior... 

Down South CaJJun Eats

Bar Manager Job at Down South CaJJun Eats

 ...Down South CaJJun Eats is seeking to hire an experienced Bar Manager with a passion for the hospitality industry. We are looking for someone who has an in-depth understanding of bar operations, including staff management, alcohol regulations, and inventory keeping. Our...