Sr Business Intelligence Developer - OscarMike

Sr Business Intelligence Developer

Company: EFG Companies

Location: 122 W John W Carpenter Fwy Irving, TX 75039

Position: 3 Month Contract to Hire

Location: 122 W John W. Carpenter Fwy, Irving, TX 75039

Hybrid model in office Monday and Tuesday every other week, unless needed.

Company Information:

For more than 45 years, EFG Companies has provided consumer and vehicle protection programs to the retail automotive and powersports markets. At its core, EFG is a service, not a product company. The company’s strategic intent is to build sustainable market differentiation solutions to dealers, lenders, manufacturers and agents. EFG’s award-winning engagement model is built upon the belief that the company serves as an extension of its clients management teams, providing ongoing sales, F&I and compliance training and auditing with an AFIP-certified field team, recruitment solutions, best-practices consultation, and nationally-recognized product administration with an ASE-certified claims team.

www.efgcompanies.com

Job Title: Sr. Business Intelligence Developer

Job Summary

The Senior Business Intelligence Developer is responsible for the technical implementation of current and future data warehouse, business intelligence solutions and data migration strategies. Proficient with the design of database architectures, data warehouses, data migrations, data marts, business intelligence packages, and implementing user reporting solutions based upon business requirement and content knowledge. Strong understanding of database methodology, data analysis, advanced SQL queries, ETL and business intelligence application required. Experience in Financial & Insurance company environments and the vernacular of this industry is considered a strong plus. This role will immediately begin learning the business processes, and assisting with activities related to audit, month-end and project reporting tasks.

Requirements:

Job Responsibilities 

The responsibilities include, but are not limited to the following: 

• Implement new business intelligence and data warehouse requirements through the use of SQL, ETL, business intelligence tools, and database programming and reporting tools. 
• Meet with customer business and technical leaders to identify and scope the business opportunities, vet business requirements, identify effective reporting techniques, identify the best data sources for reach report field, identify risks and constraints, and design reporting formats. 
• Lead/participate in meetings with internal business partners as well as external third party teams. 
• Develop, implement, and maintain ETL (extract, transform, and load) solutions to bring new data into the data warehouse. 
• Develop optimized database design to achieve acceptable performance by tuning view, tables and indexes for proper response time. 
• Develop new capabilities and architectures that capitalize on the development of client portal, and ad-hoc BI capabilities 
• Respond to ad-hoc query requests from various departments including Product, Vendor Services, Finance, and Professional Services. 
• Full life-cycle development and maintenance of data warehouse, ETL, and business intelligence solutions. 
• Data analyst skills to determine root cause problems for data integrity and data quality issues identified through QA or by business report owners. 
• Provide guidance and recommendations on BI reporting packages 
• Strong experience with the Microsoft BI stack (SSRS, SSIS, SSAS)
• Strong experience developing SSAS and implementing data warehouse solutions
• Strong experience analyzing data sets
• Experience in month-end financial reporting processes and the technologies used to support those business processes.

Job Requirements

• Strong communication skills, both written and oral; 
• Ability to effectively communicate and present to all levels of the business and explain complex issues and concepts in simple, understandable language.
• Ability to independently analyze and solve complex technical problems involving data load issues, system response time, business rules conflicts.
• Ability to function effectively in a complex rapidly changing environment.
• Ability to provide recommendations to adjust systems or processes to prevent issue reoccurrence.
• Ability to troubleshoot, track, and resolve day-to-day issues.
• Ability to work non-traditional business hours in support of IT operations.

Required Technical Skillset

• SSIS, SSAS, SSRS
• MSSQL
• Power Bi 

Additional experience:

• Tableau
• SmartConnect

Education

• BS/BA degree - Major in Computer Science, preferred 

Benefits (once converted to FT):

• Medical, Vision, Dental
• 401k
• PTO starts acquiring day one, eligible after 90 days
• Floating holiday with 8 major paid company holidays