Senior Business Intelligence Developer
About the role
Job Title: PowerBI Developer
Location: Mississauga – Hybrid – 3 days/week
Term: 12 months contract plus extension
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 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.
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 problem-solving 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 cloud-based data solutions.
About Open Systems Technologies
Open Systems Technologies is a tier-one vendor for the world's most competitive financial and technology companies, offering both full-time and contract recruiting services across the country. We offer a positive, entrepreneurial, high performing culture where all employees have the unique opportunity to run a full desk. Our office looks, feels, and operates like a start-up, but with the stability, clientele, and resources that only an industry veteran can provide.
At our core, we are structured to be flexible. With over 30 years of experience, OST has been able to stand the test of time and remains the leading provider of IT staffing solutions in NY due to our forward thinking and adaptability through fluctuating job markets and evolving work cultures.
Open Systems Technologies is an Equal Opportunity Employer. All decisions regarding employment will be made without regard to age, race, color, religion, creed, sex, sexual orientation, gender identity or expression, national origin, marital status, the presence of any physical or mental disability, or any other status or characteristic protected by federal, state or local law.
Senior Business Intelligence Developer
About the role
Job Title: PowerBI Developer
Location: Mississauga – Hybrid – 3 days/week
Term: 12 months contract plus extension
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 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.
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 problem-solving 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 cloud-based data solutions.
About Open Systems Technologies
Open Systems Technologies is a tier-one vendor for the world's most competitive financial and technology companies, offering both full-time and contract recruiting services across the country. We offer a positive, entrepreneurial, high performing culture where all employees have the unique opportunity to run a full desk. Our office looks, feels, and operates like a start-up, but with the stability, clientele, and resources that only an industry veteran can provide.
At our core, we are structured to be flexible. With over 30 years of experience, OST has been able to stand the test of time and remains the leading provider of IT staffing solutions in NY due to our forward thinking and adaptability through fluctuating job markets and evolving work cultures.
Open Systems Technologies is an Equal Opportunity Employer. All decisions regarding employment will be made without regard to age, race, color, religion, creed, sex, sexual orientation, gender identity or expression, national origin, marital status, the presence of any physical or mental disability, or any other status or characteristic protected by federal, state or local law.