THIS IS A IN STATE REMOTE POSITION
JOB TITLE: IT DATA ENGINEER III
LOCATION: BANGOR
REPORTS TO: MANAGER, IT ARCHITECTURE & DATA GOVERNANCE
POSITION STATUS: EXEMPT, NON-BARGAINING UNIT
Be a part of the team that is transforming the power industry of northern and eastern Maine.
Versant Power is building on our 100-year history of delivering efficient, safe and reliable electricity service to customers in northern and eastern Maine. We never lose sight of safety, quality, integrity and innovation.
We are committed to our dedicated people, who inspire us every day to deliver something more powerful than power alone.
POSITION OVERVIEW:
The IT Data Engineer III is responsible for analyzing data, identifying patterns and trends, and developing predictive models to help organizations make data-driven decisions. Qualified Candidate must also be able to communicate their findings to stakeholders and work collaboratively with other teams. They are responsible for designing and building data pipelines, data warehouses, and data lakes and ensure that data is easily accessible, reliable, and secure.
ESSENTIAL FUNCTIONS:
Data Architecture and Design:
•Design, develop, and maintain scalable and efficient data pipelines, databases, and data integration processes.
•Collaborate with stakeholders to understand data requirements and translate them into technical specifications and data models.
•Evaluate and recommend appropriate data storage and processing technologies based on project requirements and business objectives.
Data Integration and ETL:
•Develop and implement Extract, Transform, Load (ETL) processes to acquire, clean, and transform data from various sources into usable formats.
•Ensure data integrity, consistency, and quality throughout the ETL processes.
•Monitor and troubleshoot data integration workflows, identifying and resolving data-related issues and performance bottlenecks.
Data Warehousing and Data Lake Management:
•Design, build, and maintain data warehouses and data lakes to support reporting, analytics, and business intelligence initiatives.
•Implement data partitioning, indexing, and optimization strategies to improve query performance and efficiency.
•Work closely with data consumers to understand their reporting and analysis requirements and provide appropriate data structures and schemas.
Data Governance and Security:
•Ensure compliance with data governance policies, standards, and regulations.
•Implement and enforce data security measures, including access controls, encryption, and data masking techniques.
•Monitor data usage and access patterns, identifying and mitigating potential data security risks.
Performance Optimization and Scalability:
•Optimize data processes and infrastructure to improve performance, scalability, and reliability.
•Conduct performance tuning, query optimization, and indexing to enhance data retrieval and processing speed.
•Proactively identify and address system bottlenecks to ensure efficient data operations.
Automation and Efficiency:
•Design, construction, implementation, and maintenance of automated jobs and reports.
•Collaborate with cross-functional teams, business analysts, and IT systems analysts, to understand their business requirements and provide data and custom application solutions
Collaboration and Communication:
•Communicate technical concepts and solutions effectively to both technical and non-technical stakeholders.
•Stay updated with the latest industry trends, technologies, and best practices related to data engineering.
ADDITIONAL RESPONSIBILITIES:
•Participate in after-hours call out for application support and engagement of Managed Service provider as required.
•Participate actively with related user groups.
•Other related duties as assigned including designated duties associated with Storm Restoration.
REQUIRED OR PREFERRED EDUCATION, CERTIFICATIONS, EXPERIENCE, KNOWLEDGE, SKILLS, AND ABILITIES:
•Bachelor's or Master’s degree in computer science, Information Systems, or a related field.
•Proven experience (10-15 years) working as a data engineer or in a similar role.
•Strong proficiency in SQL and experience with relational databases (e.g., Oracle, MySQL, MS SQL, PostgreSQL).
•Proficiency in core enterprise applications sitting in a UNIX and Windows environment, especially Customer Information Systems, Geographical Information Systems, and Financial Information Systems running Oracle.
•Proficiency in programming languages such as Python, Java, R for data manipulation, scripting, visualizations, and analysis
•Proficiency in full stack development and frameworks such as JavaScript, React, Angular, ExpressJS, Java, .NET, HTML, and CSS for web application development.
•Solid understanding of data modeling, data warehousing, and ETL principles.
•Experience with big data technologies and frameworks (e.g., Hadoop, Spark, Hive, Kafka) and cloud-based data platforms (e.g., AWS, Azure, GCP).
•Knowledge of data governance, data security, and privacy practices.
•Familiarity with data visualization and reporting tools (e.g. Plotly, Tableau, Power BI) is a plus.
•Familiarity with computer networking, current systems software, protocols, and standards, especially routing/switching/security, Active Directory, Voice over IP.
•Excellent problem-solving and analytical skills.
•Excellent technical architecture and technical support documentation skills.
•Strong communication and collaboration skills to work effectively in cross-functional teams.
•Ability to prioritize and manage multiple projects and tasks in a dynamic work environment.
•Travel for training and User Group participation required
PHYSICAL AND MENTAL JOB REQUIREMENTS
•Position is primarily sedentary, with some walking and standing required.
•Position requires mental and visual concentration.
•Position requires excellent oral and written communication skills.
•Position requires excellent organizational skills.
WORK HOURS:
Full Time: 40 hours per week. Extra hours may be required.
RATE OF PAY:
Commensurate with skills and experience.
APPLICATION INFORMATION:
Non-Bargaining Unit, Regular and Term employees who have at least six (6) months satisfactory job performance and attendance records in their current job are eligible to apply for posted openings.
This job description is subject to change at any time.
Versant Power is a tobacco-free, drug-free and fragrance-free workplace.
Versant Power is an Equal Opportunity Employer.
Posted: 6/17/2025