Lead Data Systems Engineer- Database and Dashboard Developer

Salary range: $110,000-160,000 per annum. Essential Duties and Responsibilities Design, develop, and optimize database schemas, tables, stored procedures, and high‑performance SQL queries. Develop automated Python scripts and database tools for data extraction, transformation, cleansing, and orchestration. Design and deliver interactive dashboards and visualizations (ex: Grafana). Implement data validation, error handling, logging, and performance monitoring. Ensure data quality, integrity, and security in alignment with organizational and compliance standards. Collaborate with cross‑functional teams to analyze requirements and translate business needs into scalable data solutions. Architect and maintain AWS‑based data solutions, such as S3, Lambda, Glue, Redshift, RDS, Athena, or Step Functions. Document data flows, architecture, processes, and technical specifications. Manage AWS services and ensure secure, scalable cloud environments. Develop Infrastructure as Code using Terraform or CloudFormation, deploy through a CI/CD pipeline (GITLAB). Required Technical Skills Bachelor's Degree in Computer Science, CIS, or related field Five to seven years of experience in software development or a related field Five to seven years of experience in database technologies Five to seven years of experience working on projects involving the implementation of solutions applying development life cycles (SDLC) Preferred Qualifications Strong experience with SQL and relational databases (SQL Server, Oracle, PostgreSQL, or MySQL). Proven ability to build and maintain data integration workflows. Hands‑on expertise in Python for automation, data manipulation, and API integration. Experience with CloudQuery (the open‑source data integration platform) or a similar tool to extract cloud asset data (AWS, SaaS‑Security tool WIZ) into databases for security, compliance, and analytics. Practical experience with AWS cloud services for data engineering workloads. Proficiency in designing dashboards and data visualizations using enterprise BI tools. Understanding of data warehousing concepts, dimensional modeling, and best practices. Ability to troubleshoot performance issues across databases, pipelines, and BI layers. Strong analytical, communication, and problem‑solving skills. Infrastructure as Code with Terraform or CloudFormation. Experience with cloud security tools (e.g., Wiz). Excellent communication and interpersonal skills. AWS certifications (Solutions Architect, DevOps Engineer, etc.). WIZ cloud security CSPM tool. Benefits All regular teammates (not temporary or contingent workers) working 20 hours or more per week are eligible for benefits, though eligibility for specific benefits may be determined by the division offering the position. Truist offers medical, dental, vision, life insurance, disability, accidental death and dismemberment, tax‑preferred savings accounts, and a 401(k) plan to teammates. Teammates also receive no less than 10 days of vacation (prorated based on date of hire and on full‑time or part‑time status) during their first year of employment, along with 10 sick days (also prorated), and paid holidays. For more details, please visit our Benefits site. Depending on the position and division, this job may also be eligible for Truist’s defined benefit pension plan, restricted stock units, and/or a deferred compensation plan. As you advance through the hiring process, you will also learn more about the specific benefits available for any non‑temporary position for which you apply, based on full‑time or part‑time status, position, and division of work. Equal Opportunity Employer Truist is an Equal Opportunity Employer that does not discriminate on the basis of race, gender, color, religion, citizenship or national origin, age, sexual orientation, gender identity, disability, veteran status, or any other classification protected by law. Truist is a Drug Free Workplace. EEO is the Law. IER Right to Work. E-Verify. #J-18808-Ljbffr Truist