Senior Business Intelligence Analyst
Ruchman and Associates, Inc. Washington, District of Columbia, United States
Business Consulting and Services · 201-500 employees
Applying here? Try the free cover letter tool — paste this posting and your résumé, no account needed.
About the role
The Senior Business Intelligence Analyst will analyze complex operational and investigative data to provide actionable insights for leadership. They will develop dashboards, reports, and data models using Microsoft Power BI to support organizational decision-making.
What they look for
Requirements
Candidates must possess a bachelor's degree in a relevant field and significant professional experience in business intelligence and data analysis. Proficiency in Microsoft Power BI and the ability to obtain a federal background investigation are required.
Full description
Description
Ruchman and Associates, Inc. (RAI) is seeking an experienced Senior Business Intelligence Analyst to support U.S. Customs and Border Protection (CBP), Office of Professional Responsibility (OPR). The Senior Business Intelligence Analyst will support the development, analysis, and visualization of complex data to provide actionable insights for OPR leadership, investigative activities, security programs, and organizational decision-making.
Prior CBP, DHS, federal law enforcement, investigative, or security program experience is highly preferred.
Key Responsibilities
- Analyze complex operational, investigative, workforce, and program data to identify trends, patterns, risks, and anomalies.
- Develop dashboards, reports, visualizations, and other business intelligence products for Government leadership.
- Transform large and complex datasets into clear, actionable business and operational insights.
- Develop and maintain data models and reporting solutions using Microsoft Power BI and related business intelligence tools.
- Work with stakeholders to define reporting requirements, metrics, key performance indicators, and analytical objectives.
- Perform data mining, manipulation, validation, and quality assurance.
- Integrate information from multiple data sources to support enterprise-level analysis and decision-making.
- Support investigative and security-related analytical requirements through advanced data visualization and analysis.
- Present analytical findings and recommendations to technical and non-technical stakeholders.
- Identify opportunities to improve data management, reporting, automation, and business intelligence processes.
Required Qualifications
- Bachelor's degree in business, data analytics, information technology, computer science, or a related field.
- Significant professional experience performing business intelligence, data analysis, visualization, or related analytical work.
- Demonstrated experience developing dashboards, reports, and analytical products using Microsoft Power BI or comparable BI platforms.
- Experience analyzing large and complex datasets from multiple sources.
- Strong knowledge of data visualization, data modeling, reporting, and analytical techniques.
- Ability to translate business and operational requirements into effective analytical products.
- Strong problem-solving, research, written communication, and presentation skills.
- Ability to communicate complex analytical findings clearly to senior leadership.
- U.S. citizenship and ability to satisfy applicable CBP background investigation and suitability requirements.
Preferred Qualifications
- Previous CBP experience, particularly supporting CBP OPR, is strongly preferred.
- Experience supporting DHS or another federal law enforcement organization.
- Experience analyzing investigative, security, misconduct, integrity, or risk-related data.
- Advanced experience with Microsoft Power BI, including dashboard and report development.
- Experience with SQL, data modeling, data integration, or other advanced analytics tools.
- Experience developing executive-level dashboards and performance metrics.
RAI is an equal opportunity/affirmative action employer and will not discriminate against any application for employment based on age, race, color, gender, national origin, religion, creed, disability, veteran status, marital status, sexual orientation, genetic information, military status, disability, or sex including pregnancy and childbirth or related medical condition or on any other basis prohibited by law. RAI participates in the E-Verify program to confirm the employment eligibility of all persons hired. This means that we will provide the Social Security Administration (SSA) and, if necessary, the Department of Homeland Security (DHS), with information from each new employee’s Form I-9 to confirm work authorization. RAI. will not use E-Verify to pre-screen job applicants.