Stay current with common problems and solutions for recent releases.
  HOME > Job Description
Share |

Thank you for showing interest in the job position: Data Architect / Data Analyst.

In order to be considered for this position, please review the job description provided below, Click Apply and fill out the Job Application Form.

Berean Group is looking for Data Architect / Data Analyst.
Location: Los Angeles,  CA
Duration: Contract
Job Description:
We are looking for a Data Architect / Data Analyst to work and understand the data migration/conversion requirements and translate them into ETL specifications, mapping documents and test cases.  Develop a solid understanding of the functional aspects of the data objects being migrated and develop strong relationships.  Develop and enforce standards/best practices for ETL processes. Profile Data objects and build data cleansing plans.  Work with the business data owners to drive cleansing tasks to completion on a given time frame.  Assist in developing data governance processes for given data domains.
Define and implement ETL design, development and implementation standards and procedures based on industry best practices
Work closely with the ETL Developers to ensure adherence of the ETL guidelines, standards and procedures to be applied to all development projects
Participate or assist in the translation of user requirements into data flows, detail technical specifications and data mappings
Act as the project owner for a given data domain(s)
Design and develop the data transformations for source system data extraction; data staging, movement and aggregation; information and analytics delivery; and data quality handling
Generation and administration of system test plans
Mentor, develop, train and assist team members
Profile data objects (e.g. Customers / Vendors) to identify data quality gaps
Develop data cleansing plans to achieve acceptable levels of data quality for a given schedule
Develop data governance processes and procedures
Participate in testing and deployment for data warehouse development
Seasoned Consultant with minimum 5 years experience working with Informatica IDQ / IDE or comparable data analysis / quality suite
5+ years experience in RDBMS systems such as: Oracle, SQL Server or DB2
Knowledge of data warehouse/data mart design and dimensional modeling concepts including entity relationships, indexing, and keys
Direct experience with large scale data cleansing initiatives
Ability to identify data requirements to meet business rules
Knowledge of data quality assurance issues and techniques
Experience in managing master data
Experience with global enterprise data integration projects
Ability to estimate time and resource requirements
Strong team leader with excellent verbal and written communication skills