eeking an experienced Domo professional to support a major BI migration from an existing SQL Server environment to Amazon Redshift. This role focuses on rebuilding datasets, refactoring data transformations, validating dashboard accuracy, and ensuring a seamless cutover for business users with no interruption in reporting, security, or data accessibility.

Key Responsibilities

• Rebuild Domo datasets to source data from Redshift using ODBC/JDBC connections, Workbench configurations, and federated query options while preserving scheduling, row-level security, and governance controls.

• Configure and optimize Redshift federated connections in Domo, including authentication, data pipelines, refresh cadence, and dependency orchestration.

• Refactor Magic ETL, DataFlows, DataFusion logic, and Beast Mode calculations to align with new warehouse structures, data models, and transformation conventions.

• Recreate and validate row-level access policies (PDP) so that authorized audiences retain correct filtered visibility after migration.

• Perform full dashboard parity checks—including KPIs, filters, drill paths, alerts, and visual layouts—to confirm the Redshift-backed versions match the legacy system.

• Identify, document, and resolve discrepancies by collaborating with engineering and analytical stakeholders.

• Improve dashboard performance through tuning methods such as caching strategies, optimized dataflows, and partitioned dataset designs.

• Manage a structured migration tracker covering approximately 150 datasets and 50 dashboards, including status, validation evidence, issue logs, and sign-off checkpoints.

• Facilitate user acceptance testing, gather feedback, and deliver clear cutover documentation such as data lineage, support instructions, and release notes.