Senior Data Architect

Hybrid Role
- Final onsite interview required

Data Analysis and Impact Assessment:

• Analyze and verify existing Work Program Datamart and General Ledger data models to assess impacts related to changes in Chart of Account data elements due to the Project.
• Evaluate the existing data models for dependencies on current Chart of Account structures and assess the scope of necessary changes.
• Conduct impact analysis on reporting and application usage of data models to ensure business outcomes are not disrupted by the transition.

• Provide a comprehensive design of data models, incorporating new Chart of Account data elements introduced by the system.
• Ensure that the redesigned data models are scalable, robust, and aligned with best practices in data management, supporting both current and future business needs.

• Analyze existing ETL (Extract, Transform, Load) jobs to identify inefficiencies and potential areas for enhancement.
• Design and implement robust data quality measures to ensure the timeliness, accuracy, and completeness of production data on a scheduled basis, including nightly, hourly, or less frequent intervals as needed.
• Collaborate with development teams to automate and streamline ETL processes to support efficient data flow and integration.

• Provide expertise in data visualization and reporting, offering best practices to support the business’s ability to analyze and interpret financial data effectively.
• Develop strategies to enhance existing reporting frameworks, ensuring that they are compatible with the new data models and data structures.

• Work closely with existing development teams to deploy new and revised data models, verifying that the implementation aligns with functional requirements and business goals.
• Act as a liaison between technical and non-technical stakeholders, ensuring clear communication regarding data model changes, system impacts, and timelines.
• Comprehensive assessment report on current Work Program Datamart and General Ledger data models.
• Enhanced data model designs integrating Chart of Account updates.
• Thorough documentation on data quality measures and ETL process enhancements.
• Guidelines on best practices for data visualization and reporting.
• Detailed implementation plan for the deployment and verification of new data models.
• Consistent updates and presentations to stakeholders on project progress and key insights.

Bachelor’s or Master’s Degree in Computer Science, Information Systems.

• A minimum of 7 years of experience with large and complex database management systems.
• A minimum of 7 years of experience as a data architect or senior data analyst, with extensive experience in designing, implementing, and maintaining data models and ETL processes.
• 10+ years of broad experience working with database management systems (such as Oracle, SQL Server, or DB2) and data integration tools.
• Strong background in financial data systems, including data modeling, data governance, and data quality management.
• Proven experience with ETL tools, data warehousing, and automation of data processes to ensure accuracy, timeliness, and completeness of data.
• Experience in data visualization and reporting best practices, with familiarity with tools like Power BI, Tableau, or similar platforms.
• Familiarity with cloud-based data integration solutions, such as Azure or Snowflake.

• Experience with Informatica, Cloud Data Governance and Catalog, Cloud Data Integration, or other modern data integration platforms.
• Strong analytical skills and the ability to translate business requirements into technical specifications.
• Excellent communication and collaboration skills, capable of working effectively with technical and non-technical stakeholders.

The submitted candidate must be able to perform the following duties and/or tasks:

• Analyze and verify existing data models and interfaces in the Work Program Datamart and General Ledger to assess impacts and identify potential disruptions.
• Design and implement…