Iconma logo

Senior Data Engineer – Snowflake & dbt / Data Modeling

Iconma
  • Blaine, MN
  • $50–$60.71 Per Hour
  • Instant Apply
Today

Job Description

Our Client, an IT Services and Consultant company, is looking for a Senior Data Engineer – Snowflake & dbt / Data Modeling for their Blaine, MN/Hybrid location.
 
Responsibilities:
  • Drive end to end design of robust conceptual logical and physical data models that support cross functional analytics use cases and complex reporting needs for global stakeholders.
  • Architect and implement scalable data pipelines using data build tool to transform integrate and validate diverse data sources into trusted Snowflake environments aligned with business objectives.
  • Optimize Snowflake schemas storage patterns clustering strategies and query performance to ensure efficient resource usage and consistently fast response times for critical workloads.
  • Collaborate closely with data engineers analysts and product teams to translate business requirements into precise data design specifications and maintain shared understanding of data definitions.
  • Establish and enforce data modelling standards naming conventions and documentation practices that enhance long term maintainability and onboarding efficiency across the data ecosystem.
  • Design and implement robust data quality checks data build tool tests and reconciliation routines that proactively detect anomalies and protect downstream consumers from inaccurate information.
  • Integrate Snowflake with upstream and downstream tools including orchestration platforms and analytics applications to create seamless data flows and reduce manual intervention in day to day operations.
  • Analyze existing data implementations to identify technical debt bottlenecks and improvement opportunities then propose and execute remediation plans that elevate reliability and usability.
  • Partner with security and compliance teams to embed data governance principles access controls and audit capabilities into models and pipelines ensuring responsible use of enterprise data assets.
  • Provide detailed technical guidance and mentoring to peers on data modelling patterns data build tool usage and Snowflake best practices thereby uplifting overall team capabilities and solution quality.
  • Coordinate deployment activities across hybrid work arrangements ensuring stable releases in Snowflake environments and timely resolution of issues discovered during testing and production use.
  • Document data models lineage transformation logic and operational workflows in a clear and structured manner so that teams across the organization can confidently leverage shared data products.
  • Contribute to continuous improvement initiatives by evaluating emerging features in data build tool and Snowflake and recommending pragmatic adoption paths that deliver measurable business value.
 
Requirements:
  • Demonstrate extensive experience in enterprise scale data modelling including dimensional modelling normalized structures and data vault approaches applied to complex analytical platforms.
  • Show strong hands on expertise with data build tool for developing modular transformation code managing environments implementing testing and orchestrating reliable deployment workflows.
  • Apply deep practical proficiency in Snowflake capabilities such as virtual warehouses micro partitioning time travel and role based access to design efficient and secure data solutions.
  • Bring solid understanding of cloud data architectures data integration patterns and performance tuning techniques that are relevant for modern hybrid analytics ecosystems.
  • Exhibit proficiency in structured query design and optimization along with familiarity in scripting for automation to streamline recurring data management activities.
  • Possess experience working in hybrid work models using collaborative tools and practices that maintain clear communication documentation and alignment across distributed teams.
  • Hold exposure to agile delivery methods and backlog management enabling effective prioritization of data features and transparent progress reporting to stakeholders.
  • Display strong problem solving capabilities with a track record of diagnosing complex data issues and proposing practical solutions that improve trust in analytical outputs.
  • Maintain awareness of data governance privacy and regulatory considerations and incorporate these aspects into everyday design decisions and implementation patterns.
  • Present excellent communication skills to explain technical data concepts in accessible language and support informed decision making by business and technology partners.
  • Bring prior experience in large scale MNC or similar environments where coordination across multiple domains and systems is necessary to deliver integrated data solutions.
  • Commit to ongoing learning of new data platform features modelling approaches and automation practices ensuring that solutions remain current with industry developments.
  • Experience: 10 Yrs
 
Why Should You Apply?

Numbers & Facts

LocationBlaine, MN
IndustryManagement Consulting Services
Salary$50–$60.71 Per Hour
Company Size2,000 to 2,499 employees
Year Founded2000
Websitehttps://www.iconma.com/

Benefits

401K, Employee Referral Program, Life Insurance

About Company

ICONMA is a global information consulting management firm providing Professional Staffing Services and Project-Based Solutions for organizations in a broad range of industries.

  • Corporate Headquarters in Troy, Michigan; 20+ locations worldwide.
  • Certified Woman-Owned Business Enterprise (WBE); certified by Women’s Business Enterprise National Council, National Women Business Owners Corporation (NWBOC); and California Public Utilities Commission (CPUC).
  • Founded in 2000
  • 2000+ Employees

The company was founded on the principle that success is derived from delivering high quality service and resources in the most responsive, flexible, and innovative way. ICONMA invests in people and resources with a single goal: To provide our customers with the highest quality service in the most responsive manner. Through its network of offices, ICONMA provides the resources to help clients maintain their competitive advantage.

Skills

  • Access Controlunmatched
  • Agile Programming Methodologiesunmatched
  • Analysis Skillsunmatched
  • Automationunmatched
  • Backlog Prioritizationunmatched
  • Best Practicesunmatched
  • Cloud Architectureunmatched
  • Communication Skillsunmatched
  • Consumer Protectionunmatched
  • Continuous Improvementunmatched
  • Cross-Functionalunmatched
  • Data Analysisunmatched
  • Data Managementunmatched
  • Data Modelingunmatched
  • Data Modeling Toolsunmatched
  • Data Qualityunmatched
  • Decision Supportunmatched
  • Dimensional Modelingunmatched
  • Documentationunmatched
  • Documentation Modelsunmatched
  • Ecosystemsunmatched
  • Environmental Managementunmatched
  • Establish Prioritiesunmatched
  • Functional Analysisunmatched
  • Health Planunmatched
  • Identify Issuesunmatched
  • Information Technology Consultingunmatched
  • Information/Data Security (InfoSec)unmatched
  • Mentoringunmatched
  • Onboardingunmatched
  • Performance Tuning/Optimizationunmatched
  • Privacy Regulationsunmatched
  • Problem Solving Skillsunmatched
  • Progress Reportsunmatched
  • Query Optimizationunmatched
  • Reconciliationunmatched
  • Requirements Managementunmatched
  • Scripting (Scripting Languages)unmatched
  • Snowflake Schemaunmatched
  • Structured Designunmatched
  • Team Playerunmatched
  • Technical Leadershipunmatched
  • Testingunmatched
  • Time Managementunmatched
  • Usability Engineeringunmatched
  • Use Casesunmatched
  • Warehousingunmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder