Collaborate with project teams to design end-to-end data solutions.
Deliver data models supporting design conforming to an enterprise conceptual model.
Align solutions to road maps for existing data mart and data management solutions across multiple business lines Contribute to data strategies for the migration of legacy applications.
Develop data reference architecture and promote those standards across the organization.
Contribute to data tool standards and governance processes Assist with evaluating data complexity for projects during project initiation.
Assist with reviewing data designs, data models for projects aduring architectural review meetings.
Maintenance of data dictionary and/or metadata repositories Mentor project team members in the development of complex data/ETL/BI solutions.
Partner with other data architects to influence and support data needs Present and socialize data strategy with business and IT leader
Who is Our Ideal Candidate?
Bachelor’s degree in Computer Science preferred 10+ years’ experience in the area of data management, modeling, data analysis, and/or reporting.
Strong technical documentation and technical writing skills Prior experience with financial services, retirement, insurance, or medical records industry highly desirable.
Expertise with Star, Snowflake, and 3NF data modeling techniques as well as data warehousing & data mart principles and methodologies.
Hands on expertise with data modeling tools such as ERwin or Embarcadero ER Studio Hands on experience working with relational databases such as Oracle, SQL Server, DB2, Sybase.
Hands on experience working with ETL tools such as Informatica or SSIS Familiarity with master data management tools and concepts.
Familiarity with industry standard models like ACORD or IIA Hands on experience with designing and modeling ODS/Warehouses.
Expertise on dimensional modeling and slowing changing dimensions Familiarity with BI tools like Business Objects, OBIEE, etc.
Knowledge of Big Data technologies a plus Ability to collaborate in a multi-site matrixed work environment.
Proficient with enterprise architecture and data architecture concepts.
Eagerness to learn new tools and technologies.
Experience working in an agile or continuous improvement environment Eagerness to learn new tools and technologies