Data Architect

  •  

Philadelphia, PA

Industry: Accounting, Finance & Insurance

  •  

5 - 7 years

Posted 28 days ago

  by    Catherine Leatherman

Primary Responsibilities:

  • Develop and implement strategic data requirements to align with company goals and desired data architecture
  • Develop, maintain, and enforce data standards and vocabulary as pertaining to the data architecture
  • Develop database and data warehousing solutions to store and retrieve company information
  • Design and document conceptual and logical data models
  • Design, maintain, monitor, and optimize ETL processes
  • Promote and support adoption of self-service enterprise reporting through Power BI
  • Oversee the migration of data and reporting from legacy systems to new solutions
  • Evaluate cloud-based and emerging technology solutions for new data requirements
  • Develop, maintain, and enforce data standards and vocabulary as pertaining to the data architecture

Required Qualifications:

  • A Bachelors' degree combined with a minimum of 5 to 10 years of experience as a databasedeveloper and data architect (candidates with similar education & background will be considered on a case-by-case basis)
  • Extensive experience with data modeling and database design
  • Extensive experience with SQL development and administration
  • Experience with Power BI, Tableau, or other data visualization tools
  • Expert level experience with ETL processes, data cleansing, balancing, and optimization
  • Experience with SQL Server Analysis Services
  • Experience with modern data warehousing techniques and the use of big data, predictive analytics, and unstructured data
  • Experience with agile development and DevOps practices
  • Experience in the insurance industry, preferably property and casualty, is not required, but would be a big plus

Salary

$120K - $130K
$120K - $130K base, Bonus eligible bonus