SENIOR DATA & ANALYTICS ENGINEER
About The Position
The Senior Data and Analytics Engineer leads business requirements discussions across business functions and translates business needs into prioritized reporting and analytics solutions. The role develops an understanding of Carter’s enterprise data model, business processes, and source relationships, and connects data across functions to support consistent analysis. The engineer designs and optimizes Power BI reports, dashboards, semantic models, and DAX measures, and builds reusable SQL datasets, views, and transformations on cloud data platforms including Snowflake and Microsoft Fabric. The role owns delivery from requirements through development, testing, business validation, rollout, documentation, and user adoption. It also partners with stakeholders to define KPIs and business rules, supports AI data preparation and modeling, and collaborates with architecture and data development teams on standards and pipeline dependencies. Additional work includes migrating Tableau reports to Power BI, modernizing legacy reporting, validating data accuracy, documenting lineage and source mappings, optimizing performance, applying version control and release practices, supporting delivered solutions, and mentoring colleagues. The position requires occasional travel and occasional after-hours work, including nights and/or weekends.
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 business 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.
- Occasional travel is required, including overnight or out-of-town travel by car or airplane.
- Ability to work occasional after-hours shifts, including nights and/or weekends, to meet business and customer needs.
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, connecting 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.
- Partner with stakeholders to define KPIs and business rules, resolve conflicting definitions, and teach users 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 migration of Tableau reports to Power BI 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.
- Work with the team to achieve Continuous Improvement goals and objectives.
- Perform other related duties as assigned.
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.
- Compensation package may include participation in performance-based incentive programs and overtime eligibility depending on the role.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
