Senior Data & Analytics Consultant

Job Title: Senior Data & Analytics Consultant Location - Charlotte, NC Duration - 12 months Key Responsibilities: • Collaborate with business stakeholders to gather and refine requirements for data use cases. • Design and architect scalable data models and data element relationships with a strong emphasis on usability, performance, and data accuracy. • Identify and write requirements for data source integrity monitoring. • Support database enhancement requests and contribute to logical data design solutions. • Participate in data management documentation including data lineage, data sharing agreements, and other metadata management. • Evaluate upstream system of record changes for potential data impact and provide recommendations. • Translate business needs into actionable data requirements and technical specifications. • Partner with technology and data governance groups to ensure alignment with the team’s and enterprise data standards. Required Skills: • MSSQL: Ability to write, read, and optimize queries for data extraction, transformation, and analysis. • Data Analysis: Experience in data cleansing, validation, and transformation logic using Alteryx and SSMS. • Documentation: Ability to define clear data sourcing and transform logic requirements and database/table/column specifications. • Experience with metadata management and data governance practices. • Proficiency in data profiling and root cause analysis for data quality issues. Soft Skills: • Proven ability to work independently and manage multiple priorities. • Strong communication and stakeholder engagement skills. • Comfortable navigating ambiguity and driving clarity in complex data environments. Preferred Skills: • Experience with Google Data Cloud stack (Dataplex, big query, etc.). • Familiarity with SSIS packages and jobs. • Familiarity with Agile processes and Atlassian software (Jira)