Power BI Analyst
Toronto, Ontario, Canada
Zeitview
Advanced Inspection Software for Renewable Energy and Sustainable InfrastructureLocation: Toronto,Ontario,Canada
Zeitview (formerly DroneBase) is the leading intelligent aerial imaging company for high-value infrastructure, providing businesses with actionable, real-time insights to recover revenue, reduce risk and improve build quality. Zeitview serves customers in the solar, wind, insurance, construction, real estate, and critical infrastructure industries. Trusted by the largest enterprises in the world, DroneBase is active in over 70 countries.
We seek a highly analytical and results-driven Power BI Analyst who will play a critical role in interpreting business requirements and transforming them into data-driven solutions that optimize business processes. This role demands a keen eye for detail, the ability to manage complex data pipelines, and the creativity to develop insightful dashboards and reports.
RESPONSIBILITIES:
- SQL Query Writing and Database Management: Write complex SQL queries for data analysis and reporting. Optimize query performance, design relational database schemas, and support ETL processes. Develop stored procedures and functions to automate data-related tasks.
- Data Preparation and Integration: Employ Power Query in Excel and SQL for importing, cleaning, transforming, and integrating data from various sources. Ensure the accuracy and consistency of data through rigorous quality checks and governance practices.
- Data Analysis and Reporting: Utilize advanced Excel features, including complex formulas, pivot tables, Power Pivot, and DAX, to analyze and interpret business data. Develop BI reports and dashboards using Power BI, with a strong emphasis on data visualization and interactive reporting.
- System Monitoring and Documentation:
- Monitor and maintain automated systems and perform manual tasks as necessary to ensure smooth day-to-day operations of data management and reporting.
- Provide training and support to the process and technology team, and end-users, enabling them to navigate and interact with Power BI reports effectively.
- Troubleshoot/test solutions to ensure optimal performance, tune these solutions as necessary, and document the results.
- Continuous Learning and Improvement: Stay abreast of the latest trends in business intelligence, analytics, and data management. Actively seek opportunities to enhance technical skills and apply best practices in BI and data analysis.
QUALIFICATIONS:
- Bachelor's degree in Computer Science, Data Science, Information Technology, or a related field
- Proficiency in data management, encompassing data cleaning, transformation, and validation using Excel's advanced functions and Power Query.
- Zealous dedication to data quality and data-driven decision-making.
- 1-2 years of relevant experience in business intelligence, data analysis, or a similar role. Internship experience in BI or analytics considered.
- Completion of PL-300 would be an asset
- Strong proficiency in Excel, SQL, and Power Query, with the ability to manipulate, analyze, and visualize data.
- Familiarity with BI tools (e.g., Power BI) and basic knowledge of programming languages (Python, R) for data analysis.
- Excellent analytical, problem-solving skills, and attention to detail. Ability to communicate complex data insights in a clear and effective manner.
- Comfortable working in a startup-like environment that is fast-paced and nebulous; demonstrating tenacity and resilience
- Self-motivated, able to work independently as well as contribute to cross-functional and global teams.
BENEFITS:
- Work with the leading intelligent aerial imaging company with established, successful relationships across myriad industries
- Paid private medical insurance
- Stock incentive program
- Work from home environment
- Autonomy and upward mobility
- Diverse, equitable, and inclusive culture, where your voice matters
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Business Intelligence Computer Science Data analysis Data management Data pipelines Data quality Data visualization ETL Excel Pipelines Power BI Python R RDBMS SQL
Perks/benefits: Career development Health care Startup environment
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Lead Data Analyst jobs
- Open Data Science Manager jobs
- Open Marketing Data Analyst jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Engineer II jobs
- Open MLOps Engineer jobs
- Open Principal Data Engineer jobs
- Open Data Scientist II jobs
- Open Power BI Developer jobs
- Open Business Intelligence Developer jobs
- Open Data Analytics Engineer jobs
- Open Business Data Analyst jobs
- Open Junior Data Scientist jobs
- Open Data Analyst Intern jobs
- Open Sr Data Engineer jobs
- Open Product Data Analyst jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Research Scientist jobs
- Open Big Data Engineer jobs
- Open Data Quality Analyst jobs
- Open Principal Data Scientist jobs
- Open Manager, Data Engineering jobs
- Open Azure Data Engineer jobs
- Open Data Product Manager jobs
- Open Data quality-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open Business Intelligence-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Deep Learning-related jobs
- Open PhD-related jobs
- Open Data visualization-related jobs
- Open Finance-related jobs
- Open PyTorch-related jobs
- Open NLP-related jobs
- Open TensorFlow-related jobs
- Open APIs-related jobs
- Open Consulting-related jobs
- Open LLMs-related jobs
- Open CI/CD-related jobs
- Open Generative AI-related jobs
- Open Snowflake-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Databricks-related jobs
- Open Airflow-related jobs