Data Engineer

Build a Bigger, Better, Bolder Future

Imagine working for a company that measures its success based off the growth of its colleagues, a company that invests in its future by investing in you. Little Caesars is a company where our colleagues make an impact.

Your Mission

:In this role, you will be responsible for moderately complex designing and growing our Business Intelligence product in all aspects of our Business Intelligence solution, such as building new BI features, data modeling, machine integration, dashboard creation, Analyze Business Intelligence project requirements and perform the design, coding, testing, and documentation steps required to complete the project. A responsibility of this role will be providing technical assistance to less experienced staff

.

How You’ll Make an Impact

• Perform moderately complex data analysis and data profiling against source systems and data warehouse
• Apply data warehousing best practices to define, design, and develop data transformation rule
• Perform intermediate ETL design, development, and support for moving large data volumes from various sources into the various destinations after significant cleansing, transformation, and processing
• Handle job stream design, development, and implementation
• Experienced partnering with the business to develop reports and dashboards to meet requirements, including: Develop test plans, test scripts, and test conditions based on the business and system requirements, in addition to testing solutions to validate whether requirements have been met, Identify project tasks and providing estimates for those task
• Provide end-user support in post deployment phase; assess and evaluate all feedback to ensure that the requirements necessary to correct issues are addresses
• Analyze business requirements and work with client areas to produce functional specifications for use as reference in creation of the reporting and analytical solution
• Develop and maintain relationships with business customers to identify and develop additional analytic and reporting capabilities
• Define and prepare advanced data delivery designs and provide development support to leverage technology investments to support business need
• Coordinate prototype reviews and validating solutions meet requirements and service-level agreement
• Continue to apply concepts and develop technical knowledge of features and functions of business intelligence tool
• Determine the level of effort for development work given a set of requirements and determine estimate to complete through implementation
• Understand and identify the correct resources to help define and validate both requirements and specification
• Resolve system issues and respond to suggestions for improvement
• Communicate and monitor compliance with existing practice
• Maintain existing business reporting and analytical solutions by providing production support for troubleshooting and regular processing need
• Train and assist users with use of the business intelligence toolset
• Provide guidance in the creation of reporting and analytical solution

Who You A

• Bachelor’s in Computer Science, equivalent degree, or related course work in systems or computer programming. Equivalent experience may be considered in lieu of formal degree
• Minimum of five (5) years of programming experience with advanced SQL experience leveraging complex SQL statements, PL/SQL, and analytics functions to perform data profiling, data validation, and performance tuning
• Minimum of three (3) years’ experience with Microsoft BI Platform (SQL Server, SSIS, SSAS, SSRS, Integration, Reporting, and Analysis too
• Demonstrated experience with other Business Intelligence tools (Cognos, Business Objects, Tableu, Qlikview) is a plus
• Evidence of excellent analytical and problem-solving skills. Ability to find creative solutions to solve problems while staying within practice guidelines
• Possess In-depth knowledge of data warehousing and business intelligence concepts and methods. Sound understanding of business intelligence best practices, relational data structures, dimensional data modeling, and data warehouse and reporting technique
• Proof of experience contributing to and creating data warehouse project deliverables such as source system analysis, business definitions, data dictionary, source to target mappings
• In-depth experience preparing advanced report and dashboard design
• Evidence of Tableau Server administration and dashboard development experience
• Evidence of ability to document complex business process
• Demonstrated excellence in communication skills working with business areas and other non-technical groups, translating requests into requirements with the ability to express ideas effectively, verbally, and in writing
• Experience working in a client-facing role with the ability to build strong relationship
• Must have the ability to work independently and within a team environment
• Evidence of ongoing pursuit of technical knowledge and experience
• Ability to participate in an on-call rotation performing weekend and after-hours support
• Ability to work various schedule to support a 24 X 7 shift which can include nights, weekends and holidays.