Job Opportunities API

ABOUT UPCLEAR UpClear delivers a SaaS revenue management platform that is used by some of the most recognizable consumer goods brands in the world. Our system supports Trade Promotion Management, Trade Promotion Optimization, Integrated Business Planning and Revenue Management. We serve more than 80 brands in over 30 countries. Our growth is substantial and consistent; we have been on the Inc 5000 list of fastest growing private companies for eight years in a row. UpClear's global headquarters is in New York City and we have satellite offices in London, Paris, and Singapore. POSITION OVERVIEW We are seeking a skilled Data Architect to design, optimize, and scale our data and reporting layers. This role is also open to contractors. You will focus on building a robust SQL-based data warehouse, improving data models for business intelligence, and leveraging Microsoft Fabric to create efficient, reliable data pipelines. The ideal candidate has experience working with Consumer Packaged Goods (CPG) data and understands the nuances of sales, distribution, retail, and customer analytics.  Please note: We are not able to provide sponsorship for employment authorization at this time. This role requires 4 days on site collaboration per week. You must be able to commute to our West 22nd Street office in New York. RESPONSIBILITIES  Design and optimize data architecture to support scalable, high-performance reporting and analytics  Develop and maintain SQL-based data warehouse structures  Improve and standardize data models used for BI and reporting tools  Build and manage data pipelines using Microsoft Fabric  Ensure data quality, consistency, and governance across reporting layers  Collaborate with business and analytics teams to translate requirements into efficient data solutions  Identify performance bottlenecks and implement improvements in data storage and query performance  Document data models, architecture, and processes  Requirements Bachelor’s or Master’s Degree in Computer Science, Data Engineering, or a related field.  Proven experience as a Data Architect or Senior Data Engineer in BI environments  Strong expertise in SQL and data warehouse design principles  Hands-on experience with dimensional modeling (Kimball or similar)  Experience with Microsoft Fabric  Deep understanding of BI/reporting workflows and data optimization techniques  Familiarity with modern data architecture patterns  Strong problem-solving skills and ability to work cross-functionally  Hands-on mindset: comfortable contributing technically while shaping the strategic direction.  Nice to Have  Experience working with Consumer Packaged Goods (CPG) data (POS data, syndicated data, sales and distribution)  Familiarity with Power BI or other visualization tools  Exposure to data governance and data quality frameworks  Experience working in a fast-paced, scaling environment  Benefits WHY UPCLEAR ? Be part of a growing global SaaS company, with offices in NYC, London, Paris, Singapore Work on latest Cloud technology and build architecture for fast-growing Tech Weekly happy hours, good office culture, global cross team collaboration, direct access to executive leadership for guidance. UpClear employees have access to a range of competitive benefits, including Various Health Care Plans you can choose from to best fits your needs (Medical, Dental & Vision) Retirement Plan with company match (401k, IRA) Generous Paid Time Off package that grows with seniority (Vacation, Sick, and Public Holidays) Paid Maternity leave Paid Parental b