As an integral member of our Business Intelligence and Analytics Team, the Data Architect will be responsible for the design, architecture, development, implementation, and support of critical enterprise E2E Business Intelligence EDW solutions in MySQL or Snowflake as well as sourcing data from MySQL, Snowflake, Salesforce, Netsuite, and other data sources.
You will handle the product's or project’s conception, design initial product specifications and lead scheduling, estimate and secure resources, as well as provide technical guidance to other internal and external teams. You will help train new employees and stay ahead of industry trends and issues.
**Must be authorized to work in the US without requiring employer sponsorship.**
What You Get to Do:
Design conceptual and logical data models and flowcharts
Design and implement effective database solutions and models to store and retrieve company data
Examine and identify database structural necessities by evaluating client operations, applications, and programming
Optimize new and current database systems
Assess database implementation procedures to ensure they follow internal and external regulations
Install and organize information systems to guarantee company functionality
Prepare accurate database design and architecture reports for management and executive teams
Lead all aspects of the migration of data from legacy systems to new solutions
Monitor the system performance by performing regular tests, fixing and integrating new features
Recommend solutions to improve new and existing database systems
What You Bring:
Advanced working knowledge and ability to write complex SQL queries in MySQL, Snowflake, and Salesforce (SFDC) environments
Extensive hands-on experience working with SQL and Python for the purposes of data modeling and ETL
Strong familiarity with Kimball, OLAP, and EDW data design methodologies, especially for Healthcare and Benefits datasets and Financial Datasets.
8+ years’ experience in Data Modeling and Architecting, ETL, Data Engineering, or BI fields with concentration on data transformations and data modeling with financial data.
Experience working with BI Tools such as Tableau CRM(TCRM)/Einstein Analytics is preferred.
API integration experience is preferred.
Understanding of various data extraction and transformation techniques
Working familiarity with Salesforce, Netsuite, and Tableau
Familiar with Data Visualization standard methodologies
Ability to succeed in a dynamic, Agile environment
Strong prioritization and time-management skills
Dedication to team goals that include support of live 24/7 production systems
A consummate collaborator, able to establish good relationships with technical, product, and business owners
A champion of quality, able to QA and vouch for the integrity of the report output
Maintaining business partner engagement and setting expectations
Assessing current processes and recommending changes as needed
Documenting and communicating technical specifications to ensure that proper and optimized techniques, queries, data standards, and final outputs are understood and incorporated into data and analytics processes
Participate in business analysis activities to gather required reporting and dashboard requirements
Translate business requirements into specifications that will be used to implement the required user-friendly environments, reports and dashboards, built from potentially multiple data sources
Sequoia exists to come through for people who put their trust in us. Our team members live by a set of core values that underscore everything we do – for each other and for our clients. We expect that these will resonate with you, excite you, and empower you to do your best work:
Integrity Passion for service Innovative Growth oriented Caring for others Promise-centric Focused on relationship building
Compensation & Benefits
Sequoia offers team members compensation and benefits to support the physical, financial and emotional wellbeing of you and your loved ones. We continuously and purposefully build an inclusive culture, designed to empower everyone to do their best work.
Our compensation and benefits are thoughtful, competitive and leading edge, but most of all, they reflect what our people value most.
We employ diverse talent across North America and India. We focus on well-rounded, values-based colleagues to add to our culture and help us forge new ground.
Sequoia provides equal opportunity to all applicants without regard to race, color, creed, religion, citizenship, national origin, age, sex, sexual orientation, gender identity, pregnancy, marital status, military or veteran status, disability, or any other basis prohibited by applicable law.
We are building something special in the world of HR and this is an important role for us, and an incredible opportunity for the right candidate. Our environment is inclusive, diverse, ignited, built on integrity and deeply committed. Come and help us truly make a difference investing in people.
Sequoia has offices in the San Francisco Bay Area, New York, Tempe, and Bangalore. Visit Sequoia.com or follow us on LinkedIn and Twitter to learn more.
For more than 20 years, people-driven companies have turned to Sequoia to get their employee experience right. We’re in this business because we know that taking great care of people leads to better business outcomes. Helping our clients achieve those outcomes is what drives our team, our strategic service offerings, and our technology forward.
Sequoia comes through for clients with guidance, service, and the Sequoia People Platform. Through their compensation, benefits, and overall people programs, we enable them to better manage their global workforce, reduce administrative burdens, and reach a deeper level of employee care and support. We strategically use technology to enhance the expert guidance and committed service we bring to every client engagement.