Software Engineer (BI) - Neptune

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.
• Document ETL processes, data mappings, technical specifications, and best practices for reference and future maintenance.
• Develop PowerBI functionality to optimize, extend, and integrate enterprise applications, data, and reports.
• Design and develop PowerBI data models, following best practices for dashboard and report creation.
• Engage in prototyping, designing, and publishing PowerBI Reports.
• Collaborate with Data Engineers to acquire, clean, and transform data for reporting purposes.
• Conduct data analysis, profiling, and pattern recognition to troubleshoot and resolve data discrepancies.
• Support QA and UAT testing activities for PowerBI solutions.
• Participate in agile team ceremonies including sprint planning, daily stand-ups, backlog grooming, and retrospectives.
• Stay updated on industry best practices, tools, and technologies related to ETL, data integration, and cloud-based data solutions.

Requirements:

• 5 + years of relevant experience.
• Strong interpersonal skills, and strong team-building skills.
• Pragmatic problem solving and decision-making skills with excellent written and verbal communications.
• Relentless passion and commitment to operational excellence – delivering in scope, on time, on the budget to the delight of our internal customer.
• Experience with QAD or SAP ERP Preferred.
• Experience with Azure or AWS Cloud Preferred.
• Power BI Certification Preferred.

Education:

• Bachelor's degree in business, computer science, or a related field of study, or equivalent experience.
• Any Cloud DB Certification

Location: Tallassee, Alabama or Duluth, Georgia

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 objects.

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

#HP1

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c) Information Systems