WHAT YOU'LL BE DOING & THE IMPACT YOU'LL MAKEWe are looking for an experienced
BI Engineer to design and build scalable, governed analytics solutions that enable trusted and intuitive access to enterprise data. This role will focus on developing Power BI semantic models, reusable business/context layers, and self-service analytics capabilities, leveraging Microsoft Power BI, Microsoft Fabric, Snowflake, and AI-assisted development practices. The ideal candidate will have 6-8 years of experience in Business Intelligence, Analytics Engineering, Data Engineering, or related areas, with strong hands-on expertise in Power BI, dimensional modeling, semantic model development, SQL, and modern cloud data platforms. This role also requires an AI-first engineering mindset. The engineer will be expected to use approved AI capabilities to accelerate development, testing, documentation, optimization, and modernization while maintaining accountability for the quality, security, and maintainability of production solutions.
This is a progressive role that will be filled at the level based on the skills and experience of the selected candidate.
ADDITIONAL DETAILS- The salary range for this role is $85,000 - $110,000. Final compensation varies based on several factors.
- This is a U.S.-based remote role.* We're committed to creating a connected, collaborative culture, no matter where you are. You'll have access to virtual tools, team support, and opportunities to engage and grow with us. *Due to state-specific benefits regulations, Hallmark cannot consider candidates for remote positions who reside in Alaska, Hawaii, or Puerto Rico, or any country outside of the United States.
- This is a progressive role designed to grow with you. We'll match the job level to your skills and experience so you can hit the ground running and keep building your career.
- Hallmark is committed to recognizing and rewarding performance. Employees are eligible for annual merit-based increases, aligned with individual and company performance.
- In alignment with our culture of care, Hallmark offers a competitive benefits package, including medical, dental and vision plans, paid time off, 401K with company match, and profit-sharing.
BASIC QUALIFICATIONS (the following is required to be considered for this role):- At lease 6 years of experience in Business Intelligence, Analytics Engineering, Data Engineering, or a related technology discipline.
- Hands-on experience with Microsoft Power BI, including semantic model development, DAX, Power Query/M, dimensional modeling, Power BI Service, data security, and performance optimization.
- Experience designing and developing dimensional data models using star schemas, facts, dimensions, aggregations, relationships, hierarchies, measures, and KPIs.
- Demonstrated experience building shared and reusable semantic/business layers, rather than primarily developing individual reports.
- Experience developing and implementing self-service analytics capabilities for business users.
- Experience developing and optimizing SQL queries for performance and efficiency.
- Hands-on experience working with Snowflake or a comparable cloud data platform.
- Experience developing analytical solutions using Microsoft Fabric.
- Understanding of modern analytical architectures spanning data platforms, analytical data products, semantic models, and visualization layers.
- Experience designing or developing modern analytical architectures that include data platforms, analytical data products, semantic models, and visualization layers
- Experience translating complex business requirements into scalable technical and analytical solutions.
- Demonstrated experience incorporating Generative AI or AI coding assistants into real-world development workflows.
- Ability to use AI effectively to generate, review, refine, and troubleshoot SQL, DAX, M, semantic-model metadata, documentation, and other engineering artifacts.
- Experience using AI across multiple stages of the development lifecycle, including design, development, testing, troubleshooting, optimization, and documentation.
- Ability to evaluate AI-generated solutions for correctness rather than accepting generated code without appropriate engineering review.
- Experience applying responsible AI development practices, including data protection, security, validation, governance, and human accountability
PREFERRED QUALIFICATIONS (your application will stand out if you have the following):- Advanced experience with Microsoft Fabric, including Lakehouse, Warehouse, OneLake, Direct Lake, Dataflows Gen2, and data pipelines.
- Experience integrating and optimizing Power BI with Snowflake.
- Experience with medallion or layered data architectures and curated analytical data products.
- Experience with CI/CD, Git integration, deployment pipelines, source control, and DevOps practices for BI and analytics solutions.
- Experience establishing BI governance, semantic-model standards, common metric definitions, and self-service analytics frameworks.
- Experience modernizing legacy BI/reporting platforms to Power BI, Fabric, Snowflake, or other modern cloud analytics platforms.
- Experience with metadata management, data catalogs, lineage, business glossaries, or Microsoft Purview.
- Experience developing AI-enabled accelerators, agents, reusable prompts, or automated development workflows for BI and analytics engineering.
- Experience applying AI to accelerate BI modernization, report migration, semantic modeling, metadata management, testing, and self-service analytics.
COME JOIN US! Now's your chance to embrace a future with Hallmark-just follow the instructions below to applyYou must show how you meet the basic qualifications in a resume or document you upload, or by completing the work experience and education application fields. Accepted file types are DOCX and PDF.