Junior Analyst (SQL / Database)
Irving, TX

Job Description

JOB SCOPE & PURPOSE

The Junior Data Analyst is responsible for supporting the creation and execution of marketing, reporting and analytics processes as defined by client. He/she will become a subject matter expert on client's data sources and become intimately familiar with database, email and preference data including understanding key business rules that drive data outputs.

MAIN RESPONSIBILITIES

The Junior Data Analyst will be expected to take an active role in the following activities:

* Be technically able to understand and create ETL processes.
* Based on business requirements, contributes to detailed technical requirements and specifications; identifies missing details in the business requirements and engages the appropriate resource(s) for clarification.
* Become an internal expert in ETL, CDI and complex Datamart Build services for campaign, reporting and analytics processes.
* Develops mapping and data processing procedures to import data from various data sources and populate the client database.
* Demonstrates knowledge of the data model and the data, to provide insights and recommendations.
* Develops data extracts and procedures to support internal and client (external) business analytics.
* Effectively utilizes programming tools and applications (SQL, Informatica, and Oracle), learning new skills as needed.
* Actively involved in troubleshooting data / data process anomalies and works with the team to efficiently identify solutions.
* Coordinates with cross-competency teams to ensure quality deliverables.
* Consistently follow best practices and standards defined by the team / organization.
* Contributes to the project estimation process.
* Multitasks through project execution and prioritizes accordingly, ensuring project deadlines are met and deliverables are completed in a timely fashion.
* Assists with the transition from project completion to ongoing production and production support
* Communicates requirements and status with other teams and competencies, as required on an ongoing basis.

REQUIRED SKILLS

EXPERIENCE & EDUCATION

* 0-2 years of Informatica experience or equivalent ETL experience
* 0-2 years of SQL/database experience, preferably Oracle
* 0-2 years of process management/automation experience
* 0-2 years process/data analysis experience
* Bachelor's Degree in Information Systems, Computer Science, Engineering, MIS is preferred

KNOWLEDGE & ABILITY

* Development Tools/Platforms
* Knowledge of Informatica, or similar enterprise ETL tool experience
* Knowledge of SQL, PL/SQL is a plus
* Knowledge of UNIX/LINUX experience is a plus
* Shell scripting experience (KSH, Bash, Perl, Python, etc.) is a plus


* Database
* Exposure to enterprise databases required
* Oracle is a plus
* SQL Server 2005/2008 is a plus


* Methodologies
* Demonstrates the ability to follow a consultative approach to data management
* Experience with various methodologies, like Waterfall, Lean, or Agile, is a plus


* Demonstrates the ability and desire to learn new technical skills and tools

POSITION REQUIREMENTS

* Overtime as necessary