Data Analytics Engineer
Job Description
Vallourec is seeking a Data Analytics Engineer in Houston, TX to help expand analytics engineering capabilities across the Gold and Semantic layers. In this onsite role, you will turn validated requirements into governed semantic metrics and Power BI dashboards, supported by certified datasets, data-quality testing, documentation, and self-service enablement.
Working within a framework that emphasizes lineage, metadata, and repeatable delivery, you will use dbt and Databricks tooling to build and maintain certified data products, including dimensional models, fact tables, and business metrics.
What you’ll do
- 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 using 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 contribute to self-service adoption and training materials.
- Develop and maintain the domain Use-case (Gold) layer in dbt, following approved modeling and naming standards.
- Create dimensional models, fact tables, and business metrics from the Domain (Silver) layer.
- Implement and maintain dbt data-quality tests and work toward agreed test-coverage targets.
- Document dbt models and publish documentation and metadata in Unity Catalog.
- Coordinate data contracts between the 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 redefining logic independently.
- 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.
- No direct people management responsibility, with an expectation to coordinate technical work across business and technology stakeholders and contribute to peer reviews and knowledge sharing.
- Help deliver certified Gold-layer dbt models, tested and documented data products, governed semantic metrics, optimized Power BI dashboards, data contracts, lineage and metric documentation, and 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 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 cloud data platforms.
- Experience supporting self-service analytics and user enablement.
Tools & technologies
- SQL, dbt, Databricks SQL, Unity Catalog
- Power BI, DAX
- Git
- CI/CD pipelines
- MetricFlow (or the 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