Who we are:
Tria Federal delivers digital services and technology solutions that support the health and safety of veterans, service members and civilians. For two decades, federal agencies have relied on Tria companies to advance their critical missions and modernize their systems, so that they can uphold their commitment to the American people. Today, we are pushing the boundaries of possibility through partnerships and investments in artificial intelligence and emerging technologies, developing solutions for the biggest challenges that government will face tomorrow.
We are proud to employ and support military veterans who bring mission-first mindset, technical expertise, and leadership qualities that strengthen our work. Veterans, transitioning service members, and military spouses are strongly encouraged to apply.
Job Description: 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.
Key Responsibilities
Data Engineering
- 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.
BI Reporting & Analytics
- 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.
- Ability to configure and manage Row-Level Security (RLS) and apply it across datasets, analyses, and dashboards.
- Ability to securely embed QuickSight dashboards into web portals/applications with integrated application-level security and RLS-based access control.
- Ability to create and manage QuickSight Topics and Spaces to enable natural language querying and self-service analytics for business users.
- Ability to provide AI-powered insights and dashboard interactions through Amazon QuickSight Q/Generative BI capabilities.
- Develop cloud-native data solutions leveraging AWS services.
- Work with AWS services such as:
- Amazon S3
- AWS Glue
- Amazon Redshift
- Amazon Athena
- AWS Lambda
- Amazon RDS
- AWS Quick Sight
- Implement data security, access controls, and compliance requirements within AWS.
Collaboration & Support
- 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.
Required Qualifications
- 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.
Preferred Qualifications
- 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.
Technical Skills
Required
- AWS QuickSight
- SQL
- Python
- AWS Glue
- Amazon Redshift
- Amazon S3
- Amazon Athena
- ETL/ELT Development
- Data Modeling
- Data Warehousing
Preferred
- Apache Spark
- Lambda
- Airflow
- Terraform
- Tableau or Power BI
- Snowflake
Key Competencies
- Strong analytical and problem-solving skills.
- Excellent communication and stakeholder engagement abilities.
- Ability to translate business requirements into technical solutions.
- Attention to detail and commitment to data quality.
- Strong collaboration and teamwork skills.
Nice-to-Have Experience
- 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.
Target Experience Level: Junior-Mid (5–10+ years)
Primary Focus: Data Engineering, AWS Data Platform, BI Reporting, AWS Quick Sight Dashboard Development.
Why Tria?
What defines the Tria brand is more than just our dedication to excellence in our craft; it’s our incredible team of dedicated, talented, and passionate people that make Tria so exceptional. As people powering possible, we are all partners in our team’s shared success.
As a company that cares about people, we seek to cultivate a culture in which all can thrive personally and professionally. We offer a top-tier benefits package to invest in your physical, mental, and financial health and wellness so that you can be your best self - at work and in life. At Tria, we are growth-minded, entrepreneurial in spirit, and committed to fostering a culture of inclusion and opportunity for all. Whatever your background, your role, your department, or stage in your professional journey, here you will have opportunities to learn new skills, seize new challenges, and advance your career as we grow.
California Consumer Privacy Act (CCPA)
We are committed to protecting your privacy. As part of our compliance with the California Consumer Privacy Act (CCPA), we want to inform you about how we collect, use, and protect your personal information during the job application process. For more details, please review https://www.oag.ca.gov/privacy/ccpa.
Similar Jobs
.png){kind=logo}
What you need to know about the Chicago Tech Scene
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
