Responsibilities and Duties:
· Candidate must be able to design, develop and implement efficient and scalable data storage solutions using Snowflake and Tableau
· Must be able to Write, optimize, and troubleshoot SQL queries within the Snowflake and SQL Server environments.
· Integrate Snowflake with various data sources and third-party tools: for example: Salesforce, AWS S3, SQL Server.
· Ensure data security (data encryption) and compliance with industry standards.
· Collaborate with cross-functional (internal and client) teams to meet data-driven business objectives.
· Stay updated with the latest Snowflake features and best practices. · Candidate must be able to developing and working Tableau driven dashboards, analytics.
Required skills and experience:
· Candidate must possess a Bachelor's degree in Computer Science, Computer Engineering, or a software-related discipline or similar work experience in relevant field.
· Mastery skills in SQL and familiar with ETL (extraction, transformation, and Load) processes
· Experience with data modeling and cloud computing environments
· Must possess hands-on experience with Snowflake features like Time Travel and Zero-Copy Cloning
· Understanding of data compliance and security best practices
· Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe,Able to administer and monitor Snowflake computing platform
· Handling large and complex sets of XML, JSON, and CSV from various sources and databases
· Experience with any scripting languages, preferably Python
Proven experience in developing and working Tableau driven dashboards, analytics.
Ability to query and display large data sets while maximizing the performance of workbook.
Ability to interpret technical or dashboard structure and translate complex business requirements to technical specifications.
Working knowledge of Tableau administrator/architecture.
Must have ability to pull data from Snowflake, SQL Server, Salesforce data as source and develop Tableau visualizations.
Advanced Tableau development skills required.
High-level competency in Excel (macros, pivot tables, etc.).
Understanding of advanced calculations and statistical functions.
A solid understanding of SQL, relational database management system, data modeling, and normalization
Strong communication skills.
Attention to detail and accuracy.
Design, develop, conducts unit testing, and maintains complex Tableau reports for scalability, manageability, extensibility, performance, and re-use.
Provide technical expertise in areas of architecture, design, and implementation.
Determine the best implementation that will meet the design of the architect.
Work with team members to create useful reports and dashboards that provide insight, improve/automate processes, or otherwise add value to the team.
Will be able to connect Tableau data sources such as Snowflake, SQL Server, Salesforce
Work through iterative review cycles to deliver results that meet or exceed user expectations.
Ensure consistency by adhering to a set of software coding and style guides.
Resolve support tickets related to Tableau reports.
Preferred skills and experience:
· SnowPro Certification · Tableau Certification
· Familiarity with BI tools integration, such as Tableau or Looker
· Proven track record of data migration and optimization within Snowflake
· Ability to translate business needs into technical specifications
Flexible work from home options available.