IT Software Engineer Analyst

We're looking for a database-focused analyst with SQL (PostgreSQL) experience reviewing code to find and address potential issues and defects. You'll manage, and audit databases, partner with your team to gather requirements, and help ensure our data is accurate, reliable, and usable., * Maintain, update, and audit relational databases (PostgreSQL), ensuring accuracy, consistency, and traceability.

• Write and improve SQL queries, including multi-table joins, aggregations, and validation checks.
• Perform data quality checks, reconcile discrepancies, and document causes and fixes.
• Build Excel-based audit tools (pivots, lookups, Power Query as applicable) for reporting and verification.
• Partner with internal users to gather requirements, challenge unclear requests, and translate our needs into data definitions and logic.
• Create documentation: table definitions, field mappings, audit results, and change logs.
• Support process improvements and controls around data updates, permissions, and governance.

• SQL experience, including PostgreSQL (or equivalent with an ability to ramp quickly).
• Experience with relational database fundamentals (keys, constraints, normalization concepts, data integrity).
• Demonstrated experience updating, and auditing datasets/databases.
• Advanced Excel skills (filters, pivot tables, XLOOKUP/VLOOKUP, data validation; Power Query).
• Demonstrated experience performing data audits and documenting findings, remediation steps, and outcomes (repeatable and traceable work).
• Comfortable managing ambiguous requests and independently questioning partners to gather requirements and confirm data definitions before building.
• Can explain logic and assumptions to all kinds of partners.
• Show Experience approaching a problem from different angles, analyzing pros and cons of different solutions, ask "why," identifies risks and edge cases, and proposes better approaches rather than implementing blindly.
• Experience investigating inconsistencies, ask probing questions, and validate assumptions., * Mechanical or engineering background/familiarity (or experience supporting engineering/asset-heavy environments).
• Familiarity with AVEVA PI (PI System / PI Data Archive / PI Vision) or time-series data concepts.
• Familiarity with IBM Maximo (asset management / work orders / equipment hierarchies).
• Familiarity with AWS (RDS, S3, Athena/Glue, IAM concepts, basic cloud data patterns).
• Experience being a BA: independently gathering requirements, defining acceptance criteria, mapping data sources to outputs.
• Familiarity with tools like Quest (e.g., Toad) or data access/auditing tools.

WECTEC Staffing Services offers competitive pay to all of our employees. Additionally, most positions qualify for benefits including the following:

• Comprehensive Health and Income Protection Benefits
• 401(k) Savings Plan
• Paid Vacations for Qualifying Positions

We are committed to transparency and equity in all our people practices. We estimate the base salary range for this position, which is dependent upon review of qualifications, to be $45/hour to $50/hour.

WECTEC Staffing Services delivers customer-focused solutions, offering everything from high-volume, cost-effective staffing to specialized niche roles, while maintaining the best service. Our employees bring expertise across technical and corporate functions, supporting international contracts in over five countries. We invite you to explore opportunities within our distinguished global talent network.