Data Analytics Specialist

at  Crawford Murphy Tilly Inc

DATA ANALYTICS SPECIALIST - CORPORATE SUPPORT

Hiring Site: Springfield, IL - Aurora, IL - St. Louis, MO - Indianapolis, IN - Office location may be altered depending on candidate availability.
Crawford, Murphy & Tilly, Inc. (CMT), named a Zweig Group’s “Best Firms to Work For.” is a consulting firm with a team of engineers, planners and other related design professionals is actively seeking to add a talented Data Analytics Specialist to our Corporate Support Business Unit. This position is responsible for leading and completing special projects in support of the four operational business units. These projects will include organizing CMT’s data warehouse, compiling and analyzing data, utilizing Azure Open AI (and the Microsoft stack), as well as promoting the use of machine learning and generative AI across CMT. This role will be complementary to the design processes within the operational units and will work closely with the existing technology team and development staff.

KNOWLEDGE, SKILLS & ABILITIES (KSAS)

To execute responsibilities, data analytics engineers should possess the following KSAs:

• Excellent technical skills in data research, data analysis and machine learning.
• Ability to learn civil engineering work flows to allow for effective data analysis
• Advanced analytical, critical thinking, and problem-solving skills
• Knowledge of data security and quality assurance procedures
• Knowledge of Azure Data Lakes, Azure OpenAI, and machine learning technologies
• Advanced communication and organizational skills
• Ability to design and utilize SQL databases and analysis tools for data analytics projects
• Strong project management skills
• Proficient software skills in Microsoft Office Suite including Power BI

Education & Experience

• Bachelor’s degree is required in related field.
• Master’s degree is preferred.
• Four years of progressive data analysis experience is preferred. Experience can include collegiate research projects.

Who is CMT?
CMT is recognized as a leader in delivering solutions across the entire infrastructure lifecycle, providing our clients with services across the spectrum of planning, design, construction, technology, and funding strategy. We design roads, bridges, and trails that connect people together, and we devise solutions that provide clean water for people and the environment. We also design sites and buildings, as well as solve complex challenges at some of the biggest airports in the country. For over 75 years, our team of engineers, planners, and consultants has delivered a trademark brand of excellence and value to those we serve.
CMT has been honored as the Top Engineering Design Firm in the Midwest by Engineering News Record and was recently named among Zweig Group’s “Best Firms to Work For.” CMT’s success has been a direct result of enabling our people to pursue their passions and grow as professionals, while also maintaining an appropriate work-life balance centered around flexibility. Through innovation and a passionate pursuit of excellence, our team of engineers, planners and other related design professionals are driven to help our clients achieve the highest value possible for the infrastructure they build and manage. Together we work to make our communities more livable and sustainable. A firm with approximately 500 employees and 25 offices in 9 states, CMT is growing fast and continuously creating opportunities for our employees.
CMT is committed to individual opportunity and the professional development of our employees. This position offers an opportunity to take the next step, helping reach your career goals and personal potential.

DUTIES & RESPONSIBILITIES

Responsibilities will include the following:

• Data Analysis: Conduct thorough data analysis using statistical methods and tools. Interpret complex data sets and provide actionable insights. Develop and implement data collection systems and other strategies to optimize statistical efficiency and data quality.
• Data Modeling and Visualization: Create and maintain advanced statistical models for predicting and analyzing trends. Develop and implement data visualization tools and dashboards to present data-driven insights to stakeholders. Utilize tools such Power BI, or others to create compelling visualizations.
• Database Management: Work with databases to retrieve, store, and manipulate data. Collaborate with database administrators to optimize database queries and performance.
• Collaboration and Communication: Collaborate with cross-functional teams to understand business needs and objectives. Communicate findings and insights to both technical and non-technical stakeholders.
• Programming and Machine Learning: Use programming languages such as Python, R, or SQL for data analysis tasks. Apply machine learning algorithms for predictive modeling and other analytical tasks. Stay up-to-date with advancements in machine learning and data science.
• Continuous Learning/Research: Stay informed about industry trends, emerging technologies, and best practices in civil engineering and public infrastructure construction. Attend conferences, workshops, or training sessions to enhance skills and knowledge.
• Project Management: Manage and prioritize multiple projects simultaneously. Define project requirements, scope, and objectives.

To execute responsibilities, data analytics engineers should possess the following KSAs:

• Excellent technical skills in data research, data analysis and machine learning.
• Ability to learn civil engineering work flows to allow for effective data analysis
• Advanced analytical, critical thinking, and problem-solving skills
• Knowledge of data security and quality assurance procedures
• Knowledge of Azure Data Lakes, Azure OpenAI, and machine learning technologies
• Advanced communication and organizational skills
• Ability to design and utilize SQL databases and analysis tools for data analytics projects
• Strong project management skills
• Proficient software skills in Microsoft Office Suite including Power B