Are you looking for a new opportunity in a fast paced, growing environment? Venable LLP has an exciting opportunity for a Business Intelligence Analyst to join our IT team.
The Business Intelligence Analyst will be responsible for collaborating with IT peers and management on the design, development, security, documentation and quality assurance of the technical architecture of business intelligence solutions as well as supporting complete life cycle development of enterprise data warehouse, analytics reports and dashboards.
The ideal candidate will be responsible for...
Supporting the engineering of technology and information solutions encompassing Business Intelligence tools, ETL, database query, master data, meta data and visualizations
Working with subject matter experts to design ETL processes in SQL through Dashboard visualizations
Monitoring data quality, analytics and metrics results
Presenting recommendations to identify BI related workflows and sequencing events for automating and streamlining reports
Recommending additional performance/quality data points for firm management review and interpretation
Assisting with deployment of data to data warehouse
Analyzing requirements for "ad-hoc" reporting requests, including timeframes, priorities, data sources and output formats and delivery
The successful candidate will demonstrate...
Three plus years of database (SQL) experience
Proven experience with Business Intelligence tools such as Tableau or Power BI
Thorough understanding of database technologies, including the skills to query database and recognize performance opportunities of reports/queries
Technical skills to develop and implement effective methodologies for retrieving/presenting data for analysis
Technical skills to develop, document and maintain data dictionary of firm database/tables, indexes and other similar systems as it pertains to data warehouse
SQL, T-SQL experience
Aderant database experience (is a plus)
Project Management experience (is a plus)
Information Builders design and development experience (is a plus)