The Perficient Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Perficient Business Intelligence Interview Guide

Getting ready for an Business Intelligence interview at Perficient? The Perficient Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:
<ul>
<li>Know what skills are necessary for Perficient Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Perficient.</li>
<li>Practice real Perficient Business Intelligence interview questions.</li>
</ul>
Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Perficient Business Intelligence interview.


Getting ready for an Business Intelligence interview at Perficient? The Perficient Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for Perficient Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Perficient.
- Practice real Perficient Business Intelligence interview questions.

Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Perficient Business Intelligence interview.
        

Overview

We've gathered this data from parsing thousands of interview experiences sourced from members.

We've gathered this data from parsing thousands of interview experiences sourced from members.

Perficient Business Intelligence Interview Process

We’re given a table of bank transactions with three columns, <code>user_id</code>, a deposit or withdrawal value (determined if the value is positive or negative), and <code>created_at</code> time for each transaction.

Write a query to get the total three-day rolling average for deposits by day.

Note: Please use the format <code>&#39;%Y-%m-%d&#39;</code> for the date in the outout

Example:

Input:

<code>bank_transactions</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>transaction_value</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
Output:

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>dt</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>rolling_three_day</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>

Rolling Bank Transactions

Suppose your company needs to cut costs due to an economic downturn. During a coffee break, you hear a rumor that a lot of money goes to employees who don’t do their work, and you decide to find out if the rumor is true.

Given two tables: <code>employees</code> and <code>projects</code>, find the sum of the salaries of all the employees who didn’t complete any of their projects.

Clarification:

We will consider a project unfinished if it has no end date (its <code>End_dt</code> is <code>NULL</code>).

Given this, we’ll say an employee didn’t finish any of their projects when:

<ul>
<li>They were assigned at least one project.</li>
<li>None of their projects have an <code>End_dt</code>.</li>
</ul>

Example:

Input:

<code>employees</code> table

<table>
<thead>
<tr>
<th>id</th>
<th>salary</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<code>projects</code> table

<table>
<thead>
<tr>
<th>employee_id</th>
<th>project_id</th>
<th>Start_dt</th>
<th>End_dt</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
<td>INTEGER</td>
<td>DATETIME</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
Output:

<table>
<thead>
<tr>
<th>total_slack_salary</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
</tr>
</tbody>
</table>

Find the total salary of slacking employees.

Slacking Employees Salaries

You’ve been asked to analyze the player’s behaviors at a gaming company.

Write a query to get the number of players who played between 5 and 10 games (5 and 10 excluded), and the number of players who played 10 games or more.

Example:

Input:

<code>players</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>name</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>games_played</td>
<td>INTEGER</td>
</tr>

<tr>
<td>registered_at</td>
<td>TIMESTAMP</td>
</tr>
</tbody>
</table>
Output:

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>players_more_than_5_to_10_games</td>
<td>INTEGER</td>
</tr>

<tr>
<td>players_10_plus_games</td>
<td>INTEGER</td>
</tr>
</tbody>
</table>

Obtain count of players based on games played.

Player Analysis

Perficient Business Intelligence Interview Questions

