Data Engineer

Bright Mind Solutions LLC; Arden Hills (MN); On-site; USD 110,000 - 170,000; Full time

Job summary

Bright Mind Solutions LLC in Arden Hills, MN is seeking a Data Engineer for a 6-month on-site engagement. You will build reliable data solutions, deliver robust data pipelines, and collaborate with HR and analytics teams to strengthen enterprise data maturity.

The role requires deep SQL and data modeling expertise, Snowflake experience, and hands-on work with Azure-based data services, orchestration, and governance to ensure scalable, secure data delivery.

Qualifications

• 7+ years in SQL, data engineering, and data modeling.
• Experience with data warehouses, data lakes, and lake house environments.
• Snowflake: at least 2 years hands-on experience.
• Leads full-lifecycle data engineering or reporting initiatives.
• Designs ingestion patterns for files, APIs, databases, CDC, replication, and streaming data sources.
• Builds, optimizes, and operates ETL/ELT pipelines and integrated datasets.
• CI/CD, automated testing, and deployment practices for data solutions.
• Uses Python scripting for data automation.
• Works independently, prioritizes, and drives outcomes with minimal supervision.
• Strong analytical, troubleshooting, and root-cause analysis skills.
• Communicates clearly with technical and business partners.
• Applies security practices such as encryption, anonymization, masking, and access-aware design.
• Understands modern data architectures: warehouse, lake, lake house, cloud-based patterns.
• Understands Azure services used for data storage, integration, processing, orchestration, and security.
• Manages pipeline orchestration, scheduling, monitoring, and data flow reliability.
• Uses metadata-driven practices to improve usability, lineage, and governance.
• Uses version control to support quality, traceability, and team collaboration.
• Designs pipelines with scalability, performance, and distributed processing considerations.

Responsibilities

• Build reliable, scalable data solutions that strengthen trusted HR and enterprise analytics.
• Deliver well-managed data pipelines, improve data quality, and enhance data-driven operations.
• Collaborate with business analysts, lead data engineers, and HR on site to deliver data products.
• Support deployment and ongoing maintenance of data platforms.

Skills

SQL

Data engineering

Data modeling

Snowflake

Delivery leadership

Data ingestion

ETL/ELT pipelines

CI/CD & DevOps

Python scripting

Ownership

Problem solving

Communication

Data security

Azure

Orchestration

Metadata management

Version control

Scalability

Tools

Databricks

Airflow

Git

Job description

Job Title: Data Engineer

Duration: 6 months

Location: 4001 Lexington Ave. N, Arden Hills, MN 55126

On-site/Remote/Hybrid: On-Site

Need Local for this one

Job Summary: The Data Engineer will build reliable, scalable data solutions that strengthen trusted HR and enterprise analytics. This role works closely with business analysts, lead data engineers, and the HR team on site to deliver well-managed data pipelines, improve data quality, and improve data-driven operations across the organization.

Competencies-Skills (Required):

• Core Experience: 7+ years in SQL, data engineering, and data modeling.
• Data Platforms: Builds and supports data warehouses, data lakes, and lake house environments.
• Snowflake: Minimum 2 years of hands-on Snowflake experience.
• Delivery Leadership: Leads full-lifecycle data engineering or reporting initiatives.
• Data Ingestion: Designs and builds ingestion patterns for files, APIs, databases, CDC, replication, and streaming/message-based data sources.
• Data Pipelines: Builds, optimizes, and operates reliable ETL/ELT pipelines and integrated datasets.
• DevOps: Uses CI/CD, automated testing, and deployment practices for data solutions.
• Scripting: Uses scripting languages, preferably Python, for data engineering automation.
• Ownership: Works independently, manages priorities, and drives outcomes with minimal supervision.
• Problem Solving: Applies strong analytical, troubleshooting, and root cause analysis skills.
• Communication: Communicates clearly and coordinates effectively with technical and business partners.
• Data Security: Applies security practices such as encryption, anonymization, masking, and access-aware design.
• Modern Data Architecture: Understands warehouse, lake, lake house, and cloud-based data architecture patterns.
• Azure Familiarity: Understands Azure services used for data storage, integration, processing, orchestration, and security.
• Orchestration: Manages pipeline orchestration, scheduling, monitoring, and data flow reliability.
• Metadata Management: Uses metadata-driven practices to improve usability, lineage, and governance.
• Version Control: Uses version control to support quality, traceability, and team collaboration.
• Scalability: Designs pipelines with scalability, performance, and distributed processing considerations.

Competencies-Skills (Preferred):

• Advanced Platform Optimization: Optimizes complex Snowflake and Databricks/Spark workloads, including streams, tasks, dynamic tables, and performance tuning.
• HR Data Experience: Works with HR systems such as Workday and supports workforce analytics, employee lifecycle reporting, and people data use cases.
• HR Data Governance: Applies privacy, minimization, masking, and access practices specifically for confidential employee and workforce data.
• Enterprise Solution Design: Shapes reusable data product patterns, logical models, and target-state designs for enterprise analytics.
• Power BI Enablement: Partners with analysts to support semantic models, curated datasets, dashboards, and trusted reporting experiences.
• Data Vault: Understands Data Vault modeling concepts and architecture.
• Practical Innovation: Identifies pragmatic opportunities to improve data products, analytics delivery, and user adoption.
• Agentic AI Exposure: Understands agentic AI concepts and opportunities to apply AI-enabled workflows in data and analytics contexts.
• AI Productivity: Uses AI tools responsibly to improve personal productivity, streamline analysis, accelerate documentation, and support delivery quality.
• MLOps Exposure: Understands machine learning operations and production model lifecycle concepts.