Power BI and Snowflake Consultant

$124,800 - $145,600/Yr

Mastech Digital - Dallas, TX

Part-time - Mid Level

Dallas, TX

Professional, Scientific, and Technical Services

About the position

The Power BI and Snowflake Consultant role at Mastech Digital involves providing expertise in data management and analytics using Power BI and Snowflake. The consultant will be responsible for managing user access, optimizing performance, and ensuring data security while collaborating with stakeholders to design effective data solutions. This is a part-time contract position with a focus on immediate availability.

Responsibilities

• Create and manage new Snowflake users, ensuring proper role assignments and access control.
• Provide technical support for data pipelines and troubleshoot related issues as needed.
• Monitor Snowflake performance, optimize expensive queries, and manage resource usage to control costs.
• Plan and implement SSO (Single Sign-On), clean up roles, and apply Snowflake best practices for security and performance.
• Onboard and orient new Power BI users, while maintaining the Power BI Data Gateway for seamless data access.
• Manage permissions and workspaces in Power BI, ensuring secure and efficient collaboration across teams.
• Develop, deploy, and maintain reports, analytics, and dashboards in Power BI, while troubleshooting and resolving any reporting issues.
• Collaborate with stakeholders to design databases and data warehouses that integrate smoothly with BI tools and leverage Snowflake's full capabilities.
• Apply 5+ years of hands-on experience with Snowflake and Power BI, including administration, query tuning, and reporting/visualization.
• Ensure data security for sensitive PII/PCI data in Snowflake, adhering to protocols like SAML, OAuth, and OpenID, with experience in administering Snowflake in AWS or Azure environments.

Requirements

• Minimum 3+ years of experience in Power BI and Snowflake.
• Bachelor's degree in Computer Science, Electrical/Electronic Engineering, Information Technology or a related field or equivalent experience.
• Hands-on experience with Snowflake administration, query tuning, and reporting/visualization.

Benefits

• Medical, Dental (Including Ortho) & Vision Insurance (Option to Enroll).
• Paid Leaves (Wherever applicable).
• Life & Disability Coverage (Upon eligibility).
• 401K Option, Education Assistance Program and more.