DataJobs.io
← Back to all jobs

Job Description

Design, build, and support data-centric applications while modernizing data platforms using cloud and analytics engineering tools.

Responsibilities

  • Collaborate with product teams to design, develop, test, and deploy complex data applications and modifications aligned to defined requirements.
  • Create technical specifications, flowcharts, and data flow diagrams to communicate application designs and changes.
  • Prepare and execute unit tests for new and modified code; participate in code reviews per team standards.
  • Partner with product and change control teams to deliver quality solutions, refine work, estimate effort, and communicate project progress and roadblocks.
  • Troubleshoot application failures and data quality issues; lead resolution and communication for urgent production incidents.
  • Create and maintain technical documentation; share knowledge with colleagues and stakeholders.
  • Identify opportunities for automation and process improvement to enhance application reliability and team efficiency.
  • Support cloud data platform modernization by evaluating and applying Snowflake, dbt, and other cloud data engineering patterns as standards mature.
  • Assist the transition from existing data platforms and ETL processes to cloud-based data engineering approaches.
  • Analyze dependencies among application components and recommend solutions to complex technical and business process challenges.
  • Contribute to team development practices, standards, and policies with consideration for product, architecture, and business priorities.
  • Provide responsive support to internal customers; collaborate with teammates, other departments, and vendors.
  • Perform special projects and other duties as assigned.

Requirements

  • Five to eight years of relevant experience.
  • Advanced knowledge of data structures, relational databases, and data warehousing concepts.
  • Advanced proficiency in Python and SQL, including accessing and managing relational data.
  • Experience developing modular SQL transformations, data tests, and pipeline dependencies; apply these practices in Snowflake and dbt.
  • Advanced experience developing ETL solutions using Microsoft SSIS packages and stored procedures.
  • Advanced proficiency managing and merging software changes with version control tools, including Git and GitLab.
  • Working knowledge of software containerization and deployment tools.
  • Strong mathematical, analytical, problem-solving, organizational, and prioritization skills.
  • Ability to work independently, manage multiple complex assignments, and deliver high-quality work within established timelines.
  • Strong attention to detail and a demonstrated interest in data.
  • Ability to communicate technical concepts clearly to both technical and nontechnical audiences.
  • Experience contributing to a team operating within an agile framework.
  • Proficiency with standard office and computer software and equipment.
  • Bachelor’s degree in computer science or a related technical field.
  • Experience managing data in Microsoft SQL Server and PostgreSQL.
  • Hands-on experience with Snowflake and dbt (or comparable cloud data platforms), including modernization of legacy ETL or data warehouse workloads using reusable models, automated tests, and deployment workflows.
  • Experience mentoring colleagues and supporting their technical development.

Technologies

  • Snowflake
  • dbt
  • Python
  • SQL
  • Microsoft SSIS
  • Git
  • GitLab
  • Microsoft SQL Server
  • PostgreSQL
  • ETL
  • Software containerization
  • Cloud data engineering practices
  • Agile framework

Location

  • Edina, MN (hybrid)

Compensation

  • Targeted hiring range: $104,300 - $143,440 per year
  • Base pay may vary based on job-related knowledge, skills, credentials, experience, scope, and location
  • Candidates seeking compensation outside the posted range are encouraged to apply

Benefits

  • Medical insurance options and standard benefits, including dental, vision, life insurance, disability insurance, and more
  • Health Savings Accounts (HSA) and Flexible Spending Accounts (FSA)
  • 401(k) Plan with 100% matching on the first 6% of contributions
  • Wellbeing Program, including onsite fitness studio
  • Paid Time Off including holiday, vacation, and volunteer
  • 100% company-paid tuition reimbursement for approved job-relevant coursework; access to The Institutes (Risk and insurance education)
  • Paid parental leave
  • Bonus opportunities
  • Flexible work environment with a variety of hybrid and remote work arrangements designed to balance individual, job, department, and company needs

Work Authorization

  • Applicants must be authorized to work for any employer in the U.S.
  • Western National is unable to sponsor or take over sponsorship of an employment Visa at this time

Similar Jobs