Sr BI Engineer

Guild Mortgage Company, closing loans and opening doors since 1960. As a mortgage banking firm we are dedicated to serving the home owner/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.

Position Summary

The Senior 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.

Essential Functions

• Partner 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.
• Partner 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.
• Partner 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.
• Partner 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.
• Partner 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, BS in Statistics, Computer Science, Data Science or related quantitative field is required, along with a minimum of five to seven years’ experience in BI Analyst related role(s) and at least two of those years spent in a senior technical level role(s) required.
• Highly 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
• Highly proficient in configuring and managing enterprise-wide used platform by adopting Best Practices
• Highly proficient in designing and rolling out SDLC processes to govern usage on BI Platforms
• Highly proficient in concepts and implementation of Data Governance, Stewardship, Metadata Management.
• Highly 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, guides the 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.
• Ethical, with a commitment to company values.

Requirements

Travel: Infrequent based on company events and/or relevant conferences or training

Physical: Work is primarily sedentary; mobility in an office setting.

Manual Dexterity:  Frequent use of computer keyboard and mouse.

Audio/Visual: Ability to accurately interpret sounds and associated meanings at a volume consistent with interpersonal conversation. 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 as print and other media.

Environmental:  Office environment – no substantial exposure to adverse environmental conditions.

Guild offers a pleasant work environment, competitive compensation and excellent benefits package; including medical, dental, vision, life insurance, AD&D, LTD and 401(k) with employer match.

Guild Mortgage Company is an Equal Opportunity Employer. 

Targeted Salary Range: $102,000 - $139,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.

 REQ#: SRBIE016771