Senior Business Intelligence Developer

Company: East West Bank
Location: El Monte
Posted on: June 20, 2022

Job Description:

OverviewEast West Bank is seeking a Senior Business Intelligence Developer to work closely with internal customers and BI Analysts to turn data into critical information and knowledge that can be used to make sound business decisions. The right candidate will need to identify business needs and build solutions to drive business growth, automation and enablement for multiple business partners such as Retail Banking, Digital Banking, Compliance, Financial Planning and Analysis, Operations, and more. This role requires a strong knowledge of BI solutions, data analytics, data management and normalization, data modeling & visualization tools. This position will be responsible for unlocking, designing and implementing data solutions for business partners, utilizing data, data science and tech solutions to drive insights and ultimately value for the company. This individual must function in a fast-paced environment, be adaptable to the many changing processes and technology related to the various data warehouse environments.Responsibilities

• Work closely with BI team, data engineers, DBA groups, and business partners to create technical requirements, database design and BI solutions that will empower business partners to embrace data confidently and responsibly to address their complex challenges
• Designing and Implementing tools for analyzing complex large-scale datasets used for modeling, data mining, research and Predictive analytics.
• Rapidly iterate, prototype, and implement visualizations that meet business visualization needs, considering composition, color, texture, and optimizing the depth and information density for the business users.
• Power BI and SSRS administration for on premises and Reporting Services
• Build enterprise scalable, complex data visualizations, dashboards, KPI scorecards, and KRI reports, etc. in Power BI Desktop
• Provide user experience inputs to business teams on report/dashboard design.
• Leverage knowledge of data modeling methodologies and other data warehousing activities to translate data into actionable analytical solutions and promote information-based decision-making recommendations.
• Determine and implement the security model based on business requirements, confirm safeguards are followed, address any data quality issues, and data governance processes are followed for the data model.
• Using past experiences, make recommendations on Enterprise BI standards/best practices
• Recognize and adopt best practices in reporting and analysis: data integrity, test design, validation and documentation.
• Performance tuning and query optimization
• Provide guidance to other BI developers with oversight from the BI Managers and Leads
• Implement statistical or other mathematical methodologies as needed for specific models or analysis
• Keep up to date with latest technology trends Qualifications
  • 7+ years practical experience with business intelligence solution including building/supporting data-intensive systems, data warehouses and data marts with clear understanding of industry standard concepts (star schema, snowflake, ER)
  • 3+ years hands on experience in Data Visualization or advance analytics using Power BI
  • Proficient in DAX and M queries
  • Expertise in SQL, ELT/ETL, reporting and Visual Analytics tools including SSMS, SSRS, SSIS and Power BI, with proven implementation and adoption in a large-scale enterprise environments
  • Solid T-SQL knowledge and SQL query development using MS SQL 2016 or later
  • Expertise skills in data visualization, user interface design and the software development life cycle to develop data products and expertise in demonstrating the work to business groups.
  • Proficiency in data analysis, data profiling, data mining, data extraction, and data enrichment
  • Creative problem solver who thrives when presented with a challenge
  • Excellent attention to detail
  • Comfortable in both a leadership and team-player role
  • Able to multitask, prioritize, and manage time effectively
  • Excellent communication, interpersonal and organizational skillsDesired
    • MS in Computer Science, Information Systems, Data Science, Data Analytics or equivalent combination of skills, experience and education
    • Software language - C#, Power Shell, Python, .NET
    • Experience in Cloud Data Warehouse technologies such as AZURE Data Warehouse, Synapse Analytics, Azure Data Lake, Snowflake.
    • Experience in banking or financial services
    • General understanding and wide application of advanced principles, theories, concepts, tools, and techniques in user interface design for data science and data visualization applications.
    • Experience with DevOps, Continuous Integration and Continuous Delivery (Maven, Jenkins, Stash, Ansible, Docker) is a plus
    • Understanding of Machine Learning
    • Understanding of cloud platform maintenance and experience in migrating legacy systems to new age technologies.
    • Understanding of Adobe Analytics and Omniture, Google Analytics, and other Social/App Tracking Tools
    • Understanding of analytical methods and regression models, and advanced analytics software (SAS, R, Python and others), big data programming
    • Have solid / emerging experience with statistical modeling, analytics, database usage and design theories

Keywords: East West Bank, El Monte , Senior Business Intelligence Developer, IT / Software / Systems , El Monte, California