L

Senior Business Intelligence Engineer

Leapros
Full-time
On-site
Irvine, California, United States


LEAPROSβ„’ Workforce Solutions strategically links employers and professionals through innovative workforce solutions and transformative technology that catalyze growth for impact. LEAPROSβ„’ is a trusted workforce solutions partner, offering customized recruitment and interim staffing solutions, as well as innovative resources designed to empower employers and professionals to accomplish their hiring and career objectives.Β Operating on a national platform, our areas of concentration include finance and accounting, information technology and engineering, human resources and administration, sales and marketing, supply chain and operations. Whether you are a talented professional or a company looking for a talented professional, we welcome you to take a leap with us!


CLIENT SUMMARY: ​​LEAPROSβ„’ Workforce Solutions has partnered with a notableΒ Β Fortune 500 companyΒ that provides value-added services to consumers with a commitment to socially responsible, sustainable growth, and environmentally-conscious products headquartered in OC.Β This role is a high-impact, high-visibility role, with a deep commitment to continuous improvement, optimal efficiencies, and distribution excellence.





POSITION TITLE:Β  Senior Engineer, Business Intelligence




POSITION SUMMARY:Β The Senior Business Intelligence Analyst works within the BIΒ team and focuses onΒ leveraging technology to extract and share analytics insights using creative data visualizations. This exciting opportunity lives in the most visible team across the organization and will focus on front line initiatives that are regularly communicatedΒ the Fortune 500 company public message given by the CEO.




ESSENTIAL DUTIES AND RESPONSIBILITIES:Β 



  • Develop data quality and testing plans to validate data pipelines, validate KPIs & quality trends for the data across multiple systems

  • Take ownership of end to end data quality and rules implementation

  • Design, develop, implement and execute automation testing, data quality processes and requirements and track data issues

  • Actively engage in data validation technology discovery and implementation for on-prem and cloud

  • Develop scripts in SQL/Python/etc. to achieve data quality objectives

  • Participate in architecture design and discussions

  • Be part of the Agile team to collaborate and to help shape requirements

  • Supports the development and design of the internal data integration framework

  • Works with Business Analysts and Developers based on test findingsΒ  to resolve source data issues and refine transformation rules


POSITION REQUIREMENTS:Β Β Β 


  • Bachelor’s degree in Computer Science, Engineering, Math, Finance, Statistics or related discipline.

  • 5+ years of relevant experience in a business intelligence role, including data warehousing and business intelligence tools, techniques, and technology, our expertise in analytics, business analysis, or comparable consumer analytics solutions

  • 5+ years of experience writing advanced SQL, performance tuning of BI queries, data modeling, and data mining from multiple sources (SQL, ETL, data warehousing).

  • 5+ years experience with advanced Power BI topics such as complex calculations, table calculations, parameters, geographic mapping, multiple disparate data sources, and performance optimization

  • Effectively handle multiple projects simultaneously and pay close attention to detail

  • Hands on data validation experience on AWS or Azure cloud technologies and no-sql databases


At LEAPROSβ„’, we are committed to our core values and guiding ethical principles, to conducting business in a non-discriminatory manner, and to operating in strict compliance with applicable federal and state laws pertaining to Equal Employment Opportunity. This commitment enhances our ability to conduct business with the highest level of integrity, solidifying our position as the most trusted workforce solutions partner. To learn more about LEAPROSβ„’ or to speak with one of our recruitment partners, call 866-920-LEAP or visit our website at www.leapros.com. Β