Junior Data Analyst

Physical Requirements of the Job Lift 30 lbs.

Primary Job Functions

• Data Extraction and Analysis-
• Should be able to extract data from various sources by executing existing processes or using an existing tool.
• Should assist in creating processes to profile, clean, manipulate, and map the extracted data.
• The candidate should be able to reconcile the data to ensure there are no discrepancies or missing data from the source after extraction and cleanup.
• Candidate should be able to assist in summarizing, analyzing the data, and interpreting results.
• Data Warehousing -
• Candidate should be able to use established design, update, and maintain the databases used for the data warehouse.
• Assist the data analyst in designing and creating data models for data warehousing and mining.
• Build and run SQL scripts to pull, aggregate, display, and interpret data.
• Reports and Visualization -
• Build, monitor, and maintain dashboard.
• Use existing analytical tools available in different applications and create, modify data visualizations based on user requirements (i.e. Avatar KPI, Azara, PowerBI, etc.).
• Should inform stakeholders of any red flags by looking at the data and help them make decisions.
• Respond and review ad-hoc data requests. Create and format reports based on user requests.
• Company and project initiatives
• Learn AltaPointe business processes and organizational needs.
• Collaborate with IT stakeholders to understand business needs and assist in providing analytical information and/or solutions.
• Participate in new project initiatives and assist in analyzing the impact on existing analytics and developed applications, and communicate necessary changes and development.
• Document all development in various systems and maintain ongoing documentation.
• Other IT duties as deemed necessary should include, but not be limited to the following
• Test and document compliance related to the MIS policy and procedure.
• Assist in system(s) evaluations with other IT staff.
• Participate in IT team meetings and initiatives.
• Participate in the strategic planning process for IT.
• Participation in and chairing committees deemed necessary to support standards and accreditations.
• Assist in providing training when deemed necessary.
• Participate in Orientation Training for IT.
• Provide application training when deemed necessary.
• Perform other duties as assigned by the supervisor.
• Administrative and other related duties as assigned
• Actively participates in Performance Improvement activities
• Actively participates in AltaPointe committees as requested.
• Completes assigned tasks in a timely manner.
• Treats consumers with dignity and respect.
• Works in a cooperative manner with other AltaPointe employees.
• Follows AltaPointe policies and procedures.
  
  
  

Minimum Qualifications

Bachelor’s degree in Information Systems or Business. Experience in SQL database design, T-SQL programming, data modeling, data warehousing, experience in Integration Services (SSIS), Reporting service (SSRS), and Analytical services (SSAS), experience in .Net programming, ASP, JavaScript; experience managing software deployments; application planning, development, and training; experience working with departmental leaders, task-oriented, good communication, analytical, quick learner, problem-solving, and organizational skills. Candidate must possess a combination of business, technical, and project management skills. Knowledge of Microsoft Office and analytical and reporting tools, i.e. Power BI and Crystal.