Position: Sr. Data Engineer
Location: Blaine, MN (Hybrid, 3 days/week)
Duration: 4 Months
 
Job Description:
This Architect role focuses on designing and optimizing enterprise data solutions using advanced data modelling, Data Build Tool and Snowflake within a hybrid work model. The professional will create scalable data platforms, ensure data quality, and enable analytics that support strategic decisions for global stakeholders while contributing to responsible data use that benefits customers and society.
 
Responsibilities:

• Design robust enterprise data models that align with business capabilities and support scalable analytics while ensuring consistent data definitions across domains
• Develop optimized data pipelines using Data Build Tool to transform raw data into curated datasets that are reliable, reusable and easy to maintain
• Implement Snowflake based data solutions that leverage features such as virtual warehouses cloning and micro partitioning to deliver high performance and cost-efficient workloads
• Collaborate with product owners analysts and engineering teams to translate business requirements into logical and physical data models that meet evolving needs
• Define standards for naming conventions modeling patterns and documentation so that data assets remain understandable discoverable and reusable across the organization
• Review and refine existing data architectures identifying bottlenecks technical debt and improvement opportunities to enhance stability and performance
• Establish robust testing and validation practices for Data Build Tool projects ensuring data transformations are accurate reproducible and aligned with governance policies
• Coordinate with infrastructure and platform teams to configure Snowflake environments for optimal security access control and workload isolation
• Guide adoption of best practices for data versioning deployment and monitoring so that changes to models and pipelines can be delivered safely and predictably
• Prepare high quality architectural diagrams data flow views and design documents that clearly communicate current and target state solutions to technical and non-technical stakeholders
• Engage with cross functional teams in a hybrid model participating in workshops onsite sessions and virtual collaboration to support regional and global initiatives
• Partner with governance and compliance teams to embed privacy by design and ethical data use principles into data models and transformations
• Participate in limited travel as needed to coordinate with distributed teams clients or partner organizations ensuring alignment on architecture and implementation
• Drive continuous improvement by evaluating emerging data engineering tools patterns and cloud capabilities that can enhance performance and reduce operational overhead
• Provide mentorship to less experienced data professionals helping them grow proficiency in data modeling Data Build Tool and Snowflake through design reviews and knowledge sharing
• Align data architecture decisions with organizational sustainability and social impact goals ensuring that solutions support responsible insights and equitable outcomes.

Required:

• Possess extensive experience in conceptual logical and physical data modeling including normalization dimensional modeling and data vault approaches tailored to analytics use cases
• Demonstrate advanced proficiency with Data Build Tool including project structuring modular modeling configuration of environments and integration with version control and CI processes
• Exhibit strong hands-on experience with Snowflake encompassing schema design query optimization resource management security configuration and cost monitoring
• Show proven background in data warehousing ETL and ELT patterns including batch and near real time ingestion within complex enterprise ecosystems
• Bring solid understanding of SQL performance tuning data quality frameworks and observability practices to ensure reliable and trustworthy datasets
• Apply knowledge of cloud platforms such as major hyperscale providers to design resilient secure and scalable data architectures integrated with Snowflake
• Communicate clearly with technical and non-technical audiences using concise documentation and presentations that support informed decision making
• Display experience working in hybrid work environments and collaborating with distributed teams while being willing to travel when project needs require onsite engagement.

Years of Experience: 14 Years of Experience 
 
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $ 65.00/hr.