Solution Architect – Advanced Analytics (Data Vault, Canonical Modeling, Databricks) - 100% Remote - US Based

Company Description

CoEnterprise is an award-winning B2B software and professional services company headquartered in New York City. Founded in 2010, CoEnterprise delivers Data & Analytics solutions and services that transform how companies connect and do business. CoEnterprise approaches each relationship and engagement from the perspective of three core values: collaboration, ownership, and excellence. We value collaboration with both our partners and clients in order to present the best possible outcome for our customers. Our vow to accept ownership ensures that our entire staff takes pride in our work and it is our commitment to excellence that ensures that this work is at the highest standard possible. 

Job Description

As a Solution Architect – Advanced Analytics within our professional services practice, you will lead the design and delivery of cloud-native analytics architectures that solve complex data challenges for enterprise clients. This is a highly technical role that also requires strong consultative and business communication skills. You’ll work directly with clients to assess needs, define modern analytics solutions, and lead implementation across the data lifecycle—from ingestion and storage to reporting and machine learning. In addition to technical excellence, you’ll play a key role in articulating the business value and ROI of these solutions, bridging the gap between IT and strategic business outcomes.

Key Responsibilities:

• Lead the architecture of scalable, secure, and cost-efficient data platforms on cloud infrastructure (AWS, Azure, GCP).
• Collaborate with client stakeholders to define business goals and map them to technical capabilities and solution designs.
• Design and implement robust data pipelines (batch and streaming), modeling strategies, and analytics workflows using modern toolchains.
• Guide the selection and integration of data warehousing, lakehouse, and visualization platforms.
• Present architectural proposals and technical recommendations to client leadership, emphasizing expected business impact and measurable outcomes (e.g., faster time-to-insight, reduced data ops overhead, improved data quality).
• Translate technical trade-offs into business terms to help clients make informed decisions.
• Support clients in aligning analytics architectures with KPIs, compliance requirements, and digital transformation goals.
• Participate in sales support activities such as technical scoping, RFP responses, demos, and solution architecture documentation.
• Act as a mentor to consultants and data engineers, ensuring best practices are followed throughout implementation.

Qualifications

Technical Stack (Experience Preferred):

• Cloud Platforms: AWS (Redshift, Glue, EMR), Azure (Synapse, Data Factory), GCP (BigQuery, Dataflow)
• Data Engineering: dbt, Spark, Airflow, Databricks, Snowflake, Delta Lake, Data Vault, Canonical Data Model
• Streaming: Kafka, Kinesis, Event Hubs
• Storage & Warehousing: S3, ADLS, BigQuery, Synapse, Snowflake
• Programming: SQL (advanced), Python, PySpark
• BI/Visualization: Power BI, Tableau, Looker
• Infra & DevOps: Terraform, Docker, Kubernetes, CI/CD (GitHub Actions, Azure DevOps)
• Security & Governance: IAM, RBAC, encryption, compliance (HIPAA, SOC 2, GDPR)

Qualifications:

Required:

• Bachelor’s degree in Computer Science, Data Engineering, or a related technical discipline.
• 7+ years of experience in data and analytics, with 3+ years in a lead or architect role.
• Proven ability to design and implement complex analytics platforms and data ecosystems.
• Demonstrated experience communicating technical concepts to business audiences, with an emphasis on value realization and impact.
• Background in consulting or professional services with client-facing responsibilities.

Preferred:

• Master’s degree in a technical or data-focused discipline.
• Certifications in AWS, Azure, or GCP (architect or data engineering tracks).
• Experience aligning analytics initiatives with business strategies like digital transformation, customer 360, or operational optimization.
• Exposure to MLOps and integration of ML models into data pipelines.

Soft Skills:

• Strong communicator capable of translating technical detail into business language and strategic insight.
• Confident and consultative client presence, able to influence and build consensus with stakeholders at all levels.
• Analytical thinker with the ability to balance innovation with practicality.
• Proactive and self-directed, with a commitment to continuous learning and knowledge sharing.

Additional Information

At CoEnterprise, we believe diversity drives innovation. We are committed to creating and maintaining a workplace in which all employees have an opportunity to participate and contribute to the success of our business.  In recruiting for our team, we welcome the unique contributions that you can bring. We value employees for their differences represented by a variety of dimensions including demographics, behaviors, work style and perspectives.

We are an AA/EOE employer.