Solution Architect -Data Engineering and Analytics

Job Summary

As a Solutions Architect, the candidate will be responsible for understanding requirements and building solution architectures for the Data Engineering and Advanced Analytics Capability. The role will require a mix of technical knowledge and finance domain functional knowledge while the functional knowledge is not necessarily a must have.The candidate will apply best practices to create data architectures that are secure, scalable, cost-effective, efficient, reusable, and resilient. The candidate will participate in technical discussions, present their architectures to stakeholders for feedback, and incorporate their input. The candidate will evaluate, recommend, and integrate SaaS applications to meet business needs, and provide architectures for integrating existing Eaton applications or developing new ones with a cloud-first mindset. The candidate will offer design oversight and guidance during project execution, ensuring solutions align with strategic business and IT goals.

• Collaborate with data engineers, system architects, and product owners to implement and support Eaton's data mesh strategy, ensuring scalability, supportability, and reusability of data products.
• Lead the design and development of data products and solutions that meet business needs and align with the overall data strategy, creating complex enterprise datasets adhering to technology and data protection standards.
• Deliver strategic infrastructure and data pipelines for optimal data extraction, transformation, and loading, documenting solutions with architecture diagrams, dataflows, code comments, data lineage, entity relationship diagrams, and metadata.
• Design, engineer, and orchestrate scalable, supportable, and reusable datasets, managing non-functional requirements, technical specifications, and compliance.
• Assess technical capabilities across Value Streams to select and align technical solutions following enterprise guardrails, executing proof of concepts (POCs) where applicable.
• Oversee enterprise solutions for various data technology patterns and platforms, collaborating with senior business stakeholders, functional analysts, and data scientists to deliver robust data solutions aligned with quality measures.

• Support continuous integration and continuous delivery, maintaining architectural runways for products within a Value Chain, and implement data governance frameworks and tools to ensure data quality, privacy, and compliance.
• Develop and support advanced data solutions and tools, leveraging advanced data visualization tools like Power BI to enhance data insights, and manage data sourcing and consumption integration patterns from Eaton's data platform, Snowflake.
• Accountable for end-to-end delivery of source data acquisition, complex transformation and orchestration pipelines, and front-end visualization.
• Strong communication and presentation skills, leading collaboration with business stakeholders to deliver rapid, incremental business value/outcomes.
• Lead and participate in the planning, definition, development, and high-level design of solutions and architectural alternatives.
• Participate in solution planning, incremental planning, product demos, and inspect and adapt events.
• Plan and develop the architectural runway for products that support desired business outcomes.
• Provide technical oversight and encourage security, quality, and automation.
• Support the team with a techno-functional approach as needed.

• BE in Computer Science, Electrical, Electronics/ Any other equivalent Degree
• Education level required: 10 years
• Experience or knowledge of Snowflake, including administration/architecture.
• Expertise in complex SQL, Python scripting, and performance tuning.
• Understanding of Snowflake data engineering practices and dimensional modeling for performance and scalability.
• Experience with data security, access controls, and setting up security frameworks and governance (e.g., SOX).

• Advanced SQL skills for building queries and resource monitors in Snowflake.
• Proficiency in automating Snowflake admin tasks and handling concepts like RBAC controls, virtual warehouses, resource monitors, SQL performance tuning, zero-copy clone, and time travel.
• Experience in re-clustering data in Snowflake and understanding micro-partitions.
• Excellent analysis, documentation, communication, presentation, and interpersonal skills.
• Ability to work under pressure, meet deadlines, and manage, mentor, and coach a team of analysts.
• Strong analytical skills for complex problem-solving and understanding business problems.
• Experience in data engineering, data visualization, and creating interactive analytics solutions using Power BI and Python.
• Extensive experience with cloud platforms like Azure and cloud-based data storage and processing technologies.
• Expertise in dimensional and transactional data modeling using OLTP, OLAP, NoSQL, and Big Data technologies.
• Familiarity with data frameworks and storage platforms like Cloudera, Databricks, Dataiku, Snowflake, dbt, Coalesce, and data mesh.
• Experience developing and supporting data pipelines, including code, orchestration, quality, and observability.
• Expert-level programming ability in multiple data manipulation languages (Python, Spark, SQL, PL-SQL).
• Intermediate experience with DevOps, CI/CD principles, and tools, including Azure Data Factory.
• Experience with data governance frameworks and tools to ensure data quality, privacy, and compliance.
• Solid understanding of cybersecurity concepts such as encryption, hashing, and certificates.
• Strong analytical skills to evaluate data, reconcile conflicts, and abstract information.
• Continual learning of new modules, ETL tools, and programming techniques.
• Awareness of new technologies relevant to the environment.
• Established as a key data leader at the enterprise level.