"Alerted.org

**OUC - The** **_Reliable_** **One** **,** is presently seeking a **Sr. Programmer Analyst** to join the Transmission, Substation & Systems Protection division supporting **Florida Municipal Power Pool** (FMPP). At OUC, we don’t just work – we’re building a bright future of innovation and transformation for future generations.

We are looking for a self-directed technical expert responsible for developing and maintaining the applications and data infrastructure that support FMPP. In this role, you will be responsible for planning, designing, implementing, and maintaining technology solutions used by a wide range of stakeholders. You will play a key role in modernization and continuous advancement of our technology capabilities. Effective partnership with both internal and external teams will be essential to ensure success in this role.

OUC’s mission is to provide exceptional value to our customers and community by delivering sustainable and reliable services and solutions.Click here (https://youtu.be/s\_ZnGjX\_Sas) to learn more about what we do.

The Ideal Candidate Will Have:

+ Bachelor’s degree in Information Technology, Computer Science, Computer Engineering, Management Information Systems (MIS), or a related field; in lieu of a degree, a combination of equivalent education, certifications, and experience will be considered.

+ Minimum of seven (7) years of experience involving software development and employing formal software development methodologies to include:

+ Minimum of three (3) years of in-depth core applications work experience in applying software engineering best practices to plan, design, implement and maintain technology solutions, utilizing tools such as Python, PowerBI, Snowflake, SQL, Control-M and other similar modern platforms.

+ Proficiency in standard software development languages and tools such as Python, C++, C#, Java, SQL, Visual Studio, Snowflake, Talend, Visio, PowerBI, relational database management systems (such as Oracle, MS SQL Server, PostgreSQL).

OUC offers a very competitive compensation and benefits package. Our Total Rewards package includes, to cite a few:

+ Competitive compensation

+ Low-cost medical, dental, and vision benefits and paid life insurance premiums with no probationary period. Retirement benefits include a cash balance account with employer matching along with a health reimbursement account

+ Paid vacation, holidays, and sick time

+ Paid parental leave

+ Educational and Professional assistance programs; Paid Memberships in Professional Associations

+ Access to workout facilities at each location

+ Paid Conference and Training Opportunities

+ Free downtown parking

+ Hybrid work schedule

Click here to view our Benefits Summary. (https://www.ouc.com/docs/human-resources-documents/benefits\_summary.pdf)

**Salary Range:** $104,000.00 to $130,000.00 annually commensurate with experience.

**Location:** 6003 Pershing Ave., Orlando, FL 32822

Job Purpose:

Serves as an expert level resource for on-premises and/or cloud-based applications such as Python, PowerBI, Snowflake, SQL, Control-M and other similar modern platforms leveraging structured system methodologies and advanced information technology to ensure optimal system performance. Serves as Subject Matter Expert (SME) for system health, maintenance, and continuous improvements of corporate applications. Develops and implements programmatic solutions ensuring adherence with business requirements and alignment with best practices. Designs, tests, and validates solutions with defined test plans to ensure accuracy and effectiveness. Coordinates the implementation of new systems, system modifications, and problem resolutions. Collaborates with internal IT teams and external vendor representatives to deliver fully integrated solutions to end-users.

Primary Functions:

+ Develop complex to highly complex code to support various solution requirements and designs for assigned on-premises and/or cloud-based applications and data sources for planning, designing, implementing, and maintaining technology solutions used by a wide range of stakeholders.

+ Investigate and analyze how the system processed transactions to determine if system functionality is configured correctly and provides accurate results;

+ Provide complex to highly complex application analysis for Information Technology and client base, and serve as a contact for IT business application analysts requiring in-depth understanding/results;

+ Evaluate business impact of errors and provide recommendations for solution through collaboration with analysts and business experts;

+ Evaluate existing and new system functionality; determine any requirements not met by the specific system and develop action plans to correct deficiencies. This includes system nonfunctional requirements for data management;

+ Define and document system scope, current logical view, general technical requirements and proposed logical view using structured design and analysis techniques;

+ Provide comprehensive data queries and results to analyze the system output and functional execution of key transactions;

+ Monitor and track system updates/access to ensure successful auditing;

+ Ensure appropriate monitoring, logging, and audits are in place to trace events, review results and make recommendations;

+ Review application interfaces to determine if functionality is configured correctly and provide accurate results;

+ Work on complex to highly complex business scenarios to ensure system processes transactions accurately;

+ Implement on-premises and/or cloud-based designs and solutions leveraging Python, PowerBI, Snowflake, SQL, Control-M and other similar modern platforms;

+ Guide and participate with the Business Application Analysts in understanding business needs and assist translation for detailed technical and program specifications, if applicable;

+ Prepare necessary end-user reports, extracts, and queries; Develop and maintain documentation regarding system functionality, performance benchmarks, and system integration;

+ Document all issues and their resolutions;

+ Develop, research and evaluate feasibility of alternatives to meet project/solution objectives and recommend optimal alternative;

+ Design and execute test plans for unit and integration tests;

+ Participate on technology services and vendor application upgrades, patching, testing, as well as production implementations;

+ Work on small, medium, and large scale projects as needed by OUC;

+ Follow triage, development life cycle processes, change management, and other IT methodologies in place to promote new/revised objects to all environments;

+ Develop documentation for new system functions and/or updates to existing system documentation;

+ Contribute to system architecture and design, ensuring compliance with design principles and scalability requirements;

+ Stay up-to-date with emerging technologies, tools, and best practices in software development;

+ Collaborate with technical teams to identify solutions and lead design sessions with functional users, business analysts, and developers to define and document technical interface requirements;

+ Analyze, diagnose and troubleshoot complex system issues to identify root-cause and implement solutions to minimize or prevent occurrences;

+ Contact software vendors to report, track, and resolve problems with their software products;

+ Research, evaluate and correct system malfunctions. Work with Business Analysts to resolve application issues in a timely manner;

+ Work independently and take initiative by developing recommendations for system and/or solution improvements;

+ Provide guidance, coaching, and/or mentor junior employees as appropriate;

+ Plan, document, and test disaster recovery procedures;

+ Utilize version control systems for collaboration and code management for planning, designing, implementing, and maintaining technology solutions used by a wide range of stakeholders;

+ Handle scheduled on-call rotation responsibilities;

+ Effectively communicate technical information with non-IT personnel;

+ Perform other duties as assigned.

Technical Requirements:

+ Working knowledge of many, but not limited to the following as they relate to planning, designing, implementing, and maintaining technology solutions used by a wide range of stakeholders :

+ Software Applications and Languages/Scripting such as Python, PowerBI, Snowflake, SQL, Control-M and other similar modern platforms;

+ Developing structured test scenarios, test cases, and perform accurate testing with documented results;

+ Developing complex structured queries for accurate results;

+ Best practices for presenting system output to end-users;

+ Preparing system technical documentation;

+ Data analysis;

+ Administration and troubleshooting of operating systems (OS) to include Windows Servers, Linux, and HP-Unix;

+ System performance metrics and benchmarking techniques;

+ Researching and introducing new versions of Operating Systems, Relational Databases (Oracle and SQL Server), and applications such as Python, PowerBI, Snowflake, SQL, Control-M and other similar modern platforms;

+ Network architectures, relational databases (Oracle and SQL Server) and client/server environment;

+ Web Services such as SOAP;

+ Release management and code deployments;

+ Quality assurance methodologies;

+ Data warehouse and data-mart techniques desired.

+ Familiarity with all, but not limited to the following as they relate to planning, designing, implementing, and maintaining technology solutions used by a wide range of stakeholders:

+ Some of the following programming languages: Python and SQL;

+ System performance metrics and benchmarking techniques;

+ Software Version Control (SVN);

+ Equipment (i.e. Virtual servers, SAN storage);

+ Network routing, firewalls, and load balancers;

+ Related industry, organizational and departmental regulatory guidelines, best practices, and procedures.

+ Ability to:

+ Research and introduce new versions of operating systems, databases, and application software;

+ Take on new system assignments;

+ Learn, obtain structured and ad hoc training on vendor products/releases;

+ Integrate/share/publish timely data to third party systems needing access to application data (real-time, or batch);

+ Adapt to changing technology by acquiring new skills (i.e. by attending continuing educational courses/trainings);

+ Create logical and physical data models and design user interfaces;

+ Lead technical design through application system testing;

+ Write optimized, well-structured SQL statements;

+ Develop complex structured queries for accurate results;

+ Develop structured test scenarios, test cases, and perform accurate testing with documented results;

+ Use productivity tools for analysis, data behavior, and data mining;

+ Work independently on tasks and projects of varying complexity;

+ Provide training and guidance on technologies to others;

+ Take the lead on technical projects;

+ Use Microsoft Office Suite (Word, Excel, Outlook, etc.) and standard office equipment (telephone, computer, copier, etc.);

+ Manage time effectively and meet deadlines;

+ Make presentations to both technical and non-technical audiences.

Education/ Certification/ Years of Experience Requirements:

+ Bachelor’s degree in Information Technology, Computer Science, Computer Engineering, Management Information Systems (MIS) from an accredited college or university, other disciplines considered. In lieu of a degree, equivalent combination of education, certifications and experience may be substitutable.

+ Minimum of seven (7) years of experience involving software development and employing formal software development methodologies to include:

+ Minimum of three (3) years of in-depth core applications work experience in applying software engineering best practices to plan, design, implement and maintain technology solutions, utilizing tools such as Python, PowerBI, Snowflake, SQL, Control-M and other similar modern platforms.

Working Conditions:

This job is absent of disagreeable working conditions. This job is performed in an office work environment.

Physical Requirements:

This job requires sitting, reading, and detailed inspection/editing, typing, and writing. This job may require standing, walking, reaching overhead, bending/stooping, and lifting up to 10 pounds.

_OUC–The Reliable One is an Equal Opportunity Employer who is committed through responsible management policies to recruit, hire, promote, train, transfer, compensate, and administer all other personnel actions without regard to race, color, ethnicity, national origin, age, religion, disability, marital status, gender, sexual orientation, gender identity or expression, genetic information and any other factor prohibited under applicable federal, state, and local civil rights laws, rules, and regulations_ .