Software Engineer (BI)- job post Neptune Technology Group Group Inc.
Job 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 (http://www.neptunetg.com).
Software Engineer (BI)
Position Summary
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 pipelines.
Responsibilities:
Understand business requirements and perform technical implementations using knowledge of enterprise applications and technical expertise.
Understand master data management concepts and principles.
Design, develop, and maintain ETL processes using SQL Server Integration Services (SSIS) for on-premises and hybrid environments.
Develop and optimize SSIS packages for data extraction, transformation, and loading (ETL) from various sources to target databases.
Implement error handling, logging, and auditing mechanisms to monitor and troubleshoot SSIS packages for data quality and integrity.
Design and implement data integration and orchestration workflows using Azure Data Factory (ADF) for cloud-based data solutions.
Perform performance tuning and optimization of ETL processes to meet scalability and performance requirements.
