Data Engineer II

Job description

**WHO WE ARE** Headquartered in Nashville, Tennessee, Ncontracts leads the industry in integrated risk management and compliance solutions, serving over 5,000 financial institutions nationwide. As an eight-time Inc. 5000 Fastest Growing Companies honoree and consistent year-over-year recipient of "Best Places to Work" awards, we offer a thriving, work environment where career growth and life-work balance go hand in hand. At Ncontracts, you'll join a team of industry experts dedicated to strengthening the financial services sector through innovation and thought leadership. We're seeking creative, collaborative, and self-driven professionals across all areas of our business - from developing cutting-edge solutions to sales, marketing, customer support, and beyond. Join us in our mission to make the financial industry stronger and more resilient, while advancing your career in a supportive, dynamic environment that values your unique skills and perspectives. **Data Engineer** II **Nashville or Remote | Engineering | Full-Time** At Ncontracts we help financial institutions make better decisions. This is achieved by creating tools that help them understand their risks and compliance concerns and provide pathways for them to mitigate them. We also have teams of industry leading experts to walk them through the process. This is an individual contributor role, working closely with other data team members to complete the building out of ETL pipelines, our data warehouse and data models. Your day-to-day tasks will include extracting data from Ncontracts applications, transforming it according to business logic, and efficiently loading it into data models for analytics. In addition, you will be working with stakeholders to refine requirements and at times be involved in creating reports and dashboards. You will work with members from the cross-functional team to help them with the consumption of the data. You will be expected to use your knowledge to optimize the process for performance and accuracy as well as assist other less experienced team members. Your commitment to continuous improvement will drive enhancements in our data architecture and ensure that our data system can scale. **A successful Data Engineer II at Ncontracts will:** - Contribute to building out ETL pipelines to include data from all Ncontracts products - Write performant and maintainable code, utilizing state-of-the-art tooling and AI agents - Ensure the quality of ETL process - Define data models and build reports in our analytics platform - Communicate well with other members of the data team and across the functional area - Advocate for best practices and continuous improvement - Participate in architecting and building a scalable data platform - Mentor team members on their area of expertise **It is expected you will have the following skills and experience:** - 3+ Years of experience as Data Engineer designing and implementing data warehouse and data lake solutions in an enterprise environment - Intimate knowledge of dbt is required - 3+ years experience with Azure Data Factory, Snowflake, or AWS Redshift is required - Strong background in MS SQL Server is required - Experience in data architecture using different database types and data formats - Strong knowledge in building data pipelines to clean, enrich, and transform data. - Experience with Python is a plus and highly desirable - Experience in database design and tuning techniques - Experience with version control systems (Azure DevOps, Git) and familiarity with CI/CD concepts **It is helpful for you to have at least some of the following:** - Experience working in horizontally scaling systems - Experience with Claude Code in developing ETL pipelines and data models - Prior work in creating reports and dashboards in a modern analytics platform (Sigma, Omni, etc.) - Exposure to Microsoft Fabric is a plus - Experience with other cloud data stacks (Google, AWS) is a plus - Familiarity with message/event driven architecture patterns and distributed systems architecture - Familiarity with systems integration **A Data Engineer II at Ncontracts is expected to exhibit the following behaviors:** - **Intentional mentorship:** Ncontracts is dedicated to teaching and growing talent and expects everyone to help those less experienced. - **Honesty**: Whether reviewing someone’s code, participating in retrospectives, or working with your team on what direction to take a project we expect openness and honesty. Honesty creates trust, and we believe that all great teams are built on trust. - **Low Ego**: Have confidence in your skills and experience but be willing to alter your opinions and ideas when another, better one comes along. Have strong opinions but loosely held. - **Deep Curiosity:** You will be expected to research new and exciting technologies, perfect the use of existing technologies, and discover new libraries and tools that can affect change across the organization. - **Motivation:** You are a natural self-starter, and you enjoy solving problems. You can solve the problem with minimal instruction and figuring out what should be done. **WE OFFER ALL REGULAR FULL-TIME TEAM MEMBERS:** - A fun, fast-paced work environment - Responsible PTO Plan that meets or exceeds state and local medical and family leave laws - 11 paid holidays - Community and social events to keep you connected and engaged - Mental Health Benefits - Medical, Dental and Vision insurance - Company-paid Group Life Insurance, Short- and Long-Term Disability - Flexible Spending Account & Health Savings Account - Aflac Benefits – Critical Illness, Cancer Protection, & Hospital Choice - Pet Insurance - 401 (k) with company match with eligibility on Day 1 of employment - 2 Paid Volunteer Time Off Days - And much more! *\*Part-Time and Contractor positions are not eligible for company benefits, including paid time off, health insurance, and other employee benefit programs. Full-time temporary employees are eligible for certain group benefits after a waiting period; specific eligibility timing will be provided at the time of offer.* **AAP/EEO Statement** Ncontracts provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training. **Other Duties** Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.