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 EligibilityApplicants 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.
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
Skills Required
- Bachelor's degree in Computer Science, Information Systems, Data Analytics, Business Intelligence, or related field
- 5+ years of experience in Tableau and/or Power BI development and enterprise reporting
- Expertise in Tableau Desktop, Tableau Server, and Tableau Cloud
- Advanced SQL skills, including complex queries, stored procedures, and views
- Experience with relational databases (SQL Server, Oracle, PostgreSQL, Snowflake or similar)
- Strong understanding of data warehousing concepts, dimensional modeling, and ETL processes
- Experience developing KPIs, metrics, and executive-level dashboards
- Ability to perform data validation, troubleshooting, and quality assurance for reports
- Excellent analytical, problem-solving, and communication skills
- Ability to manage multiple priorities in a fast-paced, startup-like environment and work autonomously
- Authorized to work for any employer in the U.S. without sponsorship
- Willingness and ability to travel approximately 50%
- Power BI experience
- Experience with cloud platforms (Azure, AWS, or Google Cloud)
- Knowledge of Python or R
- Tableau certifications (Tableau Desktop Certified Professional or Tableau Certified Data Analyst)
- Experience with other BI tools (SSRS, Cognos, Business Objects)
- Familiarity with Agile/Scrum methodologies
- Experience in healthcare, finance, retail, manufacturing, or consulting environments
What We Do
Modern organizations depend on business systems that work in concert. FormativGroup enables our clients by connecting their processes and workflows, applications, and layers of data in ways that reflect how the business needs to operate. We help organizations knock down technology barriers, integrate workflows, and design connected data ecosystems, so information is available where and when they need it most. We are industry-centric consultants with expertise in design AND execution, working across your ecosystem to future-proof your business environment. See how you can transform possibility into progress with FormativGroup.
