Data Engineer
Remote | Product and Development | 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 and Operational Data Store (ODS). Your day-to-day tasks will include extracting data from Ncontracts applications, transforming it according to business logic, and efficiently loading it into our Operational Data Store (ODS). 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 expertise to optimize the process for performance and accuracy. Your commitment to continuous improvement will drive enhancements in our data architecture and ensure that our data system can scale.
A successful Data Engineer at Ncontracts will:
Contribute to building out ETL pipeline to include data from all Ncontracts products
Write performant and maintainable code
Ensure the quality of ETL process
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 system
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 on Microsoft Azure.
Experience with Azure Data Factory is required
Azure Data Lake is a plus
Exposure to Microsoft Fabric is a plus
Very strong background in MS SQL Server is required
Expertise in data architecture using different database types and data formats
Expertise in building data pipelines to clean, enrich, and transform data
Experience with Python is a plus and highly desirable
Expertise in database design and tuning techniques
Strong understanding of ETL process and tooling
Experience with version control systems (Azure DevOps, Git)
Familiar with CI/CD concept
It is helpful for you to have at least some of the following:
Experience working in horizontally scaling systems
Exposure to Azure SQL/warehouse/data lake products such as Azure SQL, Synapse, Databricks, ADLS
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
An automation mindset
A Data Engineer 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
- 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!
Compensation Information
Pursuant to state and local law disclosure requirements, the pay range for this role, with final offer amount dependent on education, skills, experience and location is $130,000 to $150,000 per year. This position may be eligible for an annual discretionary incentive award. The incentive award amount is dependent upon company performance and your personal performance and is not guaranteed.
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.