Data Engineer

The Data Engineer II supports customer workload onboarding through requirements gathering, query conversion, schema design, metadata analysis, data loading, workload testing, and performance analysis. The role collaborates with Solutions Architects and engineering teams to prepare pre-pilot workloads, create validation assets and technical documentation, assist with system sizing and timelines, and contribute to GDPR and data rolloff procedures., The Data Engineer II independently contributes to data engineering workstreams at Ocient, supporting customer workload onboarding, schema design, query conversion, data loading, and pre-pilot workload testing with growing technical depth and autonomy. This role works closely with Solutions Architects and Senior Data Engineers to deliver high-quality pre-pilot engineering outputs and developing customer solutions, applying growing expertise in Ocient’s SQL data platform, metadata analysis tooling, and workload performance analysis. The Data Engineer II is technically rigorous, collaborative, and developing the deep engineering skills that define Ocient’s customer-facing data engineering excellence. Responsibilities:

• Work with Solutions Architects to understand customer workloads, capture requirements through questionnaires and workshops, and obtain sample queries and data where possible.
• Convert customer queries to Ocient syntax using internal tools and perform metadata analysis to understand field types, relationships, multi-dimensional elements, and changing schemas.
• Analyze queries in bulk to understand indexing schemes and refine schema; define initial schema designs for pre-pilot workload preparation.
• Load data, create workload test suites, and deploy end-to-end sample workloads to run initial pre-pilot tests.
• Build test cases and validation assets for Delivery and Development teams, and create artifacts in GitHub and other repositories.
• Assist with system sizing, delivery timeline development, and GDPR and data rolloff procedure definition.
• Report performance results and status to management and contribute to cross-functional workload documentation., Architects the data and AI foundation for marketing, sales, and analytics. Responsibilities include building Databricks pipelines, Gold Layer tables, semantic models, documentation, AI-enabled data products, and production LLM or agent systems. The role leads cross-functional initiatives, translates ambiguous business needs into scalable solutions, ensures data quality and reliability, mentors engineers, automates workflows, and partners with BI, data science, marketing, sales, and R&D teams. Top Skills: Ai AgentsBigQueryClaude CodeCursorData WarehousesDatabricksDbtEtl/EltLakehouse ArchitecturesLlmsMarketing AutomationMartechPythonSalesforceSemantic LayersSnowflakeSQLStreamlitWeb Analytics Verisk

Data Engineer

2 Days Ago Remote or Hybrid United States Junior Junior Analytics Develop and operate cloud-based data pipelines, dimensional data models, data warehouse solutions, CI/CD automation, and platform governance controls. The role integrates APIs and diverse data sources while supporting security, monitoring, incident response, and reliable data product delivery. Responsibilities include collaborating with product owners and engineering teams, participating in design and code reviews, troubleshooting technical issues, and applying repeatable DevOps practices. Top Skills: Api GatewaysCi/CdCloud Data WarehousesContainer OrchestrationDimensional Data ModelingGitInfrastructure As CodeKimball Data ModelingMessage QueuesNoSQLPythonRdbmsRest ApisServerless ComputingSnowflakeSQLSqldbmWorkflow Orchestration

What you need to know about the Colorado Tech Scene

With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.

Key Facts About Colorado Tech

• Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
• Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
• Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
• Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
• Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
• Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute

• 2+ years of experience in data engineering, database engineering, or a related technical role with demonstrated SQL proficiency and data pipeline experience.
• Demonstrated experience contributing to schema design, data loading, and workload testing in a data warehousing or analytics environment.
• Strong SQL proficiency with the ability to write, convert, and optimize queries in large-scale analytical database environments.
• Working knowledge of schema design, indexing strategy, ETL/ELT processes, and data loading in relational or columnar database systems.
• Familiarity with metadata analysis, query bulk analysis, and workload performance testing.
• Strong attention to detail with the ability to independently produce accurate technical documentation and engineering artifacts.
• Good written and verbal communication skills with the ability to collaborate cross-functionally with Solutions Architects, Delivery, and Engineering teams.

An Exceptional Candidate Will Have:

• Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or a related technical field.
• Experience with Big Data platforms, distributed database systems, or cloud data warehousing (AWS Redshift, Google BigQuery, Snowflake, or comparable).
• Familiarity with GDPR data compliance, HA/DR requirements, or data governance processes.
• Experience with GitHub or comparable version control and artifact repository tools.

85K-120K Annually Mid level 85K-120K Annually Mid level Cloud * Computer Vision * Information Technology * Sales * Security * Cybersecurity Plan and manage data center capacity across global sites, including power, space, cooling, racks, fiber ports, and cross-connects. Maintain allocation records, forecasting models, dashboards, and DCIM data. Translate infrastructure demand into rack-level deployment plans, identify capacity risks, support colo expansions, reconcile physical and system inventories, and partner with operations, engineering, supply chain, and vendors. Contribute to automation and AI-enabled workflow improvements. Top Skills: AssetdbDcimDevice42Google SheetsGrafanaIdfIpamMdfExcelNlytePduPower BIRppSunbirdTableauUps Samsara

Ocient is building OcientAIQ - a complete ecosystem for delivering trusted agentic AI solutions at petabyte scale, for the organizations that can’t afford to get AI wrong. Our customers protect networks, secure nations, and power the global economy. The problems we solve are genuinely hard, and the work matters. Founded in 2016 by the team that built Cleversafe (acquired by IBM in 2015), Ocient is headquartered in Chicago with a remote-first global team. We are a carbon-neutral company backed by leading investors including Greycroft, OCA Ventures, In-Q-Tel, and Buoyant Ventures.