Senior Business Intelligence Consultant (California)
DesignMind4.0
Remote California
Job details
Estimated: $100,000 - $130,000 a year
Benefits
Health insuranceVision insuranceDental insurance401(k)
Job description

DesignMind is seeking several Senior Business Intelligence Consultants to join the top data and analytics consulting teams in the county.

DesignMind is a Microsoft Gold Partner for Data Analytics and Data Platform, and has partnerships with Snowflake, AWS, Tableau, Cloudera, Profisee, StreamSets, Looker, and other leading technology providers.

As a Senior Business Intelligence Consultant, you will have the opportunity to take a leadership role in client engagements across many different industries, throughout the entire consulting and development life cycles.

Client engagements can range from a 2-week Migration Assessment to an enterprise project spanning many months. Our team often delivers work in partnership with client employees, consultants, and senior stakeholders. Work is done in a mix of locations, on site, at our office, and remotely.

Some travel may be required at times for ths role.

This specific role is for applicants living in California. If you are located elsewhere within the United States, please apply to our Senior Business Intelligence Consultant (Remote) role.


Required Skills & Experience

Technical knowledge will be evaluated based on each candidate's work experience. Having the following capabilities is essential to your success in this role:

  • Hands-on experience with the full Business Intelligence stack, on-premises or in the cloud, using technologies such as the following:
    • Databases: Microsoft SQL Server, Azure SQL DB, Azure Synapse, Azure Analysis Service (AAS), Azure SQL Data Warehouse, AWS Redshift, Snowflake or equivalent.
    • ETL: SSIS, Azure Data Factory, Databricks, Talend, Informatica, StreamSets, Matillion, or equivalent.
    • Visualization: Reports, dashboards, mobile reporting, and governance with a focus on usability, performance, flexibility, testability, and standardization using tools such as Microsoft Power BI, Tableau, Looker, QlikView, and SSRS or equivalent.
  • 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.
  • Excellent verbal and written communication skills.
  • Strong analytical and problem-solving skills.


Preferred Skills & Experience

  • Prior consulting experience highly desired
  • 5+ years with various forms of data modeling, including relational, star and snowflake schemas
  • 3+ years with semantic layer design and development
  • Experience with DAX (MDX a plus)


Nice to Have Skills & Experience

  • Pre-sales (Discovery, Project Scoping, Labor Estimation, Drafting SOWs)
  • Master Data Management (Profisee, Informatica)
  • Data Quality Management
  • Data Governance
  • Definable contributions on BI platform migration(s)
  • Machine Learning, Artificial Intelligence, Data Science


What's our Mission?

Great people working together with passion, enthusiasm, and commitment to consistently deliver high quality, high value services that fully satisfy the needs of every client. Focus on developing fulfilling long-term relationships with clients, partners, the technical community, and fellow team members.


What Makes DesignMind a Great Place to Work?

Awesome clients, cutting edge projects, a great team who really likes to work together. DesignMind recognizes the value of diversity, supports professional development, and celebrates the achievements of our team members.

DesignMind offers competitive compensation and benefits, including Medical, Dental, Vision, and 401(k). At this time, sponsorship is not available.

report job
Protect yourself
Company details

Headquarters

268 Bush St #2823 San Francisco, CA 94104

Employee

11 to 50

Revenue

$5M to $25M (USD)

Industry

Consulting and Business Services

Company Description
DesignMind is a data engineering and data analytics consulting firm specializing in data architecture and analysis. Our clients are in San Francisco, Silicon Valley, and throughout the U.S. We help organizations organize, maintain, understand, and optimize their data. DesignMind consultants are experts in Business Intelligence, Cloud, Application Development, Database, and Data Analytics technologies. DesignMind is a Microsoft Certified Gold Partner specializing in Business Intelligence, Data Platform, Data Science, and Custom Software Development. Our team specializes in designing and developing Enterprise Data Warehouses, Data Marts, Self-Service BI, and custom Data Products & Platforms.
Company ratings
  • Overall
    4.0
  • Company & Benefits
    4.0 / 5
  • Culture & Values
    4.0 / 5
  • Career Opportunities
    3.3 / 5
  • Work/Life Balance
    3.5 / 5
  • Senior Management
    3.8 / 5
Company reviews
"BI and Data Consultancy that favors the consultants"
Current EmployeeEvent Coordinator
The best thing about DesignMind is how much they care for the consultants. I really enjoy working here. The only limitations are the ones you put on yourself.
Pros:

"They pretend that they're bigger and more important than they actually are"
Former EmployeeSoftware Architect
I developed ideas that were fundable. Rather than having me work on these projects that I had brainstormed with the client and had the original idea, they gave the project to a new mobile group that they were developing. This was an unpopular decision with other senior members, who then left at the same time that I did. A disappointing place to work.
Cons:

"Great engagements and team"
Current EmployeeBusiness Consultant
There’s always a lot to learn on every new contract. From my perspective, our consultants dedication to project completion and resulting client satisfaction is an inspiring thing to be apart of. With many global enterprise clients, who often retain us for long term services, to a range of clients that can be short to mid term, the Designmind culture promotes the sharing of experiences, challenges and take-aways from every project. As consultants, we often work closely on site with clients on a peer to peer basis. On site work will range from not too technical... to more data and business driven. That said, we’re trained to be able to address client’s needs at any level and offer the best solution which is efficacious, cost-effective and easily maintainable. The DesignMind culture thrives with an ethos of hard work and collaboration. It also knows how to have a good time; at office happy hours, movies and off sites.
Pros:
Cons:

"Great Company"
Former EmployeeIT
DesignMind is a great company that would be perfect for a skilled data analyst. It has a very friendly culture and talented individuals working there.