Lead Data Engineer

Reprise Financial•,

6d•$135,000 - $160,000•Remote

About The Position

Reprise Financial is seeking a passionate and highly motivated Lead Data Engineer with Microsoft Azure and Fabric platform experience to join our Enterprise Data Management team. The ideal candidate will be responsible for designing, developing, and maintaining Data Architecture and ETL processes that support data movement, transformation, and integration across multiple systems. In this role, you will design, build, and maintain data pipelines and ETL jobs that are essential for allowing the enterprise to access and interpret data effectively. You will be integral in architecting and delivering modern data solutions, working cross-functionally with Analytics, IT, and business teams to ensure reliable data pipelines for performance and scalability. You will join a team that values and encourages collaboration and peer-to-peer knowledge sharing. We foster a culture where ideas are freely exchanged, and every team member is encouraged to expand their knowledge both technically and within the business context. We celebrate everyone's wins and recognize that each project and business problem we tackle is an opportunity for collective learning. Our guiding principle is to make data easy and accessible for everyone to use, enabling better decision-making across the company. Experience in the finance industry, specifically in loan origination and servicing, is highly preferred.

Requirements

8+ years of experience in a Lead Data Engineer, Data Engineer, and/or Data Architect role
Experience one or more Data Architecture Domains: BI Architect, Analytics Architect, Data Architect, Data Integration/ETL Architect, Data Governance Architect, and/or Cloud Architect
Bachelor's or Master's degree in Computer Science, Information Systems, Data Science, or relevant technical degree
Strong knowledge of data warehouse and lakehouse concepts.
Strong analytic skills related to working with structured, semi-structured, and unstructured datasets
Experience with cloud data platforms like Microsoft Azure, Microsoft Fabric, Amazon Web Services, Google Cloud Platform, and Snowflake, as well as, Microsoft SQL Server, ensuring scalable data solutions
Proficient with building ETL processes using tools such as SSMS, SSIS, Azure Data Factory, and Fabric Data Factory
Proficient with SQL, Spark SQL, PySpark, and Python working with relational databases, as well as, working familiarity with a variety of databases. Experience building and optimizing big data pipelines, architecture, and data sets
Proficient in T-SQL, Stored Procedures, and Functions using REST APIs
Experience performing ad-hoc and root cause analysis on internal and external data, and processes to answer specific business questions to identify opportunities for improvement.
Build processes supporting data transformation, data structures, metadata, dependency, and workload management
Experience supporting and working with cross-functional teams in a dynamic environment
Experience maintaining code base using source control and Dev-Ops including CI/CD
Experience developing and maintaining technical and non-technical documentation.
Data governance experience involving implementation and management of data cataloging, metadata management, and data lineage tracking. Experience collaborating with cross-functional teams to improve data quality, classification, and lifecycle management
Excellent verbal and written communication skills
Good interpersonal skills with proven problem-solving abilities
Customer Focus: Strong drive to meet data consumer needs and deliver effective solutions.
Critical Thinking: Ability to analyze data and solve problems to reach well-reasoned solutions.
Team Mentality: Ability to work effectively within a team to achieve common goals.
Learning Agility: Openness to learning new technologies and methodologies to maintain a competitive edge.

Nice To Haves

Experience with cloud migration from on-prem or from another cloud platform is a big plus
Confluence experience is a plus
Knowledge of financial data structures, including loan origination, servicing, payments, and collections is a plus

Responsibilities

Collaborate with and support cross-functional teams to ensure accurate and efficient data flow across systems
Defines architectural strategy across programs or domains, handles highest-risk, highest-value solutions, influences enterprise standards and vendor selection, and advises leadership on technical direction
Leads architecture for large, complex or cross-domain solutions, mentors junior architects and engineers, defines architecture standards and patterns, manages technical risk and architectural debt, partners closely with product owners and program leaders, and influences roadmap and platform strategy
Develop, integrate, test, deploy and maintain scalable ETL pipelines and workflows using tools such as SSMS, SSIS, Azure Data Factory, and Fabric Data Factory.
Integrate data utilizing industry standard file formats such as flat files, Excel, Oracle, SQL Server, XML, XSL, and JSON. Get/Post data using SFTP and REST APIs.
Use database design and development best practices to design and maintain robust database systems involving development, implementation, and optimization of various DB objects such as Tables, Views, Stored Procedures, and Functions.
Assemble large, complex data sets that meet functional / non-functional business requirements.
Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
Develop and perform unit tests; maintain up-to-date code in source control.
Collaborate on code reviews and adhere to change management processes to deploy changes to production systems.
Troubleshoot issues reported by users and perform root cause analysis for production issues with minimal guidance.
Document ETL processes, data flows, and system integrations for audit and compliance purposes. Develop user guides and reference documents.
Use Agile best practices to enhance team efficiency and product delivery. Leverage JIRA / Azure Boards for writing detailed user stories, breakdown complex projects into manageable tasks to ensure smooth sprint execution.
Continuously learn about the business and the data that supports it.

Benefits

Comprehensive medical, dental, and vision coverage
Contributions to a Health Savings Account (HSA)
Access to an Employee Assistance Program (EAP)
401(k) program, featuring a Safe Harbor Match (100% of the first 3% and 50% of the next 2%)
Accrued time off
Company holidays
Sick time
3 floating holidays
12-week Paid Parental Leave
Market-driven salary
Bonus opportunities
Robust tech package