Associate Azure Cloud Solutions Architect Data & Automation

Electrosonic; United States; Hybrid; USD 90,000 - 105,000; Full time

Job summary

Electrosonic seeks an Associate Cloud Solutions Architect to support the design of cloud-based data flows and centralized Azure data repositories. You will contribute to automated data pipelines, secure SaaS integrations, and analytics-ready data models for Power BI under senior guidance.

The role targets early-career cloud engineers eager to take ownership, working with Python, JavaScript, JSON, and Microsoft 365 E5 services in a hybrid environment across the United States.

Qualifications

• 5+ years hands-on experience with Microsoft 365 E5 including identity, device, and security policy management.
• Experience with supporting integration of SaaS/business platforms.
• Proficiency in Python.
• Proficiency in JavaScript.
• Proficiency in JSON.
• Moderate Azure proficiency, including Azure SQL, Azure Functions/Logic Apps/Automation, and Azure Storage.
• Working knowledge of relational database design, indexing, permissions, and query optimization.
• Understanding of data modeling concepts and best practices for reporting performance.

Responsibilities

• 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.

Skills

MS 365 E5

SaaS integrations

Python

JavaScript

JSON

Azure SQL

Azure Functions

Azure Storage

Relational DB design

Data modeling for BI

Tools

Power BI

Job description

Electrosonic seeks an Associate Cloud Solutions Architect to support the design of cloud-based data flows and centralized Azure data repositories. You will contribute to automated data pipelines, secure SaaS integrations, and analytics-ready data models for Power BI under senior guidance.

The role targets early-career cloud engineers eager to take ownership, working with Python, JavaScript, JSON, and Microsoft 365 E5 services in a hybrid environment across the United States.