Data Architect

Intermountain Wood Products - Boise, ID

Full-time - Mid Level

Boise, ID

Merchant Wholesalers, Durable Goods

About the position

The Data Architect/Data Engineer at Intermountain Wood Products is responsible for designing, implementing, and maintaining both traditional and modern data infrastructures. This staff-level role requires expertise in relational databases, cloud technologies, and big data tools to create scalable, efficient, and secure data solutions. The position involves developing strategies for integrating enterprise data, ensuring data quality, and optimizing data access across cloud and on-premise systems, while working on moderate to complex projects under the mentorship of senior-level architects/engineers.

Responsibilities

• Records detailed logical and physical data models in the information repository and coordinates the publication and maintenance of these models.
• Facilitates database design sessions and translates business requirements into logical and physical system designs for moderately complex projects.
• Coordinates the physical database design and implementation process for moderately complex projects.
• Designs the optimal data presentation environment for the customer and works with various reporting tools.
• Coordinates with specific database performance monitoring and tuning tasks including the design of optimization and indexing schemes for moderately complex projects.
• Develops, tests and implements ETL (extract, transformation, and load) routines.
• Documents business requirements and essential functionality requirements for in-house developments.
• Ensures proper integration with existing Intermountain Healthcare’s data, standards, and business processes.
• Provides leadership for moderately complex projects through development of project work plans, recommendations for optimal utilization of resources, milestone tracking, and coordination of project team efforts.
• Keeps management and customers informed of progress and exceptions.
• Assists in the development and implementation of system backup, recovery, and support plans.
• Addresses the customer needs, manages expectations and ensures system-wide integration.
• Participates in the technical review process of designs completed by other designers.
• Develops, documents, and delivers complex ad-hoc queries of production data as requested by business users.

Requirements

• Expertise in relational databases and cloud technologies.
• Experience with big data tools and technologies.
• Proficiency in SQL, Python, and PySpark.
• Ability to develop and implement ETL routines.
• Strong understanding of data modeling and database design principles.
• Experience in performance monitoring and tuning of databases.

Nice-to-haves

• Familiarity with traditional RDBMS platforms.
• Experience in project management and leadership roles.

Benefits

• Health insurance coverage
• 401k retirement savings plan
• Paid holidays
• Professional development opportunities