Senior Data Engineer

Cascadeloans; United States; Remote; USD 120,000 - 160,000; Full time

Benefits offered by this job

Remote work opportunities

Medical coverage

Dental coverage

Vision coverage

Life insurance

401(k) match

PTO

Sick time

Ten paid holidays

Job summary

Cascadeloans is expanding its data and analytics capabilities by building a scalable data platform that ingests data from multiple sources. The role owns architecture, pipelines, and governance to deliver trusted analytics and ML-ready data for stakeholders across the business.

The ideal candidate has 5+ years in IT with strong data architecture and SQL/Java/C# skills, plus experience with ETL, data warehouses, and Azure SQL. Remote work options are available within the US.

Qualifications

• BS/BA in CS, Business, Math, or related; Master’s preferred.
• 5+ years in information technology.
• 3+ years data architecture experience.
• 3+ years programming in Java, C++, or C#.
• 3+ years with Microsoft SQL, SSIS, SSRS, SSAS.
• Experience with data warehouses, ETL, and master data management solutions.

Responsibilities

• Design the architecture for a new data and analytics platform supporting analytics, data science, and ML.
• Deploy and manage systems and infrastructure for data pipelines per project requirements.
• Develop data flows, data content definitions, and master data definitions for enterprise integration.
• Use AI-assisted tools to create production-ready SQL and Python scripts.
• Profile data sources and define metadata criteria for consistent metrics reporting.
• Build complex SQL queries and ensure data quality while enforcing governance policies.

Skills

Data architecture

SQL

Python

Java/C++/C#

Data governance

ETL tools

Education

BS/BA in CS, Business, Math, or related

Master’s preferred

Tools

SQL Server

SSIS/SSRS/SSAS

Azure SQL

ETL pipelines

Job description

Role overview

This role supports a mortgage lender focused on attainable home ownership in the manufactured housing market, building the data foundation that powers analytics and reporting across the business. The position owns the architecture, pipelines, and governance practices that turn data from multiple source systems into a trusted enterprise asset, while partnering with both IT and business stakeholders.

Responsibilities

• Develop an in-depth understanding of data structures and information content, and design the architecture for a new data and analytics platform supporting analytics, data science, and machine learning
• Select, deploy, and manage the systems and infrastructure required for data processing pipelines aligned to project requirements
• Investigate, create, and maintain data flows, data content definitions, and data element definitions with a goal of enterprise master data integration, including cleansing, de-duplication, and management
• Use AI-assisted development tools to create, optimize, debug, and validate production-ready SQL and Python scripts
• Profile data from different sources to determine whether and how it can support business and data requirements, and develop common business definitions and metadata criteria for consistent metrics reporting
• Build complex SQL queries, perform data validation and quality assurance, and collaborate with IT and business partners to identify authoritative data sources and enforce Data Governance policies

Requirements

• BS or BA in Computer Science, Business, Math, or a related field, with a Master's preferred
• At least five years of experience in information technology
• At least three years of data architecture experience
• At least three years of experience programming in Java, C++, or C#
• At least three years of experience with Microsoft SQL, SSIS, SSRS, SSAS, and related technologies
• Practical experience participating in and running data management programs, including data warehouses, ETL tools, SQL, and master data management solutions

Nice to have

• Experience with the Microsoft Azure BI and analytics stack, including Azure SQL and related technologies
• Familiarity with Java-based web frameworks
• Strong interpersonal and communication skills, with the ability to explain architectural tradeoffs to both technical and non-technical audiences

Benefits and work setup

• remote work opportunities
• medical coverage
• dental coverage
• vision coverage
• life insurance
• 401(k) match
• PTO
• sick time
• ten paid holidays

The organization emphasizes a culture built around teamwork, integrity, excellence, and service, with a focus on work-life balance.