<h5>Description </h5> The Sr. Business Intelligence Analyst will work with Credit Admin / Credit Risk / Model Dev team leaders and specialists to understand business goals and needs and translate these into requirements and solution designs with a focus on driving business value and positive outcomes. This role is responsible for developing consistent and coherent sets of analytical tools - design, development, implementation, and control designs for credit risk (e.g. portfolio stress testing and Current Expected Credit Losses (CECL) accounting used for the Allowance for Credit Loss, and concentration correlation analyses).
In this role, the incumbent will take lead analyst roles in BI projects driving requirements definitions, documentation efforts and as necessary report creation, queries, etc. to support Credit Admin team needs. This role is integral as a liaison among stakeholders and project teams helping to enhance Data team performance. Essential Functions * Responsible for developing consistent and coherent sets of models and analytical tools for credit risk measurement, management and reporting. Activities range from analytical tool design, development, implementation, and control designs used for understanding credit risk, such as portfolio stress testing and the Current Expected Credit Losses (CECL) accounting used for the Allowance for Credit Loss, and concentration correlation analyses * Interview Credit Admin / Credit Risk team stakeholders to identify business needs and translate these into requirements and solution designs with a focus on driving business value and positive outcomes. * Interview users to understand how they do their jobs and what they need from data systems to improve performance, deliver on functional enhancements, monitor portfolios, etc. * Analyze business processes, recommend changes that improve outcomes, influence stakeholders to build consensus, and implement approved changes * Build and / or maintain Documentation Librar(ies) and Catalog(s) to ensure that such documentation is available upon request by management, regulators, and internal and external auditors
* Monitor data environment builds, executions, execution run-times, change developments, change implementations, and workplans. * Develop quantitative modeling other than CECL, such as loss forecasting, predictive risk rating models, stress testing, and profitability analysis. * Take the lead in developing and implementing predictive analytical tools, ad hoc analyses, visual/interactive reporting, segmentation analysis, and process automation. Identify the problem, provide potential solutions, and design the model construct * Translate business goals, user needs and process improvements into data management functions and requirements * Explain the value, capabilities and limitations of data systems to business managers and users as the project is designed and built * Lead individual and group project designs, wireframes, and mockups of analytic dashboards, visualizations, scorecards, stack rankings, and reports, and provide approved technical specifications to developers * Analyze and structure data to implement enterprise data management goals of identifying, storing, processing, provisioning and governing data * Ensure data quality by validating data to assess fitness for use, identifying and directing remediation of issues, and completing quality assurance testing * Follow Data Governance procedures to ensure that data and data based processes are appropriately managed * Work with Enterprise data warehouse, analytical cubes, metadata and master data management to provide business insights for decision making * Analyze and complete project requests * Troubleshoot and resolve data issues Additional Essential Functions * Ensure compliance with Northwest's policies and procedures, and Federal/State regulations * Navigate Microsoft Office Software, computer applications, and software specific to the department in order to maximize technology tools and gain efficiency * Work as part of a team * Work with on-site equipment Additional Responsibilities * Complete other duties and special projects as requested Safety and Health for those without supervisory duties * Abide by the rules of the safety and loss prevention program * Perform work tasks in a safe manner * Report any and all injuries to supervisor * Know what to do in case of an emergency QUALIFICATIONS To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Education Master's Degree Finance, Statistics or Quantitative field required and CECL experience required Or Bachelor's Degree Finance, Statistics, Quantitative field or Information Technology required and experience in credit administration, CECL, and data Or Work Experience 6 - 8 years Business Intelligence Analyst, Data Analyst, Business analyst or equivalent And 3 - 5 years Banking or Financial Institution experience And 2 - 3 years Credit / Current Expected Credit Loss / Credit Portfolio Monitoring And 2 - 3 years Knowledge of SQL, Power/BI, Python, R General Employee Knowledge, Skills, and Abilities * Ability to establish effective working relationships among team members and participate in solving problems and making decisions * Ability to present and express ideas and information clearly and concisely in a manner appropriate to the audience, whether oral or written * Ability to actively listen to what others are saying to achieve understanding, sharing information with others and facilitating the open exchange of ideas and information * Ability to establish courses of action for self to accomplish specific goals, develop and use tracking systems for monitoring own work progress, and effectively use resources such as time and information * Ability to make right decisions based on perceptive and analytical processes, practicing good judgment in gray areas Additional Knowledge, Skills and Abilities Ability to analyze data using Microsoft Excel or any other equivalent tool Ability to analyze data using SQL and Microsoft Power BI Ability to analyze and document requirements Ability to analyze, design and develop reports, scorecards and dashboards Knowledge working with any data warehouse system and is any master data management (MDM) system Knowledge of working with any customer relationship management (CRM) system e.g. Dynamics CRM, etc and Microsoft SharePoint Licenses and Certifications CBAP (or equivalent) Upon Hire And Microsoft Certified: Power BI Data Analyst Associate or equivalent Within 1 year Or Microsoft Certified: Azure Data Engineer Associate or Microsoft Certified: Azure Data Scientist Associate or equivalent Within 1 year Additional Licenses and Certifications Completion of Certifications within 1 Year <h5>Qualifications </h5> Licenses & Certifications BUS ANAL CERT (preferred) MICR IT PROF (preferred) Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)

