Sr. Business Intelligence Developer

Insight Global is looking for a Senior BI Developer who will play a critical role in designing, building, and delivering end‑to‑end Business Intelligence solutions to support new business initiatives and enterprise reporting needs. This role is highly hands‑on and solution‑oriented, with a strong emphasis on independent design thinking, technical execution, and ownership.
The successful candidate will be responsible for taking loosely defined business problems and translating them into scalable BI solutions, including data ingestion pipelines, data models, and dashboards. This individual will help relieve technical bottlenecks by owning workstreams end to end and driving delivery with minimal oversight.

Key Responsibilities
BI Solution Design & Development
• Lead the design and implementation of end‑to‑end BI solutions, including ELT / ETL pipelines, data models, semantic layers, and reporting.
• Own solution architecture from data ingestion through to dashboards, without requiring step‑by‑step direction.
• Design robust and scalable data models that ensure data accuracy, consistency, and business relevance.
• Translate complex and evolving business requirements into practical, production‑ready BI solutions.
Data Integration & Engineering
• Design, build, and maintain data ingestion and ELT/ETL pipelines using Azure Data Factory and SQL‑based approaches.
• Integrate data from multiple source systems into the data warehouse.
• Apply strong T‑SQL fundamentals to support transformations, calculations, and performance‑efficient querying.
• Review and improve existing pipelines, models, and logic for performance, reliability, and maintainability.
Reporting & Visualization
• Develop and optimize enterprise‑grade dashboards and reports using Power BI and/or Tableau.
• Ensure reporting solutions effectively translate data into clear, actionable insights for business stakeholders.
• Identify opportunities to improve self‑service analytics and reporting efficiency.
Technical Leadership & Collaboration
• Act as a senior technical resource within the BI team, providing guidance, design input, and best‑practice recommendations.
• Partner closely with business and technical stakeholders to align BI solutions with business objectives.
• Proactively identify gaps, risks, and opportunities for improvement across the BI environment.
• Develop and maintain technical documentation, including solution designs, data models, and integration mappings.
Role Breakdown
• 70% hands‑on BI development and data engineering
• 30% solution design, architecture, and technical leadership

We may use artificial intelligence tools to assist with the screening, assessment, or selection of potential applicants for this position.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.

• 8+ years overall experience in BI development and analytics roles.
• 3+ years of Solution Design
• Strong T‑SQL expertise
• Hands‑on experience designing BI solutions end to end (not just report development).
• Power BI and/or Tableau development experience (dashboards, reports, visualizations).
• Solid experience with Azure Data Factory for data ingestion and orchestration.
• Proven ability to work independently, own solutions, and drive delivery without heavy oversight.
• Strong analytical and problem‑solving skills.
Excellent communication skills with the ability to engage both technical and non‑technical stakeholders.

• Experience with Snowflake and modern data warehousing concepts (e.g., ELT/ETL, Data Vault).
• Exposure to the Azure data platform beyond ADF.
• Familiarity with the Microsoft Fabric ecosystem.
Prior experience reviewing and modernizing legacy BI solutions.

Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.