Data Warehouse Engineer

Mitchell Martin Inc, a forty-year-old, privately owned, technology-focused, staffing company where data is central to how we understand, run, and transform our business. We run a centralized data team that serves the entire organization, both delivering analytics and operating business-critical data and software pipelines that directly affect the lives of our consultants. This role takes over the engineering half of that team and, by virtue of our size, is a multi-faceted position spanning the responsibilities of software engineer, data engineer, and analytics engineer. The platform is focused on Python assets orchestrated with Dagster.Take the next step in your career now, scroll down to read the full role description and make your application.The successful candidate will continue to enable the synthesis of data across the organization's different departments and tools, creating a single unified data platform. You will evolve fundamental systems, procedures, and reporting infrastructure that make moving up the data pyramid into higher-level initiatives (such as data science and machine learning) possible.Responsibilities:Design, build, and maintain Python-based data assets orchestrated with Dagster, covering ingestion, transformation, and loading across internal and external data sourcesDevelop and maintain dbt models to support clean, tested, and documented data transformations within the warehouseBuild and maintain integrations with third-party APIs and vendor systems to construct reliable data pipelinesImplement best practices to standardize and improve the integrity and reliability of extraction, transformation, loading, and storage processes, including:Organizing and versioning code in GitHub, with appropriate branching, protection, and PR review practicesLogging and monitoringAlerting for failed or degraded pipelinesDesign and maintain data models and schemas within Snowflake, applying sound RBAC and access-control practicesOrganize and automate tasks and infrastructure on AWSPartner with both technical and non-technical stakeholders across departments to understand data needs and translate them into pipelines, models, and reportsParticipate in the evaluation and integration of new tools and products that support the firm's business processesContribute to the long-term evolution of the data platform as the team takes on higher-level initiatives such as data science and machine learningSkills:Strong problem-solving and project-management skills, with the ability to work independently on a small, high leverage teamDesire to understand and maintain established data assets, while critically thinking about improvements and new implementationsExcellent communication and interpersonal skills, with comfort translating between technical and non-technical audiencesExemplary analytical skillsExperience:Intermediate to advanced Python, including object-oriented programming, dataclasses, and exception handling; experience with async programming is a plusExperience working with third-party APIs and vendors to build data pipelinesIntermediate to advanced SQL, including CTEs, window functions, and recursive queriesExperience with dbtExperience with Dagster (or comparable orchestration tools such as Airflow)Working knowledge of Snowflake or an equivalent cloud data warehouse, including RBAC, data loading, and data modelingBasic AWS knowledge, particularly IAM and S3Basic HTML and CSSBasic Excel, including sorting and filteringBasic GitHub, including branching, branch protection, merging, pull requests, and secrets/actionsEducation/Training:Degree in Computer Science or related field or similar experienceWork Environment – Must be willing and able to commute to New York City up to 4 days a weekCore TechnologiesPython | SQL | Snowflake | Dagster | DBT | Data Modeling | API IntegrationContact AuthorizationBy applying for this job, you agree to receive AI-generated calls, text messages, and/or emails from Mitchell Martin Inc and its affiliates and contracted partners at various frequency through traditional and automated methods. Message and data rates may apply for texts. xhyhwjd Carriers are not liable for delayed or undelivered messages. You can access our privacy policy here ( ).Onboarding ExpectationsLearn more about our Onboarding Process here ( )BenefitsLearn more about our benefits offerings here ( )