Software Engineer

Responsibilities:

• Develop, maintain, and enhance software applications that interface with SCADA systems, and real-time data sources.
• Design and implement data pipelines and automated data acquisition processes for control and reporting systems.
• Collaborate with instrumentation, control, and operations engineers to ensure seamless data collection and interpretation from PLC/DCS systems.
• Create software tools, dashboards, and data visualization interfaces to support operations, alerts, and maintenance planning.
• Perform model-based design using tools like MATLAB for embedded logic and system simulation, where applicable
• Apply best practices in embedded C, Python, and industrial protocols for software development and integration.
• Maintain documentation including software specifications, validation reports, and data architecture.
• Assist in testing, commissioning, and troubleshooting software used in remote water treatment and pump control systems.
• Support compliance initiatives for system safety, cybersecurity, and reliability.
• Design, develop, and maintain robust and scalable data pipelines for various data sources (e.g., databases, APIs, cloud storage).
• Develop and maintain reports, dashboards, and visualizations using BI tools like Oracle Analytics, BI Publisher, and Microsoft Power BI to provide insights into Oracle Utilities application data. Translate business requirements into technical specifications for BI solutions and develop reports and dashboards that meet user needs.

Education:

• Bachelor s Degree from an accredited college or university with a major in Engineering, Computer Science, Mathematics or a related field.
• Master s degree preferred. At least ten (10) years of professional job-related experience with a bachelor s degree or eight (8) years with a master s degree or six (6) years with a Ph.D. degree.

Required Experience:

• Work Experience: 8+ years of experience designing and implementing data solutions and pipelines for enterprise-level applications.
• Industry Knowledge: 5 8 years of professional experience in embedded systems, SCADA integration, or control system software development
• Project Experience: Experience with data integration platforms, time-series databases, or data lakes
• Experience with data acquisition, processing, and visualization from sensors and control systems.
• Strong understanding of functional block diagrams, state machines, and structured text programming
• Excellent written and verbal communication skills
• Data Modeling: Extensive experience with data modeling and database design, particularly for Oracle-based applications and BI platforms.
• Enterprise Analytics: Proven expertise in implementing enterprisewide analytics and business intelligence solutions, including data integration from multiple systems into a single data repository.
• BI Tools: Proficiency in Oracle Analytics, Microsoft Power BI, and BI Publisher, both as a developer and administrator.

Required Skills:

• Business Intelligence: Strong knowledge of BI platforms, including dashboard development, data visualization, report generation, and system administration for Oracle Analytics, Power BI, and BI Publisher.
• Tools: Python scripting, automation, data processing, and integration with control systems. SCADA Systems development and integration experience (e.g., Wonderware, GE, Siemens). PLC/DCS Systems hands-on experience with logic design, control loop programming, and system interfacing.
• Database & Data Structures: Deep understanding of database design principles, SQL, PL/SQL, and Oracle database management systems, including performance optimization and troubleshooting. developing real-time analytics solutions for utility businesses.
• Data Governance & Quality: Familiarity with data governance frameworks, ensuring data integrity, quality, and security within an enterprise context.
• Communication & Collaboration: Excellent verbal and written communication skills, with the ability to work closely with stakeholders to translate business needs into technical solutions.
• Problem-Solving: Strong analytical skills and problem-solving abilities, especially when working with large, complex datasets.
• Data Acquisition & Processing building pipelines from sensors/control systems to central applications.
• Data Visualization Tools creating dashboards, alerts, and monitoring interfaces for operations.
• Time-Series Databases & Data Lakes (preferred) experience with platforms like InfluxDB, OSIsoft PI, or Azure Data Lake.