Database and Dashboard Developer
Washington DC, WA - USA
Job Summary
The position is described below. If you want to apply click the Apply Now button at the top or bottom of this page. After you click Apply Now and complete your application youll be invited to create a profile which will let you see your application status and any communications. If you already have a profile with us you can log in to check status.
If you have a disability and need assistance with the application you can request a reasonable accommodation. Send an email to Accessibility (accommodation requests only; other inquiries wont receive a response).
Regular or Temporary:
RegularLanguage Fluency: English (Required)
Work Shift:
1st shift (United States of America)Please review the following job description:
We are seeking a versatile and highly skilled Database and Dashboard Developer with strong expertise inextract cloud asset data RDBMS (ex: Postgres Redshift) Python and AWS to support enterprise data engineering analytics and reporting initiatives. This role combines responsibilities across database development data transformation and business intelligence/dashboard creation requiring a hands-on developer who thrives in a dynamic data driven environment.
The ideal candidate will design and optimize relational databases build scalable data transformation and develop intuitive dashboards that transform raw data into actionable insights. This position plays a critical role in ensuring data quality accessibility performance and usability across the organization.
This role will focus on building modern cloud infrastructure automating deployments enhancing security posture and ensuring seamless collaboration across engineering teams.
***For this opportunity Truist will not sponsor an applicant for work visa status or employment authorization nor will we offer any immigration-related support for this position (including but not limited to H-1B F-1 OPT F-1 STEM OPT F-1 CPT J-1 TN-1 or TN-2 E-3 O-1 or future sponsorship for U.S. lawful permanent residence status.)***
The annual base salary for this position is $165000 -$180000
ESSENTIAL DUTIES AND RESPONSIBILITIES
Following is a summary of the essential functions for this job. Other duties may be performed both major and minor which are not mentioned below. Specific activities may change from time to time.
Design develop and optimize database schemas tables stored procedures and highperformance SQL queries.
Develop automated Python scripts DB Tool 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 crossfunctional teams to analyze requirements and translate business needs into scalable data solutions.
Architect and maintain AWSbased 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 CICD pipeline (GITLAB)
Required Technical Skills
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 opensource data integration platform) or 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 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.
Strong analytical and problem-solving capabilities.
Ability to collaborate effectively across diverse teams.
Preferred Qualifications:
AWS certifications (Solutions Architect DevOps Engineer etc.).
WIZ cloud security CSPM tool
General Description of Available Benefits for Eligible Employees of Truist Financial Corporation: 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 of Truist offering the offers medical dental vision life insurance disability accidental death and dismemberment tax-preferred savings accounts and a 401k plan to teammates. Teammates also receive no less than 10 days of vacation (prorated based on date of hire and by 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 on Truists generous benefit plans please visit our Benefits site. Depending on the position and division this job may also be eligible for Truists 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.
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 other classification protected by law. Truist is a Drug Free Workplace.
Required Experience:
IC
About Company
Your journey to better banking starts with Truist. Checking and savings accounts, credit cards, mortgages, small business, commercial banking, and more.