Sr. Consultant - Business Intelligence

About this role

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

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, syst

Similar jobs

• Sr. Business Intelligence Engineer — Doordashusa · New York, NY; San Francisco, CA; San Jose, CA; Seattle, WA; Los Angeles, CA; Washington D.C.; Austin, TX; Chicago, IL
• Senior Manager, Business Intelligence — Justworks · New York, New York
• Senior Manager, Business Intelligence — Thetradedesk · New York
• Senior Business Intelligence Engineer — Imprint · New York City
• Senior Business Intelligence Engineer — Themotleyfool · Remote
• Senior Business Intelligence Analyst — Imaginepediatrics · Remote
• Senior Business Intelligence Analyst — Contentful · Denver, Colorado, United States
• Senior Business Intelligence Analyst — Caredxinc · Remote