Business Intelligence Software Engineer

Location: Dallas, TX Corporate Office
Employment duration: Full time

About Mimi's

About Mimi's

The story of Mimi’s started with people; Arthur J. Simms was inspired by the beauty, foods and flavor of France and a woman he met there named Mimi. Today at Mimi’s we embody this inspiration and we strive to provide the same warmth and sincerity that one would welcome a guest into their home with. At Mimi's, our Associates are the most important resource in our service commitment to our Guests. By applying the 'Three Standards of Excellence' and embracing our values of trust, teamwork, respect integrity and commitment, we nurture and maximize talent to the benefit of each individual and the Company. Mimi's fosters a work environment where diversity is valued, quality of life is enhanced individual career aspirations are fulfilled and Mimi's continued success is celebrated by all.

When you work for Mimi’s, you become family!


Description

TITLE:             Business Intelligence Software Engineer

DEPT:              Information Technology

REPORTS TO:  Director, Enterprise & IT Solutions

 

POSITION PURPOSE

The Business Intelligence Software Engineer is responsible for the technical design, architecture and delivery of ETL-based integrations and Business Intelligence solutions that enhance data flows between disparate operational systems and the Enterprise Data Warehouse.  This position interacts with various internal business units and the technology team to discover and translate business requirements, to design, build, & maintain data models, and create complex reports and dashboards in various projects.  The position is responsible for developing dependable, well thought out integrations and applying BI subject matter expertise (Data Discovery, Data Modeling, and appropriate BI solution delivery) to provide the business units with the tools and data representations that will help attain strategic goals for those business units and the organization.  This position designs, develops, deploys and supports various integrations and BI applications utilizing the Microsoft SQL stack, including SSIS, SSAS, SSRS and Power BI.  The position also performs ad-hoc analysis and supports business owners to identify performance trends.

 

ESSENTIAL RESPONSIBILITIES & DUTIES

  • Work with internal constituents to understand business requirements and goals, and help capture the strategy, content, and features for layout of our reporting environments.

  • Lead BI efforts for enterprise projects through entire project lifecycle; Lead analysis, architecture, design and development of data warehouse and business intelligence solutions; Analyze data sources, requirements and business rules, perform logical and physical data modeling, write prototype SQL to prove data transforms, write specs for ETL development, implement and test database design.

  • Design, develop, deploy, maintain, monitor, and tune ESB and ETL solutions to incrementally load Enterprise Data Warehouse, populate summary data structures, analysis cubes and Enterprise reporting systems.

  • Work with cross functional teams to collect requirements, analyze, identify critical metrics and KPIs and design BI or Reporting solutions to meet business needs.

  • Perform ad-hoc analysis and support business owners to identify performance trends.

MINIMUM REQUIREMENTS

 

  • Experience with business intelligence and enterprise reporting solutions, proficiency with Microsoft tools including SSAS, SSRS, SSIS, Visual Studio and/or Business Intelligence Development Studio, Excel Analytical Services, Microsoft Power BI, and Oracle Essbase

  • Expert experience in designing and developing SSIS ETL routines for data warehouses.

  • Tabular Modeling experience including SSAS cube development, fluent in MDX, Power BI and SSRS.

  • Proven experience architecting, building and delivering enterprise reporting and business intelligence solutions.

  • Professional experience with high performance T-SQL development methodologies; Strong knowledge of SQL Server programming practices with solid SQL optimization and relational database knowledge.

  • An understanding of Excel PowerPivot, Power Query, Power View, PowerPivot Galleries, and SharePoint integration around MS BI tools.

  • Must be detail-oriented data analysis expert with deep knowledge of relational database structures.

  • Excellent verbal communication skills.

  • Perform well under pressure, with ability to manage multiple projects and deadlines simultaneously.

  • Excellent analysis, development and requirements gathering skills

  • Outstanding communication skills (oral, written, presentation)

  • Strong analytical and problem solving skills, with strict attention to accuracy and detail, and the ability to evolve data into knowledge

  • Strong software development life cycle experience from requirements definition to design to development to testing to deployment with skills in documentation, IT processes, and leading.

EDUCATION & EXPERIENCE

  • Bachelor’s Degree in IT or Technical field preferred

  • 8+ years of experience, specializing in integrations and BI solution architecture, design, and development.

  • Technical Specialization in: SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services and other related technologies.

  • Strong background in Data Warehousing principles and Data Modeling, specifically design and delivery of star-schema based data marts

  • Strong aptitude for learning new technologies and analytics techniques

  • Highly self-motivated and able to work independently as well as in a team environment

OTHER REQUIREMENTS/WORKING CONDITIONS

  • Occasional travel - 10%

  • Work is completed in a general office environment.

  • 90% work on a computer.





Are you a returning applicant?

Previous Applicants:

If you do not remember your password click here.

Back to Search Results

New Search


Powered By Taleo