Data Analyst

LocationKansas City, MO
Job TypeFull-time

About This Job


Company Description

CRB's nearly 1,400 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.

As an AEC firm, we proudly specialize in industries that inherently carry important social responsibility - we recognize our impact and influence in the communities we serve and pursue corporate responsibility through the lens of people, community, and planet. From oncology and rare disorders to COVID-19 or alternative proteins, our design and construction projects are pioneering solutions addressing important issues such as food scarcity and global health.


Job Description

CRB is looking for an energetic, self-motivated, pro-active, organized, and well-rounded individual that has 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 plan and execute multiple, simultaneous, large or long duration projects. In addition to project work, this individual will work with peers to assist in the identification, planning, and delivery of strategic infrastructure and analytical capabilities that will provide actionable information to the business.


Remote work option may be considered


Responsibilities

Elicit data related business requirements from stakeholders and develop or approve associated technical specifications
Contribute to the development of standard methods and best practices for the transformation and preparation of data for reporting, analytics, and self-service activities
Apply advanced statistical techniques and predictive models to drive strategic decision-making.
Leverage and enhance the Enterprise Data Model to deliver value to the organization
Develop and deliver secured, robust data models to business users
Work with stakeholders to develop new metrics, KPIs, Reports, and Dashboards
Provide advice to departments and stakeholders on the usage, interpretation, and analytic value of business data
Lead cross-functional teams and collaborate with various departments to support data-driven initiatives.
Participate in discipline related internal and external project communication and coordination
Ensure the accuracy, completeness, and reliability of data used for analysis.
Adhere to data protection regulations and ensure confidentiality of sensitive information.
Apply data team best practices regarding documentation, access, and security.
Mentor junior data analysts and contribute to their professional growth within the organization.
Explore and recommend new data technologies and analytical tools to enhance business insights.
Set and execute professional development goals to keep abreast of emerging technologies, services, and methods.
Travel as required for project development and execution


Qualifications

Bachelor’s Degree or equivalent experience
7+ years’ experience designing Reports and Dashboards using reporting and/or analytical tools such as SSRS, Tableau, Power BI, etc.
7+ years of experience working with MS SQL Server and Azure SQL Database
7+ years of experience developing ETL processes with data warehouses
7+ years of experience with Microsoft BI Stack (SSIS, SSRS and SSAS)
7+ years’ experience developing data models from OLTP, Data Warehouse, Data Mart, or Analysis Services solutions
Proficiency using Azure Data Factory, Azure Data Lakes, and associated technologies
Expert proficiency in Data Warehousing methodologies and concepts to store and model the data (Kimball)
Expert proficiency authoring SQL queries, tables, views, stored procedures, and functions
Advanced proficiency using Power BI Desktop, and advanced Microsoft Excel features including Power Query, M and DAX
Experience using developer tools such as Azure DevOps, Git, TFS/TFVC
Experience with other languages, such as C#, VB, PowerShell, Python is a plus
Familiarity with D365 ERP modules (e.g., Finance and Operations, Customer Engagement) preferred.
Understanding of D365 data structures, entities, and integration points preferred.
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.

Trending Jobs

company-logo

Assistant General Manager, Navy Yard Electric Utility

Job TypeFull-time
Salary
$108000 - $108000
Philadelphia, Pennsylvania
17 days ago
company-logo

Electrical Engineer

Dudley Staffing
Job TypeFull-time
Salary
$55 - $75
Canonsburg, Pennsylvania
3 months ago
company-logo

Accounts Payable Clerk

Job TypeFull-time
Salary
$65000 - $65000
Dallas, Texas
19 days ago
DM

Apprentice Lineman

Delta Montrose Electric Association
Job TypeFull-time
 
Montrose, CO
22 days ago
company-logo

Division Order Analyst

Job TypeFull-time
 
Dallas, Texas
9 days ago
company-logo

contract landman

HPS Oil & Gas Properties
Job TypeFull-time
 
Lafayette, Louisiana
3 months ago
company-logo

Oil and Gas Land and Title Analyst - SAM Associate II

Bank of America
Job TypeFull-time
 
Dallas, Texas
about 1 month ago
company-logo

Attorney

Toeppich & Associates
Job TypeFull-time
 
Houston, Texas
about 1 year ago
company-logo

Apprentice Lineman I

San Patricio Electric Cooperative, Inc.
Job TypeFull-time
 
Sinton, TX
about 1 month ago
HM

Lineworker Apprentice I

Henderson Municipal Power & Light
Job TypeFull-time
 
Henderson, KY
26 days ago
company-logo

Associate Attorney

Buffalo Biodiesel Inc.
Job TypeFull-time
 
Buffalo, NY
29 days ago
company-logo

Senior Landman

Greenlake Energy
Job TypeFull-time
 
Austin, Texas
about 1 month ago
company-logo

Foundry Professionals

Penticton Foundry
Job TypeFull-time
 
British Columbia, Canada
10 days ago
company-logo

Apprentice Lineman

Southern Pine Electric
Job TypeFull-time
 
Brandon, MS
23 days ago
company-logo

Contracts Administrator

Third Coast
Job TypeFull-time
Salary
$70000 - $85000
Houston, Texas
23 days ago
company-logo

Electrical Designer

Dudley Staffing
Job TypeFull-time
Salary
$45 - $60
Canonsburg, Pennsylvania
3 months ago
company-logo

Deckhand

Ballard Marine Construction
Job TypeFull-time
 
Bradenton, FL
12 days ago
company-logo

Residential Helper

Waste Pro
 
Columbus, MS
26 days ago
company-logo

Groundman (Local 659) - Medford, Oregon - #113370

PacifiCorp
Job TypeFull-time
Salary
$73560 - $73560
Medford, OR
25 days ago
company-logo

Operator Assistant Trainee - Frac Acid

Halliburton
Job TypeFull-time
 
Zanesville, OH
26 days ago