Job Summary:**Responsibilities**:- Providing SQL expertise, proposing design recommendations and optimization.- Providing and designing information tools to assist in the management of business lines.- Supporting data analysis inquiries from business partners and presenting results.- Identifying and resolving database performance issues- Developing security schemes for database environments as well as assisting in disaster recovery as necessary.- Works closely with Senior Developer and Solution Architect in understanding the functional and technical design;- Develops and configures automation processes as per the technical design document (TDD) to meet defined requirements;- Develops and configures new processes, tasks and objects using core workflow principles that are efficient, well structured, maintainable and easy to understand;- Complies with and helps enforce design and coding standards, policies and procedures;- Creates and maintains solution documentation;- Designs and develops solutions utilizing RPA tools and maintains technical responsibility for project delivery as the sole technical resource on a project or the leader of a delivery team;- Drives the strategic and tactical roll-out of the RPA solution to department/functions;- Consults with partners to provide functional and technical expertise in areas including solution design, development, testing and risk identification/mitigation;- Ensures quality of coded components by performing thorough unit testing;- Analyzes, understands and documents the business processes in detail where required;- Identifies and communicates the technical infrastructure requirements;- Designs RPA process solutions in accordance with standard design principles and conventions;- Supports existing processes and implementing change requirements as part of a structured change control process;- Works within project planning constraints, communicating any identified project risks and issues to the delivery/project manager accordingly and providing inputs to the change control process;- Creates and documents test procedures and scenarios for the initial phases;- Works collaboratively with test teams to fix assigned bugs with quality- Supports the Operational Teams during the rollout phases.Skills and Experience:- At least 6 months of experience writing SQL queries, stored procedures or views.- Expecience designing tables and dependencies between them.- Experience creating BI reports using Power BI, SSRS or Tableau.- Knowledge of SQL Server 2012 or newer.- English Language (Oral and writing)
