Business Intelligence and Data Solutions Engineer

We are seeking a highly skilledBusiness Intelligence and Data Solutions Engineerwith a strong background in SQL, Power BI, and enterprise data modeling. The ideal candidate will combine technical expertise with business acumen to design, implement, and optimize scalable data solutions that drive decision-making across the organization. Key Responsibilities • SQL Development & Optimization: Design and optimize queries using joins, CTEs, and window functions for high-performance analytics. • Power BI Leadership: Build and manage enterprise-grade dashboards, reports, and semantic models using DAX, Power Query, and advanced data modeling techniques. • Data Modeling & Warehousing: Architect data warehouse solutions using Snowflake, Azure Synapse, and SQL Server to support financial, operational, and executive reporting needs. • Business Insight & Stakeholder Engagement: Partner with finance, operations, and executive leadership to gather requirements, define KPIs, and translate business needs into actionable BI solutions. • Automation & Advanced Analytics: Implement automation pipelines and ML solutions using Azure Data Factory, Power Automate, Python, and R; integrate APIs to streamline reporting and forecasting processes. • Governance & Performance Management: Manage BI governance, security (RLS), and Power BI Premium capacity to ensure reliability, scalability, and compliance. • Team Leadership: Mentor and guide data analysts and engineers, providing technical oversight while driving best practices in BI and ML development. Qualifications • Proven track record delivering enterprise-scale BI solutions across finance, sales, and operations. • Advanced expertise inSQL (Joins, CTEs, window functions, optimization). • Deep proficiency inPower BI (DAX, Power Query, dashboards, semantic modeling, RLS). • Hands-on experience withSnowflake, Azure Synapse, and data warehouse architecture. • Skilled inautomation and machine learningusing Python, R, Power Automate, and Azure services. • Strong communication skills with experience leading requirements sessions and delivering executive-ready insights. • Experience managing BI platforms, governance frameworks, and ML lifecycle management. • Bachelor’s or Master’s degree in a technical field. Job Type: Full-time Pay: $90,000.00 - $100,000.00 per year Benefits: • 401(k) matching • Dental insurance • Employee assistance program • Health insurance • Health savings account • Life insurance • Paid time off • Professional development assistance • Referral program • Tuition reimbursement • Vision insurance Application Question(s): • Are you a US Resident or US Citizen? Experience: • Power BI: 4 years (Required) • Microsoft SQL Server: 3 years (Preferred) • ETL: 3 years (Preferred) • Azure: 3 years (Preferred) Work Location: In person