What are the responsibilities and job description for the Senior PowerBI Developer with Snowflake :: Onsite :: W2 Only position at Aorton Inc?
Role: PowerBI and Snowflake Developer
Location: WestLake, TX(onsite)
We are seeking a skilled Power BI & Snowflake Developer with a strong background in handling large datasets, optimizing data models, and ensuring high-performance reporting. The ideal candidate will have expertise in Power BI, SQL, and Snowflake, along with experience in data security, performance tuning, and cloud platforms.
Key Responsibilities:
- Design, develop, and optimize Power BI reports and dashboards for efficient data visualization.
- Work with large datasets, ensuring performance optimization for reporting and analytics.
- Implement data security measures and enforce best practices for handling sensitive information.
- Integrate Snowflake with Power BI, ensuring smooth data flow and query performance tuning.
- Develop scalable data models using star and snowflake schemas for efficient data organization.
- Write and optimize complex SQL queries and Oracle PL/SQL scripts for data retrieval and transformation.
- Collaborate with cross-functional teams to improve data processing and visualization strategies.
Must-Have Skills:
- Proven expertise in Power BI (Desktop & Service), DAX, and Power Query.
- Strong understanding of SQL and Oracle PL/SQL for data handling and optimization.
- Hands-on experience with Snowflake integration, data modeling, and performance tuning.
- Knowledge of data security best practices and performance optimization techniques.
- Experience working with cloud platforms (AWS, Azure, or GCP) for Snowflake integration.
- Hands-on experience with Python for automation and data transformation.
Preferred Skills:
- Experience in migrating reports from other BI platforms, such as Oracle OBIEE to Power BI.
- Familiarity with Snowflake-specific features like Snowpipe, Streams, and Data Sharing.
- Hands-on experience with Python for automation and data transformation.
- Exposure to other BI tools like Tableau or QlikView is a plus.