Senior Consultant - Data & Analytics

MorganFranklin Consulting LLC; McLean (VA); On-site; USD 76,194 - 122,981; Full time

Job summary

MorganFranklin Consulting LLC in McLean, Virginia, is seeking a Senior Consultant for their Data & Analytics team. You will design and build modern data warehouses, develop scalable data pipelines, and implement analytics solutions that transform complex data into actionable insights.

The ideal candidate has a Bachelor's degree, 2+ years of experience, and strong proficiency in SQL and Python. The role offers a competitive compensation package and opportunities for growth within a dynamic, collaborative environment.

Qualifications

• 2+ years of relevant experience delivering data or analytics solutions.
• Strong proficiency in SQL and Python.
• Hands-on experience with cloud-based data platforms.

Responsibilities

• Design and build modern data warehouses and analytics-ready data models.
• Develop scalable data pipelines using cloud-based platforms.
• Implement analytics and reporting solutions for actionable insights.

Skills

SQL

Python

Data transformation

Analytics

Data engineering

Business Intelligence

Communication skills

Education

Bachelor's degree in Information Systems, Computer Science, Data Analytics, Engineering, or a related field

Tools

Snowflake

Databricks

Power BI

Tableau

Job description

Transform Your Career

We deliver unparalleled opportunities for growth and career advancement. Our dynamic, entrepreneurial culture supports your journey every step of the way.

Embrace new challenges and deliver real value to some of the world's most influential Fortune 100 brands, growth companies transforming their industries, and mid-market firms that need help navigating the defining moments of their lifecycle. Work side by side with business leaders to solve complex client challenges and make a true impact. Love what you do as part of a diverse organization committed to collaboration and continuous learning.

The Team - Data & Analytics

Our Data & Analytics practice is comprised of functional and technical experts across data strategy, data engineering, analytics, and transformation. We help clients maximize the value of their data by designing modern data platforms, building scalable pipelines, and delivering analytics and reporting solutions that enable better decision-making. Our consultants are hands‑on problem solvers who partner closely with clients in fast‑paced, project‑based environments.

Your Impact

As a Senior Consultant, Data & Analytics, you will:

• Design and build modern data warehouses and analytics-ready data models
• Develop scalable, reliable data pipelines using cloud-based data platforms
• Implement analytics, reporting, and visualization solutions that translate complex data into clear, actionable insights for client stakeholders
• Partner with client teams to understand business objectives, data challenges, and success metrics through interviews and working sessions
• Manage discrete project workstreams, balancing technical execution with client communication and delivery timelines
• Present findings, recommendations, and solution designs to both technical and non-technical audiences
• Leverage AI-assisted development environments to design, generate, test, and iterate on production-quality analytics and data engineering code
• Support broader data transformation initiatives, including system implementations, migrations, and modernization efforts
• Actively participate in internal knowledge sharing, mentoring, and career development activities

At a Minimum, You Will Have:

• Bachelor's degree in Information Systems, Computer Science, Data Analytics, Engineering, or a related field
• 2+ years of relevant experience delivering data, analytics, or data engineering solutions in a consulting or project-based environment
• Strong proficiency in SQL and Python for data transformation, analysis, and pipeline development
• Hands‑on experience with cloud-based data platforms such as Snowflake, Databricks, Redshift, or similar technologies
• Experience building dashboards and reports using BI tools such as Power BI, Tableau, Sigma, or equivalent
• Experience working in AI‑assisted development environments (e.g., Codex, Claude Code, Cursor) to accelerate and improve code quality
• Demonstrated ability to manage workstreams, prioritize tasks, and deliver high-quality, client-facing solutions under tight timelines
• Strong communication skills and comfort engaging with client stakeholders at varying levels of technical depth
• Ability to work independently while collaborating effectively within cross‑functional teams
• Flexibility for travel, as needed

Preferably, You Will Have:

• Experience designing data architectures and analytics solutions in cloud‑native environments
• Familiarity with modern data engineering and analytics best practices, including version control and collaborative development workflows
• Exposure to Agile or other iterative delivery methodologies
• Experience supporting enterprise data transformation initiatives across finance, operations, or other core business functions
• A demonstrated interest in continuously learning new tools, platforms, and analytics techniques

Base Compensation Range: $76,194 – $122,981 USD