Summary
Join DesignMind's top data and business intelligence consulting team as a Business Intelligence Consultant to deliver client engagements across various industries.
Requirements
- Hands-on experience with the full Business Intelligence stack, on-premises or in the cloud, using technologies such as Microsoft SQL Server, Azure SQL DB, Azure Synapse, Azure Analysis Service (AAS), Azure SQL Data Warehouse, or Snowflake
- Develop queries and transformations with SQL, T-SQL, Stored Procedures, Views, SQL Functions and Triggers
- Experience with database performance tuning
- Excellent verbal and written communication skills
- Strong problem-solving skills
Responsibilities
- Deliver client engagements across many different industries, throughout the entire consulting and development life cycles
- Develop queries and transformations with SQL, T-SQL, Stored Procedures, Views, SQL Functions and Triggers
- Experience with database performance tuning
- Gathering and documenting requirements based on discussions with business stakeholders and technical team members
- Be hands-on with the development of ETL/ELT, reports, dashboards, visualizations, and data models
Preferred Qualifications
- Prior consulting experience highly desired, but not required
- 3+ years with various forms of data modeling, including relational, star and snowflake schemas
- 2+ years with semantic layer design and development
- Experience with DAX (MDX a plus)