Senior Business Intelligence Analyst Job at Ampcus, Washington DC

Uzc1cjhJRGpMQmN6NW1zbHdpSnFyQ21DeEE9PQ==
  • Ampcus
  • Washington DC

Job Description

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team. Job Title: Senior Business Intelligence Analyst Location(s): Washington, DC Overview: Serves as technical team leader in the development of business intelligence solutions and other reports and analysis across all divisions of the organization. Writes complex SQL scripts to extract data from various databases and systems to make data available for enterprise reporting. Provides day-to-day management of overall reporting environment. Essential Duties:

  • Serve as technical team lead in the development of business intelligence reports and analysis, providing mentoring, guidance and troubleshooting to analysis team members in solving complex reporting and analytical problems
  • Manage reporting environment including report data sources, security, subscriptions and metadata
  • Assist in initiative towards data normalization and data integrity across the enterprise
  • Assist Data Warehouse Engineer in identifying and revising enterprise reporting requirements
  • Evaluate, test and implement new or upgraded software
  • Troubleshoot reported problems pertaining to reports and the reporting database environment, working closely with other IT members, especially DBAs, Systems Analysts and Systems Engineers, identifying the cause and designing or developing an approach for resolution
  • Assess impact of changes and updates to source production systems, planning and implementing resulting changes to reports
  • Conduct end user training on reporting system
Technical Experience:
  • Knowledge of Relational Databases
  • Knowledge of Columnar Databases or columnar storage
  • SQL Programming
  • Microsoft SQL Server 2005 or above
  • SQL Server Management Studio
  • SQL Server Integration Services
  • SQL Server Analysis Services
  • Pentaho BI Suite

• PDI ETL

  • Pentaho Analytics/Reporting
  • Microsoft Excel
  • Microsoft Access
  • Microsoft Visio
  • Data Modelling
  • Data Warehousing

NOTE:

In addition, please list any desired experience.
  • Microsoft SQL Server 2012/2014
  • 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
  • Creating visual displays for data analysis and presentation
Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identify, national origin, age, protected veterans or individuals with disabilities. Ampcus

Job Tags

Similar Jobs

Dover Corporation

Advanced Manufacturing Engineer Job at Dover Corporation

 ...Dover is a diversified global manufacturer with annual revenue of over $8 billion. We deliver...  ...through five operating segments: Engineered Products, Clean Energy & Fueling, Imaging...  ...the New York Stock Exchange under "DOV." Additional information is available at dovercorporation... 

Aura Staffing Partners

School Based Occupational Therapists Needed Job at Aura Staffing Partners

Benefits:401(k)Competitive salaryDental insuranceHealth insuranceSchool-Based Occupational Therapist Needed for the 2024-2025 School YearIt's hard to believe school is almost here again! We're in need of a dedicated School-Based Occupational Therapist to join our... 

Serco

Electrical Engineer Job at Serco

 ...Position Description Serco's Maritime Engineering, Technology and Sustainment (METS) business unit employs a team of U.S. Navy Combat System experts based out of our Port Hueneme, CA location. Our goal is to provide our sailors with access to cutting edge technology... 

GardaWorld Security Services U.S.

Security Professional - Afternoon Officer Job at GardaWorld Security Services U.S.

 ...Job Description: GardaWorld Security Services Security Officer Now Hiring! Youve got the right skills. What you need is the right opportunity to unleash your potential. We agree, and were hiring! Every day is different at GardaWorld with diverse work... 

MRG Exams

Clinical Psychologist-Fairbanks AK Job at MRG Exams

 ...Disability Assessments Nationwide To Serve Our Veterans Help Military Families - Achieve Work-Life Balance - Make a Difference Founded...  .... Licensed Psychologist will be brought on as an Independent Contractor Schedule Part Time This is an IN-PERSON position. Requirements...