bi consultant

Architecture In Motion

<div>Power BI Consultant

Location: Remote

Job Type: Contract

About AIM

AIM is a Canadian technology company that helps organizations modernize their systems through advanced API management, cloud engineering, security solutions, and full-stack software development. Our teams work across North America and globally, delivering stable, scalable, and secure digital platforms for enterprise clients.

We take pride in being hands-on, collaborative, and focused on delivering real results for our clients. As we grow, we are expanding our marketing team to strengthen our brand presence and support our next stage of growth. 


Role Summary

We&rsquo;re looking for a hands‑on Power BI Consultant to design, model, and deliver high‑performance BI solutions. You will translate business requirements into robust semantic models, efficient DAX measures, and impactful dashboards, while ensuring governance, performance, and security in Power BI Service.

Key Responsibilities
<ul>
<li>Engage stakeholders to capture requirements and convert them into BI specifications and data models.</li>
<li>Design star/snowflake models with conformed dimensions and surrogate keys.</li>
<li>Build optimized DAX (time intelligence, iterator patterns, context transition) and reusable calculation logic.</li>
<li>Develop ETL/ELT using Power Query (M), Dataflows, and SQL; implement incremental refresh and partitions.</li>
<li>Choose and justify Import vs. DirectQuery vs. Composite based on latency, volume, and SLA.</li>
<li>Publish and manage content in Power BI Service (Workspaces, Apps, Dataflows, Gateways, Deployment Pipelines).</li>
<li>Implement Row‑Level Security (RLS) / Object‑Level Security (OLS) and workspace governance.</li>
<li>Optimize models and reports (cardinality reduction, aggregations, query folding, Performance Analyzer, DAX Studio).</li>
<li>Create executive and operational dashboards with drill‑through, tooltips, bookmarks, and KPI storytelling.</li>
<li>Partner with data engineering (SQL/Azure/Fabric) on pipelines, Lakehouse/Warehouse, and data quality.</li>
<li>Maintain documentation: data dictionary, lineage, refresh SLAs, and runbooks.</li>
<li>Support production, monitor refreshes/capacity, and drive continuous improvement and user enablement.</li>
</ul>
Required Qualifications
<ul>
<li>3&ndash;6+ years building end‑to‑end Power BI solutions (modeling, DAX, visuals, deployment).</li>
<li>Strong SQL (CTEs, window functions, query tuning).</li>
<li>Advanced DAX (CALCULATE, filter context, iterators, time intelligence).</li>
<li>Solid Power Query (M) with understanding of query folding.</li>
<li>Proven experience with RLS/OLS, incremental refresh, DirectQuery/Composite models.</li>
<li>Proficiency with Power BI Service (Workspaces, Apps, Dataflows, Gateways, Deployment Pipelines).</li>
<li>Performance tuning using Performance Analyzer and DAX Studio / VertiPaq Analyzer.</li>
<li>Clear communication and stakeholder management skills.</li>
</ul>
Nice to Have
<ul>
<li>Microsoft Fabric (Lakehouse, Warehouse, Dataflows Gen2) or Azure (Synapse, Data Lake, Databricks, ADF).</li>
<li>Tabular modeling tools (Tabular Editor, TOM/TMSL, calculation groups).</li>
<li>CI/CD for BI (Git, Azure DevOps, Deployment Pipelines).</li>
<li>Python/R for analytics; Power Automate integration.</li>
<li>Certification: PL‑300 (or equivalent).</li>
</ul>
Tools &amp; Stack

Power BI Desktop &amp; Service, DAX Studio, Tabular Editor, SQL Server/Azure SQL, Power Query (M), Fabric/Synapse (nice‑to‑have), Git/DevOps, Excel (Power Pivot). 
Work Schedule

Ability to wrk on Eastern Time Zone, Remotely.

Equal Opportunity

We value diversity and provide equal opportunities without regard to religion, gender, age, disability, or national origin.</div>

Power BI Consultant

NavitasPartners

