Company Description:

Nifty Tech is an IT consulting and technology services company specializing in cloud transformation, data engineering, and software development. Their services include Cloud & DevOps Consulting, Big Data & Analytics Solutions, Custom Software Development, Microservices & API Integrations, and IT Staffing. Nifty Tech prides itself on fast, flexible, and delivery-focused solutions, with built-in agility and transparent collaboration.

Role: Power BI Dev - (Advanced)

Onsite Interview in Toronto area ( Face to Face mandatory )

Job Summary :

We are seeking a skilled BI Developer with a strong background in data warehousing, advanced SQL, and analytics to join our dynamic team. The ideal candidate will have hands on experience with Snowflake integration, Python programming, and Power BI. Familiarity with API development, especially using PowerShell and REST APIs, is a plus. Experience with Cube Development will be highly regarded.

Key Responsibilities :

• Design, develop, and maintain data warehousing solutions.

• Implement ETL processes to ensure data quality and integrity.

• Optimize data models and storage solutions for performance and scalability.

• Write complex SQL queries for data extraction, transformation, and loading.

• Utilize advanced SQL techniques for analytical queries, ensuring efficient data retrieval and reporting.

• Implement and manage Snowflake data solutions.

• Collaborate with crossfunctional teams to integrate Snowflake with existing systems.

• Develop scripts to automate data processing and analysis using Python.

• Work on data manipulation and transformation tasks to support analytical projects.

• Create and maintain Power BI dashboards and reports.

• Collaborate with stakeholders to gather requirements and provide insights through data visualization.

• Assist in the development and integration of APIs using PowerShell and RESTful services.

• Ensure data accessibility and interoperability between systems.

• Design and develop OLAP cubes to support business intelligence needs.

• Optimize cube performance and ensure accurate data representation.

Experience :

• 10+ years of experience in BI development, data warehousing, and analytical queries.

• Proficient in advanced SQL and experience with Snowflake.

• Handson experience with Python for data processing.

• Intermediate knowledge of Power BI for reporting and visualization.

• Familiarity with API development (PowerShell, REST APIs) is desirable.

• Experience with Cube Development is a plus.

• Strong analytical and problemsolving skills.

• Excellent communication and collaboration abilities.

• Ability to work independently and as part of a team.

Preferred Qualifications :

• Certifications in relevant technologies (e.g., Snowflake, Power BI).

• Experience with cloudbased data solutions.

📧 How to Apply :

Send your resume and cover letter to hr@niftytechsolutions.ca