Data Analytics Engineer
Colwich, KS
Jul 2, 2025
Full-time
Full Job Description
JOB TITLE: Data Analytics Engineer
JOB LOCATION: Colwich, Kansas
WAGE RANGE*: $80,000-$100,000
JOB NUMBER: 25-03064

JOB DESCRIPTION:

The data analytics engineer is responsible for the development and implementation of data solutions within our Azure, D365, and Fabric environment. This resource will play a crucial role in extracting, transforming, and loading (ETL) data, and developing reporting solutions to drive ICM's operations. Additionally, this resource must be able to perform technical/analytical work, providing insight into the efficiency and functionality of company systems. The individual must maintain a comprehensive understanding of relational database concepts, table design and structure and this knowledge should be translated and applied to the data based on business needs.


ESSENTIAL FUNCTIONS AND BASIC DUTIES:


Data Engineering

  • Design, develop, and maintain robust data pipelines using Fabric Data Factory or Visual Studio SSIS.
  • Ingest, clean, and transform data from various sources, including AX2012 and D365, into a suitable format for analysis.
  • Write complex SQL queries to extract, manipulate, and analyze data from relational data sources.
  • Participate in data conversion planning, design, development, testing and implementing.


Data Modeling

  • Design, develop and implement data models, including dimensional and star schemas, to support business intelligence and analytics.
  • Create data marts and data warehouses to store and standardize data for analysis.


Data Analysis and Reporting

  • Utilize advanced analytics techniques, to extract valuable insights from data.
  • Leverage SQL to perform data exploration, analysis, and report engineering.
  • Develop interactive dashboards and reports using Power BI, SAP BOBJ or other visualization tools to communicate findings effectively to stakeholders.
  • Review, interpret, and update existing reports.
  • Provide troubleshooting, break/fix support, and SQL query optimization of existing reports and development of new requests.
  • Ability to assist with data validation and auditing.
  • Provide recommendations to address existing/future risk in business intelligence infrastructure.
  • Ensure compatibility and interoperability across on-premises and cloud-based computing systems.


Cloud Technologies

  • Leverage cloud technologies, including Azure Data Lake Storage, One Lake, and MS FABRIC, to build scalable and reliable data solutions.
  • Utilize Spark on MS FABRIC to perform big data processing and analysis tasks.


Collaboration and Communication

  • Collaborate with business systems analysts and other team members to understand business requirements and translate them into technical requirements and solutions.
  • Communicate complex technical concepts to both technical and non-technical audiences.
  • Maintain data documentation and ensure quality and accuracy.


Education/Certification:

  • Bachelor Degree in Computer Science (or related field) required, or equivalent training and/or on-the-job experience.


Required Knowledge & Experience:

  • 7+ years developing reports preferred
  • 5+ years working with SQL preferred
  • 3+ years working with SSRS/SSIS preferred
  • 3+ years experience with data warehousing and ETL processes preferred
  • Strong proficiency in SQL, Python and M programming languages
  • Experience with data visualization tools like SAP BOBJ, Power BI, Tableau
  • Knowledge of cloud computing platforms, specifically Azure
  • Experience integrating with ERP platforms (i.e., Microsoft D365, AX2012, GP, NAV) preferred
  • Experience managing SQL servers, maintenance plans, alerting preferred
  • Experience working in a team-oriented, collaborative environment
  • Extensive experience with Microsoft 365 products


Skills/Abilities:

  • Excellent analytical, mathematical, and creative problem-solving skills
  • Ability to effectively prioritize and execute tasks in a high-pressure environment
  • Ability to communicate ideas in both technical and user-friendly language
  • Ability to conduct research into systems issues and products as required
  • Highly self-motivated and efficient
  • Detail oriented

Equal opportunity employer as to all protected groups, including protected veterans and individuals with disabilities


* While an hourly range is posted for this position, an eventual hourly rate is determined by a comprehensive salary analysis which considers multiple factors including but not limited to: job-related knowledge, skills and qualifications, education and experience as compared to others in the organization doing substantially similar work, if applicable, and market and business considerations. Benefits offered include medical, dental and vision benefits; dependent care flexible spending account; 401(k) plan; voluntary life/short term disability/whole life/term life/accident and critical illness coverage; employee assistance program; sick leave in accordance with regulation. Benefits may be subject to generally applicable eligibility, waiting period, contribution, and other requirements and conditions. Benefits offered are in accordance with applicable federal, state, and local laws and subject to change at TCM's discretion.PDN-9f4c1a28-b770-4898-a280-98043b8befa1
Job Information
Job Category:
Other
Spotlight Employer
Related jobs
Who Are We? At Ditch Witch in Perry, Oklahoma we pride ourselves on being the leading manufacturer in the underground pipe and cable market. Our plant in Perry stands out because it's a place for peop...
Jul 18, 2025
PERRY, OK
Applicants must be legally authorized to work in the United States. We are unable to sponsor or take over sponsorship of a school/employment or any other visa, regardless of expiration date, now or in...
Jul 18, 2025
WEST SALEM, OH
Applicants must be legally authorized to work in the United States. We are unable to sponsor or take over sponsorship of a school/employment or any other visa, regardless of expiration date, now or in...
Jul 18, 2025
WEST SALEM, OH
©2025 TalentAlly.
Powered by TalentAlly.
Apply for this job
Data Analytics Engineer
The Computer Merchant, LTD.
Colwich, KS
Jul 2, 2025
Full-time
Your Information
First Name *
Last Name *
Email Address *
Zip Code *
Password *
Confirm Password *
Create your Profile from your Resume
By clicking the Apply button, you agree to the terms of use and privacy policy and consent to receive emails from us about job opportunities, career resources, and other relevant updates. You can unsubscribe at any time.
Continue to Apply

The Computer Merchant, LTD. would like you to finish the application on their website.

Ace your interview with
AI-powered interview practice

Get comfortable talking to hiring managers, receive personalized feedback on areas for improvement, sharpen your ability to answer the most common questions, and build confidence in formulating strong responses on the spot. Click the button below to begin your three free virtual interviews!