Job Description :
Positions: Senior Business Intelligence Analyst III
Washington, DC
Duration: 18 month with extensions

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. The results provide ongoing support to USAC decision-makers, the FCC, Congress, and other interested parties.

The position’s essential duties include the following:
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

Type of Experience Years of Experience
Knowledge of Relational Databases 7 years
Knowledge of Columnar Databases or columnar storage 5 years
SQL Programming 7 years
Microsoft SQL Server 2005 or above 5 years
SQL Server Management Studio 4 years
SQL Server Integration Services 4 years
SQL Server Analysis Services 2 years
Pentaho BI Suite 4 years
PDI ETL 5 years
Pentaho Analytics/Reporting 4 years
Microsoft Excel 4 years
Microsoft Access 1 year
Microsoft Visio 2 years
Data Modelling 4 years
Data Warehousing 5 years