The Data Engineer will be responsible for designing, developing, and maintaining data pipelines and solutions to enable our client to harness the power of the data for further analytics. We’re looking for passionate individuals with knowledge on modern cloud data platforms such as Databricks and Snowflake who want to learn DataOps concepts with tools such as DBT among others. Additionally, it is the expectation that people participate actively in all aspects of the data lifecycle and provide recommendations aligning to best practices within the process. What do you need to come aboard? <ul><li>Databricks Data Engineer Associate certification or Snowpro Core certification ideal</li><li>Less than 2 years of experience in the industry focused on modern cloud data platforms</li><li>Passionate data engineer with knowledge of Databricks and/or Snowflake, with a focus on designing and implementing data pipelines</li><li>Expertise in Snowflake and/or Databricks – be able to differentiate what makes these data platforms different from traditional data warehousing solutions, and how to model and stage data all the way from ingestion to ready for consumption layer</li><li>Solid SQL skills and understanding of database systems</li><li>Python skills are recommended</li><li>Experience with data integration, data processing, and data quality</li><li>Experience with CI/CD practices and tools including Git and branching strategies</li><li>Experience using any of the big cloud (AWS, Azure, GCP) data services are recommended; Azure preferred</li><li>Excellent English written and spoken</li><li>Willing to learn new technologies as DBT</li></ul> To Rock This Role, You Should<ul><li>Client facing or consulting experience highly preferred</li><li>Strong communication and presentation skills</li><li>Strong sense of urgency, detail oriented with the ability to manage and prioritize workflow.</li><li>Analytical problem-solving & decision making able to research, analyze, identify viable options, draw sound conclusions, present findings and make thoughtful recommendations considering overall risk and short-term and long-term impact</li><li>Flexible and adaptable attitude, disciplined to manage multiple responsibilities and adjust to varied environments.</li><li>Future technology leaders- dynamic individuals energized by fast paced personal and professional growth.</li></ul> What can we offer you?<ul><li>Law benefits</li><li>Certifications</li><li>Internal & External Courses</li><li>English Classes</li><li>Medical Insurance (Personal and Familiar)</li><li>Life Insurance</li><li>Savings Fund</li><li>Pantry Vouchers</li><li>Additional Holidays</li></ul>

Talent Acquisition Specialist - Financial Services at PerficientJob Description:We currently have a career opportunity for a Senior Business Consultant to join our team located in LAKE MARY, FL or PITTSBURGH, PA.Job Overview:The role of the Business Consultant is for individuals passionate about identifying and delivering the right Business solution for each client. Our Business Consultants have a keen Business orientation with an understanding of how technology can be effectively applied to meet a variety of Business needs.Our Business Consultants fill a number of different roles on our project teams working with a variety of technologies for a wide range of clients. The specific responsibilities vary for each client and each project. Key to the success of our Business Consultants is the willingness and desire to quickly learn the clients industry and the unique requirements of each engagement and to fill whatever role may be required to best support our clients needs.A Business Consultant thrives in challenging environments and accomplishes difficult assignments without significant supervision and instruction. Our Consultants can handle the stress of being accountable for delivery and: complete goals on time, practice strong attention to detail, persevere through tough obstacles, and do not get easily discouraged.The Senior Business Consultant will be involved in the strategic planning of an engagement or helping the client make decisions about their future IT direction. Once a project has begun, the Senior Business Consultant will facilitate key requirements with stakeholders and customers using standard and User Experience techniques. The Senior Business Consultant may be responsible for functional designs, detailed designs and system mapping, wireframes, requirement specifications, and prototypes.The Senior Business Consultant works with the Lead Business Consultant and Senior Project Managers to assist with daily operations exercising time management, communication and collaboration in a fast-paced environment to ensure the successful delivery of projects. The Senior Business Consultant will interface with Perficient technical and business delivery personnel, as well as vendors and customers on a regular basis. May mentor junior Consultants.Responsibilities:<ul><li>Build trusted client relationships through proactive account management and effective project delivery.</li><li>Establish knowledge of client business challenges and priorities to translate into opportunities.</li><li>Maintain regular client communication and satisfaction, ensuring opportunities and challenges are addressed in a timely manner.</li><li>Help deliver presentations to clients and management teams.</li><li>Contribute to project discoveries, kickoff, prepare proposals and statements of work following company standards.</li><li>Translate clients business needs into detailed business requirements documents, use cases and systems interaction diagrams.</li><li>Work with customers to establish approved wireframes and mock-ups for solutions.</li><li>Assist project team to establish high, mid, and micro level plans for project team.</li><li>Help to establish critical path, milestones, delivery dates, and review client deliverables to ensure they meet client acceptance criteria.</li><li>Provide leadership throughout the lifecycles of a project, guiding the understanding the project team has through design and development to ensure project requirements are met.</li><li>Help establish project test strategy, methodologies, test plans as well as assist with test execution.</li><li>Instill team commitment to company delivery methodologies and practices.</li></ul>Qualifications:<ul><li>Business analysts with expertise in governance, risk, and controls.</li><li>Detail-oriented individuals experienced in managing competing priorities and meeting tight deadlines.</li><li>Quick learners who can adapt and execute efficiently.</li><li>Audit experience is a plus.</li></ul>The salary range for this position takes into consideration a variety of factors, including but not limited to skill sets, level of experience, applicable office location, training, licensure and certifications, and other business and organizational needs. A reasonable estimate of the current salary range for this position is $57,798 to $109,700. Please note that the salary range posted reflects the base salary only and does not include benefits or any potential equity or variable bonus programs.Who We Are:Perficient is a leading global digital consultancy. We imagine, create, engineer, and run digital transformation solutions that help our clients exceed customers expectations, outpace competition, and grow their business. With unparalleled strategy, creative, and technology capabilities, our colleagues bring big thinking and innovative ideas, along with a practical approach to help our clients the worlds largest enterprises and biggest brands succeed.What We Believe:At Perficient, we promise to challenge, champion, and celebrate our people. You will experience a unique and collaborative culture that values every voice. Join our team, and youll become part of something truly special.Perficient, Inc. proudly provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, national origin, age, disability, genetic information, marital status, amnesty, or status as a protected veteran in accordance with applicable federal, state and local laws.Disability Accommodations:Perficient is committed to providing a barrier-free employment process with reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures. If you need assistance or accommodation due to a disability, please contact us.Disclaimer: The above statements are not intended to be a complete statement of job content, rather to act as a guide to the essential functions performed by the employee assigned to this classification. Management retains the discretion to add or change the duties of the position at any time. #J-18808-Ljbffr

