Data Solutions Architect

About The Organization

The Momentus Capital branded family of organizations - which includes Capital Impact Partners, CDC Small Business Finance, and Ventures Lending Technologies - is transforming how capital and investments flow into communities to provide people access to the capital and opportunities they deserve. We are working to reinvent traditional financial systems that have failed to address systemic issues of inequality, economic empowerment, and the widening racial wealth gap by offering a continuum of financial, knowledge, and social capital to help local leaders build inclusive and equitable communities and create generational wealth.

This includes a comprehensive package of loan products, impact investment opportunities, training and business advising programs, and technology services that advance locally-led solutions. Our suite of products and services, experience, and scope will foster equitable job creation, wealth building, and economic mobility.

Position Summary

Acting as an internal consultant to business and information technology delivery teams, the Solutions Data Architect candidate will architect and design data and technology solutions that are strategic for the business and built using the latest technologies and techniques. Utilizing data engineering and technology knowledge, the candidate will play a major role in architecting custom developed and COTS integration solutions and deliver secure, reliable, resilient and scalable data management solutions.

The Solutions Data Architect will have expertise in SSIS, Azure Data Services, and data integration, complemented by extensive experience in Power BI reporting integration and Salesforce integration. The ideal candidate will possess a strong understanding of SSIS DB, Azure Managed Instance (MI), and Azure Data Factory (ADF), and will be responsible for building and optimizing data pipelines, managing cross-platform data flows, and integrating business intelligence platforms.

The role also requires a solid background in data security, experience in the financial domain, and a proven ability to enhance system efficiency.

Essential Responsibilities

• Partner with senior business and IT management to develop and architect cost effective data and technology solutions that meet CIP objectives.
• Propose recommended and/or best practices regarding the movement, manipulation, and storage of application and enterprise data.
• Overall ownership for the data architecture and detail design.
• Research and experiment with emerging data technologies and tools (i.e., structured and big data).
• Lead technical discussions with internal and external (COTS Vendors) that drive decisions and implementation.
• Provide expert support, analysis, research, and advice into exceptionally complex problems, and processes relating to the subject matter.
• Serve as technical expert on data and software development/integration initiatives providing technical direction, interpretation and alternatives.
• Participate in tool evaluations and technology assessment.
• Synthesize requirements from business and produce Technical Architecture Design Document.
• Collaborate with business units and the Business Systems Analyst to understand business requirements and provide architectural solutions that align with both functional needs and data security protocols.
• Design and develop scalable data models, data warehouses, and pipelines to support business needs, ensuring compliance with data security and financial industry regulations.
• Conduct thorough data analysis and profiling to ensure data quality and integrity across all systems.
• Develop, deploy, and manage packages, utilizing SSIS DB for seamless and secure integration, particularly in financial applications.
• Create Data Engineering solutions using SQL Server and Microsoft Data, leveraging a tech stack that includes Azure ML, ADF, Synapse, Databricks, Stream Analytics, SSIS, SSRS, Power BI, and more.
• Serve as an Azure Data Architect, assisting in building data engineering solutions by creating frameworks, guidelines, and best practices for data engineers to utilize in their workflows.
• Leverage ADLS, Azure Databricks, Azure Synapse Spark Pool, Dedicated SQL Pool, and Azure Stream Analytics to create effective data solutions, including the use of Snowflake for Data Warehousing.
• Build and optimize ETL/ELT pipelines using Azure Data Factory (ADF), adhering to best practices for data governance.
• Create Data Engineering pipelines using Azure Data Factory and Azure…