IL
Data Analyst
ICONMA, LLC
- 🇨🇦 Canada
- Hybrid
- 15 hours ago
- $43.79 – $47.41 / hour
- Risk Management
- Agile
- Change Management
- Power BI
- SQL
- Python
- Azure
- Azure Data Factory
- Azure SQL
- Databricks
- Unity Catalog
- Data Modeling
- DAX
- Power Query
- Alteryx
- Visio
- Excel
- CSPO
15 hours ago
Â
Responsibilities:
- Product ownership & business analysis:
- Serve as Product Owner for analytics and reporting products, acting as the primary liaison between business stakeholders and delivery teams.
- Partner with Risk Management, Lines of Business, and Technology stakeholders to identify business needs, define product vision, and develop delivery roadmaps.
- Lead business discovery and requirements gathering sessions to understand current processes, pain points, and opportunities for optimization and automation.
- Translate business requirements into epics, features, user stories, acceptance criteria, and prioritized product backlogs.
- Define product objectives, success metrics, business outcomes, and value realization measures.
- Manage and prioritize product backlogs, balancing business priorities, technical dependencies, production support needs, and strategic initiatives.
- Facilitate Agile ceremonies including sprint planning, backlog refinement, stand-ups, reviews, and retrospectives.
- Identify assumptions, risks, dependencies, constraints, and mitigation strategies throughout the product lifecycle.
- Support stakeholder communications, change management activities, training, and adoption of analytics products.
- Provide status updates, recommendations, and executive communications to Risk leadership and senior stakeholders.
- Assess opportunities for standardization, optimization, automation, and scalability across Risk reporting and analytics processes.
- Data analytics & solution delivery:
- Design, develop, enhance, and maintain interactive Power BI dashboards and reports for operational, management, and executive audiences.
- Analyze, profile, and transform data from multiple internal and external sources to create scalable and reusable analytics datasets.
- Develop and optimize SQL queries, stored procedures, views, and data models to support reporting and analytics requirements.
- Utilize Python to automate data processing, reconciliation, validation, and reporting workflows.
- Perform detailed data analysis to identify patterns, trends, anomalies, and opportunities to support strategic decision-making.
- Conduct data integrity, quality, and reconciliation assessments to ensure reliability and accuracy of analytics products.
- Support the Risk Data Factory and enterprise data modernization initiatives by leveraging Azure-based technologies.
- Develop business rules, data mapping documentation, process flows, and data dictionaries.
- Support modernization and automation initiatives aimed at reducing manual reporting and increasing self-service analytics capabilities.
- Perform root cause analysis and provide ongoing support for production issues and product enhancements.
- Technology & data platform responsibilities:
- Utilize Microsoft Azure services including Azure Data Factory, Azure SQL Database, Synapse Analytics, Databricks, Unity Catalog, and Azure Storage Services.
- Collaborate with data engineers and technology teams to support data ingestion, transformation, curation, and operationalization activities.
- Support development of enterprise data assets and reporting solutions aligned with Risk data strategy.
- Ensure analytics products adhere to governance, security, and data management standards.
Requirements:
- 8+ years of experience in data analytics, business intelligence, business analysis, product ownership, or related roles.
- Strong understanding of Agile delivery methodologies and product management practices.
- Proven experience leading requirements gathering, stakeholder engagement, and backlog prioritization activities.
- Advanced experience with Power BI, including:
- Data Modeling
- DAX Measures and Calculations
- Power Query
- Dashboard and Report Development
- Performance Optimization
- Strong SQL skills with experience working with large and complex datasets.
- Proficiency in Python for data analysis and automation.
- Experience working with enterprise data environments and cloud-based analytics platforms.
- Strong analytical and problem-solving capabilities with the ability to connect business requirements to data solutions.
- Experience documenting business requirements, process flows, user stories, and data specifications.
- Soft skills:
- Excellent verbal, written, facilitation, and presentation skills.
- Ability to manage multiple priorities and work independently in a fast-paced environment.
- Nice-to-have
- Experience in Financial Services, Banking, Enterprise Risk, Credit Risk, Market Risk, Regulatory Reporting, or Governance reporting.
- Strong understanding of risk management concepts, including credit risk, market risk, and risk reporting processes.
- Experience serving as Product Owner, Product Manager, Senior Business Analyst, or Delivery Lead in an Agile environment.
- Experience leading cross-functional change initiatives involving business and technology stakeholders.
- Knowledge of reference data, client hierarchies, data governance, and enterprise data management practices.
- Experience with Azure Data Factory, Synapse Analytics, Databricks, Unity Catalog, and modern cloud data platforms.
- Familiarity with Alteryx, Visio, Power Query, Power Pivot, and advanced Excel capabilities.
- Experience developing executive presentations, strategy papers, and leadership communications.
- MBA, Agile certification, CSPO, SAFe Product Owner/Product Manager, or equivalent experience considered an asset.
Why Should You Apply?
- Health Benefits
- Referral Program
- Excellent growth and advancement opportunities
Data Analyst · ICONMA, LLC