Company Name: Analytics8

Job Details: Hiring Remotely in Chicago, IL Remote or Hybrid 92K-121K Annually Mid level

Job Url: https://builtin.com/job/data-warehouse-engineer/6888926

Job Description: Data Warehouse Engineer (Internal Data Warehouse)Reports to: Director, Revenue Operations Full-time or Part-time: Full-time     Exempt or Non-Exempt: Exempt Location: Chicago, IL. As an Analytics8 professional, you will have the exciting opportunity to work with a variety of companies, ranging from Fortune 500 companies to small businesses. Each project and client are different, giving you the chance to advance your career as you learn about new industries, businesses, and technologies.  We are looking for people who are creative thinkers, problem solvers, and have excellent communication skills to translate between business terminology and IT logic.  SummaryThe Data Warehouse Engineer designs, builds, and optimizes next-generation data pipelines and transformation layers using Databricks, SQL, and modern ELT frameworks. The Data Warehouse Engineer plays a critical role in shaping the foundation of our data infrastructure, supporting both internal and client facing teams enabling critical reporting, analytics, and operational workflows. The Data Warehouse Engineer is a highly technical professional who thrives in a fast-paced environment, enjoys solving complex data modeling and integration challenges. The DWE understands business context and can move quickly between design, deployment, and iteration.ResponsibilitiesData Modeling & TransformationBuilds robust, scalable, and well-documented SQL models for BI tools, reporting layers, and operational use cases      Translates business requirements into efficient, accurate data transformations that align with real-world metrics and definitionsApplies best practices in data modeling Pipeline Development & OrchestrationDevelops and manages ELT pipelines using SQL and Python to support large, complex datasetsOptimizes for performance, reliability, and scalability across the entire data stack Utilizes tools including Airflow, dbt or Dataform to orchestrate transformationsVersion Control & DeploymentManages code changes and deployments using Git-based workflows (branching, pull requests, CI/CD where applicable)Owns the structure and cadence of the transformation code repositoriesAPI IntegrationsDesigns and maintains scalable API pipelines to ingest third-party data sources (e.g., Salesforce, HubSpot, Google Analytics)Handles authentication, pagination, rate limits, and error management Monitoring & Data QualityImplements robust testing, data validation, and alerting to ensure data accuracy and integrityChampions data quality governance throughout the pipeline and warehouseCollaboration & Stakeholder EngagementServes as the technical partner for RevOps, BI, and other cross-functional teams. Partners with stakeholders to ensure models and pipelines meet real-time business needsEssential RequirementsExpert level in Databricks SQL, PySpark, and Delta Lake architectureAdvanced SQL development and performance tuning experienceHands-on experience with Dataform (SQLX) or similar toolsExperience working in modern ELT environments (e.g., BigQuery, Databricks SQL Warehousing)Extensive experience in troubleshooting and data profilingStrong grasp of data modeling best practices (schemas, slowly changing dimensions, etc.)Familiarity with Git-based version control workflowsAbility to operate in a fast-paced DataOps environment, balancing speed with technical debt managementExperience with dbt, Dataform, or similar transformation frameworksFamiliarity with orchestration tools (e.g., Airflow, dbt Cloud jobs)Experience with BI tools such as Sigma, Looker, TableauExperience ingesting data from external platforms like Salesforce, HubSpot, or Google AnalyticsDev ops and CI/CD experience, preferably with GitHub and GitHub actions Extensive experience working with business ownersHighly skilled in creating and maintaining backlog, trouble ticket system, managing escalations, communicating problems timelyDeep understanding of fostering a culture of data stewardship and ownership to quickly resolve source data issuesExperience in a professional services or consulting environment preferredUnderstanding of key services metrics such as utilization, bill rates, burn rates, allocation, etc. preferredFamiliarity with time materials vs. fixed fee engagement tracking preferredSalary and BenefitsAt Analytics8, we are committed to providing fair and equitable compensation packages that support our employees' success both at work and in life. Our comprehensive approach includes a competitive base salary, and a suite of benefits designed to help employees thrive. For the position of Data Warehouse Engineer, the base salary range is $91,970 – $121,200. Actual compensation will be determined based on several factors, including skills, experience, and qualifications. In addition, employees may be eligible for an annual discretionary bonus. Please note that salary ranges are subject to change and may be modified at any time. Our goal is to provide a well-rounded benefits program that supports employees' personal and professional well-being. We offer a Comprehensive Benefits Package including Unlimited Paid Time Off (PTO) and 9 paid holidays; 401(k)/Roth saving plans; 4 medical plan options (PPOs including an HDHP and a non-deductible plan); employer contribution to HSA accounts; dental and vision coverages; company-paid life insurance, AD&D, and short- and long-term disability coverage. Additional optional benefits include legal insurance, critical illness and accident coverage, and pet insurance.  Analytics8 is an Equal Opportunity Employer.