The Sr. Business Intelligence Analyst will work with Credit Admin / Credit Risk / Model Dev team leaders and specialists to understand business goals and needs and translate these into requirements and solution designs with a focus on driving business value and positive outcomes. This role is responsible for developing consistent and coherent sets of analytical tools - design, development, implementation, and control designs for credit risk (e.g. portfolio stress testing and Current Expected Credit Losses (CECL) accounting used for the Allowance for Credit Loss, and concentration correlation analyses). In this role, the incumbent will take lead analyst roles in BI projects driving requirements definitions, documentation efforts and as necessary report creation, queries, etc. to support Credit Admin team needs. This role is integral as a liaison among stakeholders and project teams helping to enhance Data team performance. Essential Functions • Responsible for developing consistent and coherent sets of models and analytical tools for credit risk measurement, management and reporting. Activities range from analytical tool design, development, implementation, and control designs used for understanding credit risk, such as portfolio stress testing and the Current Expected Credit Losses (CECL) accounting used for the Allowance for Credit Loss, and concentration correlation analyses • Interview Credit Admin / Credit Risk team stakeholders to identify business needs and translate these into requirements and solution designs with a focus on driving business value and positive outcomes. • Interview users to understand how they do their jobs and what they need from data systems to improve performance, deliver on functional enhancements, monitor portfolios, etc. • Analyze business processes, recommend changes that improve outcomes, influence stakeholders to build consensus, and implement approved changes • Build and / or maintain Documentation Librar(ies) and Catalog(s) to ensure that such documentation is available upon request by management, regulators, and internal and external auditors • Monitor data environment builds, executions, execution run-times, change developments, change implementations, and workplans. • Develop quantitative modeling other than CECL, such as loss forecasting, predictive risk rating models, stress testing, and profitability analysis. • Take the lead in developing and implementing predictive analytical tools, ad hoc analyses, visual/interactive reporting, segmentation analysis, and process automation. Identify the problem, provide potential solutions, and design the model construct • Translate business goals, user needs and process improvements into data management functions and requirements • Explain the value, capabilities and limitations of data systems to business managers and users as the project is designed and built • Lead individual and group project designs, wireframes, and mockups of analytic dashboards, visualizations, scorecards, stack rankings, and reports, and provide approved technical specifications to developers • Analyze and structure data to implement enterprise data management goals of identifying, storing, processing, provisioning and governing data • Ensure data quality by validating data to assess fitness for use, identifying and directing remediation of issues, and completing quality assurance testing • Follow Data Governance procedures to ensure that data and data based processes are appropriately managed • Work with Enterprise data warehouse, analytical cubes, metadata and master data management to provide business insights for decision making • Analyze and complete project requests • Troubleshoot and resolve data issues Additional Essential Functions • Ensure compliance with Northwest's policies and procedures, and Federal/State regulations • Navigate Microsoft Office Software, computer applications, and software specific to the department in order to maximize technology tools and gain efficiency • Work as part of a team • Work with on-site equipment Additional Responsibilities • Complete other duties and special projects as requested Safety and Health for those without supervisory duties • Abide by the rules of the safety and loss prevention program • Perform work tasks in a safe manner • Report any and all injuries to supervisor • Know what to do in case of an emergency QUALIFICATIONS To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Education Master's Degree Finance, Statistics or Quantitative field required and CECL experience required Or Bachelor's Degree Finance, Statistics, Quantitative field or Information Technology required and experience in credit administration, CECL, and data Or Work Experience 6 - 8 years Business Intelligence Analyst, Data Analyst, Business analyst or equivalent And 3 - 5 years Banking or Financial Institution experience And 2 - 3 years Credit / Current Expected Credit Loss / Credit Portfolio Monitoring And 2 - 3 years Knowledge of SQL, Power/BI, Python, R General Employee Knowledge, Skills, and Abilities • Ability to establish effective working relationships among team members and participate in solving problems and making decisions • Ability to present and express ideas and information clearly and concisely in a manner appropriate to the audience, whether oral or written • Ability to actively listen to what others are saying to achieve understanding, sharing information with others and facilitating the open exchange of ideas and information • Ability to establish courses of action for self to accomplish specific goals, develop and use tracking systems for monitoring own work progress, and effectively use resources such as time and information • Ability to make right decisions based on perceptive and analytical processes, practicing good judgment in gray areas Additional Knowledge, Skills and Abilities Ability to analyze data using Microsoft Excel or any other equivalent tool Ability to analyze data using SQL and Microsoft Power BI Ability to analyze and document requirements Ability to analyze, design and develop reports, scorecards and dashboards Knowledge working with any data warehouse system and is any master data management (MDM) system Knowledge of working with any customer relationship management (CRM) system e.g. Dynamics CRM, etc and Microsoft SharePoint Licenses and Certifications CBAP (or equivalent) Upon Hire And Microsoft Certified: Power BI Data Analyst Associate or equivalent Within 1 year Or Microsoft Certified: Azure Data Engineer Associate or Microsoft Certified: Azure Data Scientist Associate or equivalent Within 1 year Additional Licenses and Certifications Completion of Certifications within 1 Year Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)

