Data Solutions Architect

General summary:

This position is responsible for the development, maintenance, and enhancement of business applications. The incumbent works as part of project teams and is accountable for specific business application systems built with modern web and server-side technologies. Collaborate with staff, colleagues, and other stakeholders to identify user requirements, assess available technologies, and recommend solution options. This position is familiar with project management techniques and may have project leadership responsibility for projects, regularly coach other team members, or plan work for others to meet project deadlines.

Key responsibilities:

• Provides business analysis and programming expertise on systems, participating in the analysis, design, development, implementation, and maintenance of the system, typically as part of a project team.
• Creates and maintains SQL Server databases.
• Plans, coordinates, and implements security measures and control processes to safeguard the computer system, data and supports corporate system of internal controls.
• Provides daily support, troubleshooting, and problem resolution, including after-hours on-call support for assigned business application systems.
• Formulates and defines application scope and objectives; devises and modifies procedures to solve business problems.
• Prepares detailed specifications from which programs will be written. Design, code, test, debug, and document programs.
• Prepares user training material such as user guides, scripted demos, and operating instructions.
• Develops business relationships and integrates activities with other departments to ensure successful implementation and production usage of business applications.
• Leads small projects or coaches project personnel to ensure business application systems are developed to comply with architectural standards, established methodologies, and practices.
• Monitors and reports to management on the status of project efforts. Anticipate and identify issues that inhibit the attainment of project goals and implement corrective actions.
• Fosters and maintains good relationships with customers and Information Telecommunications colleagues to meet expected customer service levels.
• Participates in the evaluation and deployment planning of new technologies.

Job criteria:

Education & experience

Knowledge typically acquired through a Bachelor’s degree in Computer Science or a related field, or a two-year degree in Computer Science with two (2) years of experience in software development and database administration, or at least four (4) years of post-high school education in software development and database administration.

Knowledge, skills, & abilities

• Knowledge of electrical generation process control systems is preferred.
• Knowledge of business continuity and disaster recovery plans.
• Knowledge of MS Azure (Cloud Systems) is preferred.
• Knowledge of UDP&TCP connections Razor pages, ajax concepts Kubernetes/IBM Openshift, WSL, Ubuntu, Crystal Reports, and IBM Maximo 9.0 is preferred.
• Knowledge of C#, HTML, JavaScript, Python, Visual Studio, SQL, and MS SQL Server is required.
• Knowledge of MS O365 applications.
• Knowledge of system integration concepts, tools, and processes.
• Skilled in communicating effectively with both technical and executive audiences, with strong interpersonal, verbal, and written communication abilities and the capacity to understand and convey complex information.
• Ability to work with and maintain confidential information while exercising discretion and sound judgment.
• Ability to project/anticipate future information technology services and provide input to the planning and budgeting process.
• Ability to understand cross-functional interdependencies and respond accordingly.
• Ability to manage projects of small to moderate size within area(s) of expertise (such as managing applications, database upgrades, enhancements to change control process).
• Ability to demonstrate and foster a team environment; skill in accomplishing work through others where a direct reporting relationship does not exist.
• Ability to develop and make recommendations to management for new and existing support processes, standards, and technologies; leads implementation and continually promotes adherence.
• Ability to administer and maintain change management processes; ensures adherence within IT; coordinates change-related communication within REC.
• Ability to adapt to rapidly changing business circumstances; must be able to thrive in a constantly changing business environment.
• Ability and responsibility to work safely alone and with others while following REC safety rules, certifications, and procedures.
• Ability and responsibility to ensure security procedures are followed, including immediate notification of potential incidents.
• Ability to work under minimal direction with extensive latitude for the use of initiative and independent judgment.