Description

About the job Remote | Product and Development | Full-Time Conexess Group is aiding a large financial client in their search for a senior Data Engineer. This is an immediate, full time job opening and we are only able to accept candidates that are eligible to work on W2. 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 company 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.

Role and Responsibilities

• Responsibilities Daily Responsibilities Contribute to building out ETL pipeline to include data from all company 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 Required Skills: 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 Preferred Skills: 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 Expectations: Intentional mentorship: We are 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 Client 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. Benefits Information: 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!