Responsibilities Include:
- 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
$65/hr
CTH
