Sr. Consultant - Business Intelligence

About the 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.

Responsibilities

• 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.

Requirements

• 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.

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)

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 KPIs.

Bonus Points

• 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.

Work Environment

• Must be able to work in a fast-paced and startup environment.
• Successful in very entrepreneurial organizations.
• Must be self-sufficient and able to work autonomously using creativity and knowledge to drive new and innovative solutions.

Location & Travel

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.

Pay

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. Estimated Compensation Range: $125,000—$150,000 USD.

Benefits

• Comprehensive benefits package that includes medical, dental, vision, and 401(k).
• Paid time off.
• Eligibility for discretionary bonuses, commissions, or other incentive programs.