Business Intelligence Reporting Specialist

POSITION SUMMARY : Designs and develops complex multi-system applications and drives collaboration with others to ensure effective project completion. Works collaboratively to develop and implement unit and system testing processes

ESSENTIAL FUNCTIONS :

• Design, develop, and maintain scalable and efficient ETL processes using tools such as Informatica ensuring optimal data extraction, transformation, and loading.
• Develop, and test reports using QlikSense reporting tools
• Develop and perform unit testing
• Migrate ETL artifacts between environments
• Work with Product Owner and BI team to understand business objectives in order to satisfy report and data warehouse design requirements and translate the data requirements into technical specifications.
• Optimize and troubleshoot ETL workflows to ensure data accuracy, performance, and reliability in batch and real-time processing environments.
• Develop and enforce data quality, data profiling, and validation checks throughout ETL pipelines.
• Create and maintain technical documentation for ETL processes, data flow diagrams, and architecture.
• Participate in code reviews, promote best practices, and contribute to improving the team's development standards.
• Ensure compliance with data governance, security policies, and privacy regulations (e.G., GDPR, HIPAA).
• Own and lead complex ETL troubleshooting efforts in production environments involving large datasets, multi-source systems, and time-sensitive business processes.
• Perform rapid root cause analysis on data integrity issues, performance bottlenecks, job failures, and unexpected data flow anomalies.
• Work cross-functionally with DBAs, infrastructure teams, DevOps, and data consumers to isolate and resolve production incidents with minimal downtime.
• Lead post-mortems for critical incidents and design permanent corrective actions to eliminate recurring problems
• Maintain strong SLAs and ensure compliance with data governance, audit, and security standards.
• Continuously explore and implement modern data engineering tools and practices.
• Interact with BI team to understand the source data
• Architect and design data warehouse structures for global usage and 24 / 7 availability
• Strong knowledge in SQL and PL / SQL.
• Incorporate appropriate data security throughout all development efforts
• Consistently look at the opportunity in all change
• Give and receive feedback in a constructive manner
• Resolve conflicts with little assistance
• Exemplifies Garmin’s Mission Statement and Quality Policy and proactively works to improve Garmin’s image and culture

EDUCATION EXPERIENCE AND SKILLS REQUIRED :