ETL Developer - (REMOTE)

AMH
Las vegas, NV
29 Mar 2024

Vacancy expired!

American Homes 4 Rent 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 position is responsible for all ETL design and implementation of the organization's financial, operational, and analytical data assets. This role involves working through the Business Intelligence data acquisition lifecycle in a SDLC compliant environment. The role requires the ability to analyze unknown data sources, transform the data to fit the target model, implement of data auditing practices, and mentor on best practices for Junior ETL developers, reporting teams and functional teams in their acceptance of BI solutions. The role will be responsible for the operation, continuous improvement and innovation of the Data Analytics and Enterprise Business Intelligence platform and footprint that is used for delivering a wide variety of data and analytic solutions for various business stakeholders. The role will provide input on ways to improve our processes, incorporate best practices and policies. This position is key in leading AR 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.
  • Collaborates with data architect to implement source data into the designed target model.
  • Maintains the integrity and validity of data throughout the ETL/ELT processing cycle by designing and implementing data reconciliation processes and error handling based on source to target data comparisons.
  • Facilitates code review with peers and 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.
  • Mentors and trains members of the data team to champion code quality, integrity and reusability throughout the department as well as designing and promoting standards and best practices.
  • Creates and maintains documentation of the Data Warehouse/Business Intelligence architectures, objects, standards, and best practices.
  • Troubleshoots production outages and assists with code deployments as needed (occasionally after standard business hours).

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 (8) years in Business Intelligence development
  • Minimum of four (4) years with Data Warehousing methodologies/designs and processes (ETL, ELT, Data Modeling)
  • Proven experience architecting, 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
  • Experience with a variety of ETL tools and methodologies
  • Understanding of data security best practices
  • Understanding of systems integrations and data integration
  • Experience in the following tools and technologies are a plus:
    • Azure Data Factory
    • CICD
    • Cloud environments (particularly Microsoft Azure)
    • Tableau
    • Power BI
    • Microsoft BI stack
  • Excellent planning and organizational skills
  • Ability to interact effectively at all levels
  • Excellent communication skill, both written and verbal
  • Ability to be an effective member of project teams
  • Critical thinking a must. Problem solving skills with the ability to look for root causes and implementable, workable solutions
  • Exceptional communication and personal skills
  • Self-starter able to work with little supervision.
  • Effective prioritization with strong focus on outcomes
  • Experience in Real Estate is a plus

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!

For positions that are permitted or required to work remotely, employees may conduct work only within the United States and only in states where the Company is already conducting business, unless for brief periods, consistent with Company policy.

In the states of Colorado, California and Washington, the anticipated pay range/scale for this position is $105,000 to $150,150. Actual starting base pay within this range will depend on factors including geographic location, education, training, skills, and relevant experience.
  • Position is also eligible to receive a discretionary bonus.
Employees also 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.

Related Keywords: Information Technology, IT, computer science, engineer, etl, sql, power bi, azure, analytics, web development

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 ;br>#LI-PH1 #DICEPHO #remote #DICE #LI-Remote
  • ID: #49581780
  • State: Nevada Las vegas 89101 Las vegas USA
  • City: Las vegas
  • Salary: USD TBD TBD
  • Job type: Permanent
  • Showed: 2023-03-29
  • Deadline: 2023-05-27
  • Category: Et cetera