Data Analytics Engineer

Vallourec; Houston (TX); On-site; USD 85,000 - 125,000; Full time

Benefits offered by this job

Medical, Dental, and Vision Coverage

Profit Sharing: Up to 4%

401(k): Company match 4.5%

Paid Parental Leave

Paid Holidays: 10 days + 1 floating

Paid Vacation Time

Performance-Based Bonus Program

Tuition Reimbursement

Job summary

Vallourec seeks an Data Analytics Engineer to develop analytics engineering capabilities across Gold and Semantic layers, translating requirements into governed semantic metrics and Power BI dashboards. The role focuses on certified data products, automated data-quality testing, and enablement for self-service analytics.

Onsite in Houston, TX, with a minimum of 2 years' experience. You will work on certified Gold-layer dbt models, semantic metrics, and data contracts to empower business insights.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Computer Engineering, Data Engineering, Data Analytics, or related field.
• Equivalent relevant professional experience may be considered.
• Training or certification in dbt, Power BI, Databricks, dimensional modeling, or cloud data platforms is an advantage.
• Advanced SQL skills are required.
• Hands-on experience with dbt, including models, tests, and documentation.
• Intermediate to advanced dimensional modeling, including fact tables, dimensions, grain, and star schemas.
• Intermediate to advanced Power BI and DAX skills, including data modeling and report-performance optimization.
• Experience with Git-based version control and collaborative development practices.
• Working knowledge of data quality, metadata, and lineage concepts.
• Experience with Databricks SQL and Unity Catalog.
• Experience with a semantic layer or metric framework such as dbt Semantic Layer / MetricFlow.
• Knowledge of CI/CD pipelines for analytics engineering.
• Experience with data contracts and cross-domain metric governance.
• Knowledge of Microsoft Fabric or other cloud data platforms.
• Experience supporting self-service analytics and user enablement.

Responsibilities

• Develop and maintain certified use-case data models in dbt, including dimensional models, fact tables, and reusable metric definitions.
• Author domain metrics, dimensions, hierarchies, and time-intelligence logic with approved definitions and lineage.
• Build and optimize Power BI dashboards based on certified data and governed metrics.
• Implement automated data-quality tests and maintain technical documentation; support self-service adoption and training materials.
• Develop and maintain the domain Use-case (Gold) layer in dbt following standards.
• Create dimensional models, fact tables, and metrics from the Domain (Silver) layer.
• Implement and maintain dbt data-quality tests meeting test-coverage targets.
• Document dbt models and publish metadata in Unity Catalog.
• Coordinate data contracts between Domain and Use-case layers with Data Engineers.
• Escalate Silver-layer logic questions to Domain Specialist when needed.
• Create domain metrics in the semantic layer, including dimensions and time intelligence.
• Submit domain metrics and cross-domain definitions for review before Gold certification.
• Maintain metric definitions, lineage, and registry records.
• Apply data-security requirements and RBAC where required.
• Support analysts and end users with self-service guidance and training materials.
• Coordinate technical work across stakeholders and contribute to peer reviews.

Skills

Advanced SQL

Self-service analytics enablement

Collaborative development

Education

Bachelor’s degree in Computer Science / Information Systems / Computer Engineering / Data Engineering / Data Analytics

Tools

dbt

Databricks SQL

Unity Catalog

Power BI

DAX

Git

CI/CD pipelines

MetricFlow

Microsoft Fabric

Job description

The Data Analytics Engineer will develop analytics engineering capabilities across the Gold and Semantic layers, translating validated requirements into governed semantic metrics and Power BI dashboards. The role focuses on certified data products, automated data-quality testing, and enablement for self-service analytics.

Onsite Location & Experience

• Location: Houston, TX (onsite)
• Minimum experience: 2 years

Core Responsibilities

• Develop and maintain certified use-case data models in dbt, including dimensional models, fact tables, and reusable business metrics
• Author domain metrics, dimensions, hierarchies, and time-intelligence logic according to the approved framework, while maintaining definitions and lineage
• Build and optimize Power BI dashboards based on certified Gold data and governed semantic metrics
• Implement automated data-quality tests, maintain technical documentation, and support self-service adoption and training materials
• Develop and maintain the domain Use-case (Gold) layer in dbt, following approved modeling and naming standards
• Build dimensional models, fact tables, and business metrics from the Domain (Silver) layer
• Implement and maintain dbt data-quality tests and meet agreed test-coverage targets
• Document dbt models and publish documentation and metadata in Unity Catalog
• Coordinate data contracts between Domain and Use‑case layers with Data Engineers, including column types, refresh expectations, and nullability
• Escalate Silver‑layer business logic questions to the relevant Domain Specialist rather than independently redefining logic
• Create domain metrics in the semantic layer, including dimensions, hierarchies, and time intelligence
• Submit domain metrics and cross‑domain definitions for review by the Semantic Layer & BI Lead before Gold certification
• Maintain metric definitions, lineage, and registry records
• Apply data‑security requirements, including appropriate access controls and row‑level security when required
• Support business analysts and end users with self‑service guidance and training materials
• Coordinate technical work across business and technology stakeholders, contribute to peer reviews, and share knowledge (no direct people management responsibility)

Expected Deliverables

• Certified Gold‑layer dbt models
• Tested and documented data products
• Governed semantic metrics
• Optimized Power BI dashboards
• Data contracts
• Lineage and metric documentation
• User enablement materials

Requirements

• Bachelor’s degree in Computer Science, Information Systems, Computer Engineering, Data Engineering, Data Analytics, or a related field
• Equivalent relevant professional experience may be considered
• Training or certification in dbt, Power BI, Databricks, dimensional modeling, or cloud data platforms is an advantage
• Advanced SQL skills
• Hands‑on experience with dbt, including models, tests, and documentation
• Intermediate to advanced dimensional modeling, including fact tables, dimensions, grain, and star schemas
• Intermediate to advanced Power BI and DAX skills, including data modeling and report‑performance optimization
• Experience with Git‑based version control and collaborative development practices
• Working knowledge of data quality, metadata, and lineage concepts
• Experience with Databricks SQL and Unity Catalog
• Experience with a semantic layer or metric framework such as dbt Semantic Layer / MetricFlow
• Knowledge of CI/CD pipelines for analytics engineering
• Experience with data contracts and cross‑domain metric governance
• Knowledge of Microsoft Fabric or other cloud data platforms
• Experience supporting self‑service analytics and user enablement

Technologies

• SQL
• dbt
• Databricks SQL
• Unity Catalog
• Power BI
• DAX
• Git
• CI/CD pipelines
• MetricFlow (and MetricFlow / approved platform equivalent)
• Microsoft Fabric

Benefits

• Medical, Dental, and Vision Coverage
• Company-Paid Life Insurance & Short/Long-Term Disability
• Profit Sharing: Up to 4%
• 401(k): Company match 4.5% with no vesting period
• Paid Parental Leave
• Paid Holidays: 10 days plus 1 floating holiday
• Paid Vacation Time
• Performance‑Based Bonus Program
• Tuition Reimbursement