About this opportunity
UpClear lists this Sr. Data Architect opportunity in new york, New York. Review the employer’s description below for duties, qualifications and application requirements.
Job description
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. UpClear is on the Inc 5000 list of fastest growing private companies for eight years in a row. Our headquarters are in New York City with 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 onsite 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 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
Be part of a growing global SaaS company with offices in NYC, London, Paris, and 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
Health care plans (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 and paid parental bonding leave
One month paid sabbatical after five continuous years of work at UpClear
Hybrid work model
Competitive salary ($150K - $200K)
The salary range listed is a good faith determination of potential base compensation that may be offered to a successful applicant for this position at the time of this job advertisement and may be modified in the future. When determining a team member's base salary, several factors may be considered as applicable including, but not limited to, relevant education, qualifications, certifications, experience, and seniority.
For contractors, compensation will be offered as an hourly rate or fixed project fee, depending on the scope of work and experience level. The estimated pay range for this role is $77 to $97 per hour. Final compensation will be determined based on factors such as skills, experience, and agreed‑upon deliverables.
#J-18808-Ljbffr
Worksite address
new york, NY, 10261, US
Who can apply
Review the original listing for work authorization, qualifications and employer requirements.