Business Intelligence Lead

Data Analyst - BI Lead / Power BI Rolling Contract - W2 only, USC or GC Holders 100% Remote - must sit in Dallas, TX Optomi, in partnership with a leader in the pharmaceutical distribution company, is seekin ga skilled and motivated Data Analyst - BI Lead to join their growing team. In this role, you will be responsible for leading Business Intelligence efforts, transforming data into actionable insights, and driving strategic decision-making across the organization. Assess and complete new reporting requests and enhance existing reports Follow SOPs to design and develop new reports and visualizations based upon defined request Lead and manage delivery of daily, weekly, and monthly sales, finance, and transactional reports, both manual and automated Manage data modeling, visualizations, and analysis for existing and new reports Develop data strategy for projects to onboard new trading partners and systems Create and manage delivery of routine and ad hoc reports needed to support business and trading partner requests Lead the development of report standards and best practices or guidelines for repeatable tasks Use structured and unstructured data from ERP and other systems to develop simple and meaningful data representations that support and fulfill the requests from business users Support and implement continuous improvement processes across the reporting portfolio to incorporate automation Extract data from identified databases (on premises and cloud), and select appropriate techniques to transform it to a structure that is relevant to the problem Analyze complex data elements, extract, filter, and aggregate data through logical SQL queries and programming What we are looking for: 7 years' experience as a reports developer/analyst/engineer/administrator with the ability to read and write complex queries, create database objects (tables, views, stored procedures, user-defined functions), and create complex visualizations and dashboards Expertise in Power BI from creating complex dashboards, visualizations, DAX queries to managing data security Expert in different SQL techniques for data transformation and data analysis Sound experience designing and developing reporting solutions with SSRS/PBRS and other MSDN tools Experience working in MS Power platform tools Experience with Azure Data Factory, Azure Data Warehouse is a plus Experience in working source control tools such as SVN and GitHub Certification in Power BI modeling, visualization and analyzing data is preferable