BI Reporting & AWS Quick Sight

Tria Federal

About The Position

We are seeking a highly skilled Data Engineer with strong Business Intelligence (BI) reporting experience to design, build, and maintain scalable data solutions that support enterprise analytics and reporting needs. The ideal candidate will have expertise in data engineering, data warehousing, ETL/ELT development, and dashboard creation using AWS Quick Sight. This role will collaborate closely with business stakeholders, analysts, and technical teams to transform data into actionable insights.

Requirements

Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or related field.
5+ years of experience in Data Engineering, Data Warehousing, or BI Development.
Hands-on experience building and maintaining dashboards using AWS QuickSight.
Strong experience with SQL and relational databases.
Experience developing ETL/ELT pipelines using AWS Glue, Python, Spark, or similar technologies.
Strong understanding of dimensional modeling, star/snowflake schemas, and data warehousing concepts.
Experience with AWS cloud services and data analytics architecture.
Proficiency in Python and/or other scripting languages.
Experience with Git and CI/CD deployment practices.

Nice To Haves

AWS Certifications (e.g., AWS Certified Data Engineer, AWS Certified Solutions Architect, AWS Certified Data Analytics).
Experience with Redshift, Athena, and large-scale cloud data platforms.
Knowledge of data governance, data quality frameworks, and metadata management.
Experience working in Agile/Scrum environments.
Familiarity with healthcare, federal, financial, or regulated industry reporting environments.
Federal government or healthcare data environments.
Building executive dashboards and KPI scorecards.
Data migration and modernization initiatives.
Real-time or near-real-time analytics solutions.

Responsibilities

Design, develop, and maintain scalable data pipelines and ETL/ELT processes.
Build and optimize data models, data lakes, and data warehouses in AWS environments.
Integrate data from multiple internal and external sources while ensuring data quality and consistency.
Implement data governance, validation, monitoring, and security best practices.
Optimize database performance, query execution, and data processing workflows.
Develop, maintain, and enhance interactive dashboards and reports using AWS QuickSight.
Translate business requirements into meaningful KPIs, metrics, and visualizations.
Design data models and datasets optimized for reporting and analytics.
Collaborate with business users to gather reporting requirements and provide actionable insights.
Create self-service reporting solutions for business stakeholders.
Configure and manage Row-Level Security (RLS) and apply it across datasets, analyses, and dashboards.
Securely embed QuickSight dashboards into web portals/applications with integrated application-level security and RLS-based access control.
Create and manage QuickSight Topics and Spaces to enable natural language querying and self-service analytics for business users.
Provide AI-powered insights and dashboard interactions through Amazon QuickSight Q/Generative BI capabilities.
Develop cloud-native data solutions leveraging AWS services.
Implement data security, access controls, and compliance requirements within AWS.
Partner with business analysts, data scientists, and application teams to deliver analytics solutions.
Provide technical guidance on reporting architecture and dashboard best practices.
Troubleshoot data issues and support production reporting environments.
Document data pipelines, reporting solutions, and technical processes.