Integriti -
13 Jobs
Mississauga, ON
Salary:
Description:
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.
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 cross-functional 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.
Required Skills:
- 8 years of experience in BI development, data warehousing, and analytical queries.
- Proficient in advanced SQL and experience with Snowflake.
- Hands-on 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 problem-solving skills.
- Excellent communication and collaboration abilities.
- Ability to work independently and as part of a team.
Preferred Skills:
- Certifications in relevant technologies (e.g., Snowflake, Power BI).
- Experience with cloud-based data solutions.