Principal Consultant - Data Engineering

When you join our team, you’re a consultant first. This means there are core skills we expect out of each of our team members. These include:

• Bachelor’s degree in Data Science, Computer Science, Information Systems, Engineering, or a related field
• 8+ years of hands-on experience in data warehousing, ETL development, and data modeling (both conceptual and physical) or other related technical & analytical work
• Willingness to work a hybrid schedule (2-3 days per-week onsite)
• Data acquisition & sourcing: APIs, flat files, event streams
• Solid experience with ETL/ELT pipeline development, scripting automation, including performance optimization & data quality assurance
• Tools like: Python, SQL, Apache Airflow, dbt, Kafka, Terraform, etc.
• Strong understanding of data architecture, schema design, normalization/denormalization, and data lifecycle management
• Cloud data platforms: Azure Data Services (preferred), AWS, or Google Cloud Platform
• Data Warehousing: Synapse, Snowflake, BigQuery, Redshift, etc.
• Proficient in Reporting Platforms to query large data sets
• Ex: PowerBI, Tableau, Looker, or similar tools
• Familiarity with data governance security, and compliance best practices (Collibra, Unity Catalog, Purview)
• Strong Snowflake and Python data engineering experience with hands-on pipeline development
• Proficient in SQL and experienced in designing efficient queries for large-scale data sets
• Strong communication skills and the ability to collaborate with both technical and non-technical stakeholders

In addition, each one of our consultants brings a unique and valuable toolbox of skills with them specific to their practice. Below are some examples of skills we are always looking to add to the team (don’t worry – we don’t expect you to have all of them, but they are always a plus!):

• Experience with CI/CD pipelines for data solutions using tools like GitHub Actions, Azure DevOps, or Jenkins
• Exposure to Power BI or other BI tools for data visualization and reporting
• Experience with Delta Lake, Data Mesh, or Lakehouse architectures
• Familiarity with Databricks on Azure

While every project we work on is different, below is a high-level overview of some of the responsibilities/hats you may wear:

• Build strong relationships with data consumers to understand usage patterns and design intuitive, scalable data models.
• Design, develop, and deliver high-quality data pipelines that align with privacy, governance, and performance best practices.
• Build both real-time and batch data integrations from a variety of source systems into cloud-based data lakes and warehouses.
• Develop and maintain ETL/ELT processes and tools to support both streaming and offline analytics.
• Define and implement key performance indicators (KPIs) to measure the efficiency, quality, and reliability of data engineering processes.
• Participate in code reviews, promoting clean, maintainable, and well-documented code aligned with engineering best practices.
• Create and maintain data definitions and metadata consistent with data management standards.
• Provide operational support for data integration and transformation workflows in production environments.

We ask our consultants to be superstars, so we treat them like it. Even better, our perks are designed for employees by our employees. We do this because we believe in delivering a compelling benefits package that puts you at the heart of our rewards.

• Competitive Salary – your bank account will be smiling
• Unlimited PTO – we're serious about that work-life balance thing
• Best-in-class health/vision/dental benefits – your health is our priority
• Generous 401K options – take care of your future with us
• Paid Parental Leave – supporting you during life's biggest milestones
• Opportunity to be a key player at a highly reputable, fast-growing consulting firm
• High degree of internal mobility and diverse project opportunities

The salary range for this position considers multiple factors influencing compensation decisions, such as skillset, previous experience, certifications, and various business & organizational requirements. Being hired at or near the top of the range for this role is uncommon, as compensation determinations rely on individual circumstances. Currently, the base salary range is estimated to be between $130,000 and $170,000.

*Note: No visa sponsorship is available for this position, all applicants must be currently authorized to work in the United States for any employer.