BI Analyst

ESSENTIAL FUNCTIONS:

- Gather, structure, and operate moderately to highly complex data inputs from multiple sources, both internally and externally
- Develop and run data queries from various (reporting) tools to gain insight
- Perform QA review of results to verify data integrity
- Transform data outputs into compelling visualizations

SKILLS:

EXPERIENCE AND EDUCATION:

- Required experience with: Tableau, Microsoft Excel, SQL queries, Microsoft PowerPoint
- Preferred experience with: MapInfo Professional, Alteryx
- Bachelor's degree in a relevant field
- 6-8 years in logical and physical database design and implementation.
- Experience using data warehouse or analytic tools for business purposes.
- Experience in writing SQL and understanding of ETL Development Tools.
- Experience with ad-hoc query development (Crystal Reports, Business Objects, SAS, or other).
- Experience developing reports using a reporting tool such as Crystal Reports.
- Demonstrates thorough working knowledge of various business process and system modelling tools including: Data Flow Diagrams, Process Models, ER diagrams, Dimensional Data Models, Context Models, Event Modeling, State Modeling, Process decomposition, and Use Case Scenarios.
- Demonstrates thorough working knowledge of the system development life cycle and can train others on SDLC concepts.
- Demonstrates thorough working knowledge to effectively manage time, prioritize work, multi-task across many assignments, create deliverables and delegate to others as well as monitor their work for completion.
- Ability to assess the impact of new requirements on an existing suite of complex applications.
- Technical writing skills producing clear and unambiguous deliverables.