Overall Summary:
The Senior Data Analyst is responsible for the operational integrity of IWCO Direct’s reporting ecosystem and for leading the migration from legacy platforms to Microsoft Fabric and Power BI. This role sits at the intersection of hands-on technical delivery and strategic data governance; maintaining the reporting infrastructure the business depends on today while building the governed, self-service data platform it needs tomorrow. The right candidate brings deep SQL expertise, practical experience with modern BI platforms, and the ability to think architecturally about how data flows from source systems to business decisions.
Primary Duties/Responsibilities
- Lead the migration of IWCO Direct’s analytics platform from SQL Server–based data warehouse and SSRS/Qlik reporting to Microsoft Fabric, including lakehouse design, data pipelines, and Power BI semantic models.
- Define and execute a phased migration roadmap that balances business continuity with modernization progress.
- Design and implement data pipelines that replace legacy ETL processes with Fabric-native workflows (Data Factory, dataflows, notebooks).
- Architect Power BI semantic models with governance, row-level security, and reusability as core design principles.
- Maintain and support existing SSRS reports, Qlik Sense dashboards, and SQL Server stored procedures/views that drive daily business operations.
- Triage and resolve data quality issues, report failures, and performance problems across the current reporting stack, while identifying legacy reports and data flows that are candidates for retirement, consolidation, or migration.
- Develop, document, and maintain governed data pipelines and curated datasets that internal departments use as the foundation for their own reporting and analysis.
- Establish naming conventions, documentation standards, data dictionaries, and lineage tracking practices that make the data platform navigable and trustworthy.
- Partner with business SMEs to understand their data needs, then deliver governed data products that enable self-service analytics at scale.
- Define data quality standards and monitoring to ensure the reliability of data streams downstream consumers depend on.
- Contribute to the department’s technology roadmap, including evaluation and adoption of AI capabilities as IWCO Direct’s data platform needs evolve.
- Identify opportunities to apply automation, AI, and modern tooling to reduce manual reporting effort and improve data accessibility.
- Stay current with Microsoft Fabric, Power BI, and broader data platform developments; bring recommendations for adoption back to the team.
Required Skil