Senior Data Analyst with Snowflake experience - NYC, Orlando or Pittsburgh  We currently have a career opportunity for a  Senior Data Analyst with Snowflake experience  to join our team located  Lake Mary, FL or Pittsburgh, PA.
We are seeking a skilled Data Analyst to join our team. The ideal candidate will have a strong foundation in SQL, extensive experience in data analysis and forensics, and proficiency in using Snowflake for querying and creating views. This role involves drilling down into complex datasets to uncover insights and support decision-making processes.
Responsibilities    SQL Expertise : Utilize SQL as the baseline for querying and manipulating data.
Data Analysis : Perform in-depth analysis to identify patterns, trends, and anomalies within large datasets.
Data Forensics : Investigate data to uncover discrepancies, fraud, or other irregularities.
Snowflake Proficiency : Use Snowflake for data warehousing, querying, and creating views to organize and present data effectively.
View Creation : Develop and maintain views in Snowflake to simplify complex queries and enhance data accessibility.
Reporting : Generate reports and dashboards to communicate findings to stakeholders.
Collaboration : Work closely with cross-functional teams to understand data needs and provide actionable insights.
Qualifications    Bachelor's degree  in Computer Science, Data Science, Statistics, or a related field.
Proven experience  in SQL and data analysis.
Strong analytical skills  with the ability to drill down into complex datasets.
Experience with Snowflake  and creating views.
Excellent problem-solving abilities  and attention to detail.
Effective communication skills  to present findings clearly and concisely.
Preferred Skills:
Knowledge of data visualization tools  (e.g., Tableau, Power BI).
Experience with machine learning  and statistical analysis.
Familiarity with ETL processes  and data integration.
The salary range for this position takes into consideration a variety of factors, including but not limited to skill sets, level of experience, applicable office location, training, licensure and certifications, and other business and organizational needs. The new hire salary range displays the minimum and maximum salary targets for this position across all US locations, and the range has not been adjusted for any specific state differentials. A reasonable estimate of the current salary range for this position is $64,974 to $149,880. Please note that the salary range posted reflects the base salary only and does not include benefits or any potential equity or variable bonus programs.
About Us  Perficient is a leading global digital consultancy. We imagine, create, engineer, and run digital transformation solutions that help our clients exceed customers’ expectations, outpace competition, and grow their business. With unparalleled strategy, creative, and technology capabilities, our colleagues bring big thinking and innovative ideas, along with a practical approach to help our clients – the world’s largest enterprises and biggest brands succeed.
At Perficient, we promise to challenge, champion, and celebrate our people. You will experience a unique and collaborative culture that values every voice. Join our team, and you’ll become part of something truly special.
Perficient, Inc. proudly provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, national origin, age, disability, genetic information, marital status, amnesty, or status as a protected veteran in accordance with applicable federal, state and local laws.
Disability Accommodations:
Perficient is committed to providing a barrier-free employment process with reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures. If you need assistance or accommodation due to a disability, please contact us.
Disclaimer:  The above statements are not intended to be a complete statement of job content, rather to act as a guide to the essential functions performed by the employee assigned to this classification. Management retains the discretion to add or change the duties of the position at any time.
#LI-MG1
Job Info   Job Identification 2025000901
Job Category Platforms & Technology
Posting Date 04/15/2025, 08:39 PM
Apply Before 07/31/2025, 08:39 PM
Job Schedule Full time
Locations 111 Broadway, New York, NY, 10006, US

