Data Solutions Architect

Spaulding Ridge; New York, Chicago (NY, IL); On-site; USD 116,000 - 223,000; Full time

Benefits offered by this job

Generous time off

Paid holidays

Parental leave

401(k) with company match

Health/dental/vision plans

Life and disability insurance

Well-being and tech stipend

Learning and development reimbursement

Job summary

Spaulding Ridge is seeking a Data Solutions Architect to lead pre-sales, estimation, scoping, design, and implementation of modern analytic solutions for client organizations. You will collaborate with client partners to translate business goals into scalable data architectures and analytics deliverables.

In this role, you will manage data engineering lifecycles, mentor junior staff, develop PoCs for cloud-based analytics stacks, and support sales with solution proposals. Travel may be required.

Qualifications

• 5+ years developing BI and analytic solutions.
• 5+ years writing business requirements and use cases for data warehousing.
• 5+ years SQL development with advanced analytics.
• 3+ years consulting on SDLC projects.
• 4+ years relational databases (Postgres, SQL Server, Oracle, Snowflake, Azure Synapse).
• 3+ years creating functional test cases and supporting UAT.
• 3+ years in Agile/Kanban/DevOps Delivery.
• Strong analytical, communication, interpersonal skills.
• Ability to manage projects and teams against planned work.
• Ability to manage day-to-day client relationships.
• Ability to lead orals and build POC solutions; travel may be required.

Responsibilities

• Manage the Data engineering lifecycle including research, proof of concepts, architecture, design, development, test, deployment, and maintenance.
• Collaborate with team members to design and implement technology that aligns with client business objectives.
• Build proofs of concepts for a modern analytics stack supporting a variety of Cloud-based Business Systems for potential clients.
• Work with ETL/ELT technologies such as Azure Data Factory, Fivetran, Snowflake OpenFlow, Apache NiFi and other similar ETL/ELT tools.
• Work with analytic technologies such as Power BI, Tableau, Sigma, Omni, Looker and other similar analytic tools.
• Work with cloud-enabled data repositories such as Snowflake, AWS, Azure, and/or Google Cloud Platform.
• Team management experience and ability to mentor and develop junior resources.
• Create actionable recommendations based on identified platform, structural and/or logic problems.
• Communicate and demonstrate an understanding of client business needs, goals, and objectives.
• Collaborate with other practices on Solution Proposals, Pre-Sales Activities, Estimation, Scoping and Solutions.
• Travel as required.

Skills

BI/Analytics development

SQL development

SDLC consulting

Agile/DevOps

Team mentoring

Cloud data platforms

Snowflake/AWS/Azure/GCP

Jenkins/Kafka/Kubernetes

Communication skills

Tools

Azure Data Factory

Fivetran

Snowflake OpenFlow

NiFi

Power BI

Tableau

Sigma

Omni

Looker

Job description

Spaulding Ridge is an advisory and IT implementation firm. We help global organizations get financial clarity into the complex, daily sales, and operational decisions that impact profitable revenue generations, efficient operational performance, and reliable financial management.

At Spaulding Ridge, we believe all business is personal. Core to our values is our relationships with our clients, our business partners, our team, and the global community. Our employees dedicate their time to helping our clients transform their business, from strategy through implementation and business transformation.

Data Solutions Architect

We are looking for a Data Solutions Architect to join our Data Solutions team!

As a Data Solutions Architect, you’ll be responsible for pre-sales, estimation, scoping, designing, implementing, and testing proposed modern analytic solutions. Working closely with our client partners, you’ll develop relationships with key technical resources while delivering tangible business outcomes.

Ideal candidates will be able to:

• Manage the Data engineering lifecycle including research, proof of concepts, architecture, design, development, test, deployment, and maintenance
• Ability to collaborate with team members to design and implement technology that aligns with client business objectives
• Ability to build proof of concepts for a modern analytics stack supporting a variety of Cloud-based Business Systems for potential clients
• Experience working with ETL/ELT technologies such as Azure Data Factory, Fivetran, Snowflake OpenFlow, Apache NiFi and other similar ETL/ELT tools
• Experience working with analytic technologies such as Power BI, Tableau, Sigma, Omni, Looker and other similar analytic tools
• Experience working with cloud enabled data repositories such as Snowflake, Amazon Web Services, Microsoft Azure, and/or Google Cloud Platform.
• Team management experience and ability to manage, mentor and develop talent of assigned junior resources
• Ability to create actionable recommendations based on identified platform, structural and/or logic problems
• Ability to communicate and demonstrate a clear understanding of client business needs, goals, and objectives
• Ability to collaborate with other practices on Solution Proposals, Pre-Sales Activities, Estimation, Scoping and Solutions

Qualifications:

• 5+ years’ experience developing industry -leading business intelligence and analytic solutions
• 5+ years of experience writing Business requirements, Use cases and/or user stories, preferably for data warehouse or data mart initiatives
• 5+ years of SQL development including advanced analytic functions
• 3+ years of consulting experience working on project-based delivery using Software Development Life Cycle (SDLC)
• 4+ years of experience with relational databases (Postgres, SQL Server, Oracle, Snowflake, and Azure Synapse Analytics, etc.)
• 3+ years of experience creating functional test cases and supporting user acceptance testing
• 3+ years of experience in Agile/Kanban/DevOps Delivery
• Outstanding analytical, communication, and interpersonal skills
• Ability to manage projects and teams against planned work
• Responsible for managing the day-to-day client relationship on projects
• Ability to support sales cycles by leading orals sessions along with building POC solutions for clients
• Ability to travel

Preferred Skills:

• SnowPro certification
• 5+ years experience developing in Snowflake, AWS, Azure, GCP or similar cloud data platform
• 3+ years of experience with modern tech stack tools such as Jenkins, Kafka, Messaging, Kubernetes
• Solid understanding of data architecture, data modeling, statistics, data science and data infrastructure ecosystems

Spaulding Ridge is committed to helping team members thrive in their work and life, and we invest in comprehensive total rewards to support this goal.

• generous time off
• paid holidays
• paid parental leave
• a 401(k) with company match
• highly subsidized health, dental, and vision plans
• company-paid life and disability insurance
• monthly allowance for well-being and technology expenses
• reimbursement for approved learning and development initiatives within defined limits

Spaulding Ridge is committed to fair and equitable compensation practices. The base salary range for this position in the United States across locations is reflected below. In addition, this role may be eligible for an annual discretionary bonus. Actual compensation will be determined based on a range of factors, including skills, experience, qualifications, and location. Please note that the range provided is subject to change at any time in accordance with internal policies and applicable law.

$116,000 - $223,000 USD

Spaulding Ridge’s Commitment to an Inclusive Workplace

When we engage the expertise, insights, and creativity of people from all walks of life, we become a better organization, we deliver superior services to clients, and we transform our communities and world for the better.

At Spaulding Ridge, we believe our team should reflect the rich diversity of society and we take seriously the responsibility to cultivate a workplace where every bandmate feels accepted, respected, and valued for who they are. We do this by creating a culture of trust and belonging, through practices and policies that support inclusion, and through our employee led Employee Resource Groups (ERGs): CRE (Cultural Race and Ethnicity), Women Elevate, PROUD and Mental Wellness Alliance.

The company is committed to offering Equal Employment Opportunity and to providing reasonable accommodation to applicants with physical and/or mental disabilities. If you are interested in applying for employment with Spaulding Ridge and are in need of accommodation or special assistance to navigate our website or to complete your application, please send an e-mail with your request to our VP of Human Resources, Cara Halladay ([e-mail]). Requests for reasonable accommodation will be considered on a case-by-case basis.

Qualified applicants will receive consideration for employment without regard to their age, race, religion, national origin, gender, sexual orientation, gender identity, protected veteran status or disability.