<div><h3 class="jobSectionHeader">Job Title: Senior BI Consultant</h3>
<h3 class="jobSectionHeader">Location: Everett, MA 02149 (Hybrid &ndash; 1 day onsite/week)</h3>
<h3 class="jobSectionHeader">Duration: 6 Months Contract</h3>
<h3 class="jobSectionHeader">Work Hours: 37.5 hours/week (7.5 hours/day)</h3>
<h3 class="jobSectionHeader">Job Summary:</h3>

We are seeking a highly skilled Senior BI Consultant to support multiple data warehouse and analytics initiatives. The ideal candidate will bring strong expertise in data visualization, report development, and business intelligence solutions, primarily using Microsoft Power BI and related technologies.

This role involves designing, developing, and maintaining reporting solutions, as well as collaborating with cross-functional teams to deliver high-quality analytics products that meet business needs.

<h3 class="jobSectionHeader">Key Responsibilities:</h3>
<ul>
<li>Migrate existing SSRS reports to Power BI Report Server
</li>
<li>Design and develop reporting solutions using Microsoft Power BI
</li>
<li>Provide expertise in data visualization and dashboard design
</li>
<li>Participate in modernization and migration projects to Power BI
</li>
<li>Define and follow Power BI development best practices
</li>
<li>Collaborate with product owners, project managers, and technical teams to gather and implement requirements
</li>
<li>Optimize and enhance Power BI reports and dashboards for performance and usability
</li>
<li>Maintain and support existing BI solutions
</li>
<li>Stay updated on industry trends and Microsoft Azure-based BI technologies
</li>
<li>Mentor junior developers and provide technical guidance
</li>
<li>Develop monitoring systems to track usage and ensure system stability
</li>
<li>Create and maintain documentation throughout the software development lifecycle
</li>
<li>Analyze business requirements and provide technical solutions and development estimates
</li>
<li>Build and support enterprise data models using Power BI, SSAS, AAS, and dataflows
</li>
<li>Design and develop cubes, metadata, and reporting layers
</li>
<li>Implement solutions for ad-hoc reporting on large datasets
</li>
<li>Work with data lake and warehouse architectures
</li>
</ul><h3 class="jobSectionHeader">Minimum Qualifications:</h3>
<ul>
<li>Bachelor&rsquo;s degree or at least 3+ years of relevant technical experience
</li>
<li>5+ years of experience developing complex reports, dashboards, and scorecards
</li>
<li>5+ years of advanced experience with Microsoft Power BI
</li>
<li>5+ years of strong SQL experience with efficient query writing skills
</li>
<li>2+ years of experience with other BI tools (e.g., Cognos)
</li>
<li>Experience working with multiple data sources such as Oracle and SQL Server
</li>
<li>Strong data analysis and problem-solving skills
</li>
<li>Solid understanding of data modeling concepts
</li>
<li>Experience building SSAS tabular models
</li>
<li>Experience with Power BI data transformation and modeling
</li>
<li>Knowledge of SSRS and SSIS
</li>
<li>Understanding of OLAP and ETL frameworks
</li>
<li>Ability to manage multiple priorities and meet deadlines
</li>
<li>Excellent communication and collaboration skills
</li>
<li>Ability to work independently with minimal supervision
</li>
<li>Strong attention to detail and time management skills
</li>
</ul><h3 class="jobSectionHeader">Preferred Qualifications:</h3>
<ul>
<li>Experience with cloud technologies (e.g., Azure)
</li>
<li>Familiarity with Agile methodologies
</li>
<li>Experience with dimensional modeling (fact/dimension, star schema)
</li>
<li>Power BI Certification (preferred)
</li>
<li>Strong team collaboration and communication skills
</li>
</ul>For more details reach at ndogra@navitassols.com.</div>

Senior BI Consultant - SBIC 26-02719

<div><h3 class="jobSectionHeader">Job Title: Senior BI Consultant (Power BI)</h3>

Location: Everett, MA (Hybrid &ndash; 1 day onsite per week) 
Duration: 6 Months 
Work Schedule: 37.5 hours/week (7.5 hours/day)

<h3 class="jobSectionHeader">Position Overview</h3>

