Senior Data Engineer
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