Sr Business Intelligence Developer - OscarMike
Irving, TX 75063
About the Job
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.
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 analyzing data sets
- Experience in month-end financial reporting processes and the technologies used to support those business processes.
Job Requirements
- Minimum of 7 years of strong expert level SQL (MS SQL Server) and Microsoft SQL BI stack (SSIS, SSRS, SSAS) development experience
- Expert level development experience in a financial reporting environment using SSRS.
- Effective 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
Power BI and SSRS:
- Proficient in Power BI development, including data modeling, DAX calculations, and Power Query
- Experience in writing data‐driven reports, working with data to create new reports using SSRS.
- Maintaining reports and dashboards using SSRS and Power BI.
- Study, analyze and understand business requirements in context to business intelligence.
- Design and map data models to shift raw data into meaningful insights.
- Utilize Power BI to build interactive and visually appealing dashboards and reports.
Additional experience:
- Tableau
- 1+ years of Power BI experience.
Technical Skillset
SQL
T-SQL Proficiency:
- Advanced skills in writing complex T-SQL queries, stored procedures, functions, triggers, and views.
- Expertise in optimizing T-SQL queries for performance and efficiency.
MS SQL Server Expertise:
- Extensive experience with various versions of MS SQL Server.
- Knowledge of database design principles, performance tuning, indexing strategies, and query optimization.
- Proficiency in backup and recovery, high-availability solutions, and security measures specific to MS SQL Server.
SSIS
- Design, develop, and maintain SSIS packages to extract, transform, and load data from various sources
- Collaborate with business analysts and data engineers to understand data requirements and design ETL solutions
- Optimize SSIS packages for performance and scalability
- Troubleshoot and resolve issues with data integration processes
SSAS
- Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.
- Good experience in writing MDX queries while creating and customizing cubes.
- Expertise in identification of Business and data requirements and converting them into conceptual and logical data models.
- Experience in Dimensional Data Modelling Star and Snowflake Schemas.
Education
BS/BA degree - Major in Computer Science, preferred
Benefits (once converted to Full Time):
- Medical, Vision, Dental
- 401k
- PTO starts acquiring day one of full time, eligible after 90 days
- Floating holiday with 8 major paid company holidays