#J-18808-Ljbffr

Job Description

We currently have a career opportunity for a  Senior Data Engineer  to join our Data & Analytics Team

The Lead Data Engineer will be responsible for designing, developing, and maintaining data pipelines and solutions to enable our client to harness the power of the data for further analytics. The engineer will work with modern data technologies, emphasizing  Snowflake and dbt (Data Build Tool)  to automate, build, test, and maintain the data infrastructure. Additionally, it is expected that people participate actively in all aspects of the data lifecycle and provide recommendations aligned with best practices within the process.

Job Overview:

As a Lead Technical Consultant, you will participate in all aspects of the software development lifecycle, which includes estimating, technical design, implementation, documentation, testing, deployment, and support of applications developed for our clients. As a member working in a team environment, you will work with solution architects and developers on the interpretation/translation of wireframes and creative designs into functional requirements, and subsequently into technical design.

Perficient is always looking for the best and brightest talent, and we need you! We're a quickly growing, global digital consulting leader, and we're transforming the world's largest enterprises and biggest brands. You'll work with the latest technologies, expand your skills, and become a part of our global community of talented, diverse, and knowledgeable colleagues.

Responsibilities

Lead the technical planning & requirements gathering phases, including estimating, developing, testing, managing projects, architecting, and delivering.
Serve as a technical lead and mentor. Provide technical support or leadership in the development and continual improvement of service.
Develop and maintain effective working relationships with team members.
Demonstrate the ability to adapt and work with team members of various experience levels.
Implements processes and systems to monitor data quality, ensuring production data is always accurate and available for key stakeholders and business processes that depend on it.
Performs data analysis required to troubleshoot data-related issues and assist in the resolution of data issues.
Works closely with a team of frontend and backend engineers, product managers, and analysts.
Designs data integrations and data quality framework.
Works closely with all business units and engineering teams to develop a strategy for long-term data platform architecture.
Qualifications   BS in Computer Science, Engineering, or related technical field.
Passionate data engineer with 6-10 years of experience, with a focus on designing and implementing data pipelines
Strong expertise in Snowflake, including data modeling, ETL, and data warehousing
Proficiency in DBT (Data Build Tool) for data transformation and management
Solid SQL skills and understanding of database systems
Experience with data integration, data processing, and data quality
Experience with object storage, data lakes, and lakehouses
Experience with version control tools such as Git
Team oriented, interpersonal, highly motivated, passionate, and creative team-player with the ability to develop and maintain collaborative relationships with all levels within and external to the organization
Familiarity with Azure Data Services, including Azure Data Factory, Azure Storage, and Azure Synapse, is a plus
Familiarity with Databricks is a plus
Knowledge of data processing technologies like Apache Spark and Kafka is a plus
Cloud platform certifications are a plus
Client-facing or consulting experience is highly preferred.
Ability to communicate effectively via multiple channels (verbal, written, etc.) with technical and non-technical staff.

The salary range for this position takes into consideration a variety of factors, including but not limited to skill sets, level of experience, applicable office location, training, licensure and certifications, and other business and organizational needs. The new hire salary range displays the minimum and maximum salary targets for this position across all US locations, and the range has not been adjusted for any specific state differentials. It is not typical for a candidate to be hired at or near the top of the range for their role, and compensation decisions are dependent on the unique facts and circumstances regarding each candidate. A reasonable estimate of the current salary range for this position is $ 73,008 to $ 170,640. Please note that the salary range posted reflects the base salary only and does not include benefits or any potential equity or variable bonus programs. Information regarding the benefits available for this position are in our benefits overview.

