Cornerstone onDemand Cloud Data Warehouse Architect - Remote (United States) in Billings, Montana
Cornerstone is a global SaaS provider that services thousands of enterprise customers around the world supporting a 30 million+ user base and growing. We are looking for ahands-onCloud Data Warehouse Architect who is the “best of the best” in the industry with experience building end-to-end data architecture, designing and implementing a data warehouse from scratch in AWS cloud platform. Sound exciting? The ideal candidate will have necessary technical and business knowledge to develop overall data architecture, high-level design and implement the same. This is a unique, high visibility opportunity for someone with a passion to dive deep into disparate, structured and semi-structured data sets that provide unique insights to organization leadership and ultimately have an impact on the direction of our business.
In this role, you will…
Be ahands-onArchitect, leading and implementing a significant data architecture transformation.
Define an enterprise data architecture to establish a governed, curated, and agile data ecosystem that enables business to make data-driven decisions.
Analyze current application landscape to detect critical deficiencies in the data domain and recommend solutions for improving Business Technology’s value
Work with stakeholders, both leadership and subject matter experts, to build a holistic view of the organization's data assets.
Build and maintain a world-class enterprise data lake solution on an AWS cloud platform.
Develop data products incrementally and integrating and managing datasets from multiple sources like Salesforce, NetSuite etc.
Design and develop efficient, flexible, extensible data pipelines and reporting solutions.
Design and develop Rest APIs/ or web-service consuming clients for data push/pull for both upstream and downstream applications.
Implement and coach the team in Modern Data Architecture techniques and AWS Cloud Data Technologies.
Establish technical standards, including SW coding standards, tools, and platforms.
Possess strong understanding across Cloud and infrastructure components (server, storage, network, data, and applications) to deliver end to end Cloud architectures and designs.
Operate across organizational and computing silos to drive common approaches and to expose information assets and processes across the enterprise.
Collaborate with business stakeholders to understand the need/problem, break down requirements, and maintain communication through delivery.
Evaluate, prototype and recommend emerging data technologies and platforms from open source or vendors.
Translate strategic requirements into a usable enterprise information architecture, which include an enterprise data model, associated metamodel and taxonomy.
Consideration of security and privacy obligations
You’ve Got What It Takes If You Have…
Bachelor’s Degree in Computer Science, Management Information Systems, or a related field.
10+ years of experience in overall data warehouse and analytics space.
3+ years of experience building cloud Datawarehouse using AWS Redshift/Snowflake.
Expensive experience in relational and Dimensional data modelling .
Ability to write advanced SQL queries, Stored procedures and tune for performance.
Experience with Microsoft Power BI or any other visualization tools like Tableau.
Excellent analytical thinking and ability to identify and communicate data-driven insights.
Experience in building analytic solutions for Sales, Finance, Product and Marketing organizations
Experience working with AWS services such as Redshift, Athena, Spectrum, Glue etc.
Experience in DevOps CI/CD process using Jenkins and BitBucket/GitHub.
Coding proficiency in at least one modern programming language (Python, Java).
Ability to prioritize and manage work to critical project timelines in a fast-paced environment.
Excellent interpersonal, oral, and written communication skills with strong ability to influence both IT and business partners.
Effective team player. Honest and respectful of others.
Extra dose of awesome if you have…
- AWS Certified Big Data – Specialty certification.
Equal Employment Opportunity has been, and will continue to be, a fundamental commitment at Cornerstone OnDemand. All qualified applicants are given consideration regardless of race, color, gender, age, sexual orientation, national origin, marital status, citizenship status, disability, veteran status, or any other protected class as provided in applicable Federal, State, or Local fair employment laws. If you have a disability or special need that requires accommodation, please contact us at firstname.lastname@example.org