COMPANY Meli Consultants LLC partners with ethical, people-centric companies committed to DEIA, sustainability, and reducing carbon footprints. We specialize in connecting these purpose-driven organizations with talent across all roles to advance their missions. Our expertise spans diverse functions, ensuring inclusive, impactful solutions that align with our partners’ values. We support a wide range of organizations, from startups to enterprises, in building ethical systems that drive meaningful change. Join us to work with progressive employers dedicated to positive impact. We are seeking a highly experienced and skilled Data Modeler & Data Analyst to join our team. This role is crucial for driving our data initiatives, requiring a blend of deep technical expertise in data architecture and strong collaborative leadership. You will be instrumental in shaping our data landscape across various environments, from on-premise to cutting-edge cloud solutions. Requirements • Excellent communication skills, capable of articulating complex technical concepts to diverse audiences. • Proven leadership abilities, inspiring and guiding teams towards successful data solutions. • A proactive and collaborative mindset, eager to engage with various stakeholders to achieve shared goals. • A commitment to best practices in data governance and quality. Responsibilities • Collaborate daily with product managers, project managers, business users, application development teams, DBA teams, and the Data Governance team. • Analyze business and technical requirements to design robust and scalable data solutions. • Lead the design, development, and deployment of complex data models and data warehousing programs. • Contribute to the strategic evolution of our data architecture, incorporating new concepts like Data Lakehouse. • Ensure data quality, lineage, and adherence to data policies across all data initiatives. Qualifications • 7+ years of extensive experience in Data Modeling and Data Analysis. • Strong understanding and practical experience with cloud data warehouses, particularly Snowflake. • Expertise in Data Vault 2.0 methodology for data modeling. • In-depth understanding and hands-on experience with Data Lakehouse concepts. • Proficiency in Big Data sources and tools such as Hive, S3, Trino, and HUE. • Demonstrated experience in executing complex data modeling programs (100+ entities/tables) in both on-premise and cloud environments. • Proven ability to design normalized, denormalized, relational, dimensional, star, and snowflake schemas for cloud, big data, and on-premise databases. • Hands-on experience with data modeling tools such as Erwin, ER/Studio, or Toad Data Modeler. • Extensive data modeling experience with big data and cloud databases (e.g., Hive, Redshift, Snowflake) and on-premise databases (e.g., Oracle, SQL Server, DB2). • Experience implementing Bill Inmon and Ralph Kimball methodologies for data warehouse design. • Comprehensive understanding of Data Warehousing, Data Analysis, Data Profiling, Master Data Management (MDM), Data Quality, Data Lineage, Data Dictionary, Data Mapping, Data Policy, and Data Governance. • Financial Domain knowledge is a significant plus. Employment & Submission Policy: This is a W2-only position; Corp-to-Corp (C2C) arrangements and visa sponsorship are not available. Candidates must be legally authorized to work in the United States. We do not accept unsolicited candidate submissions from third-party agencies without a prior signed agreement. Resumes submitted outside of approved partnerships will not be considered. Equal Opportunity Employer: Meli Consultants LLC is committed to fostering an inclusive workplace and prohibits discrimination based on race, color, religion, sex (including pregnancy, gender identity, and sexual orientation), national origin, age, disability, genetic information, veteran status, or any other protected status under applicable law. We actively encourage applicants from diverse backgrounds to apply. For accommodation requests during the application process, please contact [recruitment@meliconsultants.com]