Revolution Technologies
OpenGate/Power Automate Consultant
Revolution Technologies, Nashville, Tennessee, United States, 37247
Primary skills:
OpenGate and SQLSecondary skills:
SSIS/ETLKey Responsibilities:Stored Procedures Development:
Design, write, and optimize complex stored procedures to support data processing, reporting, and application functionalities.Data Workflow Automation:
Develop and maintain automated data workflows to ensure efficient data movement and transformation across various systems and databases.ETL Process Design:
Design, implement, and manage ETL (Extract, Transform, Load) processes to support data integration from various sources into data warehouses or other centralized systems.Data Standardization:
Establish and enforce data standards to ensure data consistency, accuracy, and quality across the organization. Develop data transformation rules and procedures to standardize incoming data.Performance Tuning:
Monitor and optimize database performance, including query tuning and indexing, to ensure efficient data processing and retrieval.Collaboration:
Work closely with data analysts, database administrators, and other stakeholders to understand data requirements and deliver solutions that meet business needs.Documentation:
Create and maintain comprehensive documentation for all developed processes, including stored procedures, data workflows, ETL processes, and data standardization protocols.Troubleshooting:
Diagnose and resolve data-related issues, including data inconsistencies, workflow failures, and performance bottlenecks.[Must Have] 5+ years of experience in database development, with a focus on writing stored procedures in SQL[Must Have] Excellent knowledge on writing OpenGate queries for MeditechStrong experience in developing and managing ETL processes using tools like SSISProficiency in data workflow automation tools and platforms like Power AutomateDeep understanding of data standardization techniques and best practices.Experience with performance tuning and optimization of databases and queries.Strong problem-solving skills and attention to detail.Excellent communication skills, with the ability to work effectively with cross-functional teams.Experience with Google Cloud-data platform.Preferred ExperienceMeditech NPRExpanseHybrid Onsite team. Typically, 2 days Onsite (some weeks 3 days onsite and some weeks only 1 day onsite), but the expectation regardless is that when the team is onsite that this resource will be onsite.
OpenGate and SQLSecondary skills:
SSIS/ETLKey Responsibilities:Stored Procedures Development:
Design, write, and optimize complex stored procedures to support data processing, reporting, and application functionalities.Data Workflow Automation:
Develop and maintain automated data workflows to ensure efficient data movement and transformation across various systems and databases.ETL Process Design:
Design, implement, and manage ETL (Extract, Transform, Load) processes to support data integration from various sources into data warehouses or other centralized systems.Data Standardization:
Establish and enforce data standards to ensure data consistency, accuracy, and quality across the organization. Develop data transformation rules and procedures to standardize incoming data.Performance Tuning:
Monitor and optimize database performance, including query tuning and indexing, to ensure efficient data processing and retrieval.Collaboration:
Work closely with data analysts, database administrators, and other stakeholders to understand data requirements and deliver solutions that meet business needs.Documentation:
Create and maintain comprehensive documentation for all developed processes, including stored procedures, data workflows, ETL processes, and data standardization protocols.Troubleshooting:
Diagnose and resolve data-related issues, including data inconsistencies, workflow failures, and performance bottlenecks.[Must Have] 5+ years of experience in database development, with a focus on writing stored procedures in SQL[Must Have] Excellent knowledge on writing OpenGate queries for MeditechStrong experience in developing and managing ETL processes using tools like SSISProficiency in data workflow automation tools and platforms like Power AutomateDeep understanding of data standardization techniques and best practices.Experience with performance tuning and optimization of databases and queries.Strong problem-solving skills and attention to detail.Excellent communication skills, with the ability to work effectively with cross-functional teams.Experience with Google Cloud-data platform.Preferred ExperienceMeditech NPRExpanseHybrid Onsite team. Typically, 2 days Onsite (some weeks 3 days onsite and some weeks only 1 day onsite), but the expectation regardless is that when the team is onsite that this resource will be onsite.