Senior Data Architect

1 month ago

Chicago, Illinois, United States Bounteous Full time

Bounteous x Accolite makes the future faster for the world's most ambitious brands. Our services span Strategy, Analytics, Digital Engineering, Cloud, Data & AI, Experience Design, and Marketing. We are guided by Co-Innovation, our proven methodology of collaborative partnership.

Bounteous x Accolite brings together 5000+ employees spanning North America, APAC, and EMEA, and partnerships with leading technology providers. Through advanced digital engineering, technology solutions, and data-driven digital experiences, we create exceptional and efficient business impact and help our clients win.

We are looking for a Senior Data Architect who will perform mission-critical duties in our data engineering strategy, contributing to and leading the development of our Enterprise Data and Analytics Platforms. A passionate professional who can blend the ever-evolving technology landscape of Cloud and Advanced Analytics with responsibilities to provide input on implementation and administration methodologies to management.

The Senior Data Architect will mainly be responsible for developing, optimizing, and overseeing the company's logical, conceptual, and physical data model and providing recommendations. This role will be responsible for expanding, optimizing, and monitoring our expanding data pipelines through meticulous architecting, intelligent business logic, consistent data governance, testing, and continuous delivery. Please note this is a consulting role and has 50% travel expectations and a preference for residing in CST or EST for ease of syncing with the offshore team.

Responsibilities

Deep understanding of relational as well as NoSQL data stores, methods, and approaches (star and snowflake, dimensional modeling).

Experience with data security and data access controls and design in Snowflake.

Proficiency in complex SQL, Unix Shell/Python Scripting, performance tuning and database optimization techniques.

Must have expertise in AWS Platform as a Service (PAAS) model and its integration with Snowflake to load/unload data.

Implement cloud-based Enterprise data warehouse solutions with multiple data platforms along with Snowflake and NoSQL environment to build data movement strategy.

Make necessary ongoing updates to modeling principles, processes, solutions, and best practices to ensure that the Snowflake is aligned with the business needs of the environment.

Act as Data domain expert for Snowflake in a collaborative environment to provide a demonstrated understanding of data management best practices and patterns.

Experience in Cloud technologies such as AWS – S3, SQS, EC2, Lambda, Redshift, RDS

5+ years of experience building Snowflake Data Warehouse solutions from scratch by leading discovery, analysis, architecture, design, and development of Snowflake Data Warehouse and Business Intelligence solutions to meet business requirements.

Collaborate with stakeholders to gather requirements and translate them into technical specifications.

Implement data modeling and schema designs optimized for Snowflake.

Configure and optimize Snowflake performance, including data loading, querying, and storage optimization.

Ensure data quality and consistency across the data warehouse.

Provide guidance and support to developers and analysts on Snowflake usage and best practices.

Stay current with Snowflake updates, features, and industry trends to continuously improve our data warehouse solutions.

Participate in troubleshooting and resolution of issues related to the Snowflake data warehouse.

Build Data Flows mapping Source systems and Process flows

Build Data Warehouse Architecture including Data Ingestion, Transformation, Security, and Aggregate layers

Build a denormalized Data Model with Dimensional modeling to meet customer analytics and performance criteria

Build an optimal data pipeline approach to extract data to Snowflake

Experience in delivering ELT solutions using tools like Matillion, Fivetran, and Informatica and understanding the competitive ETL space in cloud data warehousing

Understanding of reporting systems such as Tableau, PowerBi, and Qlik.

Expertise in Snowflake concepts like setting up Resource monitors, RBAC controls, scalable virtual warehouse, SQL performance tuning, zero-copy clone, time travel, and automating them.

Experience in handling semi-structured data (JSON, XML), and columnar PARQUET using the VARIANT attribute in Snowflake.

Experience in re-clustering the data in Snowflake with a good understanding of Micro-Partitions.

Experience in Migration processes to Snowflake from an on-premises database environment.

Design and Develop automated monitoring processes on Snowflake using a combination of Python, PySpark, and Bash with SnowSQL.

Experience with data security and data access controls and design in Snowflake.

Deep understanding of relational as well as NoSQL data stores, methods, and approaches (star and snowflake, dimensional modeling).

Act as Data domain expert for Snowflake in a collaborative environment to provide a demonstrated understanding of data management best practices and patterns.

Give coaching and guidance to team members and data analysts across the Business Unit.

Excellent written and verbal communication skills

Strong understanding of business KPIs and go-to-market engines.

Nice to have.

Certified Snowflake cloud data warehouse Architect.

Worked in the Healthcare domain.

We invite you to stay connected with us by subscribing to our monthly job openings alert here.

