Lead Data Engineer - Remote 75/hr

ContractStaffingRecruiters.com; Arapahoe (NC); Remote; USD 120,000 - 170,000; Full time

Job summary

Contract Staffing Recruiters.com is seeking a Lead Data Engineer to drive complex data solutions across business and technology. The role involves hands-on development for data transformation and distribution to end users, plus analysis, design, and testing to deliver robust data products.

The candidate will work with BI and stakeholders to define metrics and acceptance criteria, serve as data SME, and collaborate with Data Product Managers, Architects, and Engineering teams to shape data

Qualifications

• Experience building data pipelines and data warehousing solutions.
• Strong SQL and Python proficiency for data processing.
• Knowledge of ETL design patterns and data modeling concepts.
• Experience with cloud-based data platforms (Azure/AWS).
• Familiarity with data governance and security best practices.

Responsibilities

• Translate objectives into success metrics and data requirements with BI stakeholders.
• Act as SME for data, analytics, and integration across domains.
• Collaborate with Data Product Managers, Architects, and Engineers on data flows.
• Provide design oversight and ensure alignment with enterprise standards.
• Develop scalable data solutions for real-time and batch data movement.
• Design and develop database objects and ETL processes.
• Understand data marts and data lakes; migrate legacy systems to data marts/lakes.
• Maintain comprehensive project documentation.
• Communicate effectively with technical and non-technical stakeholders.

Skills

Python

SQL

ETL

Data modeling

Cloud architecture

Tools

Oracle

SQL Server

MySQL

Databricks

Azure Synapse

Job description

The Opportunity:

We are seeking a Lead Data Engineer with experience in projects emphasizing complex data solutions. This is a hands-on role for someone who enjoys working across business and technology. This person will be responsible for supporting data transformation and distribution to end consumers. Candidate will assist with requirements analysis, design/develop process flow, and unit/integration testing, to deliver complex data products.

• Work with the Business Intelligence team and operational stakeholders to translate objectives into success metrics, system qualities, data requirements, and acceptance criteria that engineering teams can execute
• Serve as the primary subject matter expert for data, analytics, and integration needs across assigned business domains, translating business requirements into repeatable, executable design patterns and system qualities.
• Partner closely with Data Product Managers, Architects, and Engineering teams to identify integration opportunities, select appropriate tools, and define shared data, interfaces, and data flows.
• Provide architectural and design oversight through planning, execution, and operations to ensure alignment with enterprise standards and successful implementation.
• Develop scalable and reliable data solutions to move data across systems from multiple sources in real time as well as batch modes.
• Design and develop database objects, tables, stored procedures, views, etc.
• Design and develop ETL Processes that will transform a variety of raw data, flat files, xl spreadsheets into SQL Databases
• Understands the concept of Data Marts and Data lakes and experience with migrating legacy systems to data marts/lake
• Uses additional cloud technologies (e.g., understands concept of Cloud services like Azure SQL server)
• Maintain comprehensive project documentation
• Strong interpersonal and communication skills to be able to work in a team environment to include customer and contractor technical, end users, and management team members.

Experience Needed:

• Programming languages, frameworks, and file formats such as: Python, SQL, PLSQL, DBT
• Database platforms such as: Oracle, SQL Server, MySQL
• Big data concepts and technologies such as Synapse & Databricks
• AWS and Azure cloud computing