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 Power BI, 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

Location

The location required for this role is remote in the US with 25% US travel required.

To be considered for this position, candidates must reside in one of the following U.S. states: 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, and Washington DC. Candidates residing outside these states are not eligible for consideration currently.

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 now or in the future.

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