Tableau Developer

Job Title: Tableau Developer
Location: St Louis, MO
Duration: Full Time

Skills Required:

• Hands-on experience in all phases of SDLC (software development life cycle) involving Requirement analysis, Software design, development, implementation, testing, maintenance.
• Good knowledge in RDBMS concepts, Data warehousing concepts, OLTP & OLAP.
• Experience in data analysis, design, and development of databases for business applications in a client server and data warehouse environments
• Expert in all areas of SQL Server development including tables, user functions, views, indexes, Stored procedures, functions, triggers, clustering, T-SQL, relational database models, data dictionaries, and data integrity.
• Extensive knowledge of Tuning SQL queries, Maintaining Data Integrity and Data Consistency, Performance Tuning and Query Optimization.
• Experience in Diagnosing and Troubleshooting performance issues in SQL Server Databases using DMV and DTA.
• Planned report schedules, build data connections, projects, groups in the Tableau server.
• Broadly designed, developed, and tested visualization solutions using the most reliable methods for Tableau report development.
• Expertise in Extract Transform Load (ETL) and Data Transformation Services (DTS).
• Expert Knowledge of Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
• Extensive experience in Implementing ETL Packages using SSIS and Complex Reports using SSRS.
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
• Expert in configuring and creating SSIS solutions for high-performance Data Integration, Data Migration, and Business Intelligence Process.
• Expertise in Debugging, Error logging, Error Handling and Production support for SSIS.
• Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Expertise in creating Report Models for building Ad hoc reports using SSRS.
• Expertise in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
• Extensive experience in different type of reports including Tabular forms, Matrix form, Conditional, List items, Charts and Sub reports.
• Exploring data across multiple visualization using Power BI.
• Experience in publishing Power BI desktop reports created in report view to Power BI service.
• Experience in developing, maintaining and supporting operational reports, dashboards and scorecards using Microsoft Power BI.
• Proficient in designing and developing cubes using SQL Server Analysis Services (SSAS) and leveraging the advanced BI functionality of SQL Server 2005.
• Expertise in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies using SSAS.
• Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS
• Good understanding and designing of Star and Snow Flake data models Schema used in relational, dimensional and multidimensional data modelling.

Job Type: Full-time

Work Remotely:

• Temporarily due to COVID-19