Data Architect

Annapolis, MD - USA

Monthly Salary: $ 135000 - 175000

Posted on: 21-10-2025

Vacancies: 1 Vacancy

Job Summary

The Company

HASI is an investor in sustainable infrastructure assets advancing the energy transition. With more than $14 billion in managed assets our investments are diversified across multiple asset classes including utility-scale solar onshore wind and storage; distributed solar and storage; RNG; and energy efficiency. We combine deep expertise in energy markets and financial structuring with long-standing programmatic client partnerships to deliver superior risk-adjusted returns and measurable environmental benefits. HA Sustainable Infrastructure Capital Inc. is listed on the New York Stock Exchange (Ticker: HASI). For more information visit .

Position Summary

Responsible for the design development implementation and support of mission-critical enterprise data solutions. As a Data Architect you will work with cross-functional teams to gather and document data integration and development requirements to meet business needs. You will design develop test and implement database solutions that bring together complex data from disparate sources into databases data warehouses and data lakes. You will integrate data across systems using web-based APIs and other unstructured and semi-structured sources including extensive ingestion and processing of Excel files. The role will also require practical experience with data governance tools and ERP systems specifically SAP General Ledger.

SALARY RANGE:

Expected salary range of $135000 - $175000 based on experience and addition HASI offers an annual bonus program; 401(k) with company match; an equity incentive program; comprehensive medical dental and vision benefits; paid time off for vacation holidays and sick days; and much more.

Key Responsibilities

Develop and implement scalable high-performance and secure data architectures that meet business requirements and integrate with various data systems (e.g. databases data warehouses data marts data lakes Microsoft Fabric and other cloud platforms).

Translate business requirements into specifications for data structures and relationships including data imports/exports transformations and associated processes.

Create and maintain data models for complex non-uniform datasets using modern data access and storage methodologies.

Lead data management and governance practices by establishing data quality standards defining data governance policies (leveraging tools such as Microsoft Purview) ensuring compliance with regulatory requirements and driving best practices for data security privacy and lifecycle management.

Design and oversee the integration of data from multiple sources and formatsstructured semi-structured and unstructuredincluding large-scale ingestion and parsing of hundreds of Excel files.

Manage and support production databases data warehouses and ETL processes including security backups and upgrades ensuring speed scalability and reliability.

Provide expertise in Excel data modeling Power BI and Power Query for business analytics and reporting solutions.

Provide support as required to ensure availability and operation of applications and ETL processes.

Continuously monitor assess and improve the performance of data systems ensuring efficient data processing and reducing system bottlenecks.

Ensure proper configuration management and change controls are executed to policy.

Provide training and assistance to users for any developed systems or processes.

Participate in business analysis activities to gather data requirements.

Design and implement technology using best practices to create efficient manageable understandable reliable and well-documented implementations.

Qualifications

Bachelors degree in Computer Science Data Science or relevant field.

5 years experience designing and developing with Microsoft SQL Server (required).

5 years experience developing with Python including data parsing and transformation (required).

2 years experience working with SAP General Ledger and performing integration/migration tasks with SAP data.

Hands-on experience with data governance tools such as Microsoft Purview.

Demonstrated ability to ingest parse and transform data from a wide variety of formats including the ability to process and parse hundreds of Excel files as part of the data ingestion pipeline.

Experience with Microsoft Fabric Excel data modeling Power BI and PowerQuery.

4 years experience designing and developing data warehouses.

3 years experience with modern data technologies (e.g. Snowflake Spark Kafka).

3 years experience developing and deploying ETL solutions.

3 years experience working with data pipeline and orchestration services (e.g. AirFlow SSIS Azure Data Factory AWS Data Pipeline/Glue FiveTran).

Expert knowledge of logical and physical data modeling concepts (relational and dimensional).

Experience performance tuning for large complex data sets.

Experience working with Git.

Experience working with structured semi-structured and unstructured data sources.

Familiarity with DevOps and database deployment automation tools (e.g. CI/CD SSDT).

WORK AUTHORIZATION

HASI is willing to take over sponsorship for existing H1-B visas for exceptional talent. We are unable to provide new H-1B sponsorship at this time.

EEO STATEMENT

The Company maintains a policy of non-discrimination in employment and complies with and supports all Federal state and local laws regarding discrimination in employment. Specifically the Company does not discriminate in employment opportunities or practices against any employee intern or applicant on the basis of race color gender sex sexual orientation gender identity religion ancestry national origin age citizenship status marital status pregnancy (including childbirth lactation or related medical conditions) mental or physical disability veteran status uniformed servicemember status genetic information (including testing and characteristics) or any other characteristic to the extent prohibited by federal state or local law. Decisions regarding staffing selection and promotions are made on the basis of individual qualifications related to the requirements of the position. If you need reasonable accommodation for a job opening please connect with us at and describe the specific accommodation requested for a disability-related limitation. Reasonable accommodations are modifications or adjustments to the application or hiring process that would enable you to fully participate in that process.

We may use artificial intelligence (AI) tools to support parts of the hiring process such as reviewing applications analyzing resumes or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed please contact us.

The Company HASI is an investor in sustainable infrastructure assets advancing the energy transition. With more than $14 billion in managed assets our investments are diversified across multiple asset classes including utility-scale solar onshore wind and storage; distributed solar and storage; RNG;...