Job description

We are seeking a highly skilled Business Intelligence and Data Solutions Engineer with 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 in SQL (Joins, CTEs, window functions, optimization). • Deep proficiency in Power BI (DAX, Power Query, dashboards, semantic modeling, RLS). • Hands-on experience with Snowflake, Azure Synapse, and data warehouse architecture. • Skilled in automation and machine learning using 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

Requirements