The Production Support Analyst is a position focused on designing, developing, enhancing, and supporting application programs and processes across the *** enterprise. This role requires interfacing with internal business clients to gather requirements, resolve issues, and provide subject matter expertise to assist with problem solving.
Essential Duties/Responsibilities:
• Design, develop, maintain, enhance and support application programs working within a team-oriented environment using various development toolsets.
• Developing reports using SQL queries/logic to extract data from SQL Server and Oracle databases, using application tools like SQL Server Management Studio and Visual Studio Code.
• Develop and maintain reports using Microsoft Power BI and SSRS.
• Provide support and monitoring of systems supporting business clients, occasionally after normal work hours.
• Facilitate requirements gathering efforts and clearly document system requirements.
• Develop new and enhanced system functionality including custom code and packaged application configuration.
• Ensure the successful transition from development to operations including operations procedures and tools such as process control points, reports, and automated monitoring.
• Regularly report status and raise issues/risks as appropriate. Anticipate and adjust for problems and roadblocks while eliminating roadblocks within control.
• Collaborate with team members and operational groups to identify and prioritize/reprioritize work when necessary.
• Develop strong working relationships with individuals at all levels of company, operations, and IT applications and infrastructure teams.
• Willingness to work hours as necessary, especially during critical issue resolution and milestone time periods.
• Interface with IT application owners and the IT organization to provide technical solutions to meet user needs. Escalate or resolve conflicts, as needed.
• Helps identify and recommend options, risks and alternatives to deliver a robust and stable infrastructure.
• Devises or modifies procedures to solve problems considering computer equipment capacity and limitations, operating time, form of desired results, and integration of components.
• Assists in researching, evaluating, specifying and coding the configuration of hardware and/or software for application's environment.
• Requires skill and proficiency in many technical functions and ability to integrate across disciplines.
• Remain abreast of current technologies and best practices that may be applicable to the company.
Working Conditions
• Position is Hybrid full time
• Standard work week, with occasional overtime required.
Minimum Requirements:
• Minimum two years' experience designing, developing, testing, and implementing ETL solutions using enterprise ETL tools (experience with SSIS is preferred)
• Minimum two years' experience developing and implementing data integration solutions in a SQL Server and/or Oracle database environment.
• Minimum two years' experience writing stored procedures, T-SQL/PL-SQL, functions, and SQL queries.
• Experience utilizing report writing best practices (optimization, use of joins and sub-queries)
• Experience with manual testing to include User Acceptance Testing (UAT)
• Experience with SQL Server Data Tools (SSDT) SSRS/SSIS/SSAS, Visual Studio, and/or other (non-Microsoft) reporting platform
• Minimum one year's experience working with high volume data exchange and transaction processing systems, preferably in a custom software development environment
• Proficiency estimating work assignments and delivering to these estimates
• Demonstrated proficiency of SQL development skills is required
• Understanding of SDLC and Agile Methodologies
• Understanding of ETL best practices
Additional Knowledge, Skills and Abilities:
• Application configuration experience and testing experience.
• Experience writing C# and VB.net code is a plus
• Experience writing Python is a plus
• Knowledge of automation tools like Control M would be an additional asset
• Create and maintain technical documentation
• Experience working with end users, taking their business problems and translating them into system requirements.
• Configuration, testing, maintenance, enhancements and/or support activities.
• Perform ad hoc analysis, insight generation, and data migrations
• Evaluating user change requests and obtains approval to make modifications.
• Participating in project planning sessions with team members to analyze business and technical requirements.
• Conducting unit testing to ensure application meets specifications.
• Experience with energy business and systems that support retail energy is a plus.
• Knowledge of Software Configuration Management discipline and systems change management processes.
• Excellent verbal and written communication skills are required to provide appropriate cross functional support and interaction.
• Excellent troubleshooting and problem resolution skills
• Ability to work well under pressure, remaining focused and calm in the face of distractions, changing priorities in a fast-paced environment.
• Understanding of Relational Database concepts is a must
• Flexibility, dedication, and team spirit is a must
• Strong organizational skills.
• Strong analytical and problem-solving skills.
• Adept at communication, both verbally and written.
LanceSoft