Lead Architect - Applications

AVANGRID SERVICE COMPANY; Orange (CT); On-site; USD 128,000 - 168,000; Full time

Benefits offered by this job

Bonus 12%

401(k) match

Health/dental/vision

Tuition reimbursement

Professional development

Job summary

AVANGRID SERVICE COMPANY in Orange, CT is seeking a Lead Data Architect – Applications to design enterprise data solutions supporting analytics, cloud adoption, and digital transformation. Focus on SAP ecosystems, real‑time data, and governance.

Role reports to Manager – Data Analytics and requires strong SQL, SAP, cloud skills, and leadership in large‑scale deployments across Azure/AWS environments.

Qualifications

• Bachelor’s degree in Computer Science or a related field with 8+ years of experience.
• Strong experience with SAP HANA, BW, Datasphere, BTP, and SAC.
• Proficiency in SQL and data engineering tools (SSIS, SSRS, SSDT).
• Familiarity with Python and ML frameworks (NumPy, Pandas).
• Experience with governance, visualization tools (Power BI, SAC).
• Migration across data platforms and large‑scale cloud infra (Azure/AWS).
• Ability to lead complex projects and collaborate across IT and business teams.

Responsibilities

• Design and implement enterprise data warehousing solutions (SAP HANA, BW, SQL Server).
• Develop and optimize HANA models, SQL scripting, and performance tuning.
• Develop secure, data‑driven apps with real‑time insights via APIs/databases.
• Translate business needs into scalable technical solutions and architectures.
• Lead architecture/design/deployment in project phases; guide development teams.
• Ensure data governance, security, and visualization standards across platforms.
• Collaborate with stakeholders and vendors for high‑quality solutions.
• Contribute to cloud‑native data platforms (AWS/Azure) and Lakehouse ecosystems.
• Assist in real‑time data architectures with event‑driven designs (Kafka).
• Support AI/ML pipelines integration and CI/CD for data pipelines.

Skills

SAP HANA

BW

Datasphere

BTP

SAC

SQL

SSIS

SSRS

SSDT

Python

ML frameworks

Power BI

Databricks

Snowflake

AWS/Azure

Education

Bachelor’s degree in Computer Science or related field

Tools

Databricks

Snowflake

Azure

AWS

SAP Datasphere

Job description

Lead Data Architect - Applications

Reports to: Manager - Data Analytics

Location: In Office, Orange CT, Boston MA

Salary

The base salary range for this position is dependent upon experience and location, ranging from:

• $128,320 - $160,400 (Orange, CT)
• $134,080 - $167,600 (Boston, MA)

What We Offer

• Competitive benefits and growth opportunities
• Generous performance‑based bonuses 12% 401(k) match
• Comprehensive health, dental, and vision insurance
• Tuition reimbursement
• Professional development and clear career‑advancement pathways

Job Summary

The Lead Architect – Applications plays a key role in designing and implementing enterprise data solutions that support advanced analytics, cloud adoption, and digital transformation. This position focuses on SAP-centric ecosystems, cloud platforms, and real‑time data integration, while contributing to enterprise data strategy and ensuring compliance with governance and security standards. The Lead Architect – Applications role reports into the Manager – Data Analytics.

Key Responsibilities

• Support the design and implementation of enterprise data warehousing solutions using SAP HANA, BW, SQL Server, and related technologies.
• Develop and optimize HANA models, SQL scripting, and performance tuning for efficient data processing and reporting.
• Develop secure, data-driven applications integrating APIs and databases for real‑time business insights.
• Translate business requirements into scalable technical solutions aligned with best practices.
• Participate in project implementation phases, including architecture, solution design, and deployment.
• Provide technical guidance to development teams and ensure adherence to data governance and visualization standards.
• Collaborate with business stakeholders and vendors to deliver high‑quality solutions.
• Contribute to the architecture of cloud‑native data platforms (AWS/Azure) and Lakehouse ecosystems (Synapse, Databricks, Snowflake, SAP Datasphere).
• Assist in designing real‑time, event‑driven data architectures leveraging Kafka or event mesh for grid operations and loT integration.
• Support integration of AI/ML pipelines and predictive models into enterprise platforms for advanced analytics.
• Help implement data governance and quality frameworks, ensuring compliance and lineage tracking.
• Participate in developing ESG and sustainability data frameworks, including carbon modeling and energy optimization pipelines.
• Assist in automation initiatives for data engineering, including CI/CD for data pipelines and infrastructure‑as‑Code (IaC).
• Ensure cybersecurity principles are applied in data architecture, including encryption for sensitive data flows.
• Coordinate with vendor partners to ensure seamless end‑to‑end deployment of enterprise data solutions, including alignment of technical requirements, integration activities, and ongoing support throughout the project lifecycle.
• Responsible for collaborating with IT teams to efficiently address and troubleshoot Data Platform Administration issues.
• Automate workflows to simplify Platform management and minimize manual tasks.
• Design, develop, and automate AI‑driven workflows within the enterprise data platform, focusing on seamless integration of machine learning models and efficient deployment of AI solutions. This includes leveraging the platform’s data pipelines and infrastructure to enable advanced analytics, ensure scalability, and maximize platform efficiency for business operations.

