Business Services Tech-Level 1 Associate (0 5 Years)

Job Summary

We are seeking a detail-oriented Database Analyst / Data Quality & Requirements Specialist to support database management data quality initiatives reporting and business requirements gathering. The ideal candidate will possess strong SQL and database management skills a business analyst mindset and the ability to work directly with stakeholders to ensure data accuracy integrity and usability across systems.

This role combines database administration data analysis reporting and requirements gathering while supporting process improvements data governance and application integrations.

Key Responsibilities

• Maintain update and audit relational databases to ensure accuracy consistency and traceability.
• Write optimize and troubleshoot SQL queries including complex joins aggregations and validation checks.
• Perform data quality reviews identify discrepancies conduct root cause analysis and implement corrective actions.
• Develop and maintain Excel-based audit and reporting tools using Pivot Tables XLOOKUP/VLOOKUP data validation and Power Query.
• Partner with business stakeholders to gather analyze document and validate business requirements.
• Translate business requirements into data definitions business rules technical specifications and reporting solutions.
• Create and maintain documentation including field mappings data dictionaries audit reports process flows and change logs.
• Support data governance initiatives security controls and compliance requirements.
• Assist with application integrations API data exchanges workflow automation and reporting enhancements.
• Participate in Agile development processes sprint planning testing and scrum ceremonies.
• Support troubleshooting maintenance and enhancement of existing applications and databases.
• Analyze business processes and recommend improvements to increase efficiency accuracy and data reliability.

Required Qualifications

• Bachelors degree in Computer Science Information Systems Business Administration Data Analytics or a related field.
• 0 5 years of experience in software development database administration data analysis business analysis or related technical roles.
• Strong SQL experience preferably PostgreSQL.
• Solid understanding of relational database concepts data modeling keys constraints normalization and data integrity principles.
• Advanced Microsoft Excel skills including Pivot Tables XLOOKUP/VLOOKUP formulas filters and data validation.
• Experience performing data audits reconciliation and documentation of findings and remediation efforts.
• Ability to independently gather requirements clarify ambiguous requests and validate business needs.
• Strong analytical problem-solving and critical-thinking skills.
• Excellent written and verbal communication skills.

Technical Skills

• SQL and PostgreSQL
• Microsoft Excel (Advanced)
• Data Analysis and Data Quality Management
• Power BI Dashboard Development
• API Integrations
• Python
• AWS Cloud Technologies
• Database Auditing and Validation
• Reporting and Analytics
• Agile/Scrum Methodologies

Preferred Qualifications

• Experience with Power BI development and reporting.
• Familiarity with AWS services including RDS S3 Athena Glue IAM Lambda SNS and SQS.
• Experience supporting engineering utility manufacturing or asset-intensive environments.
• Familiarity with AVEVA PI System PI Vision or time-series data platforms.
• Experience with IBM Maximo or Enterprise Asset Management (EAM) systems.
• Experience with data governance metadata management and compliance controls.
• Knowledge of DevOps practices CI/CD pipelines cloud automation and microservices architecture.
• Familiarity with Quest tools such as Toad or similar database administration tools.
• Certifications in AWS Microsoft Power BI Agile SAFe PMP or related technologies are preferred.

Responsibilities

• Ensure data integrity quality and consistency across enterprise systems.
• Support business users by providing accurate reporting analytics and data insights.
• Develop and maintain technical documentation audit records and data mappings.
• Collaborate with technical and business teams to implement data-driven solutions.
• Participate in software development testing integration and deployment activities as required.
• Identify process improvement opportunities and recommend automation solutions where appropriate.