-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 efficient 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. Solid 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 (Ontario)
🏢 Open Systems Technologies
📍 Ontario