Required Qualifications

• Bachelor’s degree in Computer Science or a related field and a minimum of 8 years of relevant experience. An equivalent combination of education and experience may be considered.
• Strong experience with SAP HANA, BW, Datasphere, BTP, and SAC.
• Proficiency in SQL and data engineering tools (SSIS, SSRS, SSDT).
• Familiarity with Python and ML frameworks (NumPy, Pandas).
• Experience with enterprise data architecture, governance, and visualization tools (Power BI, SAP Analytics Cloud).
• Expertise in migrating between different data platforms.
• Proven experience in implementing data platforms and products across large‑scale cloud infrastructure including Azure and AWS.
• Ability to work on complex projects and collaborate across IT and business teams.
• Project experience: Led multiple enterprise‑scale projects involving the integration of advanced analytics, AI/ML capabilities, and automation frameworks, ensuring robust architecture and operational excellence throughout the project lifecycle.
• Proven experience in implementing data platforms and products across large‑scale cloud infrastructures, including Azure and AWS.

Preferred Qualifications

• Advanced certifications in SAP, cloud platforms, or data architecture.
• Hands‑on experience with cloud‑native architecture (AWS/Azure), Databricks, Snowflake.
• Exposure to event‑driven systems, AI/ML platforms, and automation frameworks.
• Demonstrated experience in the end‑to‑end deployment of data platforms and data products.

#LI-Onsite #LI-VF1

Company: AVANGRID SERVICE COMPANY Mobility Information

Please note that any applicant who is not a citizen of the country of the vacancy will be subject to compliance with the applicable immigration requirements to legally work in that country. At Avangrid we provide fair and equal employment and advancement opportunities for all employees and candidates regardless of race, color, religion, national origin, gender, sexual orientation, age, marital status, disability, protected veteran status or any other status protected by federal, state, or local law. If you are an individual with a disability or a disabled veteran who is unable to use our online tool to search for or to apply for jobs, you may request a reasonable accommodation by contacting our People and Organization department at [e-mail].

Avangrid employees may be assigned a system emergency role and in the event of a system emergency, may be required to work outside of their regular schedule/job duties. This is applicable to employees that will work in Connecticut, Maine, Massachusetts, and New York within Avangrid Network and Corporate functions. This does not include those that will work for Avangrid Power.

Avangrid employees may also be assigned a NERC Reliability Standards compliance role supporting Critical Infrastructure Protection (CIP) and/or Operations and Planning (O&P) responsibilities. This is applicable to employees that will work in electric transmission, operations, and cyber security business areas in Connecticut, Maine, Massachusetts, and New York within Avangrid Network and Corporate business areas. NERC Reliability Standards compliance roles and responsibilities may include additional access protections, training, audit engagement, and required evidence retention, and will be communicated by the employee’s management.

Job Posting End Date: October-30-2026

We are one of the main energy companies in the world, a leader in renewables, which champions the energy transition towards a low‑emissions economy. We supply energy to nearly 100 million people in dozens of countries and develops its renewable, network and commercial activities in Europe (Spain, the United Kingdom, Portugal, France, Germany, Italy and Greece), the United States, Brazil and Australia and maintains markets such as Japan and Poland, among others, as growth platforms.

Do you want to be part of the energy of the future? Do not hesitate, join us!