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:
- Bachelor of Science Degree in Computer Science, Information Technology, Management Information Systems, Business or another relevant field AND a minimum of 5 years relevant experience
- Outstanding academics
- Demonstrated experience in successful implementation of technology solutions
- Demonstrated ability to work collaboratively to drive projects to an effective and timely completion
- Experience with ETL tools such as Informatica and Talend
- Experience with QlikSense reporting suite
- Demonstrated strong and effective verbal, written, and interpersonal communication skills in a large team or departmental setting