AWS Cloud Database Admin/Developer, Senior

Position Type: Contract to hire

Location: Hybrid, Dallas TX

Position Overview

The AWS Cloud Database Admin/Developer, Senior serves as the hands-on engineer for all data engineering efforts, designing, implementing, and optimizing a high-performance data warehouse environment using Snowflake, Databricks, Astronomer, and AWS. This environment serves as the enterprise’s single source of truth and provides a scalable foundation for real-time analytics, data sharing, and AI-driven insights. This role ensures that the technology data stack is scalable, secure, and aligned with the company’s five-year strategic direction.

Duration: 3–5 months, with the possibility of extension based on performance.

Key Responsibilities

• Infrastructure Automation: Architect robust infrastructure automation pipelines using Terraform, CloudFormation, scripting, Snowpipe, Tasks, and Streams, integrating with tools such as Airbyte, dbt, Fivetran, and AWS.
• Data Modeling: Create and maintain complex data models, including Star Schema, Snowflake Schema, and Data Vault 2.0, tailored for cloud-native performance.
• Stakeholder Collaboration: Collaborate with IT and business stakeholders to curate, document, and implement data lineage, knowledge graphs, data tracing, and compliance KPIs.
• Pipeline Engineering: Architect robust ETL/ELT pipelines using Snowpipe, Tasks, and Streams, integrating with tools such as Airbyte, dbt, Fivetran, and AWS.
• Governance & Security: Implement Role-Based Access Control (RBAC), data masking, and row-level security to support compliance with global standards, including GDPR and HIPAA.
• Performance Tuning: Monitor and optimize query performance and credit consumption to ensure a fast, cost-effective environment. Apply expert-level SQL and deep knowledge of Snowflake features, including Time Travel, Zero-copy Cloning, and Data Sharing.
• Snowflake Reference Designs: Implement reference designs for ETL/ELT pipeline engineering, including integration with AWS platforms.
• Data Governance: Establish architecture and governance standards from data engineering and platform perspectives, and enforce data lineage and data stewardship across all business units.

Qualifications

Education & Experience: Bachelor’s or Master’s degree in Computer Science, Management Information Systems, Data Science, Business Administration (MBA), or a related field; or equivalent practical experience. 10+ years of IT experience, including experience with Snowflake, dbt, Apache Airflow, Snowflake Cortex, SQL, Fivetran, OpenFlow, AWS data tools, and cloud data engineering. 4–6 years of progressive, hands-on development experience in data engineering using Snowflake and AWS, including semantic engineering, data modeling, and data governance. 7+ years of data engineering experience, including 3+ years focused specifically on Snowflake and Databricks implementations.

Technical Skills

• Cloud ecosystems and cloud data engineering, with mastery of AWS.
• Snowflake, Snowflake OpenFlow, Snowflake Cortex, Snowpipe, Tasks, and Streams.
• Snowflake features, including Time Travel, Zero-copy Cloning, and Data Sharing.
• Databricks and Astronomer.
• Expert-level SQL, Microsoft SQL, and PostgreSQL.
• dbt, Fivetran, Airbyte, and Apache Airflow.
• AWS data tools, including SageMaker, Glue, Kinesis, and RDS.
• Kafka, microservices, and Amazon EventBridge.
• Terraform, CloudFormation, scripting, and infrastructure automation.
• Python, JavaScript, Scala, Go, and Java.
• Microsoft Power BI and Tableau reporting.
• ETL/ELT pipeline development and data integration patterns.
• Star Schema, Snowflake Schema, and Data Vault 2.0.
• Data standards, IT governance, security architecture, and architecture guidance.
• RBAC, data masking, and row-level security.
• Data lineage, data stewardship, knowledge graphs, data tracing, and compliance KPIs.

Core Competencies

• Design, implement, and optimize scalable, high-performance data warehouse environments.
• Develop cloud-native data models and reliable data pipelines.
• Enable real-time analytics, enterprise data sharing, and AI-driven insights.
• Establish and enforce data engineering, platform architecture, and governance standards.
• Optimize system performance and manage resource consumption.
• Align technical solutions with long-term business objectives.
• Collaborate effectively with IT and business stakeholders.
• Influence stakeholders without formal authority.
• Explain complex data engineering concepts to non-technical audiences.

Required Certifications

• Snowflake Core Pro.
• Snowflake Advanced Architect.

Preferred Certifications

• AWS Data Engineering certifications.
• AWS Solutions Architect Professional.