Why this role stands out
This hybrid role offers a fantastic opportunity to advance your career by building robust data models using cutting-edge Microsoft technologies like Azure Synapse Analytics. You'll thrive here if you're a mid-senior engineer passionate about translating complex business needs into scalable data solutions and are eager to collaborate with a forward-thinking team. Apply now to leverage your expertise and contribute to impactful data initiatives!
Quick overview
Job description
***We are unable to sponsor as this is a permanent full-time role***
***Hybrid, 3 days onsite, 2 days remote***
An established firm is looking for BI Data Modeler Engineer. This role will be focused on data modeling, Microsoft tech Stack, SQL Server, Azure, Azure Synapse Analytics, and Microsoft Data Analytics Foundation.
Responsibilities:
· Create and maintain conceptual, logical, and physical data models that support reporting and analytics across enterprise systems.
· Collaborate with stakeholders to translate business needs into scalable data structures and solutions.
· Contribute to the design of Extract, Transform, Load (ETL) processes to ensure efficient data movement into Business Intelligence (BI) platforms and warehouses.
· Implement checks and rules to ensure data accuracy, consistency, and reliability across systems.
· Continuously monitor and refine data models and database performance for efficient querying and reporting.
· Maintain clear documentation of models, schemas, and data flows while adhering to data governance standards.
· Help design access controls and security measures to protect sensitive data.
· Develop and utilize Structured Query Language (SQL) queries for ad hoc analysis, troubleshooting, and data validation.
· Participate in Agile workflows across analysis, development, quality assurance (QA), and user acceptance testing (UAT) phases as a data subject matter expert.
· Build strong knowledge of business systems and data domains to support strategic initiatives.
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.
· Strong Hands-on experience of dimensional modeling, fact tables, star/snowflake schemas, slowly changing dimensions (SCDs), and tools like Erwin.
· Expertise with SQL (including Transact-SQL) and deep experience with relational database systems such as Microsoft SQL Server.
· 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.
· Familiarity with Business Intelligence (BI) platforms such as Microsoft Power BI and Qlik Sense, and experience supporting enterprise reporting.
· Exposure to Python, PySpark, Databricks, or programming languages like Java or C# is a plus.
· Understanding of data governance principles, access controls, and data protection best practices.
Similar jobs
- CA
Data Designer
Carrier · Atlanta, GA · Hybrid 🇺🇸
RecruitingFigmaTableau+7$79k - $158k/yr - BR

Data Engineer/ArchitectRecently posted
Blue Rose Technologies LLC · Fremont, CA · Hybrid · Posted 17 Nov 2026 🇺🇸
SQLApache SparkETL+3TechnologySalary not listed - MA

Snowflake AdminRecently posted
Magicforce · United States · Hybrid · Posted 17 Nov 2026 🇺🇸
SQLGitAWS+7TechnologySalary not listed - ID
Sr AWS Data Engineer (with ETL, Python, AWS Glue, Lambda, Node.js & Microservices exp)Recently posted
Info Dinamica Inc · Malvern, PA · On-site · Posted 16 Nov 2026 🇺🇸
DynamoDBMicroservicesOracle+18TechnologySalary not listed - PG

Data Engineer – Databricks, PySpark, Cloud | Hybrid - 71701Recently posted
PRIMUS Global Services Inc. · Princeton, NJ · Hybrid · Posted 17 Nov 2026 🇺🇸
SQLScalaApache Spark+4TechnologySalary not listed - PH

Data EngineerRecently posted
Photon · Sunnyvale, CA · Hybrid · Posted 17 Nov 2026 🇺🇸
SQLAWSETL+6TechnologySalary not listed - GE

SQL Server DBARecently posted
Genesis10 · Charlotte, NC · Hybrid · Posted 17 Nov 2026 🇺🇸
SQLShellMicrosoft Office+3Technology$53 - $61/hr - NT
Oracle DBA with Security ClearanceRecently posted
NorthHill Technology Resources · Fairfax, VA · Hybrid · Posted 17 Nov 2026 🇺🇸
MariaDBMongoDBOracle+6TechnologySalary not listed - IT

ETL LeadRecently posted
ITSYNTAX INC · Dallas, TX · Hybrid · Posted 16 Nov 2026 🇺🇸
OraclePL/SQLSQL+6Salary not listed - VI

Sr. Data EngineerRecently posted
Visa · Foster City, California · Hybrid · Posted 17 Nov 2026 🇺🇸
SQLScalaApache Spark+14Technology$131.9k - $204k/yr - VI

Staff Data EngineerRecently posted
Visa · Foster City, California · Hybrid · Posted 17 Nov 2026 🇺🇸
SQLScalaApache Spark+13Technology$156.8k - $251.1k/yr - FA

Systems Engineer (Data Flow/NiFi) Level 2Recently posted Auto Apply
Fantom Corporation · Fort Meade · On-site · Posted 17 Nov 2026 🇺🇸
ApacheComplianceComputer Vision+5TechnologySalary not listed
