DOMO Migration Engineer

USA contract remote role 3 months duration asap start 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.