WHO WE ARE

Perficient is a leading global digital consultancy. We imagine, create, engineer, and run digital transformation solutions that help our clients exceed customers' expectations, outpace competition, and grow their business. With unparalleled strategy, creative, and technology capabilities, our colleagues bring big thinking and innovative ideas, along with a practical approach to help our clients - the world's largest enterprises and biggest brands succeed.

WHAT WE BELIEVE

At Perficient, we promise to challenge, champion, and celebrate our people. You will experience a unique and collaborative culture that values every voice. Join our team, and you'll become part of something truly special.

We believe in developing a workforce that is as diverse and inclusive as the clients we work with. We're committed to actively listening, learning, and acting to further advance our organization, our communities, and our future leaders... and we're not done yet.

Perficient, Inc. proudly provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, national origin, age, disability, genetic information, marital status, amnesty, or status as a protected veteran in accordance with applicable federal, state and local laws. Perficient, Inc. complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including, but not limited to, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training. Perficient, Inc. expressly prohibits any form of unlawful employee harassment based on race, color, religion, gender, sexual orientation, national origin, age, genetic information, disability, or covered veterans. Improper interference with the ability of Perficient, Inc. employees to perform their expected job duties is absolutely not tolerated.

Disability Accommodations:

Perficient is committed to providing a barrier-free employment process with reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures. If you need assistance or accommodation due to a disability, please contact us.

Disclaimer:  The above statements are not intended to be a complete statement of job content, rather to act as a guide to the essential functions performed by the employee assigned to this classification. Management retains the discretion to add or change the duties of the position at any time.

#LI-PS1

#LI-Remote

About Us

Perficient is always looking for the best and brightest talent and we need you! We're a quickly growing, global digital consulting leader, and we're transforming the world's largest enterprises and biggest brands. You'll work with the latest technologies, expand your skills, experience work-life balance, and become a part of our global community of talented, diverse, and knowledgeable colleagues.

