Tria Federal, founded in 2023, is a technology and advisory services firm specializing in digital transformation solutions for the federal sector. Guided by its commitment to servi
BI Reporting & AWS Quick Sight
Location
United States
Posted
5 days ago
Salary
0
Seniority
Mid Level
No structured requirement data.
Job Description
BI Reporting & AWS Quick Sight
Tria Federal
Role 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 QuickSight. 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, and AWS QuickSight. - 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. 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. Requirements - 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 QuickSight Dashboard Development. Benefits 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.
Related Guides
Related Categories
Related Job Pages
More Business Intelligence Developer Jobs
Power BI Implementation Consultant
VigilWe’re a tech consultancy, expert in software engineering and cloud transformation.
• Managing the end-to-end rollout of new Power BI dashboards to business end users across Sales and Finance functions. • Coordinating and overseeing user acceptance testing, ensuring dashboards are validated before full deployment. • Supporting users in transitioning from static legacy reports (IBM Cognos) to interactive Power BI dashboards, driving adoption and reducing friction. • Capturing issues raised by end users, prioritising resolution with the development team, and tracking outcomes through to completion. • Identifying unmet reporting and information needs within the business and feeding structured requirements back to the development team. • Owning communication between end users and IT, ensuring feedback loops are clear, consistent, and followed through. • Engaging stakeholders at all levels, from individual contributors in sales to senior finance leadership, with confidence and clarity. • Conducting training and enablement sessions to accelerate user adoption and reduce dependency on legacy tooling.
Business Intelligence Engineer
Auto-Owners InsuranceHeadquartered in Lansing, Michigan, Auto-Owners Insurance Group was founded in 1916 and is now one of the largest insurers in the United States, providing over
Title: Business Intelligence Engineer Location: Lansing United States Job Description: time type Full time job requisition id R_13795 A career at Auto-Owners is challenging and rewarding. Our group of caring associates create financial security by helping individuals and businesses make a new start when a loss occurs. Job Description We offer a merit-based work-from-home program based on job responsibilities. After initial training in-person, this specific role could have the flexibility to work from home up to 3 days per week. Auto-Owners Insurance, a top-rated insurance carrier, is seeking a motivated entry-level Business Intelligence Engineer to join our team. The position is responsible for creating data processes, assets, and solutions to help us accomplish our growth and profitability objectives and requires the person to: - Create data extracts and infrastructure to support the Business Intelligence Reporting teams. - Build, maintain, and document code used to transform, aggregate, and present data. - Learn and apply the tools and techniques employed in designing and implementing data engineering solutions. - Develop an understanding of our data sources and data flows. - Effectively communicate with other employees through verbal and written means. - Participate in both formal and informal training sessions. Desired Skills & Experience - Bachelor’s degree or higher in Mathematics, Statistics, Actuarial Science, Computer Science, or another related technical field is required - High aptitude for mathematics and statistics - Actuarial studies and exams are considered but not required - Experience with Microsoft SQL, Python or other programming/database/statistical languages - Proficient in Microsoft Excel - Above average communication skills (written and verbal) - Ability to adapt to constant change and innovation Benefits Auto-Owners offers a wide range of career opportunities, and we are seeking talent that will help us continue our long tradition of success. We offer a friendly work environment, structured training program, employee mentoring and an excellent compensation/benefits package. Along with a competitive base salary, matched 401(k), fully-funded pension plan (once vested), and bonus programs, Auto-Owners also provides generous paid time off including holidays, vacation days, personal time, and sick leave. If you're looking to do rewarding work alongside great people, Auto-Owners is the place for you! Equal Employment Opportunity Auto-Owners Insurance is an equal opportunity employer. The Company hires, transfers, and promotes on the basis of ability, without consideration of disability, age, sex, race, color, religion, height, weight, marital status, sexual orientation, gender identity or national origin, or any factor contrary to federal, state or local law. *Please note that the ability to work in the U.S. without current or future sponsorship is a requirement. #LI-DNI #IN-DNI
• Build and own the central performance dashboard across all GRVT divisions (Trading, Marketing, BD, Product, Operations). • Create and maintain KPI frameworks that link every department’s goals to company revenue and growth targets. • Generate weekly and monthly CEO reports with clear narratives — what’s working, what’s not, and where to allocate resources. • Analyze company performance and identify growth levers. • Conduct deep dives into metrics like P&L, conversion funnels, and user retention. • Develop data-backed forecasts and scenarios (volume, revenue, user growth, liquidity). • Turn findings into strategic recommendations that shape company direction. • Define and track KPIs for marketing efficiency, BD ROI, and partner venue performance. • Measure impact of every campaign, BD partnership, and feature launch — and recommend optimization levers. • Build ROI models for decision-making on partnerships, vendors, and budgets. • Set up the data foundation for the company, pipelines, databases, dashboards, and analytics tools (e.g., BigQuery, Looker, Metabase, Mixpanel). • Build and maintain SQL queries and data models directly, minimizing dependency on engineers. • Design self-serve data systems for teams to access accurate and unified data.
IT Analyst Sr, BI Developer -Clinical Analytics
UVA HealthThe University of Virginia is an equal opportunity employer. All interested persons are encouraged to apply, including veterans and individuals with disabilities.
Role Description Jobs in this group are typically responsible for managing the university’s technology infrastructure and services. They handle system maintenance, support, and cybersecurity to ensure technology resources are reliable and secure. These jobs focus on analyzing and leveraging data to help make informed business decisions. These roles involve collecting, processing, and interpreting data to provide actionable insights and support strategic planning and creating end products such as dashboards and data visualization tools. The IT Analyst Sr, BI Developer will be responsible for: - Using the enterprise's data to design, create, and maintain BI reports and tools in support of clinical, business, and research operations at UVA Health. - Performing data analysis utilizing appropriate analytics methodologies. - Fostering data-driven decision making by providing valuable consultative analytics support to executives and service area leadership, in accordance with regulatory standards. - Participating in cross-functional performance improvement team efforts, ensuring appropriate analysis of data, data accuracy, and data availability. - Consulting with all levels of staff to help solve problems and contribute to highly visible organizational projects through the analysis and presentation of data. - Collaborating with operational subject matter experts and stakeholders, serving as lead developer and resident expert for outcomes-related metrics. - Ensuring accurate metadata, target/threshold acquisition, appropriate metric and report development, data validation, maintenance, and modification. - Collecting business requirements from appropriate stakeholders. - Designing, coding, validating, deploying, and maintaining the semantic layer and metadata for complex reports and reporting tools. - Building BI intelligence solutions. - Developing code with structured query language (SQL), preferably Microsoft T-SQL. - Performing analysis of data and designing data collection tools based on parameters appropriate for the situation. - Performing system administration: build, test, and assist with upgrade/enhancement/patch-related implementation activities. - Adhering to specific team and departmental quality standards and development best practices. - Monitoring the teamwork queue and triaging requests. - Participating in governance and Change Control-related activities. - Regularly providing guidance and training to less experienced team members. - Coaching customers, as appropriate, on the use of BI tools. - Adapting to competing demands, shifting priorities, and organizational constraints. Remote work permitted. Qualifications - Bachelor’s degree in Health Informatics, or related field. - Five (5) years of experience in the job offered or as a Data Analyst, Data Scientist, Business Intelligence Analyst, Business Intelligence Developer, Data Engineer, or related occupation. Alternatively, a Master’s degree in Health Informatics or a related field and three (3) years of experience in the job offered or as a Data Analyst, Data Scientist, Business Intelligence Analyst, Business Intelligence Developer, Data Engineer, or related occupation, or a PhD in Health Informatics or a related field and one (1) year of experience in the job offered or as a Data Analyst, Data Scientist, Business Intelligence Analyst, Business Intelligence Developer, Data Engineer, or related occupation. - Good understanding of relational databases. - Proficient with T-SQL. - Intermediate experience with organizing and analyzing large datasets. - Proficient with Microsoft Excel and Word. - Able to learn new software as required for the position. - Experience and skills may be gained before or during attainment of graduate degree. - Remote work permitted. Requirements - None required; Epic certification preferred. Benefits - Comprehensive Benefits Package: Medical, Dental, and Vision Insurance. - Paid Time Off, Long-term and Short-term Disability, Retirement Savings. - Health Saving Plans, and Flexible Spending Accounts. - Certification and education support. - Generous Paid Time Off. Company Description UVA Health is a world-class Magnet Recognized academic medical center and health system with a level 1 trauma center. 2023-2024 U.S. News & World Report “Best Hospitals” guide rates UVA Health University Medical Center as “High Performing” in 5 adult specialties and 14 conditions/procedures. We are one of 70 National Cancer Institute designated cancer centers. UVA Health Children’s is named by 2023-2024 U.S. News & World Report as the best children's hospital in Virginia with 9 specialties ranked among the best in the nation. Our footprint also encompasses 3 community hospitals and an integrated network of primary and specialty care clinics throughout Charlottesville, Culpeper, Northern Virginia, and beyond. The University of Virginia is an equal opportunity employer. All interested persons are encouraged to apply, including veterans and individuals with disabilities. Learn more about UVA’s commitment to non-discrimination and equal opportunity employment.



