> Markdown version of [/jobs/ext/2069462-programmer-analyst-iii](https://www.wearedevelopers.com/jobs/ext/2069462-programmer-analyst-iii). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Programmer Analyst III - **Company:** Property Insurance Company Of America - **Location:** League City, United States - **Experience:** Expert - **Salary:** $138,237.0 - $181,600.0 - **Contract:** Permanent contract - **Skills:** Amazon Web Services, Automation of Tests, Microsoft Azure, Cloud Storage, Software Documentation, Databases, Computer Engineering, Data as a Services, Data Conversion, Extract Transform Load (ETL), Data Transformation, Data Mining, Data Systems, Dimensional Modeling, Python (Programming Language), Performance Tuning, Query Optimization, Software Engineering, Software Requirements Analysis, Data Streaming, System Testing, Transaction Processing (Computing), Scripting, Data Ingestion, Sql Optimization, Indexer, Star Schema, Serverless Computing - **Published:** August 15, 2026 - **Apply:** https://www.dice.com/job-detail/226f7584-cc06-4140-b6b6-6a8edd37e8fd ## About the Role Education requirements: Bachelor's degree in Computer Engineering or closely related field Experience requirements: 6 years of experience in the job offered or related occupation. Special Skills or Other Requirements ## Description * Understands business requirements and can relate these to the supporting system requirements, producing technical specifications for the work to be done. * Codes readable, reliable, and maintainable programs in any of a variety of languages on multiple platforms necessary to support the team's assigned systems. * Identify and rectify errors in coding quickly, showing initiative and a proactive approach. * Prepare the initial problem definition, define the project scope and objectives, determine the specific requirements to be satisfied, and design system solutions for all levels of service requests. * Lead and/or provide guidance to junior team members. * Perform unit and system testing using test plans and scripts approved by the business. * Review test results with the business and makes the necessary adjustments to the deliverable. * Obtain an approval and submit proper documentation for migration to the locked-up production environment. * Record the time and status to the appropriate projects or support activity for billing. * Respond promptly to production issues by serving an on-call rotation for the 24-hour support of the team's systems, making decisions that will positively influence the up-time and full recovery of the team's systems from outages. * Provide analytical support for the ongoing maintenance of developed systems. * Understand and follow current corporate project management standards. * Communicate effectively with technical and non-technical teams; understand audience and adapts accordingly. * Prepare detailed definitions of proposed solutions which includes data base design, screen and report definitions, data flow, detailed transaction processing requirements, definition of system interfaces, detailed program specifications, and designing system test cases. * Develop estimates of time and cost for the development and on-going operation of proposed service requests and prepares analysis to show economic payout for the system. * Document conversion approach, task sequences, and dependencies for implementation plans. * Design and develop manual procedures and user documentation and provide user training in the use of the developed system. * Communicate fluently with the business representatives., * Utilize advanced SQL for data extraction, transformation, performance tuning, joins, indexing, and query optimization across relational database systems. * Design, develop, and maintain ETL pipelines to ingest, transform, validate, and load data from heterogeneous sources using ETL tools, cloud-native services, and scripting frameworks. * Develop Python-based workflows and automation scripts for data ingestion, data transformation, orchestration, error handling, and integration with cloud and database systems. * Implement data solutions on cloud platforms such as Azure or AWS, leveraging services including cloud storage, compute, orchestration, serverless components, and managed data services. * Apply dimensional modeling principles, including star schema and snowflake schema design, to build fact and dimension models supporting business intelligence and analytical reporting. * Deliver end-to-end data solutions encompassing requirements gathering, design, development, testing, deployment, performance tuning, and production support. ## Related Videos - [Optimizing Discovery: PostgreSQL's Role in Transforming GetYourGuide's Search](https://www.wearedevelopers.com/videos/1647-optimizing-discovery-postgresql-s-role-in-transforming-getyourguide-s-search) - [JavaScript? No. Java Scripts! - Scripting with Java](https://www.wearedevelopers.com/videos/2094-javascript-no-java-scripts-scripting-with-java) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Building with IBM Bob](https://www.wearedevelopers.com/videos/100275-building-with-ibm-bob) - [Dynamic Entities in .NET: Building Low-Code Systems on Top of Entity Framework Core](https://www.wearedevelopers.com/videos/100218-dynamic-entities-in-net-building-low-code-systems-on-top-of-entity-framework-core) - [30 powerful AWS hacks in just 30 minutes: Boost your developer productivity](https://www.wearedevelopers.com/videos/1624-30-powerful-aws-hacks-in-just-30-minutes-boost-your-developer-productivity) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Best Paying Jobs in Technology](https://www.wearedevelopers.com/magazine/256-best-paying-jobs-in-technology) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [The 12 Best Jobs for Software Engineers](https://www.wearedevelopers.com/magazine/401-the-12-best-jobs-for-software-engineers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)