Software Engineer (BI)Position SummaryAs 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.
Education:- Bachelor's degree in business, computer science, or a related field of study, or equivalent experience.
- Power BI Certification (Mandatory)
- Azure Certification (Database, AI/ML)
- Any Cloud DB Certification
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 objects.
Working Conditions: Generally agreeable working conditions such as those found inside offices or equivalent work areas for more than 70% of the time.
