BI Developer 2

July 10, 2023
Apply Now

Job Description

Baylor Scott & White Health

Dallas, Texas, JOB SUMMARY The BI Developer II is accountable 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 help data movement/transformation, data testing, relational/multidimensional (OLAP) database objects, and data visualization. The Developer 2 assumes tasks of a moderate to high level of complexity and difficulty. The pay range for this position is $36. 41 (entry-level qualifications) – $61. 87 (highly experienced) The specific rate will depend upon the successful candidate’s specific qualifications and prior experience ESSENTIAL FUNCTIONS OF THE ROLE Understands 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.

Helps 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 accountable 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 systematic 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, Informatica) as well as enterprise BI reporting tools (IBM Cognos, SAP Business Objects, Microsoft SSRS) preferred. 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 – 2 Years of Experience

Source