Software Engineer BI

Description

Neptune Technology Group Inc. is a technology company serving more than 4,000 water utilities across North America. We make data actionable using effective software and measurement systems that are interconnected by a smart network, with expertise and experience specifically focused on the business of water. The company’s story is rooted in loyalty to our customers and in sound stewardship. Neptune, as your most valued partner in water metering tools, technology, and connectivity, will connect you to what’s next in water. For additional information, visit www.neptunetg.com

.

Software Engineer (BI

)

Position Summar

y
As a Business Intelligence Software Engineer, you will apply knowledge of enterprise applications and development to analyze, program, and implement Data Sourcing (ETL), Report Building, & Data Governance best practices in support of business objectives. You will be responsible for the analysis, development, testing, deployment, and post-deployment support of the ETL processes and PowerBI solutions for the Enterprise Applications & Data team. You will work closely with Product Owners to understand business requirements, design effective ETL solutions, and ensure the reliability and performance of data pipeline

s.
Responsibiliti

• es:
  Understand business requirements and perform technical implementations using knowledge of enterprise applications and technical expert
• ise.Understand master data management concepts and princip
• les.Design, develop, and maintain ETL processes using SQL Server Integration Services (SSIS) for on-premises and hybrid environme
• nts.Develop and optimize SSIS packages for data extraction, transformation, and loading (ETL) from various sources to target databa
• ses.Implement error handling, logging, and auditing mechanisms to monitor and troubleshoot SSIS packages for data quality and integr
• ity.Design and implement data integration and orchestration workflows using Azure Data Factory (ADF) for cloud-based data soluti
• ons.Perform performance tuning and optimization of ETL processes to meet scalability and performance requireme
• nts.Document ETL processes, data mappings, technical specifications, and best practices for reference and future maintena
• nce.Develop PowerBI functionality to optimize, extend, and integrate enterprise applications, data, and repo
• rts.Design and develop PowerBI data models, following best practices for dashboard and report creat
• ion.Engage in prototyping, designing, and publishing PowerBI Repo
• rts.Collaborate with Data Engineers to acquire, clean, and transform data for reporting purpo
• ses.Conduct data analysis, profiling, and pattern recognition to troubleshoot and resolve data discrepanc
• ies.Support QA and UAT testing activities for PowerBI soluti
• ons.Participate in agile team ceremonies including sprint planning, daily stand-ups, backlog grooming, and retrospecti
• ves.Stay updated on industry best practices, tools, and technologies related to ETL, data integration, and cloud-based data soluti

ons.
Requirem

• ents:
  5 years of relevant exper
• ience.Strong interpersonal skills, and strong team-building s
• kills.Pragmatic problem solving and decision-making skills with excellent written and verbal communica
• tions.Relentless passion and commitment to operational excellence – delivering in scope, on time, on the budget to the delight of our internal cus
• tomer.Experience with QAD or SAP ERP Pref
• erred.Experience with Azure or AWS Cloud Pref

e

rred. Educ

• ation:
  Bachelor's degree in business, computer science, or a related field of study, or equivalent expe
• rience.Power BI Certification (Man
• datory)Azure Certification (Database,
• AI/ML)Any Cloud DB Certif

i

cation Location: Tallassee, Alabama or Duluth, Georgia, Mississauga, ON (

Canada)Physical Requirements: Sedentary Work - Exerting up to 10 pounds of force occasionally and/or a negligible amount of force frequently or constantly to lift, carry, push, pull, or otherwise move o

bjects.Working Conditions: Generally agreeable working conditions such as those found inside offices or equivalent work areas for more than 70% of th