We currently have a career opportunity for a Lead Data Analyst / Management to join our team located in Orlando, FL.
Job Overview :
The role of the Business Consultant is for individuals passionate about identifying and delivering the right Business solution for each client. Our Business Consultants have a keen Business orientation with an understanding of how technology can be effectively applied to meet a variety of Business needs.
Our Business Consultants fill a number of different roles on our project teams working with a variety of technologies for a wide range of clients. The specific responsibilities vary for each client and each project. Key to the success of our Business Consultants is the willingness and desire to quickly learn the client's industry and the unique requirements of each engagement and to fill whatever role may be required to best support our client's needs.
A Business Consultant thrives in challenging environments and accomplishes difficult assignments without significant supervision and instruction. Our Consultants can handle the stress of being accountable for delivery and: complete goals on time, practice strong attention to detail, persevere through tough obstacles, and do not get easily discouraged.
The Lead Business Consultant is a key delivery point of contact and will be involved in the strategic planning of an engagement or helping the client make decisions about their future IT direction. Once a project has begun, the Lead Business Consultant will facilitate key requirements with stakeholders and customers using standard and User Experience techniques. The Lead Business Consultant may be responsible for functional designs, detailed designs and system mapping, wireframes, requirement specifications, and prototypes.
The Lead Business Consultant works directly with Senior Project Managers and assist with daily operations exercising time management, communication and collaboration in a fast-paced environment to ensure the successful delivery of projects. The Lead Business Consultant will interface with Perficient technical and business delivery personnel, as well as vendors and customers on a regular basis. Will mentor junior Consultants.
Responsibilities
Build trusted client relationships through proactive account management and effective project delivery.
Establish knowledge of client business challenges and priorities to translate into opportunities.
Maintain regular client communication and satisfaction, ensuring opportunities and challenges are addressed in a timely manner.
Help deliver presentations to clients and management teams.
Contribute to project discoveries, kickoff, prepare proposals and statements of work following company standards.
Translate client's business needs into detailed business requirements documents, use cases and systems interaction diagrams.
Work with customers to establish approved wireframes and mock-ups for solutions.
Assist project team to establish high, mid, and micro level plans for project team.
Help to establish critical path, milestones, delivery dates, and review client deliverables to ensure they meet client acceptance criteria.
Provide leadership throughout the lifecycles of a project, guiding the understanding the project team has through design and development to ensure project requirements are met.
Help establish project test strategy, methodologies, test plans as well as assist with test execution.
Instill team commitment to company delivery methodologies and practices.
Qualifications
10+ years of experience in Data Management.
Experience with data lake, UCM / URM.
Ability to implement new processes, including data quality checks.
Experience/knowledge of controls and automation tools.
Experience with Contexa is a plus.
Experience working in an Agile environment.
Deep understanding of iterative development methodologies.
Excellent knowledge of current technologies and complex enterprise level applications.
Skilled ability to obtain, understand and respond strategically to client needs.
Highly detail oriented, well organized, and able to coordinate multiple projects simultaneously.
Strong analytical, problem solving and conflict resolution skills.
Energetic, motivated, service-oriented, and able to multi-task.
Proven track record of delivering on time, on budget, and meeting client commitments.
Excellent listening, oral, and written communication skills.
Excellent facilitation, presentation, and reporting skills.
Excellent interpersonal and teamwork skills.
Flexible to new situations and challenges.
Willingness to travel up to 50 percent.
Preferred skills and education :
Degree in Computer Science or Engineering.
Master's Degree.
Strong understanding of complex Internet based enterprise level applications.
Scrum or Product Owner certification.
Perficient full-time employees receive complete and competitive benefits. We offer a collaborative work environment, competitive compensation, generous work / life opportunities and an outstanding benefits package that includes paid time off plus holidays. In addition, all colleagues are eligible for a number of rewards and recognition programs including billable bonus opportunities. Encouraging a healthy work / life balance and providing our colleagues great benefits are just part of what makes Perficient a great place to work.
WHO WE ARE
Perficient is a leading global digital consultancy. We imagine, create, engineer, and run digital transformation solutions that help our clients exceed customers' expectations, outpace competition, and grow their business. With unparalleled strategy, creative, and technology capabilities, our colleagues bring big thinking and innovative ideas, along with a practical approach to help our clients - the world's largest enterprises and biggest brands succeed.
WHAT WE BELIEVE
At Perficient, we promise to challenge, champion, and celebrate our people. You will experience a unique and collaborative culture that values every voice. Join our team, and you'll become part of something truly special.
We believe in developing a workforce that is as diverse and inclusive as the clients we work with. We're committed to actively listening, learning, and acting to further advance our organization, our communities, and our future leaders.
Perficient, Inc. proudly provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, national origin, age, disability, genetic information, marital status, amnesty, or status as a protected veteran in accordance with applicable federal, state and local laws. Perficient, Inc. complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including, but not limited to, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training. Perficient, Inc. expressly prohibits any form of unlawful employee harassment based on race, color, religion, gender, sexual orientation, national origin, age, genetic information, disability, or covered veterans. Improper interference with the ability of Perficient, Inc. employees to perform their expected job duties is absolutely not tolerated.
Disability Accommodations :
Perficient is committed to providing a barrier-free employment process with reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures. If you need assistance or accommodation due to a disability, please contact us.
Disclaimer : The above statements are not intended to be a complete statement of job content, rather to act as a guide to the essential functions performed by the employee assigned to this classification. Management retains the discretion to add or change the duties of the position at any time.
#J-18808-Ljbffr

Job Description

We currently have a career opportunity for a  Senior Data Analyst with Snowflake experience  to join our team located  Lake Mary, FL or Pittsburgh, PA.

We are seeking a skilled Data Analyst to join our team. The ideal candidate will have a strong foundation in SQL, extensive experience in data analysis and forensics, and proficiency in using Snowflake for querying and creating views. This role involves drilling down into complex datasets to uncover insights and support decision-making processes.

Responsibilities

