SENIOR DATA ENGINEER (Snowflake | Power BI | PostgreSQL) 5357
100% Remote
U.S. Citizens & W2 Only
6+ Month Contract w/ 6 month renewable increments
Tier4 Group is seeking a Senior Data Engineer to help modernize and scale a cloud-based enterprise data platform. This role is ideal for an experienced engineer who enjoys building high-performance data pipelines, developing analytics solutions, and driving cloud data warehouse initiatives.
You will play a key role in designing and implementing enterprise data solutions using Snowflake, Power BI, PostgreSQL, and advanced SQL while partnering with business and technical stakeholders across multiple functional areas.
Data Engineering & Cloud Data Platforms
- Design, develop, and support scalable ETL/ELT pipelines
- Build and optimize Snowflake data warehouse solutions
- Develop data ingestion processes using Snowpipe, stages, and automated workflows
- Create dimensional data models and transformation frameworks
- Implement data quality, monitoring, and governance controls
- Support migration of legacy systems into modern cloud-based architectures
Analytics & Reporting
- Design and develop Power BI semantic models and datasets
- Create executive dashboards and self-service reporting solutions
- Optimize DAX calculations, data models, and report performance
- Implement Row-Level Security (RLS) and deployment pipelines
- Modernize legacy reporting platforms into Power BI
Database Development & Performance Tuning
- Write and optimize complex SQL across Snowflake, PostgreSQL, and Oracle environments
- Develop PostgreSQL database objects including functions, triggers, and materialized views
- Perform query tuning, indexing, and performance optimization
- Design enterprise data warehouse schemas and metadata structures
Collaboration & Integration
- Integrate data across multiple enterprise business systems
- Support API and platform integrations
- Partner with architects, analysts, and business stakeholders to deliver data solutions
- Participate in Agile development processes and technical planning
Required Qualifications
Technical Skills
- Expert-level SQL development and optimization
- Strong PostgreSQL and PL/pgSQL experience
- Snowflake architecture, development, and performance tuning
- Power BI development, data modeling, and DAX
- ETL/ELT pipeline development
- Data warehouse design and dimensional modeling
- Git/GitLab version control
Experience
- 5+ years Data Engineering experience
- 3+ years Snowflake experience in production environments
- 3+ years Power BI development experience
- 3+ years ETL/ELT development experience
- 3+ years Data Warehouse design experience
- 2+ years PostgreSQL experience
Preferred Skills
- Oracle SQL / PL/SQL
- dbt
- Data Vault modeling
- REST API integrations
- SnowPro Certification
- Microsoft PL-300 or DP-203 Certification
- Experience supporting federal, aerospace, defense, or highly regulated environments
Ideal Candidate
You are a hands-on Senior Data Engineer who can:
- Build enterprise-grade data pipelines from scratch
- Design scalable cloud data architectures
- Troubleshoot and optimize complex data environments
- Translate business requirements into technical solutions
- Work independently in a fully remote environment
- Drive modernization and continuous improvement initiatives
Highlights
- 100% Remote
- S. Citizens Only
- Enterprise-Scale Data Platform Initiative
- Snowflake-Centric Environment
- High-Impact Analytics & Modernization Projects
- Long-Term Contract Potential