BI Engineer

Business Intelligence (BI) Engineer

Guild Mortgage Company, closing loans and opening doors since 1960. As a mortgage banking firm, we are dedicated to serving the homeowner/buyer. Our goal is to provide affordable home financing for our customers, utilizing the best terms available while providing a level of professionalism and service unsurpassed in the lending industry.

The Business Intelligence (BI) Engineer is a key technical position and plays an important role in the organization by performing number of activities related to the company's Information Technology functions. The role is primarily responsible, under limited supervision, for executing Enterprise Data Strategy & Governance efforts by managing consumption platforms, governing enterprise-wide consumption for consistency and providing BI & Analytics consultation to various all levels of the organization on leveraging available data to gain actionable insights. Responsibilities include to manage and administer Enterprise-wide BI & Analytics Platforms, to understand business requirements and translate them into consumable and governed solution, from capturing data to designing KPIs and visualization for different audience across the enterprise.

This role is an exempt position with a Targeted Salary Range of $94,000 to $136,000 annually. Compensation at Guild is influenced by a wide array of factors including but not limited to local and federal minimum wage requirements, education, level of experience, and applicant's geographical location.

Essential Functions

• Collaborate with IT Infrastructure and Vendor to keep up the Business Intelligence Application and Platform for enterprise usage. Follow Best Practices to configure different environments.
• Establish processes to govern the platform and usage and, rollout across user community for adoption.
• Collaborate with key stakeholders, including the business unit leaders, Product, Data & Technology teams to assess data, KPIs, metrics needs versus readily available, verify its accuracy for the business need and facilitate reuse and consistency.
• Collaborate with key stakeholders, including the business unit leaders, Product, Data & Technology teams, to deliver on their data and analytics needs by producing live dashboards and/or reporting across multiple delivery platforms with focus on Self-Service Enablement.
• Collaborate with Business Analyst to Analyze Data and KPIs available versus Management asks to define new metrics for various business operations and strategic need e.g. New opportunities, process improvements and cost optimizations.
• Collaborate with key stakeholders in Stewardship model to maintain metadata and ownership of KPIs, metrics for consistent usage across enterprise.
• Analyze data to identify causal relations among data points and trend other correlations over time and call out outliers and anomalies
• Ensure consistent delivery of high-quality insights to key stakeholders by reconciling and validating dashboards and reports in a timely manner.
• Identify internal process improvements for automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Maintain access controls to BI and Analytics Platform, Reports, Dashboards to ensure sensitive information is restricted on a need-to-know basis.
• Identify and document the Business Continuity Plan/Disaster Recovery (BCP/DR), and technical requirements for high availability and recoverability for the analytics platform.
• Contribute to the team of data professionals by using expertise to answer questions and sharing templates, reusable artifacts with less experienced teammates, enhancing skillsets and competencies of team members, and sharing business domain knowledge throughout the team.
• Participate in stakeholder reviews, and design sessions.
• Provide data, reports, and information to management as needed.
• Identify, track, and monitor trends and avoidable technology-related errors; work across functions to develop complex solutions, improvements, and stop-gaps.
• Focus on the continual improvement of policies, procedures, and processes falling under scope of authority.
• Use expertise to resolve high level issues that cannot be solved by teammates.
• Stay abreast of latest technology trends and participate in high-level decisions impacting the direction of Information Technology function.
• Consistently monitor and model platform usage, database sizes, compute resources and third-party costs to ensure that the spend is as cost-efficient as possible.
• Champion data transformation to new ways of working and generating insights.
• Drive strong communications, partnerships, and stakeholder management with senior leaders, functional managers, and staff.
• Perform other duties as assigned.

Qualifications

• Bachelor's degree in Statistics, Computer Science, Data Science, or related quantitative field to the position is required.
• Minimum three to five years' experience in BI Analyst related role(s) two of those years spent in a senior technical level role(s) required.
• Proficient with business intelligence platforms, mainly Power BI and Tableau.
• Well Versed in MS Azure Services related to BI and Analytics.
• Considered expert in Power BI Administration and Development with relevant Certifications
• Proficient in configuring and managing enterprise-wide used platform by adopting Best Practices
• Proficient in designing and rolling out SDLC processes to govern usage on BI Platforms
• Proficient in concepts and implementation of Data Governance, Stewardship, Metadata Management.
• Proficient in developing reports, Dashboard, self-service BI and visualizations
• Experienced in technical documentation, metadata dictionary, data validation rules, quality acceptance criteria, software development lifecycle (SDLC) in Agile and ITILv4 frameworks.
• Expert in SQL and experienced with databases such as AuroraDB, IBM DB2, MemSQL, MS SQL Server, MySQL, Postgres, Redshift, or Snowflake, and NoSQL Databases such as Cassandra, DynamoDB, Redis, or MongoDB.
• Experience with analyzing structured, semi-structured and unstructured data in various popular formats and sourced from internal core systems as well as 3rd partner providers such as Google Analytics, Facebook Insights, Zillow, CoreLogic, MLS Data, Public Records, and Property Data.
• Experience using collaboration tools such as Microsoft Office or Google G-Suite as well as Jira, Confluence, and Microsoft SharePoint.
• Problem solver with an ability to performing root cause analysis, work as a team towards a solution.
• Ability to prioritize multiple tasks in a deadline-driven environment, strong sense of urgency and responsiveness.
• Strong detail orientation and highly organized with proven ability to lead effectively and drive results in a matrixed management environment.
• Ability to think critically, including the ability to evaluate facts and data to draw conclusions, determine the downstream impact of decisions and associated risks.
• Excellent verbal and written communication skills plus demonstrate strong leadership capabilities.
• Strong interpersonal and team building skills.
• Self-starter with the demonstrated ability to learn/adapt to new technologies and techniques.
• Excellent verbal and written communication skills.
• Highly organized and detail-oriented; ability to work in a fast-paced, metrics-driven environment required.
• Proficiency in Microsoft Office Suite, Word, Excel, Wiki, collaborative cloud-based programs, and third-party software applications required.
• Commitment to company values.
• Customer Service - Proactive attention to each person
• Integrity - Do and say what's right
• Respect - Treat others with dignity
• Collaboration - Listen and work together
• Learning - Seek knowledge and strive for improvement
• Excellence – Deliver the unexpected

Supervision

• Job Scope: Responsible for understanding the department/functional area objectives and goals and how own job contributes to achievement of these goals; may recommend changes and enhancements based on analysis and evaluation of circumstances
• Complexity: General precedents may exist for most problems; conducts independent research/analysis to identify the appropriate approach
• Impact: Decisions and actions primarily impact own work with limited impact on peers in their area, contributes as team member rather than leader
• Interaction/Supervision: Acts as a mentor/guide to less experienced professional contributor staff in a similar role; works independently and only under general direction; guided by professional standards, desired outcomes, and project plan specifications

Requirements

• Physical: Work is primarily sedentary; mobility in an office setting.
• Manual Dexterity: Frequent use of computer keyboard and mouse.
• Audio/Visual: Regularly required to accurately perceive, distinguish and interpret information received visually and through audio, e.g., words, numbers and other data broadcasted aloud/viewed on a screen, as well