Senior Business Intelligence Analyst

2 days ago


Washington, Washington, D.C., United States Ampcus Full time
Job Title: Senior Business Intelligence Analyst

At Ampcus, we are seeking a highly skilled Senior Business Intelligence Analyst to join our team. As a key member of our analytics team, you will be responsible for developing and maintaining business intelligence reports and analysis, providing technical guidance and support to team members, and managing the reporting environment.

Key Responsibilities:
  • Develop and maintain business intelligence reports and analysis to support business decision-making
  • Provide technical guidance and support to team members on complex reporting and analytical problems
  • Manage the reporting environment, including report data sources, security, subscriptions, and metadata
  • Assist in initiatives to improve data normalization and integrity across the enterprise
  • Evaluate, test, and implement new or upgraded software to support business intelligence needs
  • Troubleshoot reported problems related to reports and the reporting database environment
  • Assess the impact of changes and updates to source production systems and plan and implement resulting changes to reports
  • Conduct end-user training on reporting systems
Requirements:
  • 12 years of experience with relational databases
  • 5 years of experience with columnar databases or columnar storage
  • 12 years of experience with SQL programming
  • 8 years of experience with Microsoft SQL Server 2005 or above
  • 4 years of experience with SQL Server Management Studio
  • 4 years of experience with SQL Server Integration Services
  • 2 years of experience with SQL Server Analysis Services
  • 5 years of experience with Pentaho BI Suite
  • 5 years of experience with PDI ETL
  • 5 years of experience with Pentaho Analytics/Reporting
  • 4 years of experience with Microsoft Excel
  • 1 year of experience with Microsoft Access
  • 2 years of experience with Microsoft Visio
  • 4 years of experience with data modeling
  • 5 years of experience with data warehousing
Desired Experience:
  • Microsoft SQL Server 2018/2020
  • Client Vertica
  • Amazon Redshift
  • Pentaho BI Suite
  • Pentaho PDI
  • Any other BI tools like Business Objects, Cognos, etc.
  • Team Foundation Server
  • ERwin
  • TOAD for Oracle
