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 diversityAs pioneers in the industry, solidified by our place on wall street, american homes 4 rent (nyse: amh) is currently looking for qualified candidatesWith 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 assetsThis role involves working through the bi data acquisition lifecycleThe 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 solutionsThis 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.
Responsibilities
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.
Requirements
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 mustProblem 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:
Tableau
Power bi
Microsoft sql stack
Talend
Work where you feel right at home
If you are a versatile professional who values culture, a concerted environment and the potential for exponential growth, we want to work with you! apply now and someone from our talent acquisition team will reach out to you soon!
Information regarding ah4r’s collection and use of your personal information can be found at https://www.ah4r.com/employeeprivacy
