Enterprise Data Architect - Amsys Innovative Solutions LLC

Polluxa, Inc.; Houston (TX); On-site; USD 140,000 - 180,000; Full time

Job summary

Polluxa, Inc. is seeking a hands-on Enterprise Data Architect to support a data environment spanning on-premises SQL Server and cloud platforms, with Microsoft Fabric experience preferred.

This role blends architecture and implementation, translating business requirements into target-state architecture, logical and physical data designs, integrations, and working technical solutions.

Qualifications

• Strong data architecture experience across on-prem SQL Server and cloud platforms.
• Hands-on data engineering with SQL design, development, maintenance, and performance tuning.
• Experience with Medallion Architecture (Bronze/Silver/Gold) for data warehousing and analytics.

Responsibilities

• Translate business requirements into target-state architecture, logical and physical data designs, integrations, and working technical solutions.
• Develop and manage SQL-based code and Python for data processing and pipelines.
• Create target-state architectures, data models, and data-flow diagrams; contribute to architecture reviews.

Skills

Data architecture

SQL design

Python

Data modeling

Cloud data platforms

Medallion Architecture

Data integration

MDM

Architecture artifacts

Architecture reviews

Tools

Microsoft Fabric

SQL Server

Job description

Immediate opening for a hands-on Enterprise Data Architect to support a data environment spanning on-premises SQL Server and cloud platforms, with Microsoft Fabric experience preferred.

This role requires someone who can work across both architecture and implementation, translating business requirements into target-state architecture, logical and physical data designs, integrations, and working technical solutions.

What We're Looking For

• Strong data architecture experience across on-prem SQL Server and cloud data platforms
• Experience with Medallion Architecture (Bronze/Silver/Gold) for data warehousing and analytics
• Strong conceptual, logical, and physical data modeling, including fact and dimensional modeling
• Hands-on data engineering experience with SQL design, development, maintenance, and performance tuning
• Experience developing and managing SQL-based code and Python
• Microsoft Fabric experience preferred
• Experience with enterprise data integration and application-to-application data integration
• Data governance and Master Data Management (MDM) experience; data quality experience is a plus
• Experience creating target-state architectures, HLDs/LLDs, architecture decks, data models, and data-flow diagrams
• Experience evaluating data ecosystems, platforms, and architecture solutions
• Experience establishing architecture standards and reference data architectures
• Ability to work with security, risk, and governance teams through architecture review and approval

We are looking for someone who combines Enterprise Data Architecture with hands-on data engineering, SQL, and data modeling experience. This is not a high-level architecture or governance-only role.