Database Architect &Analytics - remote

Position:

Database Architect &Analytics

Department:

Solutions 

location:

Remote/travel as needed

status:

Exempt 

Supervised By:

Solutions Executive 

Revision:

February 2020

JOB SUMMARY:

This position is responsible to create and manage large and expansive electronic databases, and to store and organize vast amounts of data. ... Work closely with software designers and engineers, design analysts and others. Creates comprehensive databases to support both the strategic corporate goals and all Product Roadmaps.

MINIMUM REQUIRED EDUCATION, TRAINING AND EXPERIENCE:

• 10+ years’experience of database development
• 10+ years’experience supporting application development teams/projects
• Experience with DBA tasks supporting relational databases in an enterprise environment
• Strong experience with Extract, Transform, Load (ETL) job development and maintenance
• Expert experience in SQL writing and query optimization skills
• Experience in Postgres highly preferred
• Experience with AWS environment preferred

REQUIRED SKILLS:

• Strong understanding of data modeling
• Strong understanding of enterprise database concepts
• Strong analytical skills
• Strong communication skills
• Strong leadership skills
• Strong presentation skills (written and verbal)
• Extremely detailed approach to work effort

• Impeccable organizational skills
• Demonstrable ability in juggling multiple tasks/projects

• Ability to be a quick and independent learner
• Ability to identify and mitigate risks appropriately

JOB SPECIFIC DUTIES: These are job duties specific to your role

INTERNAL:

• Design high performance, extensible data models/database structures
• Facilitate project requirements and new requests for data
• Create normalized tables
• Write functions and views
• Maintain legacy schemas
• Refactor legacy schemas
• Model and document database objects
• Develop and support ETL processes
• Improve quality and integrity of data imports
• Perform administrative tasks on the database
• Perform maintenance tasks on the database
• Perform monitoring tasks on the database
• Complete performance tuning tasks on the database
• Identify proactive solutions and corrective measures
• Apply proactive solutions and corrective measures
• Minimize downtime
• Troubleshoot production and development database environments
• Provide configuration for production database environments
• Maintain and support production and development database environments
• Collaborate with business stakeholders and other technical team members as required
• Gather application requirements
• Analyze application requirements
• Design database solutions that satisfy business requirements
• Analyze database Schemas in legacy systems
• Identify appropriate Data Elements
• Build scripts
• Build utilities
• Migrate data into new reporting layer
• Writes SQL queries
• Extract data
• Transform data
• Aggregate data
• Provide key insights on performance
• Identify data patterns
• Create metrics
• Track metrics
• Identify early performance issues
• Provide recommendations
• Reduce operating costs
• Increase operating efficiency
• Rapidly prototype
• Create exploratory analytical work
• Support the ideation process

EXTERNAL:

• Leverage commercial, public, and private data
• Ensure knowledge of BI best practices/methodologies
• Keep current on relational database management concepts
• Keep current on dimensional data modeling
• Keep current on data warehouse concepts
• Keep current on reporting techniques
• Collaborate with multiple, cross-industry clients
• Demonstrate understanding of client data and reporting needs
• Support business development efforts as required

JOB ESSENTIAL DUTIES:  These are job duties essential for every position at Libera

COMMUNICATION: 

• Actively listens to others
• Ability to present information
• Written communication skills
• Demonstrate concern and understanding
• Treat confidential information appropriately
• Promote open communication
• Provide timely and effective written/verbal communication
• Keep others informed of progress and/or problems
• Share information
• Explain reasons for decisions affecting others

PROBLEM SOLVING:

• Proactive approach to solving problems
• Gathers and analyzes information skillfully
• Think creatively
• Anticipate problems
• Demonstrate conflict resolution skills and ability to solve problems
• Identify and mitigate risks appropriately
• Recommend improvements to security policies when possible weaknesses are observed

 LEADERSHIP:  

• Deliver according to Corporate goals
• Demonstrate ability to manage conflict
• Prepare research-based recommendations for data tools and industry trends
• Take proactive approach to implement change
• Ensure all people are treated with dignity and respect
• Be self-motivated
• Demonstrate a positive attitude
• Display willingness to make decisions
• Is customer focused
• Motivate others to perform well
• Manage stress
• Seek opportunities for professional / self-development
• Exhibits confidence in self and others
• Be polite and avoid offensive language
• Seek to be an example in all actions and interactions

 TEAMWORK:  

• Work effectively and dependably with others to meet team objectives
• Encourage others
• Demonstrate concern and understanding for co-workers
• Exhibits objectivity and openness to other’s views
• Prepares for and leads meetings
• Demonstrate strong responsibility toward personal assignments
• Is accountable for actions
• Use and/or encourages joint problem solving
• Involves others in decision making
• Is open to receiving and giving feedback
• Develop peer relationships

CORPORATE CULTURE:

• Follow Libera’s Mission by “Simplifying life through leveraging technology”
• Embrace Libera’s Vision “To become the provider of choice for those bettering our world”
• Values: Foster and deliver according to:
  • “Integrity” by being fair and balanced, truthful, and upholding moral fortitude
  • “Innovation” by taking action to revolutionize, change, and transform our organization
  • “Collaboration” by working together and sharing common goals to find the Win-Win
  • “Pioneering” by discovering, spearheading, and trailblazing to create original products
  • “Community” by serving the needs of others and of our world
• Guiding Principles:
  • Consistently place “Relationship First, Business Second”
  • When collaborating “Never Negate Perception”because our “Differences Matter”
  • Embrace our “Always Be Improving”mentality
  • Exhibit continuous “Overcome Every Problem” attitude by recommending solutions

All the above job duties are subject to reasonable accommodation. This job description is to provide a representative summary of the major duties and responsibilities performed by incumbents of this job. Incumbents may be required to perform job-related tasks, duties, and/or responsibilities other than those specifically presented in this description.