Sr. Business Intelligence Engineer

Description

Basic Function

The Sr. BI Engineer is responsible for compiling, organizing, and analyzing business data sets using analytic software tools. Responsibilities include research/analytic design, data exploration and preparation, data analysis, dashboard, and report preparation. The position will work closely with the Data Services Team and other Business Units to provide data quality, data integration, data warehousing, and metadata management to the organization and help identify business data needs. A wide degree of creativity and latitude is expected.

In addition, this role plays a crucial part in designing, developing, and maintaining data models to support efficient data management and analytics within the organization. This role is essential in optimizing data architecture, translating business initiatives into robust data models, and enhancing data integrity, availability, and performance. The position is responsible for developing conceptual, logical, and physical data models.

Typical Requirements

Requires strong technical and analytical skills, data management skills, and general business experience to achieve results. Ability to deep dive into data, do analysis, discover root causes, and help to design long-term solutions with the goal of answering business questions. Understanding the business data needs and aligning to strategic goals will greatly increase effectiveness. Must be able to prepare high level architectural understanding of data services to present to business leadership. Must work well with others while performing a variety of detailed tasks daily. Additionally, requires excellent oral/written communication skills, working knowledge of application design and limitations with deep knowledge of relational database concepts. Position will regularly utilize both business and technical abilities.

Essential Functions

1. Gather and interpret data from a variety of sources (e.g., proprietary transactional systems, 3rd party applications, financial systems, client/associate satisfaction surveys feedback, etc.) to help improve and enhance the franchise, client, and associate experience.

2. Manage and optimize the Power BI environment, including workspaces, dataflows, gateways, user access, Row-Level Security (RLS), and Object-Level Security (OLS), while ensuring compliance with governance and organizational standards.

3. Design, develop, and maintain advanced data, incorporating best practices for data flows, DAX, star schema design, and performance optimization, as well as managing deployment pipelines across environments.

4. Assist in developing standards, procedures, and quality control measures for data analytics to ensure consistency and compliance with Express Acceptable Use Policies.

5. Use statistical methods to analyze data and generate useful business reports.

6. Partner with business stakeholders to construct insightful data models and infrastructure.

7. Identify, analyze, and interpret data to create models that depict trends or patterns in complex data sets.

8. Work with management to prioritize business and information needs.

9. Use data to create models that depict trends across all customer segments.

10. Be a resource and advocate for data within the organization by teaching and empowering others to use data.

11. Work with departmental management to outline the specific data needs for each business segment.

12. Automate internal and external reports, create executive-level dashboards, and present information to help business units and others understand the operational impact of the data.

13. Develop reports and visualizations of data, which clearly illustrate analytic results and prepare findings for use in decision-making and/or presentations. that drives business improvements.

14. Interviewing business managers and users to understand their needs.

15. Maintain technology/industry job knowledge.

16. Design, create, and implement logical and physical data models for both IT and business solutions to capture the structure, relationships, and constraints of relevant datasets.

17. Build and operationalize complex data solutions, correct problems, apply transformations, and recommend data cleansing/quality solutions.

18. Effectively collaborate and communicate with various stakeholders to understand data and business requirements and translate them into data models.

19. Create entity-relationship diagrams (ERDs), data flow diagrams, and other visualization tools to represent data models.

20. Collaborate with database administrators and software engineers to implement and maintain data models in databases, data warehouses, and data lakes.

21. Develop data modeling best practices and use these standards to identify and resolve data modeling issues and conflicts.

22. Conduct performance tuning and optimization of data models for efficient data access and retrieval.

23. Incorporate core data management competencies, including data governance, data security and data quality.

Job Requirements

Education:

A bachelor’s degree in computer science, data science, software engineering, information systems, or related quantitative field.

Experience:

At least five years of work experience in data management disciplines, including data integration, modeling, optimization and data quality, or other areas directly relevant to data analytics responsibilities and tasks. Proven project experience developing and maintaining data models and visual analytics reporting.

Skills:

• Hands-on relational, dimensional, and analytical project experience using RDBMS, NoSQL data platform technologies, and ETL Skills.
• Expertise in developing and optimizing DAX codes, dataflow, dataset, refresh times, and report performance.
• Experience designing Power BI architecture, including dataflows, semantic models, and performing impact analysis to ensure scalable solutions and alignment with enterprise data strategies.
• Knowledge of relational databases and database design principles.
• Familiarity with dimensional modeling and data warehousing concepts.
• Strong SQL skills for data querying, manipulation, and optimization, and knowledge of other data science languages, including JavaScript, Python, and R.
• Ability to collaborate with cross-functional teams and stakeholders to gather requirements and align data models.
• Excellent analytical and problem-solving skills to identify and resolve data modeling issues.
• Strong communication and documentation skills to effectively convey complex data modeling concepts to technical and business stakeholders.

Confidential Information

The position has access to most all proprietary business systems and critical business data, and the utmost of confidentiality and secure governance is required. Access to information is given under appropriate approval, and absolute discretion is critical for most instances.

Working Conditions

Professional office environment, operating under normal office conditions within a well-lit, climate-controlled office. Must be able to work effectively under managing multiple deadlines and commitments. May require occasional travel to franchise locations or corporate events and training sessions. Flexible remote work options may be available with approval.

Special Assignments

Due to the dynamic nature of our business, there is a constant need for assignments that were neither foreseen nor expected. This may be the need to evaluate or implement a new technology, gather specific relevant data, or simply to handle a challenge encountered by a franchisee.

Other Information

This position will assist in creating a new model of data services delivery to the company. This person must be a well-rounded individual and have the ability and patience to manage constant growth over time while developing skillsets and collaboration with the ITS team.

Constant education, both self-directed and classroom, is required to grow and keep up with changing technology, tools, and business systems.

Qualifications