Senior BI Analyst

Bright Vision Technologies - Boerne, TX

Full-time - Mid Level

Boerne, TX

About the position

The Senior BI Analyst position at Bright Vision Technologies involves developing and managing business intelligence reports and applications, primarily using Tableau and SQL. The role requires transitioning existing reports from Business Objects to Tableau, maintaining current reports, and utilizing Python for data analysis and visualization. The analyst will also be responsible for presenting insights to non-technical audiences and creating user-developed applications (UDAs) to enhance reporting efficiency.

Responsibilities

• Develop new reports in Tableau, integrating with various data sources.
• Use SQL to connect to and retrieve data from multiple sources.
• Transition existing reports from Business Objects to Tableau.
• Maintain and update existing reports in both Business Objects and Tableau.
• Manage and update UDAs (User Developed Applications) created with Excel VBA macros and Tableau.
• Retire or re-platform outdated UDAs with modern solutions.
• Present reports and insights to non-technical audiences effectively.
• Create new UDAs using Tableau or Excel VBA macros for quick solutions, with plans to eventually replace them with fully developed IT solutions.
• Utilize Python for data analysis, connections, visualization, and file management.

Requirements

• Proficiency in Tableau for reporting and visualization.
• Strong knowledge of Python for data preparation, analysis, connections, and visualization, with experience managing files and folders.
• Advanced Excel skills, particularly for data preparation (UDA assets).
• SQL for data retrieval and management (non-UDA assets).
• Strong presentation skills for delivering insights to non-technical audiences.
• Effective requirement gathering and documentation abilities.

Nice-to-haves

• Experience with essential Python libraries such as Pandas, Numpy, Pyodbc, Matplotlib, Os, Pathlib, and other common libraries (math, datetime, json, collections, etc.).
• Familiarity with preferred libraries like SciPy, Scikit-learn, TensorFlow, NLTK, TextBlob.