Senior Data Modeler

We are seeking a Senior Data Modeler & Analyst to support enterprise data management, analytics, reporting, and data modernization initiatives. This individual will be responsible for designing, documenting, and analyzing complex data structures while translating business requirements into scalable data models, source-to-target mappings (STMs), and technical specifications., The role will work closely with business stakeholders, data engineers, architects, and analytics teams to deliver reliable, well-governed data solutions across multiple platforms. The ideal candidate has strong expertise in data modeling, advanced SQL, data integration, and modern cloud data technologies.

• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Engineering, Mathematics, or a related field preferred. \n

• Equivalent education and relevant professional experience may be considered. \n, * 5+ years of experience in data modeling, data analysis, business analysis, data warehousing, or a related discipline.

n \n

• Analyze business requirements, source systems, and data structures to define data entities, relationships, business rules, and transformation requirements. \n

• Develop and maintain Source-to-Target Mapping (STM) documentation for data integration, reporting, and analytics initiatives. \n

• Write and optimize complex SQL queries to profile data, validate requirements, troubleshoot issues, and support data quality initiatives. \n

• Design and maintain conceptual, logical, and physical data models using ERwin or similar enterprise modeling tools. \n

• Collaborate with business stakeholders, data product owners, engineers, architects, and project teams to align data solutions with business objectives and enterprise standards. \n

• Support data solution development across Snowflake, Azure Data Factory (ADF), Azure SQL Managed Instance (SQL MI), Denodo, and similar technologies, including DBT and Databricks. \n

• Maintain data documentation, metadata, and modeling artifacts to support data lineage, governance, compliance, and knowledge sharing. \n

• Participate in solution reviews, project planning, testing, and release activities. \n

• Evaluate existing data processes and recommend scalable solutions to support ongoing modernization initiatives. \n

• Identify opportunities to improve data quality, consistency, accessibility, and operational efficiency. \n

\n

\n