Business Intelligence Consultant

3 weeks ago


Ann Arbor, United States DesignMind Full time

DesignMind

is seeking a Business Intelligence Consultant to join one of the country’s top data and business intelligence consulting teams.

This role is local to the Ann Arbor area

.

DesignMind is a

Microsoft Gold Partner

for several Data related competencies, and has partnerships with Snowflake, AWS, Tableau, Cloudera, Profisee, StreamSets, Looker, and other leading technology providers.

As a Business Intelligence Consultant, you will have the opportunity to deliver 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.

Most of your work will be done remotely, but there will be times when travel to client sites will be essential. Also, due to the nature of our work background checks will be required.

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, or Snowflake.

ETL : SSIS, Azure Data Factory, Databricks, Talend, StreamSets, 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, 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 problem-solving skills.

Preferred Skills & Experience

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)

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)

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.

#J-18808-Ljbffr



  • Ann Arbor, United States Clarivate Full time

    We are seeking a Senior Director, Product Management – Patent Intelligence to drive the commercial strategy and go-to-market execution for Clarivate’s Patent Intelligence, Search, and Analytics group. You will support customers in developing, protecting, and investing in their intellectual property (IP) and R&D. Collaborate with cross-functional teams...

  • Solutions Consultant

    3 weeks ago


    Ann Arbor, United States Pyrovio Full time

    SOLUTIONS CONSULTANT – BUSINESS AND IT, MI DESCRIPTION: The Consultant will work with diverse clients ranging from small and medium size enterprises to Fortune 100 firms. Working in a team environment with internal and Client stakeholders, the consultant will develop, analyze, and architect solutions to address clients' business and IT processes &...


  • Ann Arbor, United States Quantum Talent Management Full time

    Job DescriptionJob Description(REMOTE)Position DescriptionThe Senior Technical Consultant is a SyteLine developer with 5 plus years of experience who provides billable services to customers in support of their SyteLine system. Depending on your skill set, a Technical Consultant may also provide other development or technical services, which may be unrelated...

  • Business Analyst

    2 weeks ago


    Ann Arbor, United States Pyrovio Full time

    Business Analyst – Pyrovio - Remote, US Remote Full Time Experienced Are you a Business Analyst with a desire to work with a rapidly growing company helping Fortune 500 companies achieve performance excellence? About Us: We help organizations successfully develop and implement their strategies. We assist a diverse client base across all industries in...


  • Ann Arbor, United States Pyrovio Full time

    Consultant – UML Documentation, Data and Process Modeling Description : This position is for a Consultant with a strength in process development, mapping and improvement for business and IT organizations. The Consultant will work with diverse clients ranging from small and medium size enterprises to Fortune 100 firms. Working in a team environment with...


  • Ann Arbor, United States Pyrovio Full time

    Consultant - UML Documentation, Data and Process Modeling Description: This position is for a Consultant with a strength in process development, mapping and improvement for business and IT organizations. The Consultant will work with diverse clients ranging from small and medium size enterprises to Fortune 100 firms. Working in a team environment with...


  • Ann Arbor, United States Infiniti Ann Arbor Full time

    Job DescriptionJob DescriptionJob Description:AUTOMOTIVE SALES CONSULTANT Are you interested in joining a growing business that is committed to family, promotes employees from within, is passionate about protecting the environment, has an inspiring company culture, and is actively involved with the community and local charities? If so, this opportunity might...


  • Ann Arbor, United States Ramboll US Corporation Full time

    Company Description Ramboll is a global multi-disciplinary engineering, design, and consultancy company. We have 16,500 employees worldwide, with 300 offices across 35 countries, including 59 offices in the US. Joining Ramboll means working for a company that strives to make a difference - for our employees, clients, and society. We truly support and...


  • Ann Arbor, United States Ramboll Full time

    Company Description Ramboll is a global multi-disciplinary engineering, design, and consultancy company. We have 16,500 employees worldwide, with 300 offices across 35 countries, including 59 offices in the US. Joining Ramboll means working for a company that strives to make a difference – for our employees, clients, and society. We truly support and...


  • Ann Arbor, United States LaFontaine Buick GMC of Ann Arbor Full time

    Job DescriptionJob DescriptionJob Description:Are you interested in joining a growing business that is committed to family, promotes employees from within, is passionate about protecting the environment, has an inspiring company culture, and is actively involved with the community and local charities? If so, this opportunity might be for you! THE POSITION:...


  • Ann Arbor, United States Ramboll Group AS Full time

    Lead Consultant, Investigation and Remediation Applicants must be currently authorized to work in the United States on a full-time basis. No sponsorship is available for this position. Ramboll has adopted a hybrid model, with a combination of remote and in-person working. A successful candidate would ideally be based in our Ann Arbor office, but a fully...


  • Ann Arbor, United States Fidelity Investments Full time

    Job Description: Financial Consultant If you no longer want to spend your time on sourcing new clients and would rather have the time to deepen relationships and create complex financial plans, then join a team that is a stable industry leader. Fidelity provides a business model with an existing client base and institutional feeders of business that is...


  • Ann Arbor, United States Hylant Full time

    Description The Opportunity: The Client Service Assistant is responsible for supporting the commercial service team by providing excellent service and deliverables to external and internal clients in accordance with Hylant standards. This enables continuous growth & development of insurance knowledge & professionalism to the highest level possible....

  • Business Analyst

    2 weeks ago


    Ann Arbor, United States AccumTech Full time

    As a Business Analyst at AccumTech you will join a cross functional team in managing a sophisticated healthcare data integration system. You will work directly with customers and partners to become a subject matter expert on their processes, needs, and capabilities. You will help investigate and resolve issues in complex data processing systems, perform data...


  • Ann Arbor, United States Ramboll US Corporation Full time

    Company DescriptionJob Description Applicants must be currently authorized to work in the United States on a full-time basis. No sponsorship is available for this position. Ramboll has adopted a hybrid model, with a combination of remote and in-person working. A successful candidate would ideally be based in our Ann Arbor office, but a fully remote work...


  • Ann Arbor, United States Yeo & Yeo Full time

    It’s people like you that make us great! At Yeo & Yeo, we recognize that the champions behind our success are our people. We are a people-first organization fully committed to creating a dynamic work environment that values your contributions, supports your professional growth, and allows you to enjoy life outside the office with flexible remote, hybrid,...


  • Ann Arbor, United States Ramboll US Corporation Full time

    Company DescriptionJob Description Applicants must be currently authorized to work in the United States on a full-time basis. No sponsorship is available for this position. Ramboll has adopted a hybrid model, with a combination of remote and in-person working.A successful candidate would ideally be based in our Ann Arbor office, but a fully remote work...

  • Business Analyst

    7 days ago


    Ann Arbor, United States AccumTech Full time

    Job DescriptionJob DescriptionAs a Business Analyst at AccumTech you will join a cross functional team in managing a sophisticated healthcare data integration system. You will work directly with customers and partners to become a subject matter expert on their processes, needs, and capabilities. You will help investigate and resolve issues in complex data...

  • Business Analyst

    1 month ago


    Ann Arbor, United States AccumTech Full time

    Job DescriptionJob DescriptionAs a Business Analyst at AccumTech you will join a cross functional team in managing a sophisticated healthcare data integration system. You will work directly with customers and partners to become a subject matter expert on their processes, needs, and capabilities. You will help investigate and resolve issues in complex data...


  • Ann Arbor, Michigan, United States Ramboll Full time

    Company DescriptionRamboll is a global multi-disciplinary engineering, design, and consultancy company. We have 16,500 employees worldwide, with 300 offices across 35 countries, including 59 offices in the US.Joining Ramboll means working for a company that strives to make a difference – for our employees, clients, and society. We truly support and...