Laveer Engineering · 13 hours ago
IT Software Engineer Analyst
Norwell, MA
Contract
Onsite
Mid Level
$45/hr - $50/hrLaveer Engineering is seeking an IT Software Engineer Analyst to focus on database management and auditing. The role involves maintaining relational databases, developing SQL queries, and collaborating with internal users to ensure data accuracy and reliability.
Industrial EngineeringMechanical EngineeringService Industry
Responsibilities
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
Qualification
Required
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
Preferred
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
Benefits
Comprehensive Health and Income Protection Benefits
401(k) Savings Plan
Paid Vacations for Qualifying Positions
Company
Laveer Engineering
Laveer Engineering provides custom and off the shelf equipment solutions to industry.
Founded in 2013
11-50 employees
Funding
Current Stage
Early StageTotal Funding
unknown2021-06-01Acquired
Company data provided by crunchbase