Data Analyst-BI Developer III

Kansas City, MO, United States

Applications have closed

Company Description

CRB's nearly 1,800 expert professionals drive innovative, life-changing and life-saving solutions for manufacturers in the life sciences and food and beverage industries. Our mission, vision and core values put client satisfaction and employee experience at the center of everything we do. See us at crbgroup.com.

CRB was founded (and still headquartered) in Kansas City in 1984. We've certainly grown since then, now with Construction Projects from Coast to Coast and a total of twenty-one offices Worldwide, with our newest location in Jacksonville, FL.

Our proven track record of success within the Life Sciences along with the Food & Beverage Industry has been a primary contributing factor to our growth and success. Our Senior Leadership Team along with our Subject Matter Experts have played an instrumental role in maintaining and building long-lasting relationships and have demonstrated the ability to mentor, guide and train the next generation of Consulting Professionals.

Job Description

CRB is looking for an energetic, self-motivated, pro-active, organized, and well-rounded individuals that have an advanced understanding of Microsoft’s data, reporting, and business intelligence tools to assist in delivering on our internal data and business intelligence initiatives. 

The successful candidate must possess the skills required to successfully execute project tasks, have a strong work ethic, and be a dynamic team player. This person will be expected to execute work on one or more data or analytics projects simultaneously as delegated by the Information Director. Project work will include the planning and delivery of value-added ETL, Reporting, and analytical capabilities that will provide actionable information to the business.

Responsibilities

  • Assist in the collection of data related business requirements, and the development of associated technical specifications
  • Manage and utilize existing processes to extract, transform, and load data into our enterprise data infrastructure
  • Utilize the Enterprise Data Model to develop reports, dashboards, and other analytics artifacts
  • Prepare data for report consumption 
  • Leverage and manage existing data models, metrics, KPIs, Reports, and Dashboards
  • Provide advice to stakeholders on the usage, interpretation, and analytic value of business data
  • Provide analytical assistance, and knowledge transfer to business users to aid their self-service analysis efforts
  • Assist end users in the use of Excel, Power BI, and the consumption of corporate data models
  • Participate in discipline related internal and external project communication and coordination
  • Set and execute professional development goals

Travel as required for project development and execution

Qualifications

  • Bachelor’s Degree or equivalent experience
  • 4+ years’ experience designing Reports and Dashboards using reporting and/or analytical tools such as SSRS, Tableau, Power BI, etc.
  • 4+ years of experience working with MS SQL Server and Azure SQL Database
  • 4+ years of experience developing ETL processes with data warehouses
  • 4+ years of experience with Microsoft BI Stack (SSIS, SSRS and SSAS)
  • 3+ years’ experience developing data models from OLTP, Data Warehouse, Data Mart, or Analysis Services solutions
  • Experience using Azure Data Factory, Azure Data Lakes, and associated technologies
  • Demonstrable understanding of Data Warehousing methodologies and concepts to store and model the data (Kimball)
  • Proficiency authoring SQL queries, tables, views, stored procedures, and functions
  • Proficiency using Power BI Desktop, and advanced Microsoft Excel features including Power Query, M and DAX
  • Exposure to developer tools such as Azure DevOps, Git, TFS/TFVC
  • Experience with other languages, such as C#, VB, PowerShell, Python is a plus
  • Extreme attention to detail and accuracy a must
  • Excellent verbal/written communication skills required
  • Experience with accounting terms and concepts preferred
  • Experience with R language preferred

Additional Information

All your information will be kept confidential according to EEO guidelines.

CRB is committed to hiring and retaining a diverse workforce. We are proud to be an Equal Opportunity/Affirmative Action Employer and it is our policy to provide equal opportunity to all people without regard to race, color, religion, national origin, ancestry, marital status, veteran status, age, disability, pregnancy, genetic information, citizenship status, sex, sexual orientation, gender identity or any other legally protected category. Employment is contingent on background screening.

CRB does not accept unsolicited resumes from search firms or agencies. Any resume submitted to any employee of CRB without a prior written search agreement will be considered unsolicited and the property of CRB. Please, no phone calls or emails.

CRB offers a complete and competitive benefit package designed to meet individual and family needs.

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Tags: Azure Business Intelligence Consulting Data warehouse Data Warehousing DevOps ETL Excel Git KPIs MS SQL Power BI Python R SQL SSIS Tableau

Region: North America
Country: United States
Job stats:  3  1  0

More jobs like this

Explore more AI, ML, Data Science career opportunities

Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.