Job Title: Business Intelligence Analyst Reports To: Director of IT Location: Pittsburgh, Pennsylvania Job Type: Hybrid Company Statement: Montauk Renewables, Inc. (NASDAQ: MNTK) is a renewable energy company specializing in the management, recovery, and conversion of biogas into RNG. The Company captures methane, preventing it from being released into the atmosphere, and converts it into either RNG or electrical power for the electrical grid ("Renewable Electricity"). The Company, headquartered in Pittsburgh, Pennsylvania, has more than 30 years of experience in the development, operation, and management of landfill methane-fueled renewable energy projects. The Company has current operations at 15 operating projects located in California, Idaho, Ohio, Oklahoma, Pennsylvania, North Carolina, and Texas. The Company sells RNG and Renewable Electricity, taking advantage of Environmental Attribute premiums available under federal and state policies that incentivize their use. Summary: The Business Intelligence Analyst will help deliver actionable data to end-users within the company to guide decisions and derive actionable insight. An ideal candidate would be humble, curious, and proactive in looking for new solutions and in learning new skills. Required in-office minimum 2 days a week. General Responsibilities: <ul><li>Synthesize large volumes of data and maintain SQL databases for RNG and Electric operating facilities.</li><li>Work with other departments/functions to create specific data-driven reports requiring extensive backend data manipulation and calculations. </li><li>Promote a data-driven organization and empower teams with actionable data and with automated and intuitive reports.</li><li>Create usable SQL queries and expressions within the databases and associated SSMS/PowerBI reports.</li><li>Construct and maintain all site-level data pipelines and data flows from operations facilities. </li><li>Support ongoing efforts to ensure datapoints are applied to all relative database locations and document their use in production environments.</li><li>Create and maintain documentation that includes the design, requirements and user manuals for the organization.</li><li>Identify the development needs for the purpose of streamlining and improving the operations of the organization for efficiency and profitability.</li><li>Provide the first line of support and problem resolution for technology products or applications.</li><li>Respond to inquiries and requests for assistance with organization's computer systems or PCs; resolves customer inquiries for one or more products or services.</li><li>Day-to-day support activities including ticket creation and resolution.</li></ul> Key Responsibilities: <ul><li>Database Management:</li><li>Upkeep and manage internal SQL databases using SSMS, including extensive SQL code queries, jobs, and stored procedures.</li><li>Ensure data integrity, performance, and security of SQL databases.</li><li>Conduct regular database maintenance, backup, and recovery procedures.</li><li>Optimize database performance and troubleshoot issues to minimize downtime.</li><li>Data Analysis and Modelling:</li><li>Conduct in-depth data analysis and modeling using data from renewable gas and electric energy plants across the country.</li><li>Synthesize large volumes of data and complex concepts into clear, actionable insights.</li><li>Support various departments with data extraction, transformation, and loading (ETL) processes.</li><li>Regulatory Compliance:</li><li>Work closely with Environmental and Operations departments to ensure all data complies with state regulations and requirements.</li><li>Maintain documentation of data compliance procedures and standards.</li><li>Cross-Functional Collaboration:</li><li>Develop strong partnerships across the company, including Engineering, Operations, Finance, and more.</li><li>Collaborate with team members to collect data and support the company's mission and goals.</li><li>Business Intelligence Support:</li><li>Provide support for the development and management of business intelligence solutions.</li><li>Assist in creating and maintaining reports using SSRS and PowerBI to support business decision-making.</li><li>Technical Support and Process Improvement:</li><li>Provide the first line of support and problem resolution for database-related issues.</li><li>Respond to inquiries and requests for assistance with SQL database systems.</li><li>Identify opportunities for process improvements and implement solutions to enhance database operations.</li><li>Vendor and Partnership Management:</li><li>Meet with vendors and business partners to advance relationships and create valuable partnerships for the company.</li><li>Evaluate and implement new database technologies and tools in collaboration with the IT department.</li><li>Travel and Auditing:</li><li>Travel to various site locations to conduct internal IT auditing and ensure data transfer operates in efficient and secure manner.</li></ul> Minimum Requirements: The successful candidate is expected to have a bachelor's degree in Mathematics, Computer Science, Information Management or Statistics or a minimum of 3 years of experience in the information technology and energy industry or comparable experience and education. 3-5 years of experience as a data analyst preferred. Skills Desired: •Excellent interpersonal, communication, listening and presentation skills •The ability to work both as a team and independently •Excellent problem solving and analytical skills •Technological and computer knowledge •Knowledge in SQL, SSRS, Power BI, Workflow Automations •Technical expertise regarding data models, database design development, data mining and segmentation techniques •Strong knowledge of and experience with reporting packages (Business Objects etc.), and databases (SQL etc.) •Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy •Adept at queries, report writing and presenting findings Physical Demands: •Required to be able to stand, sit, walk, and lift light objects up to 50 pounds •Ability to walk over uneven terrain •Up to 15% travel as needed Benefits: •Full-Time employees are eligible for a strong benefits package including: •Medical, Dental and Vision •Flexible spending account •Paid time off •Long term disability, and life insurance •Retirement 401K •Pay is commensurate with qualifications. Montauk Renewables is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to status as a protected veteran or a qualified individual with a disability, or other protected status, such as race, religion, color, national origin, sex, age. We are a drug free work environment based on Federal guidelines and use e-verify to confirm employment eligibility.

Business Intelligence Analyst Jobs in Pittsburgh, PA

Senior Business Intelligence Analyst
October 7, 2024

Senior Business Intelligence Analyst
October 6, 2024

Senior Business Intelligence Analyst
September 30, 2024

Senior Business Intelligence Analyst
September 26, 2024

Business Intelligence Analyst
September 25, 2024

Quick filters

Top companies

Business Intelligence Analyst Jobs in Pittsburgh, PA

Senior Business Intelligence AnalystOctober 7, 2024

Senior Business Intelligence AnalystOctober 6, 2024

Senior Business Intelligence AnalystSeptember 30, 2024

Senior Business Intelligence AnalystSeptember 26, 2024

Business Intelligence AnalystSeptember 25, 2024