Since 2012, we've grown to become one of the leading single-family rental companies and homebuilders in the country, recently recognized as a top employer by Fortune and Great Place To Work®. At AMH, our goal is to simplify the experience of leasing a home through professional management and maintenance support, so our residents can focus on what really matters to them, wherever they are in life.
The
Data Engineer will collaborate with the Data Architect to implement data frameworks and processes. Develops data models, maintains data warehouse and analytics environment. Writes scripts for data integration and analysis. Collaborates with key stakeholders of the Data Transformation, Data Governance, and Business Intelligence teams to define business requirements and objectives. Designs and builds data provisioning workflows/pipelines, physical data schemas, extracts, data transformations, and data integrations and/or designs using ETL and microservices. Participates and leads peer development and code reviews with focus on test driven development and Continuous Integration and Continuous Development (CICD). Manages large projects or processes with limited oversight from manager. Mentors and reviews work for junior ETL Developers, Reporting teams, and functional teams in their acceptance of Data solutions.
Responsibilities
- Designs and implements data management architecture to meet corporate data management needs and business functional requirements. Ensures that solution designs address operational requirements such as scalability, maintainability, extensibility, flexibility, and integrity.
- Designs and builds data provisioning workflows/pipelines, physical data schemas, extracts, data transformations, and data integrations and/or designs using ETL and microservices.
- Designs and develops programs and tools to support ingestion, curation, and provisioning of complex enterprise data to achieve analytics, reporting, and data science.
- Leads peer development and code reviews with focus on test driven development and CICD.
- Monitors the system performance by performing regular tests, troubleshoots, and integrates new features.
- Engages with cross functional teams on database integration efforts for merging BI platforms with enterprise systems and applications.
- Designs and implements data management architecture to meet corporate data management needs and business functional requirements. Ensures that solution designs address operational requirements such as scalability, maintainability, extensibility, flexibility, and integrity.
Requirements
- High school diploma or GED required
- Bachelor’s degree in computer science, information systems, business, finance, management information systems, mathematics, physics, engineering, statistics, economics, and/or a related field preferred
- Minimum eight (8) years in Business Intelligence Development (OLAP, ODS, Data Marts)
- Minimum four (4) years of experience in Database Warehousing methodologies/designs and processes (ETL, ELT, Data Modeling, Data Cleansing, Data Quality)
- Intermediate experience with methodologies, designs, and processes in technical areas of ETL, ELT, and Data Modeling
- Intermediate experience in developing data ingestion, data processing and analytical pipelines for big data, relational databases, NoSQL, and data warehouse solutions
- Intermediate understanding for providing practical direction within the Azure Native services
- Hands-on experience implementing data migration and data processing using Azure services: ADLS, Azure Data Factory, Azure Functions, Synapse/DW, Azure SQL DB, Event Hub, IOT Hub, Azure Stream Analytics, Azure Analysis Service, HDInsight, Databricks Azure Data Catalog, Cosmo Db, ML Studio, AI/ML, etc.
- Intermediate experience with Big Data technologies such as PowerShell, C#, Java, Node.js, Python, SQL, ADLS/Blob, Apache Spark/SparkSQL, Databricks, Hive and streaming technologies such as Kafka, EventHub, NiFi, etc.
- Intermediate experience in RESTful APIs and messaging systems, and AWS or Microsoft Azure
- Intermediate experience with other BI tools such as Power BI, SSRS, SSAS and Tableau
- Advanced understanding of data security best practices
- Advanced understanding of systems and data integration
- Critical thinking is a must
- Problem solving skills with the ability to look for root causes and implementable, workable solutions, as well as process improvement ability
- Proven ability to perform high quality technical documentation and presentations
- Excellent organization, time management and communication skills
- Ability to be an effective member of project teams
- Demonstrate professionalism, flexibility/adaptability, ability to multi-task and work in a team environment
Compensation
The anticipated pay range/scale for this position is $105,322.00 to $131,652.00 Annually. Actual starting base pay within this range will depend on factors including geographic location, education, training, skills, and relevant experience.
Additional Compensation
This position is eligible to receive a discretionary annual bonus.
Perks and Benefits
Employees have the opportunity to participate in medical, dental and vision insurance; flexible spending accounts and/or health savings accounts; dependent savings accounts; 401(k) with company matching contributions; employee stock purchase plan; and a tuition reimbursement program. The Company provides 9 paid holidays per year, and, upon hire, new employees will accrue paid time off (PTO) at a rate of 0.0577 hours of PTO per hour worked, up to a maximum of 120 hours per year.
CA Privacy Notice: To learn more about what information we collect when you apply for a job, and how we use that information, please see our CA Job Applicant Privacy Notice found at https://www.amh.com/ca-privacy-notice.
