Business Intelligence Consultant

at CAI in Springfield, Illinois, United States

Job Description

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.

Job Description

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 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 application.accommodations@cai.io 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.