Data Architect

  • Hannon Armstrong
  • Annapolis, MD
  • May 29, 2021
Information Technology

Job Description

THE COMPANY
Hannon Armstrong (NYSE: HASI) is the first U.S. public company solely dedicated to investments in climate change solutions, providing capital to leading companies in energy efficiency, renewable energy, and other sustainable infrastructure markets. Hannon Armstrong's core purpose is to make climate-positive investments with superior risk-adjusted returns. For more information, please visit www.hannonarmstrong.com. Follow Hannon Armstrong on LinkedIn and Twitter @HannonArmstrong.
POSITION SUMMARY
Responsible for the design, development, implementation, and support of mission-critical enterprise data solutions.  Working with cross-functional teams, you will participate in gathering and documenting data, integration, and development requirements to meet business needs. Using your skills and experience as a data architect, you will design, develop, test, and implement database and ETL solutions to transmit, transform, and store data into data warehouse(s)/data mart(s), integrate disparate systems, web-based APIs, and other unparsed/semi-structured sources. This position is based in Annapolis, Maryland (with remote work temporarily applicable at the time of hire due to the ongoing pandemic). 

KEY RESPONSIBLITES

  • Participate in business analysis activities to gather required data requirements
  • Translate business requirements into specifications that will be used to implement the required data structures and relationships including data imports/exports, transformations, and associated processes
  • Manage and support production databases, data warehouses, and ETL processes including security, backups, and upgrades
  • Provide support as required to ensure the availability and operation of applications and ETL processes
  • Ensure proper configuration management and change controls are executed to policy
  • Prepare accurate database design and architecture reports for management and executive teams
  • Oversee the migration of data from legacy systems to new solutions
  • Monitor the system performance by performing regular tests, troubleshooting, and integrating new features
  • Recommend solutions to improve new and existing database systems
  • Provide training and assistance to users for using any developed systems or processes
  • Design and implement technology using best practices and guidelines such that implementations are efficient, manageable, understandable, reliable, and well documented

QUALIFICATIONS

  • Bachelor’s degree in computer science, computer engineering, or relevant field
  • 5+ years of experience designing and developing SQL Server (T-SQL) and Oracle databases
  • 4+ years of experience designing and developing data warehouses
  • 3+ years of experience using modern data warehouse technologies (ex. Snowflake, Redshift, etc)
  • 3+ years of experience developing and deploying ETL solutions
  • 3+ years of experience developing Python
  • 3+ years of experience developing SSIS or with other ETL services (ex. Azure Data Factory, AWS Data Pipeline/Glue, Stitch, Talend, FiveTran, Matillion, etc.)
  • Strong knowledge of logical and physical data modeling concepts (relational and dimensional)
  • Experience performance tuning for large complex data sets
  • Experience working with version control systems (ex. Git)
  • Experience working with structured and unstructured data sources
  • Familiarity with DevOps and Database Deployment Automation tools (ex. SSDT, etc.)
  • Excellent interpersonal (verbal and written) English language communication skills are required to support working in project environments that includes internal, external, and customer teams
  • Strong analytical, conceptual, and problem-solving abilities required
  • Must be able to quickly learn and adapt to new technologies
  • Ability to manage multiple priorities, and assess and adjust quickly to changing priorities

COMPENSATION  Salary commensurate with experience 
TO APPLY Please visit www.hannonarmstrong.com to submit an application for this position. Select the Careers tab from the homepage and then click on View Current Job Openings. 
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.  

Organization Type

Company

Organization Size

51-100

Sectors

Energy, Funding

Drawdown solutions

Offshore Wind Turbines, Onshore Wind Turbines, Utility-Scale Energy Storage, Utility-Scale Solar Photovoltaics

Want us to tweet your job? Please write your organization's twitter username below (just the username, please do not add the '@')

HannonArmstrong