Capitis Solutions Inc. was founded in 2007 and is a Maryland-based Information Technology consulting company, specializing in implementing modern applications. Our philosophy to align with the client’s organizational culture and provide cost effective, quality solutions is key to our success. Our approach to problem solving is unique and our clients benefit from the results in weeks rather than months.
Capitis is seeking a talented Senior Data Conversion Architect to join our dynamic team. They will play a critical role in driving the successful implementation of data conversion projects within our secondary mortgage securitization business. This individual will collaborate with product owners, technical teams, and external clients to ensure that business requirements are accurately captured, converted, and integrated into our systems.
Key Responsibilities:
Requirements Gathering and Analysis:
- Lead the elicitation, analysis, and documentation of business requirements for data conversion projects.
- Identify data gaps and inconsistencies, and work with stakeholders to resolve them.
- Develop detailed functional and non-functional requirements specifications.
- Solution Design and Architecture:
- Participate in the design and development of data conversion solutions, including architecture diagrams, data flow models, and process flows.
- Evaluate and recommend appropriate technologies and tools for data conversion.
- Ensure alignment of data conversion solutions with overall system architecture and business objectives.
Data Mapping and Transformation:
- Develop and maintain data mapping rules and transformation logic to accurately convert data between source and target systems.
- Address data quality and consistency issues during the conversion process.
ETL Development:
- Design, develop, and maintain ETL pipelines using industry-standard tools (e.g., Informatica, Talend, SSIS).
- Optimize ETL processes for performance and efficiency.
Testing and Quality Assurance:
- Define and execute test cases to validate the accuracy and completeness of data conversions.
- Collaborate with testing teams to identify and resolve defects.
- Ensure adherence to data quality standards and compliance requirements.
Project Management and Coordination:
- Coordinate with project teams, including product owners, developers, and testers, to ensure timely delivery of data conversion projects.
- Manage project timelines
- Identify and mitigate project risks and issues.
Required Skills and Experience:
- Strong understanding of mortgage-based securities, particularly Government-Sponsored Agency (GSE) products.
- Proven experience in data conversion projects, including requirements gathering, data mapping, ETL development, and testing.
- Proficiency in ETL tools (e.g., Informatica, Talend, SSIS).
- Advanced SQL skills and experience with relational databases.
- Knowledge of XML schemas, especially MISMO/ULDD standards.
- Familiarity with data quality and governance frameworks.
- Excellent analytical and problem-solving skills.
- Strong communication and interpersonal skills.
- Ability to work independently and as part of a team.
Preferred Skills and Experience:
- Experience with cloud-based data platforms (e.g., AWS).
- Knowledge of enterprise systems including event driven systems
- Knowledge of data modeling and data warehousing concepts.
- Experience with data integration and API development.
- Certification in data management or data engineering.