Invitation Homes
Overview
Data Architect
role at
Invitation Homes Invitation Homes is nations premier home leasing company, pioneering a new industry supported by advanced and robust technology solutions to enhance the resident experience. We are looking for innovative, dynamic individuals who are passionate about building business focused technology solutions using best of the breed tech stacks and take the platform to the next level. The Data Architect will design, implement, and maintain robust data infrastructure to support our data-driven initiatives. The candidate should have a strong background in data engineering, with expertise in data modeling, data processing, Python programming, and database SQL/PLSQL scripting (procedures, functions, dynamic programming, etc.). This role shapes the architecture of our data platform solutions by building and optimizing data models, and standardizing and implementing efficient ETL processes. Active involvement in database management, ensuring data quality and governance, and automation through scripting are integral components of this position. If you are motivated, passionate, a quick learner, and have outstanding data engineering skills, this role is waiting for you! Note: Invitation Homes does not offer employment-based visa sponsorship for this role at this time. Responsibilities
Develop and implement comprehensive and scalable data models that align with business requirements and objectives. Collaborate with data architects and Analysts/Information engineers to understand data needs, optimizing models for performance and analytical use. Regularly review and enhance existing data models to accommodate evolving business requirements and ensure long-term sustainability. ETL Development
Design, develop, and deploy robust ETL processes to extract, transform, and load data from diverse sources into the data lake platform. Gather and understand data integration requirements from business stakeholders to ensure ETL workflows meet processing needs. Monitor and troubleshoot ETL processes to maintain data integrity and minimize downtime. Manage and configure data processing workflows orchestration using enterprise schedulers like AWS Airflow. Framework, Automation & Standardization
Use Python and SQL to build frameworks for source data extraction, transformation, and loading, and craft scripts using PowerShell and Unix shell for end-to-end automated pipelines. Build reusable scripts to automate code deployment (CI/CD) across environments. Develop scripts to manage infrastructure as code (IaaC) using Python/Terraform or AWS CloudFormation. Implement data governance policies to ensure data accuracy, consistency, and security. Participate in data quality improvement initiatives and provide guidance on best practices. Implement solutions to automate code reviews based on organizational standards. Education and/or Experience
Bachelors Degree in Computer Science or equivalent work experience 7+ years in enterprise-scale data warehousing, data engineering, and data lake solutions Minimum 3+ years of data modeling experience (Dimensional Modeling, Normalized models, OBTs, etc.) Kno wledge of ETL/ELT tools (AWS Glue, DBT, SSIS, Apache Spark, Informatica) 3+ years with modern columnar data platforms (Snowflake, AWS Redshift, Azure Synapse) Extensive SQL/PLSQL scripting, dynamic programming, and performance tuning 3+ years using Python for data engineering solutions Experience with data pipeline orchestration tools (Airflow, Control-M, AutoSys) 3+ years of cloud experience, preferably AWS, with related data services (Glue, S3, Lambda, CloudWatch, MWAA, etc.) Strong understanding of core infrastructure components (servers, network, storage) Experience with Git for version control in a team environment Experience in an agile development environment Skills and Knowledge
Excellent communication, presentation, and interpersonal skills Ability to work under pressure in a fast-paced environment Attention to detail and accuracy Collaboration and consensus-building abilities Passion for technology and ongoing learning Experience building analytic solutions for Sales, Finance, Product, Operations, and Marketing in an enterprise setting Experience data quality management in a data warehouse Experience with Salesforce and Yardi in real estate domain is highly desirable Experience with CI/CD and agile methodologies in large teams Salary range: $118,800.00 - $205,920.00 plus eligible for annual discretionary bonus. Actual compensation depends on skills, experience, location, and applicable laws. Benefits include: annual bonus, health/dental/vision/life insurance, disability insurance, generous paid time off, 401(k) with company match, casual work environment, team events. Invitation Homes is an equal opportunity employer committed to fostering a diverse, inclusive and innovative environment. If you require accommodation, contact humanresources@invitationhomes.com. #J-18808-Ljbffr
Data Architect
role at
Invitation Homes Invitation Homes is nations premier home leasing company, pioneering a new industry supported by advanced and robust technology solutions to enhance the resident experience. We are looking for innovative, dynamic individuals who are passionate about building business focused technology solutions using best of the breed tech stacks and take the platform to the next level. The Data Architect will design, implement, and maintain robust data infrastructure to support our data-driven initiatives. The candidate should have a strong background in data engineering, with expertise in data modeling, data processing, Python programming, and database SQL/PLSQL scripting (procedures, functions, dynamic programming, etc.). This role shapes the architecture of our data platform solutions by building and optimizing data models, and standardizing and implementing efficient ETL processes. Active involvement in database management, ensuring data quality and governance, and automation through scripting are integral components of this position. If you are motivated, passionate, a quick learner, and have outstanding data engineering skills, this role is waiting for you! Note: Invitation Homes does not offer employment-based visa sponsorship for this role at this time. Responsibilities
Develop and implement comprehensive and scalable data models that align with business requirements and objectives. Collaborate with data architects and Analysts/Information engineers to understand data needs, optimizing models for performance and analytical use. Regularly review and enhance existing data models to accommodate evolving business requirements and ensure long-term sustainability. ETL Development
Design, develop, and deploy robust ETL processes to extract, transform, and load data from diverse sources into the data lake platform. Gather and understand data integration requirements from business stakeholders to ensure ETL workflows meet processing needs. Monitor and troubleshoot ETL processes to maintain data integrity and minimize downtime. Manage and configure data processing workflows orchestration using enterprise schedulers like AWS Airflow. Framework, Automation & Standardization
Use Python and SQL to build frameworks for source data extraction, transformation, and loading, and craft scripts using PowerShell and Unix shell for end-to-end automated pipelines. Build reusable scripts to automate code deployment (CI/CD) across environments. Develop scripts to manage infrastructure as code (IaaC) using Python/Terraform or AWS CloudFormation. Implement data governance policies to ensure data accuracy, consistency, and security. Participate in data quality improvement initiatives and provide guidance on best practices. Implement solutions to automate code reviews based on organizational standards. Education and/or Experience
Bachelors Degree in Computer Science or equivalent work experience 7+ years in enterprise-scale data warehousing, data engineering, and data lake solutions Minimum 3+ years of data modeling experience (Dimensional Modeling, Normalized models, OBTs, etc.) Kno wledge of ETL/ELT tools (AWS Glue, DBT, SSIS, Apache Spark, Informatica) 3+ years with modern columnar data platforms (Snowflake, AWS Redshift, Azure Synapse) Extensive SQL/PLSQL scripting, dynamic programming, and performance tuning 3+ years using Python for data engineering solutions Experience with data pipeline orchestration tools (Airflow, Control-M, AutoSys) 3+ years of cloud experience, preferably AWS, with related data services (Glue, S3, Lambda, CloudWatch, MWAA, etc.) Strong understanding of core infrastructure components (servers, network, storage) Experience with Git for version control in a team environment Experience in an agile development environment Skills and Knowledge
Excellent communication, presentation, and interpersonal skills Ability to work under pressure in a fast-paced environment Attention to detail and accuracy Collaboration and consensus-building abilities Passion for technology and ongoing learning Experience building analytic solutions for Sales, Finance, Product, Operations, and Marketing in an enterprise setting Experience data quality management in a data warehouse Experience with Salesforce and Yardi in real estate domain is highly desirable Experience with CI/CD and agile methodologies in large teams Salary range: $118,800.00 - $205,920.00 plus eligible for annual discretionary bonus. Actual compensation depends on skills, experience, location, and applicable laws. Benefits include: annual bonus, health/dental/vision/life insurance, disability insurance, generous paid time off, 401(k) with company match, casual work environment, team events. Invitation Homes is an equal opportunity employer committed to fostering a diverse, inclusive and innovative environment. If you require accommodation, contact humanresources@invitationhomes.com. #J-18808-Ljbffr