Business Intelligence Engineer

Veteran Benefits Guide has been proud to serve our nation’s service members for more than 10 years. They are seeking a Business Intelligence Engineer responsible for transforming raw data into well-modeled datasets that empower reporting and data-driven decision-making across the organization.

Responsibilities:

• Build, maintain, and optimize curated data models using SQL, dbt, or similar transformation tools
• Create dimensional models (fact/dimension) and semantic layers to support reporting and advanced analytics
• Construct unified datasets that bring together cross-system information (e.g., Salesforce, NetSuite, Google Ads)
• Profile, validate, and cleanse data to eliminate duplicates, missing fields, and inconsistencies
• Implement automated data tests to ensure accuracy, completeness, and referential integrity
• Investigate and resolve issues flagged by Analysts when metrics do not match or data looks incorrect
• Partner with DBAs and Data Engineers to ensure performance at the warehouse structures and optimized queries
• Adhere to and help define data governance, documentation standards, and semantic layer best practices
• Maintain version-controlled analytics codebases using Git or similar workflows
• Work closely with Analysts to understand their data needs and translate them into robust models
• Support BI Developers by providing clean, reliable datasets that power dashboards and reports
• Communicate issues, improvements, and data model changes clearly to technical and non-technical audiences

Requirements:

• Advanced SQL skills (window functions, CTEs, performance tuning)
• Experience with transformation frameworks (dbt strongly preferred)
• Strong understanding of data warehousing concepts: star schema, snowflake schema, fact/dimension modeling
• Familiarity with cloud warehouses (Snowflake, BigQuery, Redshift, Synapse)
• Ability to troubleshoot mismatched metrics, broken joins, or duplicated data
• Bachelor's degree in Data Analytics, Computer Science, Information Systems, or related field
• 3–5+ years of experience in analytics engineering, BI development, or data modeling
• Snowflake SnowPro Core Certification
• Snowflake SnowPro Advanced Data Engineer Certification
• dbt Analytics Engineer Certification
• AWS Data Engineer – Associate Certification
• AWS Solutions Architect – Associate Certification
• Experience with Python or R for data validation or automation scripts
• Knowledge of BI tools (Power BI, Tableau, Looker) and how they interact with semantic layers
• Familiarity with CI/CD for analytics code and version control (Git)
• Exposure to data governance, cataloging, and documentation tools