Data Modeling BI Engineer

Request Technology, LLC; Houston (TX); On-site; USD 120,000 - 150,000; Full time

Benefits offered by this job

Bonus eligible

Job summary

Request Technology, LLC is seeking a seasoned Business Intelligence Engineer in Houston to design and support data models powering reporting and analytics. The role partners with business analysts, data engineers, and stakeholders to build scalable data structures across enterprise systems.

You will lead data modeling efforts, help shape ETL processes, ensure data quality, and optimize performance while adhering to governance and security standards.

Qualifications

• Bachelor’s degree in computer science, a related field, or equivalent practical experience.
• 7+ years of experience in data modeling, data warehousing, and ETL processes.
• Hands-on experience with dimensional modeling, star/snowflake schemas, SCDs, and Erwin.
• Expertise with SQL (including Transact-SQL) and Microsoft SQL Server.
• Experience with data pipelines using ETL/ELT and Azure Data Factory to load data into analytics data marts, warehouses and lakes.
• Familiarity with BI platforms such as Power BI and Qlik Sense.
• Exposure to Python, PySpark, Databricks, or languages like Java or C# is a plus.
• Understanding of data governance and security.
• Domain knowledge in HR, Finance, or Risk Management is a plus.

Responsibilities

• Data modeling design to support reporting and analytics across enterprise systems.
• Partner with stakeholders to translate business needs into scalable data structures and solutions.
• Support ETL development to move data into BI platforms and warehouses.
• Ensure data quality, accuracy, and reliability across systems.
• Optimize data models and database performance for efficient querying.
• Maintain documentation of models, schemas, and data flows per governance standards.
• Help design data security controls and access controls.
• Develop and use SQL queries for ad hoc analysis and validation.
• Participate in Agile workflows across analysis, development, QA, and UAT as SME.
• Build knowledge of business data domains to support strategic initiatives.
• Stay current with evolving data modeling and analytics technologies.

Skills

Data modeling

SQL / T-SQL

Stakeholder collaboration

Dimensional modeling

Business analytics

Education

Bachelor’s degree in computer science or related field

Tools

Erwin

Microsoft SQL Server

Azure Data Factory

Azure Synapse Analytics

Power BI

Qlik Sense

Python

Databricks

PySpark

Job description

***We are unable to sponsor for this permanent full-time role***

***Position is bonus eligible***

Prestigious Global Firm is currently seeking a Business Intelligence Engineer with strong Data Modeling experience.. Candidate will play a critical role in shaping how data is structured, accessed, and for enterprise business intelligence. Candidate will be partnering closely with business analysts, data engineers, and business stakeholders, you’ll design and support development of data models that power reporting, analytics.

Responsibilities:

• Data Modeling Design: Create and maintain conceptual, logical, and physical data models that support reporting and analytics across enterprise systems.
• Business Partnership: Collaborate with stakeholders to translate business needs into scalable data structures and solutions.
• ETL Development Support: Contribute to the design of Extract, Transform, Load (ETL) processes to ensure efficient data movement into Business Intelligence (BI) platforms and warehouses.
• Data Quality & Validation: Implement checks and rules to ensure data accuracy, consistency, and reliability across systems.
• Performance Optimization: Continuously monitor and refine data models and database performance for efficient querying and reporting.
• Documentation & Governance: Maintain clear documentation of models, schemas, and data flows while adhering to data governance standards.
• Data Security: Help design access controls and security measures to protect sensitive data.
• Advanced Querying: Develop and utilize Structured Query Language (SQL) queries for ad hoc analysis, troubleshooting, and data validation.
• Agile Collaboration: Participate in Agile workflows across analysis, development, quality assurance (QA), and user acceptance testing (UAT) phases as a data subject matter expert.
• Domain Expertise: Build strong knowledge of business systems and data domains to support strategic initiatives.
• Continuous Learning: Stay current with evolving technologies and industry trends in data modeling and analytics.

Qualifications:

• Education: Bachelor’s degree in computer science, a related field, or equivalent practical experience.
• Experience: 7+ years of experience in data modeling, data warehousing, and ETL processes.
• Data Modeling Expertise: Strong Hands-on experience of dimensional modeling, fact tables, star/snowflake schemas, slowly changing dimensions (SCDs), and tools like Erwin.
• Technical Skills: Expertise with SQL (including Transact-SQL) and deep experience with relational database systems such as Microsoft SQL Server.
• Data Engineering Knowledge: Experience with data pipelines using ETL or Extract, Load, Transform (ELT) techniques and tools such as Azure Data Factory (ADF) to load data into analytics data marts, data warehouses and data lakes. Experience with analytics data platforms such as Azure Synapse Analytics, OneLake or Microsoft Fabric.
• Analytics & BI Tools: Familiarity with Business Intelligence (BI) platforms such as Microsoft Power BI and Qlik Sense, and experience supporting enterprise reporting.
• Programming & Scripting: Exposure to Python, PySpark, Databricks, or programming languages like Java or C# is a plus.
• Data Governance & Security: Understanding of data governance principles, access controls, and data protection best practices.
• Business Acumen: Experience working with operational analytics domains such as Human Resources (HR), Finance, or Risk Management; professional services industry experience is a plus.