Architect II

As an Architect II at Insight, you will play a crucial role in leading Business Intelligence (BI) and Data Warehousing (DW) initiatives. Your responsibilities will include designing and implementing end-to-end data pipelines using modern cloud services and frameworks, collaborating with stakeholders and ETL/BI developers, and ensuring scalable, secure data architectures that align with business requirements and regulatory compliance. Here is what you can expect in this role: **Role Overview:** You will be responsible for architecting and implementing end-to-end data pipelines, data lakes, and warehouses using modern cloud services and architectural patterns. Your role will involve developing analytics tools to deliver actionable insights, integrating and managing large, complex data sets, optimizing data processing workflows using frameworks like PySpark, and enforcing best practices for data quality, integrity, security, and performance. **Key Responsibilities:** - Architect and implement end-to-end data pipelines, data lakes, and warehouses using modern cloud services and architectural patterns. - Develop analytics tools to deliver actionable insights. - Integrate and manage large, complex data sets to meet strategic business requirements. - Optimize data processing workflows using frameworks such as PySpark. - Establish and enforce best practices for data quality, integrity, security, and performance. - Collaborate with cross-functional teams to prioritize deliverables and design solutions. - Develop compelling business cases and ROI analyses to support strategic initiatives. - Drive process improvements for enhanced data delivery speed and reliability. - Provide technical leadership, training, and mentorship to team members. **Qualifications Required:** - 10+ years in Business Intelligence (BI) solution design, with 8+ years specializing in ETL processes and data warehouse architecture. - 8+ years of hands-on experience with Azure Data services including Azure Data Factory, Azure Databricks, Azure Data Lake Gen2, Azure SQL DB, Synapse, Power BI, and MS Fabric. - Strong Python and PySpark software engineering proficiency. - Proficient in transforming, processing, and extracting insights from disparate datasets. - Familiarity with Agile methodologies and software development lifecycles. - Experience with SAP/ERP/Datasphere data modeling is a plus. - Excellent presentation and collaboration skills. - Problem-solving, time management, and organizational abilities. - Graduate degree in Computer Science, Statistics, Informatics, Information Systems, or related field. Join Insight today and embark on your ambitious journey in a dynamic and collaborative environment. (Note: Additional details of the company were not included in the provided job description.),