Data Analyst (CRM Administrator)

Kansas City, MO, US, 64106

Applications have closed

JE Dunn Construction

JE Dunn is one of the largest domestic general building contractors in the United States with our successful portfolio spanning across dozens of Industries.

View all jobs at JE Dunn Construction

Best People + Right Culture. These are the driving forces behind JE Dunn’s success.

By hiring inspired people, giving them interesting and challenging work, enabling them with innovative tools, and letting them share in the company’s rewards, we’ve found a sustainable way to grow in our industry for the last 100+ years.

Our diverse teams around the country strive to enrich lives through inspired people and places everyday, and we need inspired people like you to join us in our pursuit of building perfection.

Role Summary

The Data Analyst (CRM Administrator) will support the strategic development and ongoing governance of our Customer Relationship Management (CRM) system, Microsoft Dynamics in addition to collecting, compiling, transforming, and analyzing data, metrics, and statistics from various internal and external sources to make recommendations to internal operations groups. This position ultimately will serve as a Microsoft Dynamics subject matter expert as it relates to best practices, workflows, integrations and how to maximize the tool to provide value to the firm This position will assist with developing data strategy for the assigned department(s). All activities will be performed in support of the strategy, vision and values of JE Dunn.

  • Autonomy & Decision-Making: Makes decisions on assigned areas of responsibility, provides recommendations to supervisor, and refers all exceptions to supervisor, as needed.
  • Career Path: Various

Key Role Responsibilities - Core

CRM RESPONSIBILITIES

  • Ensure performance, optimization and evolution of the CRM (Microsoft Dynamics)
  • Ensuring data integrity and security is maintained within the CRM
  • Collaborate on CRM system updates and coordinate seamless execution with minimal downtime
  • Provide CRM user training and support on an ongoing basis
  • Work with IT to integrate CRM with other business systems
  • Work with internal stakeholders on customization and configuration of the CRM to align with future enhanced business processes and workflows
  • Develop and maintain advanced reporting
  • Create and maintain CRM documentation on processes, policies, application, and configuration.
  • Manage and maintain CRM licenses and permissions
  • Provide ongoing CRM troubleshooting and user support services
  • Collaborate on the development and delivery of CRM training programs

 

DATA ANALYST FAMILY – CORE

  • Collects and compiles metrics and data from a variety of internal and external sources.
  • Generates and analyzes reports, providing insights and recommendations to management.
  • Analyzes data and statistics for trends and patterns.
  • Prepares data analysis results reports and presents findings to senior leadership.
  • Identifies and recommends reasonable short- and long-term goals, milestones, and benchmarks for key performance metrics.
  • Partners with the assigned department(s) to understand their data needs and develops reports and dashboards to help accomplish initiatives.
  • May conduct or assist with conducting audits to ensure that data is accurate.
  • Develops and supports the assigned department(s)’s data governance.
  • Ensures compliance with data privacy regulations and best practices.
  • May guide or assist with the data development of all areas within the assigned department(s).

Key Role Responsibilities - Additional Core

  • Other duties as assigned.
  • Conducts actions in a professional and unbiased manner.
  • Complies with all company and site policies and best practice standards.
  • Continuously develops proficiency and understanding in the role.
  • Maintains a professional appearance and work space.
  • Participates in and complies with all company safety and quality programs and procedures.
  • Utilizes relevant JE Dunn technology to support all assigned responsibilities.

Knowledge, Skills & Abilities

  • Ability to perform work accurately and completely, and in a timely manner
  • Communication skills, verbal and written
  • Proficiency in MS Office – Intermediate
  • Proficiency in MS Excel – Intermediate
  • Proficiency in Power BI
  • Knowledge of working with Power BI on-premises data gateway
  • Knowledge of DAX queries in Power BI Desktop
  • Knowledge of integrations and API development
  • Ability to connect to multiple data sets, import data, and transform the data to support data visualizations and further analyses
  • Ability to create advanced level calculations on data sets
  • Proficiency in delivering data visualizations to internal customers based on project requirements
  • Ability to compile statistics and prepare statistical reports
  • Time management skills
  • Listening skills
  • Ability to prioritize multiple projects
  • Attention to detail and the ability to evaluate data against expected results
  • Ability to influence change through innovation and process improvement
  • Ability to think analytically for translating data into informative visuals and reports
  • Ability to communicate to executive audiences and deliver results through influence
  • Ability to build relationships and collaborate within a team, internally and externally

Education

  • Bachelor’s degree in data science and analytics, or related field (Required)
  • In lieu of the above requirements, relevant experience will be considered.

Experience

  • 0-2 years business intelligence (Microsoft Power stack, i.e. Power BI, Excel, Power Pivot, Power Apps, Power Automate) or data visualization experience (Preferred)
  • 0-2 years data analysis experience (Preferred)

Working Environment

  • Must be able to lift up to 10 pounds
  • Typically travel is not required
  • Normal office environment
  • Frequent activity: Sitting, Viewing Computer Screen
  • Occasional activity: Standing, Walking, Reaching above Shoulder

Benefits Information

The benefits package aligned to this position is Professional Non-Union. Please click the link below for more details.

Click here for benefits details

JE Dunn Construction 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. JE Dunn Construction is a background screening, drug-free workplace.

JE Dunn provides reasonable accommodations to qualified individuals with disabilities. If you would like to request a reasonable accommodation in order to apply for a job, please submit your request to accommodations@jedunn.com

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

* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰

Job stats:  5  5  0
Category: Analyst Jobs

Tags: API Development APIs Business Intelligence Data analysis Data governance Data strategy Data visualization Excel Power BI Privacy Security Statistics

Perks/benefits: Career development Team events

Region: North America
Country: United States

More jobs like this