Database Architect

Information Technology - Remote - Full Time

New Home Co. is a new generation homebuilder focused on the design, construction and sale of innovative and consumer-driven homes in major metropolitan areas in Arizona, California, Colorado, Oregon, Texas, and Washington. NEW HOME was named 2019 Builder of the Year by Professional Builder and is a multi-year recipient of "The Eliant" for Best Overall Customer Experience in the multi-divisional builder segment.

At New Home Co., we believe that PEOPLE matter. The strength of our homes is built upon a foundation of focused, energized, visionary and dedicated team members. Our goal is to provide a workplace that supports you in doing the best work of your life. 

Check out NWHM's 2023 Corporate Sustainability Report 

Job Title: Database Architect

FLSA Status: Salaried Exempt                                 

Position Summary: The Database Architect at New Home Co. is a critical Engineering team member responsible for designing, developing, and maintaining the company's data infrastructure. This role involves creating and optimizing database systems to support business operations, analytics, and reporting needs. The Database Architect will collaborate closely with cross-functional teams to ensure data integrity, availability, and performance, contributing to the organization's goal of delivering robust and scalable solutions for a rapidly growing business.

Key Responsibilities:
1. Data Architecture and Modeling:

  • Database Design:
    • Design logical and physical data models to support new and existing applications.
    • Develop and maintain data architecture diagrams and documentation.
  • Data Standards and Governance:
    • Establish and enforce database development standards, guidelines, and best practices.
    • Ensure data consistency, integrity, and security across all database systems.
2. Data Warehouse Development:
  • Enterprise Data Warehouse (EDW):
    • Lead the design and implementation of the Enterprise Data Warehouse using Kimball methodology.
    • Develop star and snowflake schemas, dimension and fact tables, and manage slowly changing dimensions.
  • Integration of Data Sources:
    • Integrate data from various operational systems such as NewStar, InformXL, Dynamics 365, and third-party systems.
3. ETL Development and Integration:
  • ETL Processes:
    • Develop, maintain, and optimize ETL processes using SQL Server Integration Services (SSIS) and Azure Data Factory.
    • Implement data ingestion from diverse sources, including flat files, relational databases, cloud databases, and APIs.
  • Data Transformation:
    • Ensure data is accurately transformed, cleansed, and loaded into target systems.
4. Business Intelligence and Reporting:
  • Reporting Solutions:
    • Develop and maintain reporting databases and infrastructure to support business intelligence initiatives.
    • Using Power BI, SQL Server Reporting Services (SSRS), and other reporting tools, create interactive dashboards and reports.
  • Analytics Support:
    • Perform data analysis to identify trends, insights, and patterns.
    • Collaborate with business users to understand reporting needs and deliver solutions that support decision-making.
5. Database Administration:
  • Performance Monitoring and Tuning:
    • Monitor database performance and optimize for speed and efficiency.
    • Implement indexing strategies and query optimization techniques.
  • Backup and Recovery:
    • Develop and manage backup and recovery plans to ensure data availability and integrity.
    • Implement disaster recovery strategies.
  • Security and Compliance:
    • Manage database security, including user access controls and data encryption.
    • Ensure compliance with legal requirements, internal policies, and industry standards.
6. Collaboration and Stakeholder Management:
  • Cross-Functional Collaboration:
    • Work closely with software developers, data analysts, and business stakeholders to gather requirements and translate them into technical solutions.
    • Provide technical guidance and support to team members.
  • Project Management:
    • Participate in project planning, estimation, and execution.
    • Ensure timely delivery of database components within project timelines.
7. Cloud Integration:
  • Azure Cloud Services:
    • Utilize Azure SQL Database and other Azure services for cloud-based data solutions.
    • Implement DevOps CI/CD pipelines for database deployments.
  • Cloud Migration:
    • Assist in migrating on-premises databases to cloud platforms as needed.

Qualifications:
Education:
  • Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field.
  • Master’s degree is preferred.
Experience:
  • Minimum of 8 years of experience in database design, development, and administration.
  • Extensive experience with Microsoft SQL Server (previous and current versions and editions).
  • Proven experience in designing and implementing data warehouses and BI solutions.
  • Experience with Azure cloud services and migrating databases to cloud platforms.
  • Experience in the real estate or homebuilding industry is a plus.
Technical Skills:
  • Database Technologies:
    • Expertise in MS SQL Server, including T-SQL programming, stored procedures, functions, triggers, and views.
    • Proficiency with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
  • Business Intelligence Tools:
    • Proficient in Power BI, including Power Query, M language, and DAX.
    • Experience with data visualization and creating interactive dashboards.
  • Data Modeling:
    • Strong understanding of data warehouse methodologies, particularly Kimball.
    • Experience with star and snowflake schemas, dimensional modeling, and data marts.
  • Cloud Services:
    • Familiarity with Azure SQL Database, Azure Data Factory, and DevOps CI/CD.
    • Experience with cloud-based data solutions and services.
  • Programming Languages:
    • Knowledge of SQL, Java, C#, and scripting languages.
    • Familiarity with .NET framework and related technologies.
Other Skills:
  • Analytical Skills:
    • Strong problem-solving abilities and attention to detail.
    • Ability to perform complex data analysis and present findings to stakeholders.
  • Communication Skills:
    • Excellent verbal and written communication skills.
    • Ability to explain technical concepts to non-technical audiences.
  • Collaboration:
    • Proven ability to work effectively in a team environment.
    • Experience collaborating with cross-functional teams and stakeholders.
  • Project Management:
    • Ability to manage multiple tasks and projects simultaneously.
    • Experience with Agile & Waterfall methodologies.
  • Certifications:
    • Microsoft certifications such as MCTS, MCDBA, or equivalent are preferred

Base Salary: The expected base salary range for this position is between $150,000 to $165,000 per year, depending on experience and skillset. Base Salary is paid bi-weekly, every other Friday. Additionally, this position is eligible for an annual bonus based on divisional and individual performance.

Benefits: In addition to competitive medical, dental and vision coverage, The New Home Company provides comprehensive benefits to eligible team members and their dependents, generous paid time off policies, like vacation, holidays, sick leave, jury duty, and bereavement; paid disability, parental and military leave; company-sponsored and voluntary term life, AD&D, and short- and long-term disability insurances; a 401(k) retirement plan with bi-weekly employer matching of 50% up to the first 8% of team member contributions; as well as a wellness incentive program.

The physical demands described below are representative of those that must be met by an employee to successfully perform the essential functions of this job.  Similarly, the work environment characteristics described are representative of those an employee encounters while performing the essential functions of this job.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Physical RequirementsPhysical Requirements
Requires the ability to hear, type and talk in addition to sitting 100% of the time. The primary work location is a corporate or home office with low to moderate noise levels.
The above statements are intended to describe the general nature and level of work being performed by people assigned to this job. They are not intended to be an exhaustive list of all responsibilities, duties, and skills required. New Home Co. retains the discretion to add or change job duties at any time

Apply: Database Architect
* Required fields
First name*
Last name*
Email address*
Location *
Phone number*
Resume*

Attach resume or Paste resume

Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or paste resume

Paste your resume here or attach resume file

Cover Letter*
Do you have a valid driver’s license?*
Are you willing to relocate?*
What’s your highest level of education completed?*
LinkedInLinkedIn profile URL:
Desired salary*
Are you willing to work weekends as needed?*
Are you willing to work overtime as needed?*
Were you referred by a current New Home Co. employee?*
If yes, enter their first and last name here.
What makes you a unique candidate for this position? Tell us something about you that is not on your resume!*
Human Check*