Associate Cloud Solutions Architect

Role Overview

• Partner with IT leadership to support the design, implementation, and progressive ownership of integrations connecting multiple SaaS and business platforms into a centralized, Azure-based data repository (e.g., Azure SQL, Azure Data Lake, Azure Storage).
• Assist in building and maintaining automated data pipelines and ETL/ELT processes, with the expectation of quickly growing into independently managing these workflows to support enterprise reporting and analytics.
• Support the design and refinement of data models optimized for Power BI consumption, including relationships, normalization, and performance considerations, while developing the skills to eventually own these models end-to-end.
• Help ensure integrations adhere to security best practices, including identity management, access controls, and governance standards, learning how to apply these principles independently as responsibility increases.
• Develop and support automation and data orchestration using Python and JavaScript, including scheduled jobs, API-based integrations, and data transformation scripts, with mentorship and code review from senior team members as you grow toward independent ownership.
• Work with JSON extensively for API payloads, configuration templates, policy definitions, and data interchange, gaining fluency in designing and maintaining structured, reliable integration patterns.
• Contribute to the creation of reusable integration components and internal tooling, initially extending existing frameworks and gradually taking responsibility for designing solutions that reduce manual effort and improve system reliability.
• Follow established version control practices, documentation standards, and coding conventions for all automation artifacts, with the expectation of quickly adopting best practices and maintaining production-quality code independently.
• Support the troubleshooting of cross-platform data flow issues, including API errors, authentication challenges, and automation failures, working alongside senior engineers while building the experience to diagnose and resolve issues independently.
• Assist in creating and maintaining standard operating procedures, architectural documentation, and integration runbooks, with the expectation of taking increasing ownership of documentation quality and operational readiness over time.
• Collaborate closely with business stakeholders to help gather data requirements and validate reporting-ready data sets, developing the communication and analytical skills needed to translate business needs into reliable technical solutions.
• Gradually grow into a mentoring role by sharing knowledge with IT team members on integration techniques, cloud data patterns, and Microsoft 365 best practices as experience and confidence increase.

Requirements

• 5+ years hands-on experience with Microsoft 365 E5, including identity, device, and security policy creation and management.
• Experience with supporting integration of SaaS/business platforms.
• Proficiency in: Python (API integrations, ETL automation, operational tooling)
• JavaScript (automation, API-layer logic, integration workflows)
• JSON (API payloads, configuration templates, data interchange)
• Moderate Azure proficiency, including experience with: Azure SQL or similar relational databases
• Azure Functions / Logic Apps / Automation
• Azure Storage, networking basics, service identities
• Working knowledge of relational database design, indexing, permissions, and query optimization.
• Understanding of data modeling concepts and best practices for reporting performance.

Tech Stack

• Azure
• Cloud
• ETL
• JavaScript
• Python
• SQL

Benefits

• Medical
• Dental
• Vision
• Life and disability benefits
• Wellness discount programs
• 401k
• Paid parental leave after 1 year of service
• 12 company paid holidays
• 3 weeks of paid time off