Sr. Consultant - Business Intelligence

We are seeking a highly skilled Business Intelligence Sr. Consultant to design, develop, and maintain business intelligence dashboards, reports, and data visualizations that support strategic and operational decision-making. The ideal candidate will possess strong Tableau and PowerBI development expertise, experience working with large datasets, and the ability to translate business requirements into actionable reporting solutions.   

What You'll Work On  

Design, develop, and maintain interactive Tableau and PowerBI dashboards, scorecards, and reports. 

Collaborate with business stakeholders to gather reporting requirements and translate them into effective visualization solutions.  

Connect Tableau to various data sources including SQL databases, cloud platforms, data warehouses, and flat files.   

Develop and optimize Tableau and PowerBI data models, calculations, parameters, filters, and dashboard actions.   

Create and maintain automated reporting solutions that improve data accessibility and reduce manual effort.   

Perform data validation, troubleshooting, and quality assurance to ensure report accuracy and consistency.   

Write complex SQL queries, stored procedures, and database views to support reporting requirements.   

Monitor dashboard performance and implement optimization techniques to improve efficiency and scalability.   

Develop documentation, data dictionaries, and user guides for reporting solutions.   

Partner with Data Engineering, Analytics, and Business teams to support enterprise reporting initiatives.   

Ensure adherence to data governance, security, and compliance standards.   

Provide end-user support, training, and guidance on Tableau reporting capabilities and best practices.  

What You'll Bring  

Bachelor’s degree in computer science, Information Systems, Data Analytics, Business Intelligence, or a related field.   

5+ years of experience in Tableau and/or PowerBI development and enterprise reporting.   

Strong expertise in Tableau Desktop, Tableau Server, and Tableau Cloud.   

Advanced SQL skills with experience querying and manipulating large datasets.   

Experience with relational databases such as SQL Server, Oracle, PostgreSQL, Snowflake, or similar platforms.   

Strong understanding of data warehousing concepts, dimensional modeling, and ETL processes.   

Experience developing KPIs, metrics, and executive-level dashboards.   

Excellent analytical, problem-solving, and communication skills.   

Ability to manage multiple priorities in a fast-paced environment.  

Relevant Skills:  

Tableau Desktop   

Tableau Server / Tableau Cloud   

SQL (Advanced)   

Data Visualization Best Practices   

Data Modeling   

ETL Processes   

Microsoft Excel   

Snowflake, SQL Server, Oracle, PostgreSQL   

Azure, AWS, or Google Cloud (Preferred)   

Power BI (Preferred)   

Python/R (Preferred)  

How You Work  

Must be able to work in a fast paced and start up environment  

Successful in very entrepreneurial organizations  

Must be self-sufficient and be able to work autonomously using creativity and knowledge to drive new and innovative solutions  

Bonus Points If You Have  

Tableau Desktop Certified Professional or Tableau Certified Data Analyst certification.   

Experience with SSRS, Cognos, Business Objects, or other BI tools.   

Knowledge of Python, R, or other data analysis/programming languages.   

Experience working with cloud platforms such as Azure, AWS, or Google Cloud.   

Familiarity with Agile/Scrum methodologies.   

Experience working in healthcare, finance, retail, manufacturing, or consulting environments.  

What Success Looks Like  

Timely delivery of reporting and dashboard solutions.   

High user adoption and stakeholder satisfaction.   

Accuracy and reliability of reporting outputs.   

Improved reporting automation and operational efficiency.   

Reduced report development and maintenance effort through scalable solutions.  

Industry focused pre-built solutions and KPI’s  

Why Join FormativGroup

At FormativGroup, you’ll work with people who are practical, collaborative, and focused on solving meaningful business and technology problems. We’re growing, which means you’ll have opportunities to contribute ideas, work closely with experienced leaders, and help shape how we deliver for clients.

Employment Eligibility

Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment visa currently.

This is a remote role with approximately 50% travel. The preferred location is the Northeast U.S. To be considered for this position, candidates must reside in one of the following U.S. states or Washington, DC: AL, AR, AZ, CA, CO, CT, DE, FL, GA, IA, ID, IL, IN, KS, KY, MA, MD, MI, MN, MO, NC, NH, NJ, NV, NY, OH, OK, OR, PA, TN, TX, VA, WI, or Washington, DC. Candidates residing outside these locations are not eligible for consideration currently. We are committed to pay equity and transparency. The compensation range for this position represents our good faith estimate of the range we reasonably expect to pay for this role at the time of posting. The actual compensation offered will be determined based on factors such as the candidate’s experience, skills, education, work location, and internal equity.  

In addition to base pay, employees may be eligible for discretionary bonuses, commissions, or other incentive programs, as well as a comprehensive benefits package that includes medical, dental, vision, 401(k), paid time off, etc.  

Estimated Compensation Range: $125,000 — $150,000 USD

FormativGroup operates within the critical middle layer of business technology, where applications and systems connect infrastructure to business processes. We are specialists who help the middle market take full advantage of their technology investments with deep, industry-centric expertise, all in one place, to unify fragmented systems.  With deep technical expertise across cloud architecture, system integration, AI, and data strategy, we bridge the gap between business goals and modern platforms.    

FormativGroup is an equal opportunity employer providing opportunities to applicants and employees without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.

ADA Specifications: Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this position.  

#formativgroupcareers #WorkWithUs

Click here to view our Privacy Policy