Dawn InfoTek Inc. is a professional IT consulting firm that partners with major financial institutions, investment firms, and government organizations. We are committed to delivering innovative technology solutions and connecting top-tier IT talent with leading organizations.
We are currently seeking a highly skilled ETL Software Developer to join our dynamic team and support one of our clients.
Location: Downtown Toronto, ON (5 days onsite in the office)
Position Type: Contract
Responsibilities:
Power BI Development & Reporting
- Design, develop, and maintain interactive Power BI dashboards and reports to support business and operational needs.
- Create data models, measures, and calculations using DAX to deliver meaningful business insights.
- Implement data visualization best practices to ensure reports are intuitive, accessible, and actionable.
- Gather and analyze business requirements and translate them into reporting solutions.
- Develop and maintain enterprise semantic models, datasets, and reusable reporting assets that support standardized analytics and reporting
Data Integration & Analytics Support
- Connect and integrate data from various enterprise data sources, including databases, APIs, cloud platforms, and data warehouses.
- Develop and optimize Power Query (M) transformations for efficient data preparation and reporting.
- Collaborate with data engineering teams to ensure data quality, governance, and consistency across reporting solutions.
- Support ad hoc data analysis and reporting requests from business stakeholders.
- Perform data validation, reconciliation, and user acceptance testing (UAT) activities to ensure reporting accuracy and integrity.
Performance, Governance & Support
- Monitor and optimize report performance, data refresh schedules, and workspace administration.
- Apply security models, row-level security (RLS), and governance standards within Power BI.
- Troubleshoot data, visualization, and performance issues and provide ongoing support to users.
- Develop and maintain documentation for reports, datasets, and reporting standards.
- Maintain data lineage, metadata, and documentation for reporting assets and semantic models.
- Ensure reporting solutions comply with organizational data governance, security, privacy, and accessibility standards.
Stakeholder Engagement & Knowledge Sharing
- Work closely with business users to understand reporting requirements and identify opportunities for enhanced analytics.
- Provide guidance and training to report consumers and business teams on Power BI capabilities and best practices.
- Participate in Agile delivery teams and contribute to continuous improvement initiatives.
Must Have:
- Degree or diploma in Computer Science, Information Systems, Data Analytics, Business Intelligence, or a related field.
- Experience developing dashboards, reports, and visualizations using Microsoft Power BI.
- Strong knowledge of DAX, Power Query (M), and Power BI data modeling concepts.
- Experience working with SQL and relational databases.
- Understanding of data warehousing, dimensional modeling, and business intelligence best practices.
- Experience working with large datasets and transforming complex business requirements into reporting solutions.
- Strong analytical, problem-solving, and communication skills.
- Ability to work collaboratively with technical and non-technical stakeholders.
- Strong understanding of dimensional modelling, star schema design, and analytical data modelling concepts.
- Knowledge of data governance, metadata management, and data lineage principles.
Nice to Have:
- Experience working with Databricks, including connecting Power BI to Databricks SQL Warehouses and Lakehouse data sources.
- Familiarity with Azure Data Platform services such as Azure Data Lake Storage, Azure Synapse Analytics, Azure Data Factory, or Microsoft Fabric.
- Experience with enterprise data governance and data quality initiatives.
- Knowledge of Python, R, or other analytics tools.
- Experience supporting data and analytics platforms within a large public-sector or enterprise environment.
- Exposure to Agile delivery methodologies and DevOps practices.
