Senior Data Transformation Architect

This is a fully remote position, open to applicants in United States.

📋 Description

• Design, develop, and sustain enterprise data architecture solutions that facilitate business growth, enhance operational efficiency, ensure regulatory compliance, and address risk management objectives.

• Spearhead modernization efforts across data platforms, integration frameworks, reporting environments, and analytical capabilities.

• Assess and integrate emerging technologies, such as cloud services, artificial intelligence, machine learning, automation, and advanced analytics solutions when applicable.

• Create scalable and reusable data integration frameworks that minimize maintenance efforts and accommodate future business growth.

• Develop and refine ETL/ELT processes, data pipelines, and data movement strategies across various systems and platforms.

• Collaborate with business leaders, risk management teams, compliance professionals, and technology stakeholders to convert business requirements into enduring technical solutions.

• Design data models, metadata strategies, governance frameworks, lineage tracking, and quality controls that meet enterprise reporting and regulatory needs.

• Work with stakeholders to uncover opportunities for process automation, operational enhancements, and improved decision-making through data-driven solutions.

• Establish and advocate for development standards, architectural best practices, and data engineering disciplines that achieve a balance between agility and long-term maintainability.

• Review existing systems and processes to identify technical debt, scalability challenges, operational risks, and opportunities for modernization.

• Facilitate risk modeling, forecasting, financial analytics, and strategic reporting initiatives through effective data architecture and engineering practices.

• Implement monitoring, validation, reconciliation, and control processes to ensure data accuracy, integrity, availability, and auditability.

• Engage in technology roadmap planning and provide architectural direction for future platform evolution.

• Act as a technical leader and trusted advisor across various business and technology teams.

• Stay informed about regulatory expectations, industry trends, cybersecurity considerations, and emerging technologies that affect financial services organizations.

⛳️ Requirements

• Bachelor’s degree in Computer Science, Information Systems, Data Engineering, Data Science, Mathematics, Finance, or a related field; an equivalent combination of education and experience will be considered.

• 5+ years of experience in designing, developing, and supporting enterprise data solutions.

• 5+ years of experience in financial services, banking, fintech, insurance, or other highly regulated environments is preferred.

• Advanced expertise in Microsoft SQL Server, T-SQL, data modeling, database design, and performance tuning.

• Strong background in developing and supporting ETL/ELT processes using SSIS or similar integration technologies.

• Proven experience in designing scalable and reusable data architectures that meet long-term business growth and evolving requirements.

• Experience in leading or making significant contributions to data modernization initiatives.

• Familiarity with implementing data governance, data quality, lineage, reconciliation, and audit controls.

• Experience in supporting enterprise reporting, analytics, forecasting, risk management, or financial modeling initiatives.

• Demonstrated ability to translate complex business requirements into effective technical solutions.

• Experience in assessing and implementing emerging technologies including cloud platforms, AI, machine learning, automation, and advanced analytics solutions.

🏝️ Benefits

• This role does not carry managerial responsibilities. However, it is anticipated that the position will provide technical leadership, mentorship, architectural guidance, and influence across project teams and stakeholders.