Business Intelligence Consultant

Job ID Number

R3282

Employment Type

Full time

Worksite Flexibility

Remote

Job Summary

As the Business Intelligence Consultant, you will have a strong foundation in Tableau, Power BI, data wrangling, data modeling, and data warehousing.



We are looking for a Business Intelligence Consultant for 12 month contract opportunity that is mostly remote with some onsite work (1x/month) in Trenton, NJ. The ideal candidate should have a strong foundation in Tableau, Power BI, data wrangling, data modeling, and data warehousing.

What You'll Do

Develop new, as well as, updating or enhancing existing dashboards using Tableau Desktop and Tableau Prep

Facilitate transition of current dashboards from Tableau to Power BI

Create process documentation: to recreate existing Tableau dashboards in Power BI, to promote user acceptance for Power BI based dashboards, and to promote wider understanding of the BI layer and its interaction with the Azure data platform

Act as a team leader for junior business intelligence developers - facilitating their learning and seamless transition using the organizational BI strategy

Design visualizations with a modular design of reports, worksheets, and views in Business Intelligence tools

Develop dashboards with advanced features such as Level of Detail, DAX queries, contextual filters, etc.

Assist in developing, testing, improving, and maintaining new and existing databases to help users retrieve data effectively

Apply critical thinking to gather requirements from an internal stakeholder and adjusting for external users to create interactive dashboards in BI tools

Organize data in a concise format

Participate and contribute to ETL/ELT processes when required

Analyze data using industry best practices and provide business value to stakeholders

What You'll Need

Required

5+ years of experience in creating Tableau dashboards

3+ years creating dashboards within Power BI

Strong foundation in Tableau Desktop and Tableau Cloud, as well as experience in troubleshooting and performance tuning of reports, and resolving issues within Tableau Cloud and reports

Work collaboratively and understand business requirements and system architecture

Tableau Desktop/Cloud experience, including recent versions of Tableau, and have in-depth knowledge of Tableau Parameters, Data blending, Action filters, joins, and Drilldowns. They should also have experience in cloud platforms like Microsoft Azure

Data Visualization: Tableau AND Power BI; in addition to any other data visualization tools

The ideal candidate should have a good understanding of views, Synonyms, Indexes, Joins, and Sub-Queries

Experience working with Agile methodology and be proficient in Database& Python/Shell Scripting

An understanding of the appropriate chart types (Bar charts, Line charts, scatter plots, Heat Maps, Sankey Diagrams, Tree maps)

Data Wrangling: SQL, Python, R

Data Modeling: ETL/ELT Processes, Python Data Science Libraries (Pandas, NumPy, Scikit-Learn)

Project Management tools: Microsoft Project, Jira, Azure DevOps, Trello, Monday

Data Warehousing experience

Experience working with large data sets

Critical thinking skills and detail oriented

Strong written and strategic communication skills for stakeholder management

Attention to details to be able to validate values and provide deliverables

Working knowledge of Power BI developer skills. Should be familiar with DAX(Data Analysis Expressions) for creating custom calculations in Power BI.

Preferred

Tableau Desktop Specialist

Tableau Desktop Certified Associate

Tableau Certified Associate Architect

Microsoft Certified: Power BI Data Analyst Associate

Physical Demands

Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal, state and local standards

Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc.

Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard and monitor

Reasonable Accommodation Statement

If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to *** or (888) 824 - 8111.

Equal Employment Opportunity Policy Statement

It is the policy of CAI not to discriminate against any employee or applicant due to race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being a protected veteran. It is also the policy of CAI to take affirmative action to employ and to advance in employment, all persons regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being a protected veteran, and to base all employment decisions only on valid job requirements. This policy shall apply to all employment actions, including but not limited to recruitment, hiring, upgrading, promotion, transfer, demotion, layoff, recall, termination, rates of pay or other forms of compensation and selection for training, including apprenticeship, at all levels of employment. Employees and applicants of CAI will not be subject to harassment due to race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being a protected veteran. Additionally, retaliation, including intimidation, threats, or coercion, because an employee or applicant has objected to discrimination, engaged or may engage in filing a complaint, assisted in a review, investigation, or hearing or have otherwise sought to obtain their legal rights under any Federal, State, or local EEO law is prohibited.