The IT Business Intelligence Analyst is primarily responsible for developing all reporting, providing support to business users for all Business Intelligence related tickets, thorough incident/project documentation, and user training on solution delivery. Duties may also include operational aspects including applying software updates, and light DBA responsibilities such as production script validation/execution, and database optimization. Responsibilities for this role also include SSRS requirement gathering, development and maintenance of quality business intelligence solutions that will improve business insights and/or processes (This includes development, maintenance, troubleshooting, and support for all Business Intelligence applications within HFF.)
Analyze business requirements, purpose, decide on best BI tool, design, and develop solution(s) to facilitate effective business decisions.
Support existing enterprise BI solutions including SSRS, SSIS ETLs, Power BI, DOMO, and ad-hoc data analysis.
Support reporting and ad-hoc analysis of the SQL aggregation engine.
Become an expert in business processes, systems, and applications used by the business.
Create/maintain documentation for all BI solutions, databases and projects.
Appropriately prioritize multiple incoming tasks that may change frequently.
Establish and maintain strong working relationships with colleagues and key business users in cross-functional areas.
Demonstrates high level of integrity and initiative in their work.
Staying current with the latest Business Intelligence technologies.
Perform other duties as required.
3+ years of experience with SSRS, T-SQL, and writing complex stored procedures.
Experience supporting and developing ETL processes.
Understanding of data warehouse concepts, data modeling and star schema.
Experience working with data visualization tools such as DOMO, Tableau, PowerBI.
Proficient communicating with non-technical users regarding technical issues.
Excellent organizational, interpersonal and communication skills.
Strong problem solving and analytical skills.
Efficient working independently or a team.
HFF is an equal opportunity employer and affords equal opportunity to all applicants for all positions without regard to race, color, religion/creed, sex/gender (including pregnancy, childbirth, lactation and related conditions), gender identity or expression, sexual orientation, marital status, national origin, ancestry, citizenship, age, handicap or disability, genetic information or predisposing characteristic, status as a victim of domestic violence, sexual assault or stalking, current or prior membership or service in the U.S. Armed Forces or state military unit, participation in a general public emergency evacuation, or any other characteristic protected by law.
Holliday Fenoglio Fowler