- -Strong database, Tableau, Sybase, and SQL expertise
- -Transitioning reporting from Sybase and microstrategy to Tableau
- -Independently create dashboards
- -Troubleshoot existing report to make it process faster
- -Must have server-level knowledge

Responsibilities:

- -Develop, maintain, and manage advanced reporting, analytics dashboards and other BI solutions.
- -Design and develop solutions using Tableau dashboards using Sybase / Big Data as backend technologies.
- -Integrate data from various sources into Tableau. Conduct data cleansing, blending, and aggregation to prepare datasets for visualization.
- -Monitor and enhance the performance of Tableau dashboards and data sources, ensuring rapid load times and intuitive user experiences.
- -Optimize data extracts and ensure effective data retrieval and performance on Tableau dashboards.
- -Maintain, test and schedule refresh of Tableau extracts.
- -Devise process for trigger-based automation of Tableau extract refresh for large volumes (TB) of data. Create scripts for automating Tableau extract refresh.
- -Assist with prioritization of bugs, feature work, and architectural enhancements.
- -Design Tableau APIs as required. Provide technical expertise in areas of architecture, design, and implementation.




- -Troubleshoot and remediate issues related to data integrity, visualization accuracy, and dashboard performance.
- -Fine tune SQL Queries for maximum efficiency and performance.
- -Conduct unit tests and develop database queries to analyze the defects and troubleshoot any issues.
- -Find the key areas of automation to make the business processes smooth.

Qualifications:

- 5+ years of experience in enterprise BI development, preferably from a consulting background. Strong background in designing and implementing enterprise scale solutions.
- Solid Hands-on experience with Tableau Desktop, Tableau Server and Tableau Prep. Thorough knowledge of Tableau administration and architecture.
- Hands-on experience in relational database management application development.
- Strong experience in data mart / data warehouse design.
- Experience in timeseries or no SQL database is highly preferred.
- Experience with relational databases Oracle, SQL server, Sybase, MongoDB.
- Experience in managing unstructured data.
- Experience in writing complex SQL, Stored Procedures and SQL Query tuning. Clear understanding of query plan management.

Education:

- Bachelor's degree/University degree or equivalent experience

#J-18808-Ljbffr

📌 Tableau Developer (Mississauga)
🏢 Open Systems Technologies
📍 Mississauga