SQL Expertise : Utilize SQL as the baseline for querying and manipulating data.
Data Analysis : Perform in-depth analysis to identify patterns, trends, and anomalies within large datasets.
Data Forensics : Investigate data to uncover discrepancies, fraud, or other irregularities.
Snowflake Proficiency : Use Snowflake for data warehousing, querying, and creating views to organize and present data effectively.
View Creation : Develop and maintain views in Snowflake to simplify complex queries and enhance data accessibility.
Reporting : Generate reports and dashboards to communicate findings to stakeholders.
Collaboration : Work closely with cross-functional teams to understand data needs and provide actionable insights.
Qualifications     Bachelor's degree  in Computer Science, Data Science, Statistics, or a related field.
Proven experience  in SQL and data analysis.
Strong analytical skills  with the ability to drill down into complex datasets.
Experience with Snowflake  and creating views.
Excellent problem-solving abilities  and attention to detail.
Effective communication skills  to present findings clearly and concisely.
Preferred Skills:      Knowledge of data visualization tools  (e.g., Tableau, Power BI).
Experience with machine learning  and statistical analysis.
Familiarity with ETL processes  and data integration.

The salary range for this position takes into consideration a variety of factors, including but not limited to skill sets, level of experience, applicable office location, training, licensure and certifications, and other business and organizational needs. The new hire salary range displays the minimum and maximum salary targets for this position across all US locations, and the range has not been adjusted for any specific state differentials. It is not typical for a candidate to be hired at or near the top of the range for their role, and compensation decisions are dependent on the unique facts and circumstances regarding each candidate. A reasonable estimate of the current salary range for this position is $64,974 to $149,880. Please note that the salary range posted reflects the base salary only and does not include benefits or any potential equity or variable bonus programs. Information regarding the benefits available for this position are in our benefits overview.

WHO WE ARE

Perficient is a leading global digital consultancy. We imagine, create, engineer, and run digital transformation solutions that help our clients exceed customers' expectations, outpace competition, and grow their business. With unparalleled strategy, creative, and technology capabilities, our colleagues bring big thinking and innovative ideas, along with a practical approach to help our clients - the world's largest enterprises and biggest brands succeed.

WHAT WE BELIEVE

At Perficient, we promise to challenge, champion, and celebrate our people. You will experience a unique and collaborative culture that values every voice. Join our team, and you'll become part of something truly special.

We believe in developing a workforce that is as diverse and inclusive as the clients we work with. We're committed to actively listening, learning, and acting to further advance our organization, our communities, and our future leaders... and we're not done yet.

Perficient, Inc. proudly provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, national origin, age, disability, genetic information, marital status, amnesty, or status as a protected veteran in accordance with applicable federal, state and local laws. Perficient, Inc. complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including, but not limited to, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training. Perficient, Inc. expressly prohibits any form of unlawful employee harassment based on race, color, religion, gender, sexual orientation, national origin, age, genetic information, disability, or covered veterans. Improper interference with the ability of Perficient, Inc. employees to perform their expected job duties is absolutely not tolerated.

Disability Accommodations:

Perficient is committed to providing a barrier-free employment process with reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures. If you need assistance or accommodation due to a disability, please contact us.

Disclaimer:  The above statements are not intended to be a complete statement of job content, rather to act as a guide to the essential functions performed by the employee assigned to this classification. Management retains the discretion to add or change the duties of the position at any time.

#LI-MG1

About Us

Perficient is always looking for the best and brightest talent and we need you! We're a quickly growing, global digital consulting leader, and we're transforming the world's largest enterprises and biggest brands. You'll work with the latest technologies, expand your skills, experience work-life balance, and become a part of our global community of talented, diverse, and knowledgeable colleagues.

