Data Engineer - EDW USL Team - Onshore

Job Description Compensation: $40/hr to $60/hr. Exact compensation may vary based on several factors, including skills, experience, and education. Benefits: Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law. Day to Day Responsibilities Design, build, and maintain semantic and metrics layers that support reporting, analytics, and downstream consumption. Develop and manage dimensional data models (star and snowflake schemas) to enable consistent, performant analytics. Translate business logic and metric definitions into reusable, governed data models and curated datasets. Partner closely with analytics, reporting, and engineering teams to ensure data consistency and metric alignment across tools. Support consumption layers used by BI dashboards and reporting, drill‑down analytics, and finance and operational use cases. Help standardize and scale a centralized semantic layer that enables consistent definitions across the organization. Maintain documentation for metrics, models, and semantic definitions to support governance and reuse. Contribute to core SQL‑based data engineering work when needed (modeling, transformations, optimization). Skills and Requirements Strong SQL data engineering background. Proven experience with dimensional modeling, including star schemas and snowflake schemas. Hands‑on experience designing and supporting semantic or metrics layers. Ability to translate complex business rules into clean, reusable data models. Solid understanding of metric consistency, data definitions, and governance across reporting layers. Experience supporting analytics and reporting use cases, not just raw data pipelines. Strong communication skills — able to partner with business and technical stakeholders to clarify metric intent. Experience with BI semantic layer tools (e.g., AtScale or similar technologies). Prior work on enterprise‑wide metric standardization initiatives. Experience supporting finance or operational reporting use cases. Familiarity with data governance frameworks and best practices. Background working in large, complex data environments with multiple downstream consumers. Experience enabling self‑service analytics through well‑designed semantic layers. Equal Opportunity Statement We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. #J-18808-Ljbffr Insight Global