Data Analyst I

Summary
This position supports the Product and Technology Department by managing work associated with the support of organizational data systems.
Responsibilities

• The role partners with leadership to maintain data warehouse for current and anticipated reporting needs
• Design and maintain data views needed for requested reports
• Document all data structures, relationships, and attributes in organizational data dictionaries
• Assist and train data warehouse users to understand the data structure and optimize the complex quires
• Assist in monitoring and improving the Data Warehouse performance and usage through query execution analysis and tuning
• Identify and report data integrity issues across data sources to promote ongoing data quality

Professional Skills

• Verbal Communication: Able to communicate complex business issues of strategic significance to large and small audiences including in an adversarial environment with customers and external parties
• Written Communication: Able to write reports, announcements, communications, and materials of significant commercial sensitivity which are clearly understood and achieve the overarching objective
• Teamwork: Able to foster a collaborative and productive environment in teams, including those of disparate members from across or outside SMS
• Relationships: Able to build strong and trusting relationships with individuals and leaders across and outside SMS which achieve desi
• Learning Agility: Able to set direction and create productive outcomes in an environment of ambiguity, uncertainty, and change
• Analysis: Able to undertake complex data analysis, using interpretive skills and business knowledge to draw conclusions and make recommendations
• Problem Solving: Able to apply a range of advanced problem-solving techniques to complex business issues, and apply creativity to the development of solutions
• Prioritization: Able to decide between competing priorities or limited resources to achieve significant business outcomes best aligned with the SMS strategy

Role Specific Skills

• Experience with Database and Data Warehouse
• Knowledge of database systems in general (Foreign keys, indexes, basic DBA tasks)
• Experience with performance tuning and query optimization
• Experience with Data Visualization Tools (Tableau, PowerBI)
• Understanding of ETL best practices and data engineering is a plus

Qualifications
Minimum Qualifications

• Education: Bachelor or Graduate degree in Computer Science, Statistics, Informatics, Information Systems, or another quantitative field - or commensurate experience
• Master's Degree preferred
• 0-3 years of experience in relevant field for Level I

Please note, this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities, and schedule may change at any time with or without notice.
SMS Assist is an Equal Opportunity Employer (EOE) that welcomes and encourages all applicants to apply regardless of age, race, color, religion, sex, sexual orientation, gender identify and/or expression, national origin, disability, veteran status, marital or parental status, ancestry, citizenship status, pregnancy or other reasons prohibited by law.
#LI-CA1