As a Business Intelligence Software Engineer, you will leverage your expertise in enterprise applications and development to analyze, program, and implement best practices in Data Sourcing (ETL), Report Building, and Data Governance. Your role will encompass the analysis, development, testing, deployment, and post-deployment support of ETL processes and PowerBI solutions for the Enterprise Applications & Data team. You will collaborate closely with Product Owners to interpret business requirements, design effective ETL solutions, and ensure the reliability and performance of data pipelines.
Key Responsibilities
Requirements Analysis: Interpret business requirements and apply technical expertise to implement solutions effectively using your knowledge of enterprise applications.
Master Data Management: Apply principles of master data management to ensure data consistency and accuracy.
ETL Process Design and Maintenance: Design, develop, and maintain ETL processes utilizing SQL Server Integration Services (SSIS) for both on-premises and hybrid environments. Optimize SSIS packages for data extraction, transformation, and loading (ETL) from diverse sources to target databases.
Error Handling and Monitoring: Implement error handling, logging, and auditing mechanisms to monitor and resolve issues with SSIS packages, ensuring data quality and integrity.
Data Integration: Design and execute data integration and orchestration workflows using Azure Data Factory (ADF) for cloud-based solutions. Perform performance tuning and optimization of ETL processes to meet scalability and performance requirements.
Documentation: Create and maintain comprehensive documentation for ETL processes, data mappings, technical specifications, and best practices to support future maintenance and reference.
PowerBI Development: Develop and enhance PowerBI functionalities to integrate and optimize enterprise applications, data, and reporting solutions. Design and create PowerBI data models and dashboards, adhering to best practices.
Collaboration and Support: Work with Data Engineers to acquire, clean, and transform data for reporting. Conduct data analysis, profiling, and pattern recognition to resolve discrepancies. Support QA and User Acceptance Testing (UAT) for PowerBI solutions.
Agile Participation: Engage in agile team practices including sprint planning, daily stand-ups, backlog grooming, and retrospectives.
Industry Awareness: Stay informed about industry best practices, tools, and technologies related to ETL, data integration, and cloud-based solutions.
Requirements
Experience: Minimum of 5 years of relevant experience in business intelligence or data engineering roles.
Skills: Strong interpersonal and team-building abilities. Demonstrated problem-solving and decision-making skills with excellent written and verbal communication.
Commitment: Proven dedication to operational excellence, with a track record of delivering projects within scope, on time, and on budget.
Preferred Experience: Familiarity with QAD or SAP ERP systems, experience with Azure or AWS Cloud platforms, and Power BI Certification.
Education
Degree: Bachelor's degree in Business, Computer Science, or a related field, or equivalent professional experience.
Certifications: Any Cloud Database Certification is advantageous.
Location
Tallassee, Alabama or Duluth, Georgia (some travel between locations may be required).
Physical Requirements
Sedentary work involving 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 favorable working conditions typical of office environments, for more than 70% of the time.