Database Architect Job in Eden Prairie 55344, Minnesota Us

Lifetouch Portrait Studios is recruiting for a Senior Data Architect with proven experience managing data integration, master data management and data warehouse systems.  Experience with Oracle Data Integrator and Oracle Data Quality is preferable. In depth knowledge of Oracle, PLSQL and ETL tools required.  Must have the ability to plan, design, develop and maintain overall data strategy, data architecture, data models, principles and standards for MDM and Data Warehouse initiatives.

 

Responsibilities:

·         Data Architect responsible for supporting Data Architecture and Data Management.

·         Data architecture and data management include, master data management, data warehousing, business intelligence, reference data management, database administration, metadata management, data analysis and design, and data quality improvement.

·          Must be well-versed in architectural and modeling principles that support data management.

·          Must be comfortable navigating between multiple roles: Data Architect, DBA, ETL Developer and Data Modeler.

·          Ability to perform Operational database tuning

·          Determine and implement strategies for real time operational data movement, data migration and data warehouse updates.

·          Establish and enforce data standards and processes.      

·          Responsible for developing and maintaining conceptual, logical and physical data models.

·          Model source data into an integrated, high performing data warehouse design, allowing for robust reporting and analytical capabilities

·         Lead efforts for automation and performance management of processes.

·         Assist in performing source data profiling and data quality assessments.

·          Design and implement Metadata architecture to capture, control and integrate Business and Technical Metadata for reporting capabilities in a metadata repository.

·          Assist with data conversion (ETL) mappings design specifications and work closely with the ETL developers on job design, development and testing.

·          Mentor and lead the work efforts of other team members.

 

Qualifications

·    Bachelor’s Degree in Computer Science, Information Systems, or related field or equivalent experience.

·    Minimum  7 years experience in data management

·    Minimum 7 years experience using one or more relational database management (RDBMS) systems, Oracle, 10  or 11 g preferred

·    Minimum 5 years experience with Data Modeling tools: Embarcadero ER/Studio, ERWIN, Designer, etc.

·    Strong interpersonal skills; ability to work on cross-functional teams and foster the teams’ commitment to tasks.

·    Strong facilitation, verbal and written communication skills, with an ability to express complex business concepts in technical terms.

·    Strong analytical, problem-solving and conceptual skills

·    Must be self-motivated, independent and able to work well with stakeholders project staff with minimal supervision.

·    Able to lead teams to consensus decisions on complex business and technical data challenges.

 

At Lifetouch, we consider it a privilege to capture precious memories for millions of individuals, families and organizations. For over 70 years, Lifetouch has been capturing the spirit of today and preserving memories for tomorrow with quality childhood, student and family photographs. Lifetouch provides professional portraits for preschools and schools, houses of Worship and the retail market. With operations in all 50 states and Canada, Lifetouch Inc. is the largest employee-owned photography company in the world. Lifetouch Portrait Studios is an Equal Opportunity Employer; employment with Lifetouch is contingent upon successful results of a criminal background check.