| JOB SUMMARY
The EBI Developer 2 is responsible for delivery of modern business intelligence, analytics, and data warehousing solutions including design, development, testing, implementation, and maintenance of the enterprise business intelligence platforms. May specialize in BI/reporting, ETL, and/or database technologies. Works with other technical team members to deploy solutions using best practices for architecture, design, coding, and testing to support data movement/transformation, data analysis, relational/multidimensional (OLAP) database objects, and data visualization. The Developer 2 assumes tasks of a moderate to high level of complexity and difficulty.
ESSENTIAL FUNCTIONS OF THE ROLE
Analyzes detailed end user specifications. Design and develop solutions to accommodate business requirements.
Tunes and optimizes process to improve the performance and works with DBAs on optimizing query response times.
Implements procedures to maintain, monitor, backup and recovery operations for the environment.
Supports production deployments and automation. Conduct troubleshooting production and performance issues.
Establishes security standards for projects, roles, users, privileges in different environments (DEV, QA, PROD etc.).
Is responsible for Installs, configures, and upgrades BI software. Own activities associated with maintaining repository and metadata information.
Performs code reviews and provide and Design and develop test plans for unit testing.
Helps EBI Developer 3 to maintain inventory of all the jobs and processes and their SLAs.
KEY SUCCESS FACTORS
- Must have experience in development using ETL or BI tools.
- Must have experience in Data Warehousing, with thorough knowledge of dimensional modeling.
- Must have experience in database development, using SQL and PL/SQL, with in-depth knowledge of analytical functions.
- Experience with SDLC a must, exposure to Agile/SCRUM practices is ideal.
- Must possess excellent documentation and communication skills.
- Experience with IBM Netezza, Microsoft SQL Server, ETL tools (Netezza, Sailfish, Informatica) as well as enterprise BI reporting tools (IBM Cognos, Power BI, Microsoft SSRS) preferred. SAP Business Objects a plus.
- Experience in tools administration is preferred.
BENEFITS
Our competitive benefits package includes the following
- Immediate eligibility for health and welfare benefits
- 401(k) savings plan with dollar-for-dollar match up to 5%
- Tuition Reimbursement
- PTO accrual beginning Day 1
Note: Benefits may vary based upon position type and/or level QUALIFICATIONS
- EDUCATION - Bachelor's or 4 years of work experience above the minimum qualification
- EXPERIENCE - Minimum 2 Years of Experience |
