Data Architect

Company Profile 

At Sand Cherry Associates, we excel in the design and delivery of strategic customer-centric initiatives through digitally-native, data-empowered solutions.  Our client’s confidence in us is centered on exceptionally skilled, high-energy talent working with the support of the full Sand Cherry team.  Finding the right match for this role is a critical aspect of continuing that success.  

Overview 

We are looking for experienced data architects with experience in Microsoft Azure and optimizing data flows within a BI environment.  These roles will work to support Sand Cherry clients with their database administrative and development needs. This role will utilize programming and scripting in Python and Ruby. This is a remote, contract role for 6+ months and candidates will work in EST, CST or MST time zones. All qualified candidates must live in the United States and be authorized to work without requiring sponsorship or C2C.

Duties & Responsibilities 

• Responsible for the design, structure, and maintenance of data, usually organized in relational databases 
• Determines end user requirements for data usage including analytics and visualization 
• Ensures the accuracy and accessibility of data relevant to client’s organization or project 
• Identifies and creates connections to relevant data sources from within the organization as well as third party sources including government data sources 
• Assists in defining how data will be stored, consumed, integrated and managed by different data entities  
• Assesses existing data architecture and data management processes to determine gaps and means of optimization 
• Creates vision and documents resource requirements for organizational structure to support all phases of client data initiatives 
• Supports BI reporting and analytic requirements including GIS data visualization 
• Defines supplemental data collection methods including manual survey processes as necessary 
• Defines user access models for internal and public models and techniques to allow user inquiry and presentation of quantitative and visual findings from data analytics 
• Leverages strong skills in data modeling and logic  
• Creates effective quality and data integrity standards and processes 
• Aggregates data from various sources to uncover cross-functional insights

Requirements

Desired Skills and Experience 

• 5-7 years of experience in cloud data architecture  
• Proficiency in using Microsoft Azure, AWS, and Databricks
• Technology or financial industry knowledge is preferred.
• Proven ability to write SQL code and have familiarity with SQL server
• Proficiency in ETL and ELT tools and techniques including Azure Data Factory
• Excellent scripting and programming skills including Python, R and/or Ruby
• Proven ability to work with team members in a robust BI environment  
• Proven ability to communicate with clients at any level 
• Data-oriented, well-organized personality 
• Experience with cloud system administration and governance
• Experience working with various data sources and formats including APIs, SFTPs, and flat files
• Experience implementing cloud solutions from inception to steady state

Compensation

For individuals assigned and/or hired to work in Colorado, Sand Cherry Associates is required by law to include a reasonable estimate of the compensation range for this role. This compensation range is specific to the State of Colorado and takes into account a wide range of factors that are considered in making compensation decisions including but not limited to skill sets; experience and training; licensure and certifications; and delivery model. This is a short-term consulting engagement, with an hourly range between $75-$100/hr. Years of experience, level of education, geographic location, unique skills/qualifications for the specific role and potential certifications can be key factors in the final compensation for this role.

Benefits

Our team is unique — we are passionate about what we do. At Sand Cherry, our consultants know they are impacting and shaping our clients’ industries. We recognize our employees for their contributions. Our culture is one of the most friendly and communicative in the consulting industry. Sand Cherry is not a top-heavy organization. We offer the opportunity to be part of a digital workforce. Discover the experience that only comes with self-responsibility in the workplace. Our team members manage their own workloads and are expected to deliver exceptional work for our clients. Professional career growth is one of our main priorities, as we affirm that investing in our consultants and empowering our people will also deliver the best results and value for our clients.