We currently have a career opportunity for an Social Media & Marketing Coordinator to join our team located in Monterrey, Mexico. We’re seeking a social media marketing professional looking to build their career with a global organization. Perficient is hiring a Social Media Marketing Associate Coordinator located in Monterrey, Mexico. (hybrid scheme)The Social Media Marketing Associate Coordinator supports the ongoing efforts of Perficient’s global social media efforts and Content and Communications team, assisting in the creation, curation, and cultivation of strategic content that aligns with Perficient’s overall global strategy and business objectives, with a strong focus on the U.S., Latin America, India and Europe markets. RESPONSIBILITIES <ul><li>Assist in the day-to-day management of Perficient’s social media calendar, adding, scheduling, and moving items through the workflow</li><li>Support collaborations with our creative design team to produce social-first graphics, videos and animations to drive followers and engagement</li><li>Assist in the deployment of organic and paid campaigns that promote the Perficient brand with the right message, right audience, right time across all channels</li><li>Brainstorm, create, and participate in content and videos for Perficient’s global social networks</li><li>Assist with gathering data and insights to support regular reporting and strategy assessments</li><li>Engage with audiences across all Perficient global social media channels, amplifying visibility and responding to messages and inquiries</li><li>Monitor brand ambassador partnerships for opportunities to amplify and engage</li><li>Monitor key market trends and conversations occurring on Perficient social networks</li><li>Stay up to date on social media trends and provide ongoing insights</li><li>Availability on site for taking photos and videos of events to post on social media in real time</li></ul> QUALIFICATIONS <ul><li>A bachelor’s level degree in marketing, journalism, communications, or business administration</li><li>One to two years’ experience in B2B social media, digital marketing, content marketing, communications, or journalism</li><li>Excellent written and verbal communication skills in English</li><li>Strong business acumen</li><li>Sound project management skills</li><li>Ability to work professionally with leaders throughout the organization</li><li>Detail-oriented and highly organized individual with the ability to multitask</li><li>Strong interpersonal and communication skills, highly motivated, autonomous and proactive</li><li>Team player, self-starter with a passion for technology who will demonstrate a commitment to elevating the group’s marketing mission</li><li>Desire for new learning opportunities and professional growth</li><li>IT industry and/or professional services experience is a plus</li></ul> Perficient full-time employees receive complete and competitive benefits. We offer a collaborative work environment, competitive compensation, generous work/life opportunities and an outstanding benefits package that includes paid time off plus holidays. In addition, all colleagues are eligible for a number of rewards and recognition programs including billable bonus opportunities. Encouraging a healthy work/life balance and providing our colleagues great benefits are just part of what makes Perficient a great place to work. WHO WE ARE Perficient is a leading global digital consultancy. We imagine, create, engineer, and run digital transformation solutions that help our clients exceed customers’ expectations, outpace competition, and grow their business. With unparalleled strategy, creative, and technology capabilities, our colleagues bring big thinking and innovative ideas, along with a practical approach to help our clients – the world’s largest enterprises and biggest brands succeed. WHAT WE BELIEVE At Perficient, we promise to challenge, champion, and celebrate our people. You will experience a unique and collaborative culture that values every voice. Join our team, and you’ll become part of something truly special. We believe in developing a workforce that is as diverse and inclusive as the clients we work with. We’re committed to actively listening, learning, and acting to further advance our organization, our communities, and our future leaders… and we’re not done yet. Perficient, Inc. proudly provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, national origin, age, disability, genetic information, marital status, amnesty, or status as a protected veteran in accordance with applicable federal, state and local laws. Perficient, Inc. complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including, but not limited to, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training. Perficient, Inc. expressly prohibits any form of unlawful employee harassment based on race, color, religion, gender, sexual orientation, national origin, age, genetic information, disability, or covered veterans. Improper interference with the ability of Perficient, Inc. employees to perform their expected job duties is absolutely not tolerated. Disability Accommodations: Perficient is committed to providing a barrier-free employment process with reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures. If you need assistance or accommodation due to a disability, please contact us. Disclaimer: The above statements are not intended to be a complete statement of job content, rather to act as a guide to the essential functions performed by the employee assigned to this classification. Management retains the discretion to add or change the duties of the position at any time. IMPORTANT INFORMATION: Applicants should ensure that their e-mail settings will receive e-mail from the iCIMS system otherwise, you could miss critical communications related to your application.

Perficient Business Intelligence Interview Guide

Overview

Perficient Business Intelligence Interview Process

Perficient Business Intelligence Interview Questions

Perficient Business Intelligence Jobs