Business Intelligence Analyst

Bright Vision Technologies - Boerne, TX

Full-time - Mid Level

Boerne, TX

About the position

The Business Intelligence Analyst role at Bright Vision Technologies involves developing and managing reports using Tableau and SQL, transitioning existing reports from Business Objects, and utilizing Python for data analysis. The position requires strong presentation skills to communicate insights to non-technical audiences and a commitment to modernizing data solutions.

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

• Bachelors Degree with 10+ years of experience required.
• Proficiency in Tableau for reporting and visualization.
• Strong knowledge of Python for data preparation, analysis, connections, and visualization, with experience managing files and folders.
• Essential Python Libraries: Pandas, Numpy, Pyodbc, Matplotlib, Os, Pathlib, and other common libraries (math, datetime, json, collections, etc.)
• 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

• Preferred Libraries: SciPy, Scikit-learn, TensorFlow, NLTK, TextBlob.