SENIOR DATA & ANALYTICS ENGINEER

Carter Machinery Careers•Mechanicsville, VA

2d•Onsite

About The Position

Carter Machinery is hiring a Senior Data and Analytics Engineer in Richmond, Virginia, with a starting compensation range of $120,000 to $145,000 per year. The role leads the delivery of business reporting and analytics solutions, translating stakeholder requirements into prioritized, validated, and adopted data products. It develops Power BI reports, dashboards, semantic models, DAX measures, and reusable SQL datasets and transformations on modern cloud data platforms, including Snowflake and Microsoft Fabric. The engineer connects data across business functions and source systems, defines consistent KPIs and business rules, validates accuracy, and documents data lineage. The role also supports AI data preparation, reporting modernization and Tableau-to-Power BI migration, and works with the Data Architect, development team, and AI team to follow architecture, security, governance, and development standards. The position includes occasional travel, occasional after-hours work, and mentoring colleagues. Carter describes its workplace as fast-paced and at times stressful, with an emphasis on customer experience and its Core Values of Integrity, Commitment, Excellence, and Teamwork.

Requirements

Eight or more years of relevant experience in data and analytics, reporting, business intelligence, analytics engineering, or related roles.
Hands-on experience with SQL, Power BI, DAX, semantic models, and modern cloud data platforms, including delivering solutions in partnership with business stakeholders.
Experience owning delivery from requirements through validation and adoption, with knowledge of AI data preparation and modeling best practices.
Bachelor’s degree in Computer Science, Information Systems, Engineering, Analytics, or a related field, or equivalent practical experience.
Strong SQL skills, including reusable dataset development, data validation, and query performance optimization.
Proficiency with Power BI, DAX, semantic modeling, dimensional modeling, and report design.
Knowledge of modern cloud data platforms and best practices for preparing and modeling data for reporting, analytics, and AI use.
Ability to translate business priorities into practical data solutions and understand how business functions connect enterprise data to processes and decisions.
Strong analytical and problem-solving skills, including data reconciliation, issue investigation, and attention to accuracy.
Excellent time management skills and a proven ability to meet deadlines.
Knowledge of data quality, governance, security, documentation, version control, testing, and release practices.
Valid driver’s license and excellent driving record.
Ability to travel occasionally, including overnight or out-of-town travel via car or airplane, and work occasional after-hours shifts, including nights and/or weekends.
Regularly sit and talk or hear; frequently stand, walk, use hands to finger, handle, or feel, and reach with hands and arms; occasionally lift and/or move up to 20 pounds; required vision abilities include close vision, distance vision, and ability to adjust focus.

Nice To Haves

Experience with Microsoft Fabric and Snowflake.
Knowledge of Microsoft Dynamics 365 schemas and data structures.
Proficiency with Python.

Responsibilities

Lead business requirements discussions across business functions and translate needs into prioritized reporting and analytics solutions with clear acceptance criteria.
Develop an understanding of the enterprise data model, business processes, and source relationships, and connect data across functions for consistent analysis.
Design, develop, and optimize Power BI reports, dashboards, semantic models, and DAX measures.
Build and maintain reusable SQL datasets, views, and transformations on cloud data platforms, including Snowflake and Microsoft Fabric.
Own solution delivery from requirements and development through testing, business validation, rollout, documentation, and user adoption; measure outcomes against agreed needs.
Partner with stakeholders to define KPIs and business rules, resolve conflicting definitions, and teach users how to interpret and apply data.
Apply AI data preparation and modeling best practices and partner with the AI team on data requirements, quality, context, and readiness.
Collaborate with the Data Architect and data development team to align solutions with architecture, security, governance, and development standards and coordinate pipeline dependencies.
Support Tableau-to-Power BI migration and modernization of legacy reporting; consolidate redundant reports and promote reusable datasets and semantic models.
Validate data accuracy, reconcile results with source systems, investigate discrepancies, and document business rules, source mappings, and lineage.
Optimize performance; apply version control and release practices; support delivered solutions; and mentor colleagues in data modeling, reporting, and business engagement.
Coordinate with the team to achieve Continuous Improvement goals and objectives.
Perform other related duties as assigned.
Travel occasionally, including overnight or out-of-town travel by car or airplane, and work occasional after-hours shifts, including nights and/or weekends, to meet business and customer needs.

Benefits

Health, dental, and vision insurance.
Paid time off.
401(k) with a $0.75 to $1.25 match up to 6%.
Life and disability insurance.
In-house training instructors and programs.
Tuition reimbursement.
Employee referral bonus program.
Tool allowances and tool loans.
Discounts on cellular phone service, computers, and vehicles.
Opportunities for overtime.
Shift differential, if applicable.
Potential participation in performance-based incentive programs and overtime eligibility, depending on the role.