Job#: 3027905 Job Description: Job Title: Lead Data Engineer / Data ArchitectOverviewWe are seeking an experienced Lead Data Engineer / Data Architect to support the design, migration, and ongoing evolution of a large‑scale data and analytics platform. This role plays a critical part in modernizing an enterprise data ecosystem, supporting analytics, reporting, and advanced data use cases. The ideal candidate brings strong hands‑on technical expertise along with the ability to lead architecture decisions and support production‑critical data systems.This position requires close collaboration with engineering, analytics, product, and business teams and will be responsible for ensuring data platforms are scalable, reliable, and well‑governed.Key ResponsibilitiesServe as the technical lead for data engineering and architecture initiativesDesign, analyze, and optimize SQL‑based data layers and analytics solutionsPerform ad‑hoc data analysis, complex SQL queries, and data transformationsLead design and evolution of cloud‑based data platforms and data warehousesSupport production deployments, monitoring, troubleshooting, and incident resolutionMigrate and modernize on‑premises data platforms to cloud‑native architecturesBuild and manage scalable data pipelines and ingestion frameworksCollaborate with cross‑functional teams to align data models with evolving product requirementsEnable standardized analytics, reporting, and self‑service data consumptionImprove platform reliability, automation, and operational maturityEnsure data quality, governance, and compliance with enterprise standardsMentor engineers and provide architectural guidance across the data teamDocument system designs, data flows, and operational processesRequired Skills & Experience10+ years of experience in data engineering, analytics, or data platform developmentStrong expertise in SQL and relational database systemsHands‑on experience with cloud data platforms, preferably AzureExperience with Azure Synapse, data lake architectures, and data warehousing conceptsStrong experience with Python for data engineering and analytics workloadsSolid understanding of Unix/Linux operating systemsExperience supporting production data systems and handling operational issuesStrong understanding of data modeling, performance tuning, and query optimizationPreferred Skills & ExperienceExperience with analytics engines and frameworks such as Spark SQL, Presto, or similarExposure to workflow orchestration tools such as Apache AirflowExperience building data products and analytics platformsKnowledge of machine learning concepts and data science workflowsFamiliarity with DevOps practices and automationExperience with tools such as Power BI or other data visualization platformsStrong leadership, communication, and stakeholder‑management skillsInterview ProcessRound 1: Technical interview with panel members (may include hands‑on SQL or data problem‑solving)Round 2: Interview with product or business stakeholders focusing on solution design and collaborationInterviews conducted via video conferenceEEO Employer Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] or 844-463-6178. Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing® in Talent Satisfaction in the United States and Great Place to Work® in the United Kingdom and Mexico. Apex uses a virtual recruiter as part of the application process. Click here for more details. Apex Benefits Overview: Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our ‘Welcome Packet’ as well, which an Apex team member can provide.VEVRAA Federal Contractor.We request Priority Protected Veteran & Disabled Referrals for all of our locations within the state.PDN-a165a0cd-d189-45e5-b59e-77f781c1d349