Research shows that women and other underrepresented groups apply only if they meet 100% of the criteria of a job posting. If you have passion and intelligence, and possess a technical knack (even if you're missing some of the above), we encourage you to apply.

Bounteous x Accolite is focused on promoting an inclusive environment and is proud to be an equal opportunity employer. We celebrate the different viewpoints and experiences our diverse group of team members bring to Bounteous x Accolite. Bounteous x Accolite does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, physical or mental disability, national origin, veteran status, or any other status protected under federal, state, or local law.

In addition, you have the opportunity to participate in several Team Member Networks, sometimes referred to as employee resource groups (ERGs), that host space with individuals with shared identities, interests, and passions. Our Team Member Networks celebrate communities of color, life as a working parent or caregiver, the 2SLGBTQIA+ community, wellbeing, and more. Regardless of your respective identity, there are various avenues we involve team members in the Bounteous x Accolite community.

Bounteous x Accolite is willing to sponsor eligible candidates for employment visas.

#BI-Remote

#LI-Remote

  • Senior Data Architect

    4 weeks ago

    Chicago, Illinois, United States AbbVie Full time

    Company DescriptionAbbVie's mission is to discover and deliver innovative medicines and solutions that solve serious health issues today and address the medical challenges of tomorrow. We strive to have a remarkable impact on people's lives across several key therapeutic areas immunology, oncology, neuroscience, and eye care and products and services in our...

  • Senior Data Architect

    1 month ago

    Chicago, Illinois, United States PerkSpot Full time

    PerkSpot is searching for a Senior Data Architect to join our Engineering Team Founded in 2006, we are on a Mission to Save Our Members Money by providing exclusive access to the best discounts available - anywhere. We ensure employees see offers curated to their interests, allowing them to save on electronics, home goods, meal delivery, mortgages, travel,...

  • Senior Cloud Architect

    2 days ago

    Chicago, Illinois, United States Nagarro Full time

    Job OpportunityNagarro, a leading Digital Product Engineering company, is seeking a highly skilled Senior Architect to lead the design and development of large-scale, high-performance applications.About the RoleWe are looking for a talented individual to join our team as a Senior Architect, responsible for creating architectural models that operate at scale...

  • Data Architect Manager

    2 months ago

    Chicago, Illinois, United States Origami Risk Full time

    The Data Architect Manager is a critical player-coach role that combines hands-on technical leadership with strategic management responsibilities in a SaaS B2B environment. This position involves actively contributing to projects as a Senior Data Architect while leading and mentoring a team of highly qualified Data Architects. This person is responsible for...

  • Data Architect

    3 days ago

    Chicago, Illinois, United States McDonald's Full time

    About the RoleThis exciting opportunity is part of the Global Technology Infrastructure & Operations team (GTIO) at McDonald's, where our mission is to deliver modern and relevant technology that supports the way our company works. We provide best-in-class foundational technology products and services, including Global Networking, Cloud, End User Computing,...

  • Senior Solutions Architect

    1 month ago

    Chicago, Illinois, United States Adame Services LLC Full time

    Job Title: Senior Solutions Architect - Google Cloud Platform (GCP) and AI/ML SpecialistMust have elite caliber GCP and AI/MI Google cloud from scratch.There are a lot of people with AWS background, but what we are specifically looking is with the GCP background and real experience on GCP and knowledge of AI/Ml with the new generation technologies, Llm and...

  • Senior Technical Architect

    3 days ago

    Chicago, Illinois, United States Dearborn Architects Full time

    Job OverviewPosition: Senior Technical ArchitectCompany: Dearborn ArchitectsDearborn Architects is a versatile firm focused on various sectors including dining establishments, entertainment venues, healthcare facilities, and childcare environments. This diverse expertise enables the firm to successfully branch into additional project categories such as...

  • Senior .NET Solutions Architect

    3 days ago

    Chicago, Illinois, United States Jobot Full time

    Job OverviewDynamic technology consulting firm is seeking a Senior Software Solutions ArchitectThis position is ideal for a skilled professional who is ready to take on a leadership role in a vibrant and innovative environment.About Us:We are a forward-thinking technology consulting company based in Chicago, looking for a Senior Developer with a strong...

  • Senior Project Architect

    1 week ago

    Chicago, Illinois, United States exp Global Full time

    Join EXP Global as a Senior Project ArchitectAt EXP, we are committed to delivering innovative solutions for both built and natural environments. As a collaborative team of engineers, architects, designers, and scientists, we unite diverse talents to tackle the world's most intricate challenges.Being part of EXP means experiencing personal growth while...

  • Senior Architect

    1 month ago

    Chicago, Illinois, United States United Airlines Full time

    Connecting People. Uniting the World. There's never been a more exciting time to join United Airlines As a global company that operates in hundreds of locations around the world — with millions of customers and tens of thousands of employees — we have a unique responsibility to uplift and provide opportunities in the places where we work, live and fly....

  • IT Architect- Data Product Solutions

    1 month ago

    Chicago, Illinois, United States Ahold Delhaize USA Full time

    Address: USA-IL-Chicago-300 South Riverside Plaza Store Code: Arch/Data - Business Intell & Analy Ahold Delhaize USA, a division of global food retailer Ahold Delhaize, is part of the U.S. family of brands, which also includes five leading omnichannel grocery brands - Food Lion, Giant Food, The GIANT Company, Hannaford and Stop & Shop. Ahold Delhaize USA...

  • Senior Cloud Solutions Architect

    1 week ago

    Chicago, Illinois, United States Elevance Health Full time

    Anticipated End Date: Position Title: Senior Cloud Solutions Architect Job Description: Senior Cloud Solutions Architect Location: This role will operate under a hybrid model (remote and office). The ideal candidate should reside within a reasonable commuting distance of an Elevance Health PulsePoint location.As a proud member of the Elevance Health family,...

  • Senior Project Architect

    9 hours ago

    Chicago, Illinois, United States EXP Full time

    About the RoleWe are seeking a highly skilled and experienced Senior Project Architect to join our team at EXP. As a Senior Project Architect, you will play a key role in leading and coordinating the technical development of projects, working closely with Project Managers and Principals to ensure the successful delivery of projects from conceptual design...

  • Senior Enterprise Architect

    2 months ago

    Chicago, Illinois, United States Thinking Minds, Inc. Full time

    Job Title: Senior Enterprise ArchitectJob Location: Chicago, ILMinimum Experience: 10 yearsJob Type: Full-timeAbout Us:Thinking Minds Inc. is dedicated to connecting top talent with leading companies. Our goal is to ensure every candidate finds a role that fits their skills and aspirations, while our clients receive the expertise they need to succeed. We...

  • Big Data Architect

    8 hours ago

    Chicago, Illinois, United States Tiger Analytics Full time

    Job OverviewTiger Analytics, a leading advanced analytics consulting firm, is seeking a highly skilled Big Data Engineer to join our team. Our company provides expert analytics services to Fortune 500 companies, helping them unlock business value from data.The ideal candidate will have a strong background in traditional and modern Big Data technologies,...

  • Azure Databricks Cloud Data Architect

    3 weeks ago

    Chicago, Illinois, United States Itl Usa Full time

    Job description Infosys is seeking an Azure Databricks Cloud Data Architect.Required Qualifications:Candidate must be located within commuting distance of Chicago, IL or be willing to relocate to this location.At least 7 years of Information Technology experienceHands on experience in architecting Cloud data solutions using Azure Synapse, Databricks, Python,...

  • Senior Manager, Data Product Strategist

    3 days ago

    Chicago, Illinois, United States AMADA Senior Care Mesa Full time

    About the RoleWe are seeking a highly skilled Senior Manager, Data Product Manager to join our team at AMADA Senior Care Mesa. This is a pivotal role in advancing our growth strategy through the effective use of data.Key ResponsibilitiesOversee data integrations for a customer data platform to ensure real-time and accurate data for our marketing team.Lead a...

  • Senior Cryptography Security Architect

    3 weeks ago

    Chicago, Illinois, United States Bank of America Full time

    Job Description:At Bank of America, we are guided by a common purpose to help make financial lives better through the power of every connection. Responsible Growth is how we run our company and how we deliver for our clients, teammates, communities and shareholders every day.One of the keys to driving Responsible Growth is being a great place to work for our...

  • Senior Solutions Architect

    1 week ago

    Chicago, Illinois, United States World Wide Technology Full time

    Position Overview:At World Wide Technology, we are on a mission to redefine the future of technology solutions. Our commitment to excellence drives us to seek a Senior Solutions Architect who will play a pivotal role in shaping the architectural vision for our clients. This individual will be a key technical leader, guiding the strategic direction of...

  • Senior Solutions Architect

    4 weeks ago

    Chicago, Illinois, United States Supernova Technology Full time

    ABOUT USFounded in 2014, we offer the industry's first and only cloud-based, fully-customizable, end-to-end software solution to automate securities-based lending from origination through the life of the loan. By combining thought leadership in suitability and risk management with industry-leading education and the latest technology, Supernova enables...