Business Intelligence Analyst

$85,000 - $95,000/Yr

Cmg Financial - Baltimore, MD

Full-time - Mid Level

Baltimore, MD

Credit Intermediation and Related Activities

About the position

CMG Financial is seeking a Business Intelligence Analyst to enhance their data analytics and reporting capabilities. The role involves creating and managing business intelligence solutions that transform data into actionable insights, focusing on various data types related to the company and its online presence. The analyst will collaborate with the IT department to develop reporting environments, ensure data quality, and support business decision-making through effective data analysis and reporting.

Responsibilities

• Work with the IT department to develop an enterprise reporting environment, advising on software and hardware decisions.
• Provide quality assurance of reporting data.
• Manage reporting users and user roles.
• Build new data procurement and data processing rules.
• Develop business reports and dashboards for operations, sales, and marketing users.
• 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.
• Provide technical expertise on data storage structures, data mining, and data cleansing.
• Manage the reporting environment, including data sources, security, and metadata.
• Support initiatives for data integrity and standardization.
• Troubleshoot the reporting database environment and reports.

Requirements

• 5+ years' experience in a business intelligence role.
• Bachelor's degree in a quantitative field such as Mathematics, Statistics, Engineering, Econometrics, Business Intelligence, or related field required.
• Master's degree in a quantitative field preferred.
• Advanced SQL knowledge with data manipulation experience in a RDMS such as MS SQL Server.
• Experience with statistical software and programming preferred (R, SAS, Python, etc.).
• Extensive experience building datasets and reports within a common BI platform (e.g., Tableau, Domo, MS Power BI, Spotfire).
• Ability to communicate with business users to develop requirements for new reports.
• Comfortable sharing reporting results with business users and training users to use reports.
• Experience using MS Office suite, with exceptional knowledge of Excel.

Nice-to-haves

• Experience in the mortgage industry.
• Knowledge of data reports specific to mortgage lenders.

Benefits

• Competitive salary ranging from $85,000 - $95,000.
• Flexibility to work overtime to meet project deadlines.