Invesco is one of the world’s leading global investment managers, entrusted with managing $1.2 trillion* in assets on behalf of clients worldwide. We are the 6th largest US retail asset manager and the 13th largest investment manager globally, and our more than 8,000 employees worldwide are dedicated to delivering an investment experience that helps people get more out of life. We are purely focused on managing a comprehensive range of active, passive and alternative investment capabilities, which we draw on to provide customized solutions aligned to client needs, our most important benchmark. (*As of May 31,2019)
Job Purpose (Job Summary):
As one of the world’s leading asset managers, we are solely dedicated to delivering an investment experience that helps people get more out of life. If you’re looking for challenging work, smart colleagues, and a global employer with a social conscience, explore your potential at Invesco The Department Our mission is to create world-class, client-centric data solutions that drive competitive advantage, grow our global business, and deliver an investment experience that helps people get more out of life. This mission is fueled by inventive and cohesive teams, which thrive on collaboration and shared trust and demonstrate the diversity of thought. Our success is driven by our people, which is why we invest heavily in our talent, promoting continuous learning and development, offering opportunities to work with emerging technologies, and creating the space to discover. Our newly formed, Enterprise Data Office is seeking candidates who innovate, operate effectively in an agile environment, challenges the status quo and are driven to succeed. Your Role: We’re seeking a Principal Data Modeler to join our Global Data Architecture team within Enterprise Data Office that supports our Investments, Distributions, and Corporate data and analytics modeling requirements. You will be driving Enterprise Data Modeling Practice alongside a dynamic, and collaborative team that wants to hear your input because you know the leading methods, tools, and theories in data modeling and architecture. The focus of this role will be to Model our Enterprise Domains & help enable data engineering teams with the integration, modeling, and distribution of internal and external datasets that support our business clients. You’ll be working alongside our data visualization, data science and machine learning teams to extend the Invesco enterprise data architecture. Candidates will be expected to architect the platform, processes, and models to ingest, curate, model and provide secure access to structured and unstructured data sets.
Key Responsibilities / Duties:
- Leading all aspects of and supporting build out of conceptual, logical, and physical dimensional domain data models to enable data warehouse / analytics data stores development & maintenance of data modeling artifacts
- Ensuring alignment of initiative level high and low designs against the agreed data/tech architecture and strategy & enforcing change control procedures & protocols
- Developing data structures for data warehouses and data marts projects and initiatives; and supports data analytics and business intelligence systems.
- Work with Agile Squads, Business and System Analytics Stakeholders to investigate & perform source system & data mapping analysis
- Communicate physical database designs and dba and explains features that may affect the physical data model
- Conforms to guidelines on creating data models and various standards relating to governed data, identify appropriate data sourcing and extraction process and designate authoritative sources as systems of record for data usage in various application
Work Experience / Knowledge:
- 8-10 Years’ Experience building complex Data Models (Entity Relationship Diagrams, Logical Models, Physical Models)
- 8-10 Years’ Experience reverse engineering models from existing databases
- 8-10 Years’ Experience leveraging modeling tools (ErWin, Oracle Data Modeler, etc)
- 8-10 Years’ Experience building OLTP, ETL data warehouse, and Relational Database Models (Analytical Data Models is a bonus)
- 8-10 Years’ Experience writing high performing SQL, and complex queries
- 3-5 Years’ Experience working in Cloud based technology environments, preferable AWS Redshift, Snowflake
- Exposure and experience with Data Factory, DataBricks, NoSQL modeling and/or Graph Modeling is nice to have
FLSA (US Only): Exempt
The above information on this description has been designed to indicate the general nature and level of work performed by employees within this role. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to this job. The job holder may be required to perform other duties as deemed appropriate by their manager from time to time.
Invesco’s culture of inclusivity and its commitment to diversity in the workplace are demonstrated through our people practices. We are proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, creed, color, religion, sex, gender, gender identity, sexual orientation, marital status, national origin, citizenship status, disability, age, or veteran status. Our equal opportunity employment efforts comply with all applicable U.S. state and federal laws governing non-discrimination in employment.
