Data Warehouse Architect

Our goal is to solve problems and deliver results for our clients. At Cloud and Things, you can be a part of transforming the public sector’s IT environment. Our team is on the forefront of helping to solve the government's most complex IT challenges. If you are seeking a role that offers the opportunity to work on rewarding projects, consider a career with Cloud and Things. • This is an exempt position. Salary commensurate with experience • Overview: We are seeking an experienced Data Warehouse Architect who will design and architect a comprehensive cloud-based data warehouse solution that will integrate multiple siloed child safety data sources into a unified platform for our client. Duties: Develop the overall approach and architecture for the Data Warehouse solution Design data integration strategies for disparate sources, including unstructured data Architect the implementation of Common Person ID across all datasets Design secure, role-based access controls and a data governance framework Architect a cloud-based solution with consideration for Express Route connectivity Design data lineage, provenance tracking, and audit trail mechanisms Plan for data encryption at rest and in transit Ensure architecture meets NYC security standards and SSAP requirements Provide technical oversight, ensuring adherence to client standards Review all third-party tools and architectural decisions Mandatory Qualifications: 10+ years of experience in Data Warehouse and Enterprise Architecture Proven experience in architecting large-scale data warehouse solutions (500GB+ databases) Strong experience with cloud platforms (Azure, AWS, or GCP) Expert knowledge in data integration and ETL/ELT processes Experience with both structured and unstructured data management Knowledge of Master Data Management and data matching solutions Experience designing analytics platforms and BI solutions Database expertise (Oracle, SQL Server, PostgreSQL) API design and integration experience Desirable Qualifications: Experience with Azure Synapse, Snowflake, or Informatica Government project experience, preferably NYC Knowledge of SAML, MFA, and identity management Experience with AI/ML model integration Familiarity with Tableau, Power BI, or Looker Experience with NYC security standards and SSAP process Cloud and Things complies with all applicable federal, state, and local laws regarding recruitment and hiring. All qualified applicants are considered for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, or any other category protected by applicable federal, state, or local laws. AI-Assisted Resume Evaluation Notice Cloud and Things – Talent Management Notice to Candidates Cloud and Things utilizes artificial intelligence (AI) tools to assist our recruiting team in evaluating candidate applications for streamlining; consistency, efficiency, and thoroughness. All hiring decisions are ultimately made by our human recruiting professionals. How AI Is Used Our AI tools assist by: Analyzing resumes against job requirements Supporting our recruiters in candidate data evaluation Ensuring consistent review standards across all applications Important: AI serves as a support tool only. As noted above, all candidate selection and hiring decisions are made by experienced human recruiters. Your unedited resume will be processed by our AI tools as part of this evaluation. Your Data and Privacy Cloud and Things Data Handling: Your information is processed securely and used exclusively for recruitment purposes Cloud and Things may store your resume in our Applicant Tracking System (ATS) indefinitely for future job matching opportunities You may opt out of long-term ATS storage by emailing your name and your request to opt out of storing your resume in the ATS to: security@cloudandthings.com All personal information is handled confidentially in accordance with our privacy policy AI Tool Data Processing: AI processing data is retained for a maximum of 90 days, after which it is deleted All data sent to AI tools is encrypted in transit and at rest AI tools comply with applicable privacy laws including GDPR and CCPA Personal data is anonymized or minimized wherever possible during AI processing Your Participation By submitting your application, you acknowledge this notice and consent to AI-assisted evaluation as part of our recruitment process. You may opt out only by choosing not to submit your resume for consideration. Pay: $130,000.00 - $145,000.00 per year Experience: Data Warehouse and Enterprise Architecture: 10 years (Required) Cloud platforms (Azure, AWS, GCP): 2 years (Required) Ability to Commute: New York, NY 10007 (Required) Work Location: Hybrid remote in New York, NY 10007