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)