Business Data Consultant

Job Title: Sr Business Data Consultant
Location: Austin, TX (Onsite)
Hire Type: Full time

Key Responsibilities

1. Data Analysis & Insight Generation: Perform in-depth analysis of enterprise data to uncover trends, patterns, and correlations. Identify actionable insights and data-driven opportunities that inform decision-making and strategic initiatives.
2. Data Use Case Identification: Collaborate with stakeholders to identify and define data use cases across functional domains, ensuring alignment with business priorities and future-state data strategy.
3. Business-to-Technical Translation: Engage with stakeholders to translate business requirements into clear technical specifications, analytical models, and actionable deliverables.
4. Impact Assessment: Analyze current-state data and infrastructure versus future-state goals; identify data and process gaps; define mitigation strategies.
5. Data Profiling & Quality Analysis: Perform deep dives into structured and semi-structured datasets to assess completeness, consistency, and accuracy; work with SMEs to understand data availability and source gaps.
6. Data Integration & Transformation: Design and validate data pipelines and transformations; document lineage and dependencies.
7. Feature Engineering & Analytics: Use Python and SQL to extract, clean, and engineer data features for analytics and modeling.
8. AI-Assisted Analytics: Apply basic AI/ML and LLM-based tools (e.g., prompt-based data exploration, AI-assisted feature engineering, or generative AI copilots) to accelerate data analysis, documentation, and insight generation.
9. Reporting & Visualization: Build and maintain insightful dashboards and reports to communicate findings effectively.
10. Governance & Documentation: Maintain business glossary, data dictionary, and metadata aligned with governance standards.
11. Testing & Validation: Participate in validation of new or transformed data sets to ensure integrity and alignment with business requirements.
12. Knowledge Management: Maintain the data dictionary and business glossary for assigned domains, capturing and documenting definitions aligned with business leadership and global teams.
13. Cross-functional Collaboration: Partner closely with data engineers, product managers, and business SMEs to align solutions with business objectives.

Required Skills & Qualifications

1. 8 12 years of experience in data analytics, business analysis, or data management.
2. Advanced SQL expertise with ability to query and optimize large, complex datasets.
3. Proficiency in Python for data analysis, transformation, and feature engineering (Pandas, NumPy).
4. Experience with building dashboards using AI or similar visualization frameworks for data storytelling and dashboards.
5. Deep understanding of data architecture, governance, MDM, and data lineage.
6. Proven track record in identifying and scoping new data use cases and converting insights into business recommendations.
7. Strong analytical thinking, stakeholder management, and communication skills.
8. Basic working knowledge of AI/ML concepts and exposure to AI-assisted tools (e.g., Copilot-style coding assistants, LLM-based chat/analytics tools, or prompt engineering for data tasks) - no deep ML modeling expertise required.
9. Experience with Snowflake, Databricks, or Hadoop/Spark environments.
10. Exposure to data catalog or governance tools (Collibra, Alation).&nbs p;
11. Familiarity with D&B data hierarchy, enrichment, or similar reference data systems.

Environment & Tooling Stack

1. SQL (PostgreSQL, Snowflake, Redshift)
2. Python (Pandas, NumPy, feature engineering)
3. AI for visualization
4. Git / Bitbucket for version control
5. JIRA / Confluence for project tracking and documentation

Key Words to search in Resume

Data analytics Consultant, Data management, Advanced SQL, Proficiency in Python (Pandas, NumPy), Building dashboards, Data architecture, Governance, MDM Data Lineage, AI/ML concepts (e.g., Copilot-style coding assistants, LLM-based chat/analytics tools, or prompt engineering for data tasks), Snowflake, Databricks, or Hadoop/Spark environments.