Special Skills:
  • Ability to track records in entity relationship and dimensional modeling
  • Ability to translate logical models into physical implementation
  • Excellent verbal and written communication skills
  • Ability to work well under pressure and work on multiple tasks simultaneously
  • Outstanding analytic skills
  • Ability to synthesize research results into actionable strategies and recommendations
  • Advanced verbal and written communication skills and the ability to present effectively to small and large groups
  • Energetic, organized, detail-oriented
  • Consistent ability to meet deadlines in a fast-paced environment
  • Must be a strong self-starter able to work independently under limited supervision
  • Ability to build consensus and to work through others in achieving desired results and objectives
  • Consistent ability to set and deliver against a work plan in a fast-paced environment
  • Ability to foster a cooperative work environment and to freely give and receive feedback
  • Strong interpersonal skills and the ability to work effectively with a wide range of constituencies in a diverse community
  • Ability to lift 15-25 pounds
  • General computer and presentation skills
  • Customer and results-oriented


  • Washington, Washington, D.C., United States Crowell & Moring Full time

    Job Title: Senior Business Intelligence AnalystCrowell & Moring LLP is seeking a highly skilled Senior Business Intelligence Analyst to join our team. As a Senior Business Intelligence Analyst, you will be responsible for transforming data into actionable insights that drive firm revenue and profitability.Key Responsibilities:Analyze and solve complex...


  • Washington, Washington, D.C., United States Crowell & Moring Full time

    Job Title: Senior Business Intelligence AnalystCrowell & Moring LLP is a leading international law firm with a strong presence in the United States, Europe, MENA, and Asia. We are seeking a highly skilled Senior Business Intelligence Analyst to join our team.Job SummaryThe Senior Business Intelligence Analyst will be responsible for transforming data into...


  • Washington, Washington, D.C., United States Trusted Advisors Full time

    Senior Business Intelligence Analyst RoleA prominent financial institution is in search of a Senior Business Analyst proficient in Tableau and Alteryx to enhance their analytical capabilities.Key Responsibilities:Oversee data-driven processes throughout the entire data lifecycle.Develop, refine, and optimize dashboards for banking operations.Utilize Alteryx...

  • Intelligence Analyst

    2 weeks ago


    Washington, Washington, D.C., United States Boeing Intelligence & Analytics Full time

    Job Summary:We are seeking a highly skilled Intelligence Analyst to join our team at Boeing Intelligence & Analytics. As a Governance and Tradecraft Analyst, you will play a critical role in supporting the establishment of policy and procedures for the implementation of Object Based Intelligence (OBI) within the Defense Intelligence All-Source Analysis...


  • Washington, Washington, D.C., United States Boeing Intelligence & Analytics Full time

    Job Title: Intelligence Support AnalystAbout the Role:We are seeking a highly skilled Intelligence Support Analyst to join our team at Boeing Intelligence & Analytics. As an Intelligence Support Analyst, you will play a critical role in supporting Department of Homeland Security (DHS) Intelligence Analysts, Information Officers, and Collection Managers in...


  • Washington, Washington, D.C., United States Boeing Intelligence & Analytics Full time

    Job Title: Intelligence Support AnalystAbout the Role:We are seeking a highly skilled Intelligence Support Analyst to join our team at Boeing Intelligence & Analytics. As an Intelligence Support Analyst, you will play a critical role in supporting Department of Homeland Security (DHS) Intelligence Analysts, Information Officers, and Collection Managers in...


  • Washington, Washington, D.C., United States Johns Hopkins University Full time

    Job Title: Business Intelligence AnalystWe are seeking a highly skilled Business Intelligence Analyst to join our Data Analytics and Business Intelligence team in the Finance and Administration department at Johns Hopkins University.The successful candidate will work closely with various departments, including Admissions, Finance, Financial Aid, HR,...


  • Washington, Washington, D.C., United States Boeing Intelligence & Analytics Full time

    Join Our Team as a Tradecraft AnalystWe are seeking a highly skilled Tradecraft Analyst to support the establishment of policy and procedures for the implementation of Object Based Intelligence (OBI) within the Defense Intelligence All-Source Analysis Enterprise (DIAAE).Key Responsibilities:Contribute to the development of governance documents and tradecraft...


  • Washington, Washington, D.C., United States Boeing Intelligence & Analytics Full time

    Join Our Team as a Tradecraft AnalystWe are seeking a highly skilled Tradecraft Analyst to support the establishment of policy and procedures for the implementation of Object Based Intelligence (OBI) within the Defense Intelligence All-Source Analysis Enterprise (DIAAE).Key Responsibilities:Contribute to the development of governance documents and tradecraft...

  • Intelligence Analyst

    2 weeks ago


    Washington, Washington, D.C., United States Boeing Intelligence and Analytics Full time

    About the RoleWe are seeking a highly skilled Governance and Tradecraft Analyst to join our team at Boeing Intelligence & Analytics. As a key member of our organization, you will play a critical role in supporting the establishment of policy and procedures for the implementation of Object Based Intelligence (OBI) within the Defense Intelligence All-Source...


  • Washington, Washington, D.C., United States IntelliBridge Full time

    Job Title: Senior Intelligence AnalystJob Summary:We are seeking a highly skilled Senior Intelligence Analyst to support our federal client's counterintelligence program. The ideal candidate will have a strong background in intelligence analysis and experience developing intelligence reports and analytic products consistent with Office of the Director of...


  • Washington, Washington, D.C., United States IntelliBridge Full time

    {"Overview": "IntelliBridge, an award-winning national security company, seeks a Senior Intelligence Analyst to support a federal client's counterintelligence program. The analyst will provide focused support for intelligence and operational initiatives in national security or law-enforcement related matters. The analyst should have experience developing...


  • Washington, Washington, D.C., United States Amentum Full time

    Job SummaryAmentum is seeking a highly skilled Senior Intelligence Analyst to join our team. As a Senior Intelligence Analyst, you will be responsible for conducting in-depth research and analysis of foreign defense industries, supply chains, and military capabilities.Key ResponsibilitiesResearch and Analysis: Conduct research on foreign defense industries,...


  • Washington, Washington, D.C., United States Amentum Full time

    Job SummaryAmentum is seeking a highly skilled Senior Intelligence Analyst to join our team. As a Senior Intelligence Analyst, you will be responsible for conducting in-depth research and analysis of foreign defense industries, supply chains, and military capabilities.Key ResponsibilitiesResearch and Analysis: Conduct research on foreign defense industries,...


  • Washington, Washington, D.C., United States 3M Consultancy Full time

    Business Intelligence and Requirements AnalystThis is a remote position.Job Title:Business Intelligence Analyst/Tableau DeveloperLocation:RemoteDuration:Full-TimeRequirements:Active IRS MBI is required.The Position:Our client has an exciting opportunity for a Business Intelligence and Requirements Analyst to join our growing team. This role leads the data...


  • Washington, Washington, D.C., United States 3M Consultancy Full time

    Business Intelligence and Requirements AnalystThis is a remote position.Job Title: Business Intelligence Analyst/Tableau DeveloperLocation: RemoteDuration: Full-TimeActive IRS MBI is required.The Position:Our client has an exciting opportunity for a Business Intelligence and Requirements Analyst to join our growing team. This role leads the data analysis,...


  • Washington, Washington, D.C., United States Amentum Full time

    Senior Intelligence Analyst at AmentumAmentum is a leading government services provider offering strategic solutions to defense, homeland security, and the Intelligence Community. With a focus on intelligence analysis, security, training, and more, we support U.S. government and commercial clients worldwide. Our team of Senior Leaders, Subject Matter...


  • Washington, Washington, D.C., United States DC Department of Human Resources Full time

    Job SummaryThis position is located in the Department of Buildings, Office of the Director, Agency Performance Office. The Department of Buildings is responsible for regulating construction activity in the District of Columbia.Key ResponsibilitiesServes as a Data Analyst, responsible for identifying, extracting, integrating, and analyzing multiple, complex...


  • Washington, Washington, D.C., United States Northern Neck Insurance Full time

    About the RoleWe are seeking a highly skilled Business Intelligence Analyst to join our team at Northern Neck Insurance Company. As a key member of our data-driven team, you will be responsible for collecting, analyzing, and maintaining data sets to improve our products, services, and business decisions.Key ResponsibilitiesDevelop and manage Business...


  • Washington, Washington, D.C., United States SES Full time

    Business Analyst - Commercial IntelligenceWe are seeking a skilled Business Analyst specializing in Commercial Intelligence to enhance our commercial strategies. As an integral part of our team, you will be essential in interpreting data, delivering insights, and influencing decision-making processes.Key Responsibilities:Performing financial assessments and...