Data Analyst II

CMG Financial is looking for a Data Analyst who can turn project requirements into custom-formatted dynamic data reports. The ideal candidate for this position can do complete life cycle data generation and outline critical information for the business. You will take responsibility for managing data sets, developing reports, and troubleshooting data issues. To do well in this role you need a very fine eye for detail, experience as a data analyst, and understanding of the popular data analysis tools and databases.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

• Provide quality assurance of reporting data.
• Manage reporting users and user roles.
• Maintain data processing rules.
• Develop business reports and dashboards for operations, sales, and marketing users.
• Generate reports from multiple systems.
• Mine and analyze loan production data to inform business decisions.
• Monitor analytical metrics and create automated alerts to trigger business response.
• Implement new data analysis methodologies.
• Train end users on new reports and dashboards.
• Manage the reporting environment, including data sources, security, and metadata.
• Support initiatives for data integrity and standardization.
• Troubleshoot the reporting database environment and reports.

QUALIFICATIONS AND EXPERIENCE:

• Bachelor’s degree in quantitative field such as Mathematics, Statistics, Engineering, Econometrics, Business Intelligence, or related field preferred.
• Proficient in SQL with experience in a RDMS such as MS SQL Server.
• Experience with statistical software and programming preferred (R, SAS, Python, etc.) a plus.
• 1+ years’ data mining experience.
• Experience working within a common BI platform (e.g., Tableau, Domo, MS Power BI).
• Ability to communicate with business to develop requirements for new reports.
• Comfortable sharing reporting results with business users and training users to use reports.
• Strong attention to detail.
• Experience using MS Office Suite, with excellent knowledge of Excel.

SUPERVISORY RESPONSIBILITIES:

Direct Reports:  N/A

PHYSICAL and ENVIRONMENTAL CONDITIONS

Standard office environment, equipment and tasks, including work at a computer terminal.  This position requires partial sitting and walking throughout the day.  Employees must be open to work overtime to complete assigned tasks.

Base Compensation Information – CMG pays a competitive salary which ranges from $75,000 - $90,000. Factors that affect salary may include: experience working as a Data Analyst, overall knowledge of data reports, number of years worked in mortgage industry, types of roles performed, computer skills, experience specific to working with mortgage lenders, and education.

 #LI-DNI