&quot;Navitas Partners, LLC&quot; is seeking an experienced Senior BI Consultant / Power BI Developer to support ongoing data warehouse and analytics initiatives. This role focuses on designing, developing, and maintaining business intelligence solutions using Microsoft technologies, particularly Power BI.

The ideal candidate is highly analytical, experienced in enterprise BI environments, and capable of collaborating with cross-functional teams to deliver scalable reporting and data visualization solutions.

<h3 class="jobSectionHeader">Key Responsibilities</h3>
<ul>
<li>Design and develop reporting solutions using Microsoft Power BI
</li>
<li>Migrate legacy SSRS reports to Power BI Report Server
</li>
<li>Build, maintain, and optimize dashboards and data models
</li>
<li>Collaborate with data engineering, analytics teams, and stakeholders
</li>
<li>Translate business requirements into technical BI solutions
</li>
<li>Implement data visualization best practices and standards
</li>
<li>Optimize report performance and usability
</li>
<li>Support and enhance existing BI solutions
</li>
<li>Participate in data warehouse and reporting modernization efforts
</li>
<li>Develop enterprise BI models using tools like SSAS, AAS, and dataflows
</li>
<li>Design and maintain cubes, metadata, and reporting layers
</li>
<li>Enable ad-hoc reporting for large datasets
</li>
<li>Create technical documentation across the development lifecycle
</li>
<li>Mentor junior developers and contribute to team knowledge sharing
</li>
<li>Monitor BI systems for performance and usage metrics
</li>
</ul><h3 class="jobSectionHeader">Required Qualifications</h3>
<ul>
<li>Bachelor&rsquo;s degree or equivalent experience in a technical field
</li>
<li>5+ years of experience in:
<ul>
<li>Power BI development (reports, dashboards, scorecards)
</li>
<li>SQL and writing efficient queries
</li>
</ul></li><li>Strong experience with:
<ul>
<li>Power BI data connections and transformations
</li>
<li>Data modeling and visualization best practices
</li>
<li>SSRS, SSIS, and ETL processes
</li>
</ul></li><li>Experience working with:
<ul>
<li>SQL Server and Oracle databases
</li>
<li>SSAS (Tabular Models)
</li>
<li>Data warehouse and data mart architectures
</li>
</ul></li><li>Solid understanding of:
<ul>
<li>OLAP concepts and data analytics frameworks
</li>
</ul></li><li>Strong problem-solving and analytical skills
</li>
<li>Excellent communication and collaboration abilities
</li>
<li>Ability to manage multiple priorities in a fast-paced environment
</li>
<li>Proven ability to work independently with minimal supervision
</li>
</ul><h3 class="jobSectionHeader">Preferred Qualifications</h3>
<ul>
<li>Experience with cloud platforms (e.g., Azure)
</li>
<li>Familiarity with Agile development methodologies
</li>
<li>Knowledge of dimensional modeling (fact/dimension, star schema)
</li>
<li>Experience with additional BI tools (e.g., Cognos)
</li>
<li>Power BI Certification is a plus
</li>
<li>Strong team collaboration mindset with a proactive approach
</li>
</ul><h3 class="jobSectionHeader">Key Skills</h3>

Power BI | SQL | SSRS | SSIS | SSAS | AAS | ETL | Data Modeling | Data Warehousing | OLAP | Azure | Data Visualization | Dashboard Development

For more details reach at resumes@navitassols.com

About Navitas Partners, LLC: It is a certified WBENC and one of the fastest-growing Technical / IT staffing firms in the US providing services to numerous clients. We offer the most competitive pay for every position. We understand this is a partnership. You will not be blindsided and your salary will be discussed upfront.</div>

Senior BI Consultant (Power BI) - 26-02719

The Hartford

