Data Engineer / Analytics Consultant

Job Description

As a Data Engineer / Analytics Consultant at McKee-Nix & Associates, you will be responsible for building and maintaining data infrastructure, pipelines, and analytics solutions that support business operations, sales strategy, and decision-making. You will work closely with cross-functional teams—such as sales, operations, and leadership—to translate data into insights that improve efficiency, forecasting, and growth across the company’s plumbing and mechanical distribution business.

Key Responsibilities

Develop, maintain, and optimize data pipelines (ETL / ELT) to integrate data from disparate systems (e.g., ERP, CRM, inventory, sales).

Build and maintain data warehouses or data lakes for efficient storage and retrieval of structured and semi-structured data.

Model data to support business reporting, analytics, and predictive insights (forecasting sales, inventory demand, etc.).

Implement data transformation processes, standardize data definitions, and enforce data quality and validation rules.

Create dashboards, reports, and visualizations for business stakeholders (sales leadership, operations, finance) to surface key metrics and trends.

Collaborate with sales and operations teams to identify analytics needs, develop business intelligence solutions, and support data-driven decision-making.

Monitor data pipeline performance, troubleshoot issues, and ensure reliability and scalability.

Establish data governance practices, including documentation, lineage tracking, and data security standards.

Train internal teams on data tools, dashboards, and analytics best practices.

Stay current with industry trends, data tools, and best practices, and recommend improvements to architecture and data processes.

Requirements

Bachelor’s degree in Computer Science, Data Science, Information Systems, or a related field (or equivalent experience).

3+ years of experience in data engineering, analytics, or a related role.

Proficiency in SQL for data modeling and querying.

Experience with data pipeline tools and frameworks (e.g., Python, Apache Airflow, or similar).

Experience working with data storage technologies (data warehouses, lakes, cloud storage).

Familiarity with BI / reporting tools (e.g., Power BI, Tableau, or similar).

Strong problem-solving and analytical thinking skills, with the ability to interpret business needs into technical data requirements.

Excellent communication skills, capable of bridging technical and non-technical stakeholders.

Experience with data governance, documentation, and metadata management.

Benefits

Competitive base salary plus performance-based incentives

Health, dental, and vision insurance

401(k) retirement plan with company matching

Generous paid time off : vacation, sick leave, and company holidays

Flexible work arrangements (hybrid or on-site, depending on business needs)

Professional development support : training, certification reimbursement, and analytics conferences

Travel reimbursement for any on-site business visits or engagements

Opportunities for career advancement into senior analytics, data architecture, or leadership roles

Wellness support : mental health resources, wellness stipend or gym benefit

Paid parental / family leave

Requirements

Bachelor’s degree in Computer Science, Information Security, or related field (or equivalent experience). 3+ years of experience in cybersecurity consulting, advisory, or professional services. Hands-on experience with security assessments, architecture design, and risk management. Knowledge of security frameworks and standards (e.g., ISO 27001, NIST Cybersecurity Framework, CIS Controls). Experience with regulatory compliance (e.g., GDPR, HIPAA, PCI-DSS) is preferred. Strong understanding of cloud security (AWS, Azure, GCP), identity management, encryption, and network security. Excellent communication skills, both technical and non-technical, with experience presenting to executives and technical teams. Consulting mindset : strong problem-solving, client-facing experience, and ability to lead engagements. Certifications such as CISSP, CISM, CRISC, or equivalent are a plus.