Senior Data Engineer

ARTC is supporting their client in sourcing an innovative Senior Data Engineer to join their Startup AI and Data Analytics Business Unit. This role is a critical bridge, connecting technical engineering with business strategy. Beyond just managing tickets or building pipelines, you will take full ownership of the data ecosystem. You will play a pivotal role in supporting our AI/ML initiatives , managing the modern data stack while simultaneously answering critical business questions to ensure data accessibility, reliability, and scalability. Role requires some travel.DUTIES AND RESPONSIBILITIES:Key Responsibilities: Ecosystem Ownership & StrategyOwn the Data Ecosystem: Build and maintain robust data pipelines and ETL processes, taking full responsibility for the health, cost, and observability of the stack to prevent downtime before it impacts stakeholdersBusiness-First Data Modeling: Design and manage data warehouses to support advanced analytics, focusing on creating "Gold Standard" data models that make self-service easy in platforms like PowerBI, Tableau, and SigmaDocumentation & Governance: Maintain comprehensive documentation of all data engineering processes to enable stakeholder self-service, following the industry’s best practiceEngineering & ExecutionInfrastructure Development: Design and manage data lakes, warehouses, and databases to support advanced analytics and AI workflowsPerformance Tuning: Act as a SQL/Python expert to optimize data pipelines and troubleshoot issues proactively, ensuring queries are efficient and scalableData Quality Management: Implement frameworks that ensure data reliability across the organization, ensuring smooth integrations across systemsAnalytics Translation & CollaborationBridge the Gap: Collaborate with cross-functional product, engineering teams, and customers to translate vague business goals into precise technical requirementsSupport AI/ML: Create models that specifically enhance Analytics and AI/ML projectsRequired Qualifications:5+ years of experience in data engineering roles, including taking ownership of pipelines and optimizing infrastructureTechnical "Ninja" Skills: Ninja-level proficiency in SQL (specifically CTE optimization) and Python (complex scripting and ML/AI)Pipeline Architecture: Expertise in architecting data pipelines and ETL processes, with tools like Fivetran, Snowflake, and DBTBusiness Intuition: Proven ability to apply business intuition, leveraging analytical skills to present complex data insights and actionable recommendations to technical and non-technical stakeholdersVisualization Proficiency: Experience building visual data analytic business-driven solutions using tools like PowerBI, Sigma, or similar analytic toolsMasters degree in engineering or analyticsCloud & Big Data: Familiarity with cloud platforms like AWS and experience with big data technologies such as SnowflakeLeadership: Proven experience in leading data engineering projects and integrating data from multiple sourcesSmall Team Experience: You have worked in small teams driving innovative solutions and thrive in agile environmentsEEO Policy: Allied Resources complies with all Equal Employment Opportunity (EEO) affirmative action laws and regulations. Allied Resources does not discriminate on the basis of age, race, religion, color, sex, national origin, marital status, genetic information, sexual orientation, gender identity and expression, disability, veteran status or other status protected by law