$80K — $100K *
As one of the country’s fastest-growing property management companies of single-family rental homes, American Homes 4 Rent has an exhilarating and fluid start-up culture and permanency of a well-founded corporation, rich with diversity. As pioneers in the industry, solidified by our place on Wall Street, American Homes 4 Rent (NYSE: AMH) is currently looking for qualified candidates. With a culture of unprecedented growth, quality and innovative collaboration, we are seeking personalities to complement our attributes.
The ETL Developer is responsible for all ETL design and implementation of the organization’s financial, operational, and analytical data assets. This role involves working through the BI data acquisition lifecycle. The role requires the ability to analyze unknown data sources, transforming the data to fit the target model, implementation of data auditing practices, and mentor on best practices for reporting teams and functional teams in their acceptance of BI solutions. This position is key in leading AH4R to become more mature in terms of the understanding of their data assets and empowering teams with self-service analytics.
Responsible for designing and implementing ETL architecture to meet corporate data management needs and business functional requirements, ensuring that solution designs address operational requirements such as scalability, maintainability, extensibility, flexibility, and integrity.
Collaborate with data architect to implement source data into the designed target model.
Maintain the integrity and validity of data throughout the ETL processing cycle by implementing data reconciliation processes and error handling based on source to target data comparisons.
Facilitates code review with data architect to ensure high performance, consistency, and adherence to standards.
Engages with cross functional teams on integration efforts for merging BI platforms with enterprise systems and applications.
Champions code quality, integrity and re-usability throughout the department by designing and promoting standards and best practices.
Creates and maintains documentation of the Data Warehouse/Business Intelligence architectures, objects, standards, and best practices.
Bachelor’s degree in Computer Science, Information Systems, Business, Finance, Management Information Systems, Mathematics, Engineering, Statistics, Economics or a related field preferred, or equivalent combination of education, training, and experience.
Minimum of (4) years in Business Intelligence development
Minimum of three (3) years with Data Warehousing methodologies/designs and processes (ETL, Data Modeling)
Proven experience designing, developing and deploying Enterprise Business Intelligence solutions to Production
Highly proficient in SQL with the ability to write and understand complex SQL Server programmable objects such as stored procedures with Dynamic SQL.
Understanding of systems integrations and data integration
Critical thinking a must. Problem solving skills with the ability to look for root causes and implementable, workable solutions
Experience in Real Estate is a plus
Experience in the following tools and technologies are a plus:
Microsoft SQL stack
Valid through: 12/16/2020