Senior BI Data Modeling Engineer — Hybrid (3 onsite/2 remote)

Request Technology, LLC; Houston (TX); Hybrid; USD 120,000 - 160,000; Full time

Job summary

Request Technology, LLC seeks a senior data modeler/ETL specialist to design enterprise data models and support BI platforms. You will collaborate with stakeholders to translate needs into scalable data structures and ensure data quality across warehouses and data lakes.

Candidate will work with SQL Server, Azure Data Factory, Synapse, Power BI, and Databricks in a hybrid environment with 3 days onsite and 2 days remote. 7+ years of relevant experience is expected.

Qualifications

• 7+ years of experience in data modeling, data warehousing, and ETL.
• Hands-on experience with dimensional modeling, star/snowflake schemas, SCDs; Erwin.
• SQL expertise including T-SQL and Microsoft SQL Server.
• ETL/ELT pipelines using Azure Data Factory to load data into analytics marts, warehouses, and lakes.
• Experience with Azure Synapse Analytics, OneLake or Microsoft Fabric.
• BI platforms such as Power BI and Qlik Sense; support for enterprise reporting.
• Exposure to Python, PySpark, Databricks.
• Understanding of data governance, access controls, and data protection.
• Experience in HR, Finance, or Risk domains; professional services a plus.

Responsibilities

• Data Modeling Design: Create and maintain conceptual, logical, and physical data models.
• Business Partnership: Translate business needs into scalable data structures.
• ETL Development Support: Design ETL/ELT processes for BI platforms and warehouses.
• Data Quality & Validation: Ensure data accuracy, consistency, and reliability.
• Performance Optimization: Refine models and database performance.
• Documentation & Governance: Document models, schemas, and data flows with governance.
• Data Security: Design access controls and security measures for sensitive data.
• Advanced Querying: Develop SQL for ad hoc analysis and data validation.
• Agile Collaboration: Work across analytics, development, QA, and UAT as SME.

Skills

Data modeling

Data warehousing

ETL/ELT

SQL / T-SQL

Python / PySpark

Databricks

Data governance

BI reporting

Analytical collaboration

Tools

Erwin

Azure Data Factory

Azure Synapse

OneLake

Microsoft Fabric

Power BI

Qlik Sense

MS SQL Server

Job description

Request Technology, LLC seeks a senior data modeler/ETL specialist to design enterprise data models and support BI platforms. You will collaborate with stakeholders to translate needs into scalable data structures and ensure data quality across warehouses and data lakes.

Candidate will work with SQL Server, Azure Data Factory, Synapse, Power BI, and Databricks in a hybrid environment with 3 days onsite and 2 days remote. 7+ years of relevant experience is expected.