Sr. BI Analyst

Stellar It Solutions - San Antonio, TX

Full-time - Mid Level

San Antonio, TX

Professional, Scientific, and Technical Services

About the position

The Sr. BI Analyst role focuses on developing and maintaining business intelligence reports and applications using tools like Tableau and SQL. The position requires transitioning existing reports from Business Objects to Tableau, managing user-developed applications, and presenting insights to non-technical audiences. The analyst will also utilize Python for data analysis and visualization, ensuring effective data management and reporting 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

• 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 ETL tools like Informatica or DataStage.
• Certifications in Tableau or Business Objects (BO).
• Experience working with Snowflake.
• Background in Staff Operations.