Senior Data Architect: EDW & Data Governance Lead

Remote Jobs; United States; Remote; USD 140,000 - 190,000; Full time

Job summary

Remote Jobs is seeking a Senior Data Architect to join a data integration project focused on consolidating multiple reporting data marts into an Enterprise Data Warehouse (EDW). The role involves profiling, designing mappings, and updating data models for a refreshed reporting architecture.

You will develop ETL processes, create Power BI reports, and ensure data governance while guiding migrations of legacy marts into the EDW.

Qualifications

• Senior Data Architect role with expertise in data warehouses and data marts.
• Experience in designing and optimizing ETL processes and mappings.
• Proficiency in creating and testing data models and governance practices.

Responsibilities

• Review existing data marts and perform detailed data profiling.
• Analyze and create design and mapping specifications.
• Identify dimensions required for facts and complete profiling of tables.
• Develop and test ETL processes and Power BI reports for testing dimensions.
• Update as-is JOIN data models for new fact attributes and stage required data.
• Provide feedback and lessons learned at project close out.

Skills

Data modeling

ETL design

Power BI

Tools

ETL tools

Job description

Remote Jobs is seeking a Senior Data Architect to join a data integration project focused on consolidating multiple reporting data marts into an Enterprise Data Warehouse (EDW). The role involves profiling, designing mappings, and updating data models for a refreshed reporting architecture.

You will develop ETL processes, create Power BI reports, and ensure data governance while guiding migrations of legacy marts into the EDW.