Power BI/ Snowflake Rptg Analyst

HMG America LLC is the best Business Solutions focused Information Technology Company with IT consulting and services, software and web development, staff augmentation and other professional services. One of our direct clients is looking for Power BI/ Snowflake Rptg Analyst in Dallas,TX. Below is the detailed job description.

Title: Power BI/ Snowflake Rptg Analyst

Location: Dallas,TX - EST/CST time zones - Remote-OK

Primary Skills: Data Fabric-Cloud Datawarehouse-Snowflake

Mandatory Skills-Power BI/ QlikView / Tableau/MicroStrategy/ Snowflake/ SQL

• Expertise in BI technologies Power BI/ QlikSense /QlikView / Tableau/MicroStrategy
• Experience in Designing of Semantic Layer in Snowflake
• Someone who is comfortable reviewing and joining data base tables to make sure they are logical, complete, data meets expectations, and knows how to put together report requirements.
• Oracle OTBi experience is plus
• work directly with users to get up to speed
  

Job Summary
The Senior Technical Specialist will be responsible for managing and optimizing Snowflake, DBT, SQL, and Python processes within the organization. They will play a key role in implementing and maintaining efficient data pipelines, ensuring data integrity, and driving data driven decision-making processes. (1.) Key Responsibilities
1. Develop and maintain snowflake data cloud environment, including optimizing database performance and troubleshooting any issues that arise.
2. Design and implement etl processes using dbt to transform and load data into snowflake for analytics and reporting purposes.
3. Write complex sql queries to extract and manipulate data as required by various business units.
4. Utilize python programming language to automate data processes, build data pipelines, and create data visualizations.
5. Collaborate with cross functional teams to understand data requirements and implement solutions that meet business needs.
6. Ensure data security and governance practices are followed in compliance with industry standards and regulations.

Skill Requirements
1. Proficiency in snowflake data platform, including data warehouse design, implementation, and optimization.
2. Experience with dbt (data build tool) for managing data transformations and modeling within a cloud data warehouse environment.
3. Strong sql skills with the ability to write and optimize complex queries for data extraction and analysis.
4. Proficient in python programming language for data manipulation, automation, and visualization.
5. Knowledge of data governance best practices and experience in implementing data security measures within a cloud environment.
6. Excellent analytical and problem-solving skills with a keen attention to detail.

Certifications: SnowPro Core Certification, DBT Fundamentals Certification (preferred).

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.