Database Modernization & Controls Automation Engineer - TX, AZ, NC

Database Modernization & Controls Automation Engineer

The Software Engineer 3 will support moderately complex software engineering initiatives with a primary focus on database/application modernization, technology controls automation, Power BI reporting, and data platform enhancements. This role is part of a major modernization effort involving data migration, schema redesign, ETL refactoring, and the operationalization of data controls across Oracle, SQL Server, and cloud/hybrid platforms.

The engineer will evaluate moderately complex data and compliance challenges, recommend solutions, validate controls, and help develop automated workflows to ensure operational resilience, regulatory alignment, and data integrity. This position requires strong technical depth, experience in large-scale enterprise systems, and the ability to collaborate across engineering, risk, and data teams.

Day-to-Day Responsibilities:

• Technology Controls Automation
• Design & implement automated control checks embedded in applications, databases, and reports
• Build monitoring, validation, and evidence-generation functions to support audits & compliance
• Integrate automated controls into CI/CD pipelines and operational dashboards
• Database Migration, Development & Modernization
• Support or lead database/application migration initiatives (on-prem → cloud/hybrid)
• Refactor schemas, stored procedures, functions, and ETL/ELT workflows
• Perform data validation, reconciliation, and parity checks for migration cutovers
• Conduct performance tuning and post-migration stabilization
• Work with Oracle and SQL Server across development, QA, and production
• Analytics & Reporting Enablement
• Create and maintain Power BI dashboards used for controls effectiveness, operational metrics, and modernization tracking
• Develop analytical data models to support insights and decision-making
• Translate technical and risk requirements into clear dashboards and KPIs
• AI & Machine Learning Enablement (Nice-to-Have)
• Operationalize ML outputs: feature tables, scoring workflows, governed data products
• Integrate Python/R models or cloud ML services into pipelines
• Build predictive dashboards such as anomaly detection or forecasting

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at employeeservices@apexsystems.com or 844-463-6178.