What are the responsibilities and job description for the Senior Data Analyst position at Triad Financial Services Inc?
Position Overview
Senior data analysts will lead in developing analysis and reporting capabilities. They will also monitor performance and quality of junior data analysts. Data analyst responsibilities include conducting full lifecycle analysis to include requirements, activities and design.
Essential Functions:
- Using automated tools to extract data from primary and secondary sources
- Setup and maintain report schedules and subscriptions via SSRS web interface
- Review business requirements to determine the current availability of data
- Review data sources to determine future availability or feasibility of obtaining data
- Create advanced or complex reports using T-SQL using provided business requirements
- Design data visualization templates using Excel or other modeling software
- Create new database tables to allow new data to be imported based on business needs
- Interpreting data, analyzing results using statistical techniques
- Removing corrupted data and fixing coding errors and related problems
- Identifies and executes on opportunities for self-service data tools
- Developing and maintaining databases, data systems – reorganizing data in a readable format
- Work with management to prioritize business and information needs
- Locate and define new process improvement opportunities
- Assist junior Data Analysts with assignments as required
- Review work of junior Data Analysts for completeness and accuracy
- Other duties as assigned
Minimum Qualifications:
- Highly proficient with Excel or other spreadsheet software, experience with Access a plus
- Strong problem-solving skills
- Accuracy and attention to detail
- Strong verbal and written communication skills
- Ability to work independently as well as in a team setting
- Strong mathematical and analytical skills to help collect, measure, organize, and analyze data
- Advanced T-SQL query writing skills
- 5 years’ experience with Microsoft SQL Server, T-SQL, SSRS and/or SSIS required
- 1 years of experience in the Mortgage Servicing Industry required
- Basic understanding of Extract, Transform, and Load (ETL) processes is a plus
- BS in Mathematics, Computer Science, Information Management or Statistics is a plus