About the role

Senior Integrations Developer leading evolution of AI-assisted data integration framework at Engineered Intelligence. Design and support ETL pipelines for electric utilities data integration.

Responsibilities

Design, build, and maintain scalable ETL/ELT pipelines for onboarding external client data into the ENGIN analytics platform
Analyze and reverse-engineer client systems, source data structures, and business processes to define integration approaches
Develop transformation logic, mapping rules, reconciliation processes, and validation workflows for complex utility and enterprise datasets
Contribute to the design and implementation of AI-assisted and metadata-driven integration development frameworks
Work with agentic workflows, reusable AI skills, metadata models, and automation pipelines to accelerate integration development
Develop integration logic using Python, PySpark, SQL, and cloud-native data processing frameworks
Support deployment and orchestration of ETL workloads within AWS-based infrastructure environments.
Implement data quality, validation, monitoring, reconciliation, and error-handling processes across integration workflows
Collaborate with product, delivery, customer, and engineering teams to define data contracts, transformation requirements, and integration standards
Document integration logic, business rules, workflows, and architectural decisions
Participate in architectural planning and contribute to long-term modernization of the company’s integration ecosystem
Assist with project estimation, implementation planning, technical discovery, and stakeholder communication.

5+ years of experience in ETL development, data integration, data engineering, or related roles
Strong hands-on experience with Python and SQL for data transformation and pipeline development
Experience working with modern cloud-based data processing and orchestration environments
Strong understanding of relational data modeling, dimensional modeling, CDC concepts, ODS/data marts, and data warehousing principles
Experience developing transformation rules, reconciliation logic, mapping logic, and data validation frameworks
Strong understanding of data profiling, pattern recognition, natural keys vs surrogate keys, and reference/lookup data management
Experience working with APIs, flat files, databases, and event-driven integration patterns
Comfortable using AI-assisted development tools to generate, review, and refine technical artifacts and code
Understanding of modern AI terminology and concepts such as agents, agentic workflows, metadata-driven processing, reusable skills, hooks, and orchestration patterns
Familiarity with AWS cloud services and distributed data processing concepts
Strong analytical, troubleshooting, and system discovery skills
Excellent communication, documentation, and stakeholder collaboration abilities
Ability to work independently in a fast-paced and evolving technical environment.

Opportunity to work on advanced AI-assisted integration and analytics platforms
Direct impact on the architecture and future direction of the company’s data platform
High level of ownership, autonomy, and technical influence
Competitive compensation and benefits
Collaborative and technically strong engineering culture
Flexible Hours – Work around a core schedule (10:00 AM – 3:00 PM) while maintaining a work-life balance that suits you.
Autonomy & Growth – Take ownership of diverse responsibilities, explore cross-disciplinary opportunities, and advance your career in a dynamic, fast-growing company.