Senior Analytics Engineer

We are looking for a Senior Analytics Engineer to join our Rexel team in North Carolina! Remote

Summary:
The Senior Analytics Engineer is a hands-on technical expert and adept business collaborator responsible for building, operating, and scaling the company’s transformation, enterprise data, and semantic layers. This role requires a skilled communicator and SQL expert who excels at working closely with business stakeholders to distill requirements and logic and apply consistent implementation patterns to varying domains and use cases. The Senior Analytics Engineer will design, build, and maintain dbt models and macros, test specifications, and technical definitions of key measures and dimensions. This role is highly technical, collaborative, and oriented toward serving data with an emphasis on validity, ease of use, and business relevance.

What You'll Do:

• Data Transformation Development: dbt Models and Macros: Contribute to the development of models and macros to unify disparate sets of ERP and other data, load sophisticated dimensional models, and expose meaningful metrics and dimensions to business users in a business delivery/semantic layer dbt Tests & Data Validation: Devise means of verifying data validity and operationalize through a combination of dbt Tests and other monitoring/observability capabilities such as Monte Carlo monitors and Atlan data asset health status. Partner with Data Governance and Business intelligence teams to ensure that tests evaluate meaningful dimensions of data quality and are appropriate in severity based on the data being tested
• Collaboration & Delivery: Logic & Definitions: Participate in and help facilitate collaboration between business units, analysts, and BI developers to translate business rules, KPIs, and operation logic into technically feasible definitionsCross-Functional Technical Collaboration: Work closely with Data Platform Architects and Data Engineers to ensure coordinated progress across end-to-end data pipelines
• Operational Reliability: Pipeline Monitoring & Incident Response: Leverage tooling to monitor transformation, unification, and Enterprise Data refresh jobs for failures, delays, and data anomalies. Contribute to and follow runbooks for identifying, escalating, and resolving issues appropriately Data Trust & Observability Support: Partner with Data Platform, Data Engineering, Data Governance, and BI Teams to implement trust and observability infrastructure as it pertains to data transformation using tools such as Atlan and Monte Carlo. Diagnose and collaborate to resolve errors, test failures, and data refresh delays
• Other duties as assigned

Job Duties Disclaimer:
The information contained in this job description is intended to describe the essential job functions required of those assigned to this job. It is not intended to be an exhaustive list of all responsibilities, duties, knowledge, skills, and abilities needed to perform the job. Please note that management retains the right to assign or reassign duties and responsibilities to this job at any time. The ability to competently perform all the essential duties of the position, with or without reasonable accommodation, demonstrate commitment to effective customer service delivery, integrity, and the ability to work productively as a member of a team or work group are basic requirements of all positions at Rexel USA.

What You'll Need

• 5+ years of experience in data engineering, analytics engineering, or data analyst roles, working with cloud-native, code-first tools
• Expert dbt Developer: Hands-on experience creating, maintaining, and optimizing dbt Cloud resources such as models, tests, snapshots, macros, and exposures. Familiarity with configuring and leveraging dbt Packages for additional functionality
• 4 Year / Bachelor's Degree - Required
• Computer Science, Engineering, Information Systems, or a related technical field

Knowledge, Skills & Abilities

• Operational Focus: Demonstrated ability to operate and support data transformations with a high standard of reliability, accuracy, and responsiveness
• Collaboration & Communication: Ability to work effectively with engineers, analysts, and business partners, clearly communicating requests, enablement/training content, informational needs, and task status
• Snowflake Proficiency: Working knowledge of Snowflake concepts including databases, schemas, warehouses, performance considerations, and query optimization
• Semantic Layer awareness: Strong understanding of semantic layer concepts such as measures, dimensions, synonyms, and relationships and experience configuring data packages in at least one BI tool (E.G. LookML Model, PBI Semantic Model, Tableau PDS, Sigma Dataset, etc)
• Engineering Best Practices: Strong background in software development lifecycles, including Git-based workflows, CI/CD, code reviews, and pre-merge checks
• SQL & Python: Advanced SQL skills for complex transformations and a working knowledge of Python for orchestration and automation tasks

Physical Demands:

• Sit: Must be able to remain in a stationary position - Frequently – 21% to 50%
• Walk: Must be able to move about inside/outside office or work location - Occasionally – up to 20%
• Use hands to finger, handle, or feel: Operates a computer and other office machinery - Constantly – at least 51%
• Talk, hear, taste, smell: Must be able to use senses to effectively communicate with co-workers and clients and detect hazardous conditions - Frequently – 21% to 50%

Weight and Force Demands:

• Up to 10 pounds - Occasionally – up to 20%

Rexel USA (A VEVRAA Federal Contractor), and its affiliated companies, is an EEO/Disabled/Veterans employer. All qualified candidates will receive consideration for employment without regard to any characteristics protected by law.

Our Benefits Include:

• Medical, Dental, and Vision Insurance
• Life Insurance
• Short-Term and Long-Term Disability Insurance
• 401K with Employer Match
• Paid vacation and sick time
• Paid company holidays plus flexible personal days per year
• Tuition Reimbursement
• Health & Wellness Programs
• Flexible Spending Accounts
• HSA Accounts
• Commuter Transit Benefits
• Additional Optional Insurance such as Pet Insurance, Legal Assistance, Critical Illness, Home and Auto Insurance to name a few.
• Employee Discount Programs
• Professional Training & Development Programs
• Career Advancement Opportunities – We like to promote from within

Our goal is to create a workplace where everyone feels respected, valued, and empowered to succeed as we understand that our success and innovation is enhanced by an inclusive and diverse workforce.
Rexel USA (A VEVRAA Federal Contractor), and its affiliated companies, is an EEO/Disabled/Veterans employer. All qualified candidates will receive consideration for employment without regard to any characteristics protected by law.

Rexel USA is one of the largest distributors of electrical products, data communication, and related supplies in the United States. Rexel USA operates its electrical distribution business in the United States through eight Regions that go to market under various banner and trade names, including Rexel, Rexel Automation, Gexpro, Mayer, and Platt Electric Supply. In addition to an online store, Rexel USA has a distribution network of over 460 warehouse storefront locations throughout the U.S.