Data Architect
Harrisburg, PA, United States On-site
Salary not listedJobFig found this opening at its original source and checks that it remains available.
About the role
Client seeks an experienced data architect who will be responsible for creating data models for enterprise applications and will participate in the design, development, and ongoing expansion of an enterprise data warehouse. The incumbent will participate in all aspects of data architecture, data quality assessment, data modeling, data integration, data migration, and Oracle PL/SQL development using tools such as ERwin, Informatica PowerCenter and TOAD. Additionally, the incumbent will support development of analytics solutions on a modern Big Data and Cloud platform. This position requires a good portion of hands-on database development work in addition to architecture, design, and technical leadership.
What you'll bring
- Relevant experience in data architecture, including data modeling, data integration, database development, and business intelligence.
- Oracle design and development experience, including PL/SQL.
- Data modeling experience using ERWin or similar modeling tools.
- Data integration experience using Informatica PowerCenter or similar DI tools.
- Technical team leadership experience.
- Experience and in-depth understanding of dimensional modeling, OLTP and OLAP database designs and implementation strategies.
- Data profiling and data quality assessment experience.
- Demonstrable experience in architecting analytic solutions: including Dashboards, KPI, Scorecards, and Operational and analytical reporting.
- Strong oral and written communication skills.
- Experience working with Big Data technologies, such as data lakes, HDFS, Hadoop, NoSQL DBs, etc.
- Experience working with geospatial data.