OVERALL PURPOSE OF POSITION: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.ESSENTIAL DUTIES: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 problemsManage reporting environment including report data sources, security, subscriptions and metadataAssist in initiative towards data normalization and data integrity across the enterpriseAssist Data Warehouse Engineer in identifying and revising enterprise reporting requirements Evaluate, test and implement new or upgraded softwareTroubleshoot 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 resolutionAssess impact of changes and updates to source production systems, planning and implementing resulting changes to reportsConduct end user training on reporting systemTECHNICAL EXPERIENCE:Knowledge of Relational Databases 12 yearsKnowledge of Columnar Databases or columnar storage 5 yearsSQL Programming 12 yearsMicrosoft SQL Server 2005 or above 8 yearsSQL Server Management Studio 4 yearsSQL Server Integration Services 4 yearsSQL Server Analysis Services 2 yearsPentaho BI Suite 5 yearsPDI ETL 5 yearsPentaho Analytics/Reporting 5 yearsMicrosoft Excel 4 yearsMicrosoft Access 1 yearMicrosoft Visio 2 years Data Modelling 4 yearsData Warehousing 5 yearsThe following skills are required:Ability to track records in entity relationship and dimensional modeling.Ability to translate logical models into physical implementation. Excellent verbal and written communication skills are an absolute must. Ability to work well under pressure and work on multiple tasks simultaneously. Outstanding analytic skills-in particular, an ability to translate an unstructured strategic question into a structured program of research, to disaggregate potential drivers of performance, to explore relationships between multiple pieces of data, and to test and identify the drivers underlying performance measuresOutstanding ability to synthesize research results into actionable strategies and recommendationsAdvanced verbal and written communication skills and the ability to present effectively to small and large groups.Energetic, organized, detail-orientedConsistent ability to meet deadlines in a fast-paced environmentMust be strong self-starter able to work independently under limited supervisionAbility 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 environmentAbility to foster a cooperative work environment and to freely give and receive feedbackStrong interpersonal skills and the ability to work effectively with a wide range of constituencies in a diverse community. Ability to lift 15 - 25 poundsGeneral computer and presentation skillsCustomer and results orientedThe following skills are desired:Microsoft SQL Server 2018/2020HP VerticaAmazon RedshiftPentaho BI SuitePentaho PDIAny other BI Tools like Business Objects, Cognos, etc. Team Foundation ServerERwinTOAD for Oracle Creating visual displays for data analysis and presentationScheduled Weekly Hours: 40 Location Washington DC (Metro Center) / Hybrid Total Rewards at HyerTek: Our benefits package for all US-based employees includes various medical plan options, some with Health Savings Accounts/Flex Spending Accounts, dental plan options, a vision plan, and a 401k plan. To encourage work/life balance, HyerTek offers employees full flex work weeks where possible. Various paid time off plans are offered including vacation, sick and personal, holidays, paid parental, military, bereavement, and jury duty leave. Employees can protect their income with optional offerings such as short and long-term disability benefits, life, accidental death and dismemberment, personal accident, critical illness, and business travel and accident insurance. We regularly review our Total Rewards package to ensure our offerings are competitive and reflect what our employees have told us they value most.HyerTek is an EEO employer.