<div>Consultant Bus Intelligence - GC08BE
We&rsquo;re determined to make a difference and are proud to be an insurance company that goes well beyond coverages and policies. Working here means having every opportunity to achieve your goals &ndash; and to help others accomplish theirs, too. Join our team as we help shape the future. 
Description
Business Intelligence Consultant, Global Specialty
Do you have a passion for solving problems using data and analytics? Do you enjoy flexing your creative visualization talents in a team environment?
Join a fast-paced and talented team that is focused on delivering analytical tools to enable the company to better manage and monitor its products. The Business Intelligence Consultant will be responsible for designing, developing and delivering analytic capabilities for the Global Specialty business area. The ideal candidate for the Business Intelligence Consultant will have a strong Business Intelligence background, a talent for telling stories with data, an aptitude for collaborating with business customers, and a focus on delivery. A strong commitment for advocacy and adoption of the Business Intelligence and analytical solutions is a key success criteria for the position.
This successful candidate will help execute a roadmap for delivering data and analytical capabilities, as well as understand and coordinate the prioritized backlog. Other responsibilities may include partnering with other BI Consultants around best practices, standards, training, documentation and peer reviews.
Responsibilities<ul><li>
Drive execution of the data &amp; analytical capabilities roadmap to solve current business challenges and unlock new opportunities.</li><li>
Create new and/or enhance existing dashboards and visual analytics that empower business partners to make informed, data-driven decisions.</li><li>
Deliver high-priority or advanced BI, data, and analytical capabilities that support enterprise goals and innovation.</li><li>
Manage individual workload effectively while maintaining clear and proactive communication with team members and leadership.</li><li>
Identify, troubleshoot, and escalate data or analytics issues to ensure timely resolution and maintain data integrity.</li><li>
Translate stakeholder feedback into actionable improvements by collaborating with product owners and development team to design, develop, deploy, and support AI &amp; visual analytic tools.</li><li>
Partner with IT, data, and other BI organizations as a thought leader to elevate enterprise-wide data and analytics capabilities.</li></ul>
Qualifications
The ideal candidate for the BI Consultant position has a passion for building BI/analytical/data solutions, is results-oriented and is self-motivated. A successful candidate will be able to demonstrate the following qualities in a fast-paced environment:<ul><li>
Bachelor's degree in a related field or equivalent professional experience</li><li>
Proficiency in querying languages.</li><li>
Experience with advanced features of data visualization tools. (Tableau, ThoughtSpot, Power BI)</li><li>
Experience with delivering GenAI solutions within BI tools.</li><li>
Solid foundation in statistical analysis and ability to analyze datasets to identify trends and patterns.</li><li>
Strong analytical, problem-solving and critical thinking skills to address complex business challenges.</li><li>
Excellent communication skills to present data insights clearly and effectively to stakeholders.</li><li>
High attention to detail to ensure data accuracy and integrity.</li><li>
Ability to work collaboratively in a team environment and contribute to cross-functional projects.</li><li>
Ability to quickly learn and apply new technologies, platforms, and methodologies to solve business problems.</li><li>
Specialty Insurance experience is a plus</li></ul>
This role will have a Hybrid work schedule, with the expectation of working in an office (Columbus, OH, Chicago, IL, Hartford, CT or Charlotte, NC) 3 days a week (Tuesday through Thursday).
Candidates must be authorized to work in the US without company sponsorship. The company will not support the STEM OPT I-983 Training Plan endorsement for this position.
Compensation
The listed annualized base pay range is primarily based on analysis of similar positions in the external market. Actual base pay could vary and may be above or below the listed range based on factors including but not limited to performance, proficiency and demonstration of competencies required for the role. The base pay is just one component of The Hartford&rsquo;s total compensation package for employees. Other rewards may include short-term or annual bonuses, long-term incentives, and on-the-spot recognition. The annualized base pay range for this role is:
$76,000 - $114,000
Equal Opportunity Employer/Sex/Race/Color/Veterans/Disability/Sexual Orientation/Gender Identity or Expression/Religion/Age</div>

Business Intelligence Consultant

Search 5091+ Bi consultant jobs near you this March. New roles added regularly across leading industries. Apply today.

5091 bi consultant jobs Near Me

Power BI Consultant

Senior BI Consultant - SBIC 26-02719

Senior BI Consultant (Power BI) - 26-02719

Business Intelligence Consultant

Business Intelligence Consultant

Business Intelligence Consultant

Business Intelligence Consultant