Qualifications:
?Bachelor's degree in Computer Science, Information Technology, or a related field.
?Minimum of 3 to 9 years of experience in SQL development.
?Proven experience with GCP BigQuery and ETL processes.
?Strong knowledge of Signavio Process Intelligence would be preferred.
?Proficiency in SAP Analytics Cloud (SAC) development would be preferred.
?Excellent problem-solving skills and attention to detail.
?Strong communication and collaboration skills.
Key Responsibilities
SQL Development:
? Design, develop, and optimize complex SQL queries, stored procedures, and functions.
? Ensure data integrity and performance optimization of SQL databases.
?
Requirements Gathering:
? Work closely with business analysts and stakeholders to gather and document detailed requirements.
? Translate business requirements into technical specifications for database solutions.
System Design:
? Design database schemas, tables, views, indexes, and other database objects.
? Develop data models and database architecture to support business needs.
? Ensure scalability, reliability, and performance of database systems.
Development:
? Implement database solutions based on design specifications.
? Write efficient and maintainable SQL code.
? Develop and maintain ETL processes to integrate data from various sources.
Testing:
? Develop and execute unit tests to ensure the quality and functionality of SQL code.
? Collaborate with QA teams to support integration and system testing.
? Identify and fix defects in a timely manner.
Deployment:
? Prepare database scripts and deployment packages.
? Coordinate with DevOps and IT teams to deploy database changes to production environments.
? Ensure smooth and error-free deployment of database updates.
Maintenance and Support:
? Monitor database performance and troubleshoot issues.
? Provide ongoing support and maintenance for database systems.
? Implement database security measures and backup/recovery procedures.
Documentation:
? Create and maintain comprehensive documentation for database designs, processes, and procedures.
? Ensure documentation is up-to-date and accessible to relevant stakeholders. GCP BigQuery ETL:
? Develop and manage ETL processes using Google Cloud Platform's BigQuery.
? Design and implement data pipelines to ingest, process, and store large datasets.
? Optimize BigQuery performance and cost-efficiency.
Signavio Process Intelligence:
? Utilize Signavio Process Intelligence to analyze and optimize business processes.
? Develop process models and dashboards to provide insights into process performance.
? Collaborate with business units to identify process improvement opportunities.
SAC Development:
? Design and develop dashboards and reports using SAP Analytics Cloud.
? Integrate SAC with various data sources to provide comprehensive analytics solutions.
? Ensure the accuracy and reliability of SAC reports and visualizations.