| POSITION | Sr. Analytics Consultant |
| LOCATION | Need to be local to DFW - if on the Dallas side need to be open to relo to Fort Worth side Hybrid in FTW Tue thur Thursday |
| REQUIRED SKILLS | Need to have a strong understanding of data and be able to discuss data modeling / star schema Need to have strong SQL experience Strong documentation experience - putting together BRDs FRDs etc. Strong experience with Power BI We need a client-facing professional with strong communication and problem-solving skills a solid background in Microsoft tools: proficiency in Power BI (mandatory) SQL expertise and familiarity with Fabric Role Profile - Business-facing role
- Communication and problem-solving are the most important skills- work directly with all levels of the business
- Must clearly explain thinking ask clarifying questions and engage stakeholders
- Consultative mindset
- Needs to ask open-ended questions
- Must dig in and consistently ask why to understand business context
- Visualization-first
- Take ambiguous problems and translate them into clear visuals
- Strong SQL and Power BI skills are essential (tableau could also work)
Technical Expectations - SQL
- Comfortable with simple and complex joins
- Understands aggregations and grouping logic
- Able to explain why a query is written a certain way
- Data Warehousing
- Has queried data warehouses before
- Understands star schemas / dimensional models
- Does not need to be a data modeler
- Reporting
- Experience reporting directly against a data warehouse
- Knows when to query fact vs. dimension tables
- Microsoft Fabric
- Nice to have but not required
- Not a deciding factor for the role
Interview Feedback Insight - Prior candidate struggled due to:
- Weak problem-solving approach
- Poor communication during role-play
- May do some live role-play does candidate ask open ended questions/ try to understand the business.
- Ability to think on the fly
- How candidates ask questions and clarify requirements
- Candidates must demonstrate:
- Strong communication
- Professional presence
- Ability to guide conversations not just answer questions
Sample Technical & Scenario-Based Interview Questions SQL Fundamentals - How would you join two tables together
- When would you use INNER vs LEFT JOIN
- How do you aggregate data
- Sample --- Explain GROUP BY SUM COUNT AVG
|
POSITION Sr. Analytics Consultant LOCATION Need to be local to DFW - if on the Dallas side need to be open to relo to Fort Worth side Hybrid in FTW Tue thur Thursday REQUIRED SKILLS Need to have a strong understanding of data and be able to discuss data modeling / star schema...
| POSITION | Sr. Analytics Consultant |
| LOCATION | Need to be local to DFW - if on the Dallas side need to be open to relo to Fort Worth side Hybrid in FTW Tue thur Thursday |
| REQUIRED SKILLS | Need to have a strong understanding of data and be able to discuss data modeling / star schema Need to have strong SQL experience Strong documentation experience - putting together BRDs FRDs etc. Strong experience with Power BI We need a client-facing professional with strong communication and problem-solving skills a solid background in Microsoft tools: proficiency in Power BI (mandatory) SQL expertise and familiarity with Fabric Role Profile - Business-facing role
- Communication and problem-solving are the most important skills- work directly with all levels of the business
- Must clearly explain thinking ask clarifying questions and engage stakeholders
- Consultative mindset
- Needs to ask open-ended questions
- Must dig in and consistently ask why to understand business context
- Visualization-first
- Take ambiguous problems and translate them into clear visuals
- Strong SQL and Power BI skills are essential (tableau could also work)
Technical Expectations - SQL
- Comfortable with simple and complex joins
- Understands aggregations and grouping logic
- Able to explain why a query is written a certain way
- Data Warehousing
- Has queried data warehouses before
- Understands star schemas / dimensional models
- Does not need to be a data modeler
- Reporting
- Experience reporting directly against a data warehouse
- Knows when to query fact vs. dimension tables
- Microsoft Fabric
- Nice to have but not required
- Not a deciding factor for the role
Interview Feedback Insight - Prior candidate struggled due to:
- Weak problem-solving approach
- Poor communication during role-play
- May do some live role-play does candidate ask open ended questions/ try to understand the business.
- Ability to think on the fly
- How candidates ask questions and clarify requirements
- Candidates must demonstrate:
- Strong communication
- Professional presence
- Ability to guide conversations not just answer questions
Sample Technical & Scenario-Based Interview Questions SQL Fundamentals - How would you join two tables together
- When would you use INNER vs LEFT JOIN
- How do you aggregate data
- Sample --- Explain GROUP BY SUM COUNT AVG
|
View more
View less
Job Location:
Monthly Salary:
Not Disclosed
Posted on:
4 hours ago
Vacancies:
1 Vacancy
