Enterprise Data Warehouse / Data Architect

Enterprise Data Warehouse / Data Architect

Jacksonville, FL 32246 | Full-Time | *Onsite | Monday–Friday, 8:00 AM–5:00 PM

Important Eligibility Requirements

• Must be authorized to work in the United States.
• **No visa sponsorship available, No H-1B transfers, No C2C / Corp-to-Corp arrangements.**

About the Role

We are seeking an experienced Enterprise Data Warehouse / Data Architect to lead the design, development, and evolution of a scalable, modern enterprise data environment.

This role will be responsible for data architecture, data modeling, ETL/ELT pipelines, cloud data solutions, data quality, governance, security, and performance optimization. You will partner with Engineering, DevOps, Business, Analytics, and Data Science teams to turn complex data into reliable, accessible information that supports reporting, business intelligence, analytics, and data-driven decision-making.

This is a hands-on technical leadership position with the opportunity to establish data architecture standards, solve complex technical challenges, improve data capabilities, and mentor members of the data team.

Key Responsibilities

Data Architecture & Data Warehouse

• Lead the design and implementation of a scalable, high-performance enterprise data warehouse.
• Define data architecture standards, principles, and best practices.
• Develop modern, maintainable, resilient, and cost-effective data solutions.
• Evaluate existing data infrastructure and identify opportunities for improvement.
• Design data solutions that support reporting, BI, analytics, and data science.

Data Modeling

• Design and implement dimensional data models, including star and snowflake schemas.
• Develop conceptual, logical, and physical data models.
• Ensure models align with business requirements and support self-service analytics.
• Perform data cleansing, normalization, transformation, and other data preparation activities.

ETL/ELT & Data Pipelines

• Design, develop, and optimize ETL/ELT pipelines.
• Integrate structured and unstructured data from multiple sources.
• Develop scalable pipelines supporting batch and real-time workloads.
• Implement incremental data processing strategies.
• Troubleshoot pipeline failures, schema changes, and data integrity issues.

Data Governance, Quality & Security

• Establish data governance practices, including data cataloging, lineage, and metadata management.
• Implement data validation, anomaly detection, and quality monitoring.
• Support data security through role-based access control (RBAC), encryption, and appropriate compliance controls.
• Partner with security and technical teams to protect sensitive data.

Cloud Data Architecture

• Design and implement cloud-based data warehouse solutions.
• Work with AWS, Azure, and/or GCP cloud technologies.
• Support cloud data integration, storage, processing, and monitoring.
• Experience with Microsoft Fabric, Synapse, or OneLake is preferred.

Performance & Optimization

• Optimize database and warehouse performance through query tuning, indexing, partitioning, and caching.
• Monitor and troubleshoot performance issues.
• Analyze data to identify trends, anomalies, and relationships.
• Design solutions that balance performance, scalability, reliability, and cost.

Cross-Functional Collaboration

• Partner with business stakeholders and analysts to translate requirements into scalable data solutions.
• Work closely with Software Engineering and DevOps teams.
• Communicate technical concepts, project status, risks, and recommendations to technical and non-technical stakeholders.
• Promote data-driven decision-making across the organization.

Leadership & Mentoring

• Provide technical leadership and mentoring to data team members.
• Establish and document standards for data warehouse development and governance.
• Promote best practices across data engineering and architecture.
• Stay current with emerging data engineering, cloud, analytics, and AI technologies.

Technology Environment

Experience with the following technologies is highly desirable:

• Data Warehousing: Snowflake, AWS Redshift, Google BigQuery, Azure Synapse, Microsoft Fabric/OneLake
• Cloud: AWS S3, Glue, Lambda; GCP Dataflow, Pub/Sub; Azure Data Factory/Synapse
• Programming: SQL, Python, Scala
• ETL/ELT: dbt, Informatica, Talend, Apache Airflow, Fivetran
• Databases: SQL Server, MySQL, MongoDB, Cassandra
• Streaming: Kafka, Pub/Sub, REST APIs
• BI: Power BI, Tableau, Looker, Mode Analytics
• Data Governance: Data lineage, metadata management, data cataloging, data quality, RBAC, encryption

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, Data Analytics, Software Engineering, or a related field.
• 6+ years of experience in data analytics, data engineering, data architecture, or software engineering focused on data warehouse design and implementation.
• Proven experience designing enterprise-scale dimensional data models.
• Strong understanding of star schemas, snowflake schemas, OLAP, OLTP, and modern data warehouse architecture.
• Hands-on ETL/ELT development experience.
• 3+ years of experience with cloud-based data warehouse platforms such as Snowflake, AWS Redshift, Google BigQuery, or Azure Synapse.
• Advanced SQL skills.
• Experience with Python and/or Scala.
• Experience with relational databases; NoSQL experience preferred.
• Experience with data governance, data quality, metadata, lineage, and RBAC.
• Experience working with cross-functional technical and business teams.
• Ability to work independently with minimal supervision.

Preferred Experience

• Microsoft Fabric, Synapse, or OneLake
• SAP or ERP data environments
• Manufacturing or regulated industry experience
• Power BI, Tableau, or Looker
• Kafka or other event-driven architecture
• Machine learning and feature engineering
• Natural language processing
• AI/data science environments
• HIPAA, GDPR, CCPA, or other data privacy requirements

What We're Looking For

• Strong analytical and problem-solving skills.
• Ability to tackle complex technical challenges and develop practical solutions.
• Strong understanding of scalable and fault-tolerant data architecture.
• Excellent communication skills with both technical and non-technical stakeholders.
• Ability to explain complex data concepts in a clear, business-friendly manner.
• Strong leadership, coaching, and mentoring abilities.
• Highly organized with the ability to manage multiple priorities.
• Passion for continuous improvement and emerging data technologies.
• Ability to identify opportunities to improve efficiency, eliminate bottlenecks, and strengthen data capabilities.

Important Eligibility Requirements

• Must be authorized to work in the United States.
• **No visa sponsorship available, No H-1B transfers, No C2C / Corp-to-Corp arrangements.**

Work Location

Jacksonville, FL 32246 – Corporate Office

If you are an experienced Data Architect, Data Engineer, or Enterprise Data Warehouse professional looking for an opportunity to lead modern data architecture and make a meaningful impact on an organization's data strategy, we encourage you to apply.

Pay: $105,000.00 - $135,000.00 per year

Benefits:

• 401(k)
• Dental insurance
• Health insurance
• Life insurance
• Paid time off
• Referral program
• Vision insurance

Work Location: In person