Database Analyst

Tracker-RMS; United States; Remote; USD 120.000 - 170.000; Vollzeit

Benefits dieser Stelle

Medical plans

401(k) starting on day one

Voluntary benefits: life and/or other

Sick time as required by law

Zusammenfassung

Overture Partners, LLC is seeking an experienced Database Analytics Engineer III to design, develop, and maintain scalable data models, semantic layers, and data pipelines for enterprise reporting, advanced analytics, and AI-enabled apps. This remote US role targets candidates with strong SQL, Python, and cloud data platform experience.

You will independently deliver complex data solutions, create reusable data products, and collaborate with cross-functional teams to improve data accessibility

Qualifikationen

• Education: Bachelor's degree or equivalent experience in CS/IS/Data Science.
• Five+ years of analytics engineering or data engineering experience.
• Advanced SQL and Python with data transformations and analytics.
• Hands-on with dbt or comparable transformation frameworks and cloud data platforms.
• Understanding of dimensional modeling, semantic models, and enterprise data design.

Aufgaben

• Design, build, test, and maintain modular data models and transformations using dbt, SQL, and Python.
• Apply dimensional modeling and medallion design principles to data architecture.
• Improve query performance, data usability, and processing costs.
• Create governed semantic layers and metadata for AI-ready data.

Kenntnisse

Advanced SQL

Python

Analytics engineering

Cloud platforms

Ausbildung

Bachelor's degree in CS/IS/Data Science

Tools

dbt

Dagster

AWS

Jobbeschreibung

Database Analyst

Job Overview

An immediate opportunity is available for an experienced Database Analytics Engineer III to design, develop, and maintain scalable data models, semantic layers, and data pipelines supporting enterprise reporting, advanced analytics, and AI-enabled applications. This remote opportunity is ideal for a technically strong professional with expertise in analytics engineering, data transformation, cloud data platforms, and emerging artificial intelligence technologies. Candidates with at least five years of relevant experience, advanced SQL and Python skills, and hands-on experience with modern data engineering tools will be best positioned to secure an interview.

The successful candidate will independently deliver complex technical solutions, develop trusted and reusable data products, and collaborate with cross-functional teams to improve data accessibility, quality, and AI readiness.

Must Haves

• Education: Bachelor's degree in Computer Science, Information Systems, Data Science, Data Analytics, or a related discipline. Equivalent combinations of education and professional experience may be considered.
• Professional Experience: At least five years of experience in analytics engineering, data engineering, business intelligence development, or a related technical discipline.
• Advanced SQL and Python: Strong programming skills with demonstrated experience developing data transformations, reusable models, and analytics solutions.
• Modern Data Engineering Tools: Hands-on experience with dbt or comparable transformation frameworks, along with familiarity with cloud-based data platforms.
• Data Modeling and Architecture: Strong understanding of dimensional modeling, layered data architectures, semantic models, and enterprise data design principles.
• Software Engineering Practices: Experience with Git, version control, code reviews, automated testing, continuous integration, continuous deployment, and workflow orchestration.
• Cloud and AI Technologies: Experience with cloud lakehouse environments, preferably AWS S3, Apache Iceberg, and Trino. Exposure to large language models (LLMs), retrieval-augmented generation (RAG), embeddings, or AI-powered analytics is desirable.
• Communication and Governance: Ability to independently manage complex assignments, communicate technical concepts effectively, and follow established data privacy, security, and governance standards.

What the Client Needs You to Do

The organization needs an experienced analytics engineering professional who can transform raw enterprise data into reliable, well-structured, and reusable data products. You will develop analytics-ready datasets, implement governed semantic models, and build data pipelines that support business intelligence, machine learning, and AI-driven applications.

A key priority is creating the business context that allows AI systems and large language models to interpret organizational data accurately. You will work alongside data engineers, AI engineers, analysts, faculty, and business stakeholders to translate functional requirements into scalable technical solutions.

Key outcomes include:

• Delivering accurate, reusable, and well-documented analytics data models.
• Establishing consistent business definitions and metrics through semantic modeling.
• Developing AI-ready metadata and contextual information for LLMs and AI agents.
• Building reliable data pipelines supporting analytics and machine learning workflows.
• Improving data quality, observability, security, and engineering standards.
• Supporting continuous improvement through emerging data and AI technologies.

Key Responsibilities

• Develop Analytics Data Models: Design, build, test, and maintain modular data models and transformations using dbt, SQL, and Python to support reporting, analytics, and AI applications.
• Implement Data Architecture Patterns: Apply dimensional modeling, layered architecture, and medallion design principles while contributing to technical architecture and solution development.
• Optimize Data Performance: Improve query efficiency, model usability, and processing costs while troubleshooting and enhancing existing data assets.
• Build Governed Semantic Layers: Implement enterprise metrics, business logic, and entity relationships to maintain consistent data definitions across reporting platforms and AI applications.
• Develop AI Context Frameworks: Create metadata, schema descriptions, technical documentation, lineage information, and structured business context that enable LLMs and AI agents to understand and query data accurately.
• Validate AI-Driven Analytics: Test natural language querying, text-to-SQL capabilities, and AI-generated analytical outputs. Refine semantic models and contextual information to improve accuracy and reliability.
• Engineer Data Pipelines: Build, maintain, and monitor orchestrated workflows using Dagster and AWS services to support analytics, machine learning, and AI-enabled applications.
• Prepare AI and ML Datasets: Develop curated datasets, machine learning features, and embeddings supporting model development, RAG workflows, and AI analytics in collaboration with engineering teams.
• Maintain Data Quality and Governance: Implement automated data tests, data contracts, and observability practices while following established security, privacy, and compliance requirements.
• Apply Engineering Best Practices: Use version control, peer reviews, automated testing, CI/CD, and technical documentation standards to ensure maintainable and dependable data solutions.
• Collaborate with Stakeholders: Partner with technical teams, analysts, faculty, and business representatives to translate research and operational requirements into data models, metric definitions, and technical specifications.
• Stay Current with Emerging Technologies: Evaluate modern analytics engineering tools, AI technologies, and development practices to continuously improve data solutions and technical capabilities.

W2 employees of Overture Partners who work 30 or more hours per week are eligible for the following benefits: medical (choice of 3 plans), 401(k) starting on day one, a variety of voluntary benefits including life and disability insurance, and sick time if required by law in the worked-in state/locality.