Senior Product Consultant Automation

Bread Financial•Columbus, OH

4d•Onsite

About The Position

As part of the Enterprise Data Science and Analytics organization, you will have the opportunity to create and implement enterprise-wide data models to improve operational effectiveness and efficiency. The Sr. Consultant position will be responsible for leading all of the Planning, Development, and Support functions for creating conceptual, logical and physical data models for the Enterprise Reporting team and other data and analytical assets. The Sr. Consultant will create and implement data models that improve operational effectiveness and efficiency for Bread Financial. The Sr. Consultant is expected to be a well-rounded expert, thoughtful, innovative, and technologically savvy with a keen interest in business transformation. This role will be relied upon to be a thought leader, to educate operational teams and train team members on emerging techniques for data modeling that will increase efficiencies in the reporting and analytical space.

Requirements

Bachelor’s degree or equivalent experience in Technology, Business Management, Finance, Accounting, Marketing, Analytics or equivalent work experience
Ten or more years of relevant work experience required

Nice To Haves

Master’s Degree or equivalent experience in Technology, Business Management, Finance, Accounting, Marketing, Analytics or equivalent work experience
Fifteen or more years of work experience preferred in Technology, Business Management, Finance, Accounting, Marketing, Analytics or equivalent work experience
Leading off shore and on shore
Experience with automation
Experience understanding processes

Responsibilities

Lead the data model product build/deployment/servicing for all new enterprise reporting and analytic needs.
Support multiple centers of excellence including process automation, new tool adoption, interaction analysis, data governance and enterprise reporting.
Successful design and execution of Planning, Development, and Support functions.
Be an expert of the toolsets used, including but not limited to SQL, DB2, Governed DataMarts, Reporting layer databases, data cubes, ETL process, etc.
Have an expert understanding of business requirements & own the entire data model design lifecycle (Conceptual to logical to physical).
Lead the identification of data gaps and inefficiencies, while keeping the team members up to date on industry trends.
Lead high performing planning, development, and support functions.
Establish and execute the framework for engaging enterprise partners to understand opportunities and level of effort in order to plan new data models.
Present and gain support from the various governance teams and IT teams to plan the work.
Lead the vision for the reporting/analytics data models, manage and prioritize needs and perform market research to ensure continuous improvement and deployment of market-leading, innovative solutions.
Work proactively & independently to address project requirements, and articulate issues/challenges with enough lead time to address project delivery risks.
Interface with Data governance teams to leverage central data repositories.
Analyze data-related system integration challenges and propose appropriate solutions.
Perform reverse engineering of physical data models from databases and SQL scripts.
Evaluate data models and physical databases for variances and discrepancies.
Accountable for throughput performance of moving work through the Planning process with a focus on duration, effort, and optimized prioritization.
Design, build & maintain the Data Warehouse, Operational Data Stores & other data assets.
Work with the Design and Build team to implement data strategies, build data flows and develop conceptual, logical and physical data models that ensure high data quality and reduced redundancy.
Guide System Analysts, Developers, Data Stewards and others on project limitations and capabilities, performance requirements and interfaces.
Have an expert ability to capture and communicate complex mappings, transformations, calculations, look ups, joins and business rules.
Have an expert understanding of ETL processing and tuning data structures for performance.
Maintain the existing data warehouses and Design subject area wise data marts / cubes to facilitate aggregation, slicing and dicing of data by reporting tools such as Micro Strategy.
Optimize & Maintain conceptual, logical and physical data models along with corresponding metadata to support new and existing projects.
Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
Validate business data objects for accuracy and completeness.
Review modifications to existing software & hardware to improve efficiency and performance.