ETL Software Developer

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.

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.