Database Architect

Remote
Full Time
IMS
Experienced

Solution Tree

About Us:

Solution Tree delivers comprehensive professional development to schools and districts around the world. We empower K–12 educators to raise student achievement through a wide range of services and products including educator conferences, customized district solutions for long-term professional development, books, videos, and online courses. Our headquarters is located in beautiful downtown Bloomington, Indiana, home of Indiana University and some of the best cultural, educational, and natural resources in the area. When you join Solution Tree, you join a highly regarded team that is dedicated to providing quality and excellence in professional development. Guided by our mission, vision, and values, our team is united under one goal – to transform education worldwide to ensure learning for all. If you have the passion and skill to help further Solution Tree’s mission, we want to hear from you.

 

Employees Enjoy:

  • Innovative, team-oriented environment
  • Working with leading voices and rising stars in staff development
  • A compensation package that includes competitive pay and benefits such as medical, dental, and vision insurance plans, 401k, paid time off, and more.
  • Doing work that matters

 

Database Architect

Position Summary:

Solution Tree is in need of a Database Architect to manage the company’s data and processes across multiple key systems. This position is responsible for defining the policies, procedures, models, and technologies to be used in collecting, organizing, storing and accessing company information. This role is also responsible for developing strategies and structures to connect data ecosystems and ensure data governance across the company.

 

Summary of Essential Job Functions:

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

  • Achieve organizational goals by defining, integrating, and upgrading a comprehensive architecture to support applications, platforms, and databases.
  • Maintain the data integrity by determining structural requirements, and developing and installing solutions.
  • Ensure adherence to the regulations and guidelines for technological systems and safeguarding of data.
  • Understand the data needs of all departments and how departments need to access and share the data.
  • Understand the business logic in current systems and develop the data plans to optimize systems with best practices.
  • Analyze the current state of the company’s databases and define a plan to integrate systems and create a source of truth.
  • Work closely with Application Development team to assist the database design for the IT projects
  • Represent data governance on cross-departmental teams and projects as appropriate
    Assist other Data Specialists in the company to improve the process efficiency and data accuracy
  • Lead the data warehouse project to provide the timely and accurate reports to the business heads and executives.

 

Competencies:

  • Data Guru
  • Technical Capacity
  • Communication Proficiency
  • Problem Solving/Analysis

 

Position Type/Expected Hours of Work:

This is a full-time position. Days and hours of work are Monday through Friday, 8:00 a.m. to 5 p.m.  Occasional evening and weekend work may be required as job duties demand.

 

Required Education and Experience:

  • Bachelor’s degree in computer science, engineering, or information systems
  • 8+ years’ experience with various database technologies, primarily MS SQL
  • 1-2 years previous experience as a Database Architect or a senior DBA with the enterprise level of software architecture design and implementation experience from data perspective
  • Understanding of data analysis, business principles, and operations
  • Strong data modeling skills
  • Experience with cloud data hosting and data management like AWS, Azure
  • Experience with building ELT processes by using technologies like SSIS, Boomi, or similar.
  • Experience with building the frontend reports with the capability to drill down to the details by leveraging BI tools like AWS QuickSight, Tableau, Zoho Analytics or similar.
  • Experience with data warehouse design and implementation is a plus
  • Experience with Netsuite and/or Salesforce is a plus
  • Good documentation and communication skill

 

Disclaimers:

The above statements are intended to describe the general nature and level of work being performed by people assigned to this position. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed.

Solution Tree is an Affirmative Action - Equal Employment Opportunity Employer.

Share

Apply for this position

Required*
Apply with
We've received your resume. Click here to update it.
Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

To comply with government Equal Employment Opportunity and/or Affirmative Action reporting regulations, we are requesting (but NOT requiring) that you enter this personal data. This information will not be used in connection with any employment decisions, and will be used solely as permitted by state and federal law. Your voluntary cooperation would be appreciated. Learn more.

Invitation for Job Applicants to Self-Identify as a U.S. Veteran
  • A “disabled veteran” is one of the following:
    • a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or
    • a person who was discharged or released from active duty because of a service-connected disability.
  • A “recently separated veteran” means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.
  • An “active duty wartime or campaign badge veteran” means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.
  • An “Armed forces service medal veteran” means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.
Veteran status



Voluntary Self-Identification of Disability
Voluntary Self-Identification of Disability Form CC-305
OMB Control Number 1250-0005
Expires 5/31/2023
Why are you being asked to complete this form?

We are a federal contractor or subcontractor required by law to provide equal employment opportunity to qualified people with disabilities. We are also required to measure our progress toward having at least 7% of our workforce be individuals with disabilities. To do this, we must ask applicants and employees if they have a disability or have ever had a disability. Because a person may become disabled at any time, we ask all of our employees to update their information at least every five years.

Identifying yourself as an individual with a disability is voluntary, and we hope that you will choose to do so. Your answer will be maintained confidentially and not be seen by selecting officials or anyone else involved in making personnel decisions. Completing the form will not negatively impact you in any way, regardless of whether you have self-identified in the past. For more information about this form or the equal employment obligations of federal contractors under Section 503 of the Rehabilitation Act, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such an impairment or medical condition. Disabilities include, but are not limited to:

  • Autism
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, or HIV/AIDS
  • Blind or low vision
  • Cancer
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or hard of hearing
  • Depression or anxiety
  • Diabetes
  • Epilepsy
  • Gastrointestinal disorders, for example, Crohn's Disease, or irritable bowel syndrome
  • Intellectual disability
  • Missing limbs or partially missing limbs
  • Nervous system condition for example, migraine headaches, Parkinson's disease, or Multiple sclerosis (MS)
  • Psychiatric condition, for example, bipolar disorder, schizophrenia, PTSD, or major depression
Please check one of the boxes below:

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.

You must enter your name and date
Human Check*