ETL Developer ETL Developer …

Black Knight Financial Services, Inc
in Burbank, CA, United States
Permanent, Full time
Be the first to apply
Competitive
Black Knight Financial Services, Inc
in Burbank, CA, United States
Permanent, Full time
Be the first to apply
Competitive
ETL Developer
SQL / ETL Developer II Glendale, CA/en-US/BKC/job/Glendale-CA/SQL---ETL-Developer-II_19-1344/apply Position: SQL / ETL Developer II Job Description:

Black Knight is the premier provider of integrated technology, services, data and analytics that lenders and servicers look to first to help successfully manage the entire loan life cycle. Our deep understanding of regulatory and compliance issues complements the knowledge, technology and solutions we offer to help our clients achieve their business goals. Black Knight offers leading software systems; data and analytics offerings; and information solutions that facilitate and automate many of the business processes across the mortgage life cycle.

JOB FAMILY DESCRIPTION
Designing, modeling, developing and supporting SQL Database Management Systems (DBMS) and ETL processes. Responsible for creating new SQL Server ETL processes and for improving the current application's performances through SQL development. The SQL Developer III will create processes that load databases, will monitor servers and recommend tuning for performance, build custom SQL solutions, and assist with architecting SQL systems.

Candidate will be expected to work in the Glendale office at least 2 days a week if preferring to be based our Irvine office.

GENERAL DUTIES & RESPONSIBILITIES

  • Analyzes data requirements, application and processing architectures, data dictionaries, and database schema(s) and recommends design and improvements.
  • Develops code modules and logic to process corporate data and support batch processes.
  • Designs, develops, amends, optimizes, and certifies SQL and other database schema design to meet system(s) requirements.
  • Gathers, analyzes, and normalizes relevant information related to, and from business processes, functions, and operations to evaluate data credibility and determine relevance and meaning.
  • Develops SQL or other types of database and warehousing designs across multiple platforms and computing environments.
  • Develops an overall data architecture that supports the information needs of the business in a flexible but secure environment.
  • Provides on call support for specific jobs and processes.
  • Performs other related duties as assigned.

EDUCATIONAL GUIDELINES
Bachelors degree in Computer Science, Information Systems or the equivalent combination of education, training, or work experience.

GENERAL KNOWLEDGE, SKILLS & ABILITIES

  • Experience in database architecture, data modeling and schema design with recent focus with MS SQL
  • Advanced experience in SQL with desired experience in Power Shell, R, or Python
  • Experience with ETL development
  • Experience in SSIS and SSRS a plus
  • Experience with TFS a plus
  • Experience in data analysis, data warehousing, business intelligence or data modeling a plus
  • Strong knowledge of relational database concepts, SQL, and data modeling techniques
  • Experience in orchestrating the coordination of data related activities to ensure on-time delivery of data solutions to support the business including job scheduling, data activity planning, risk mitigation, and issue resolution
  • Experience in utilizing performance tuning tools
  • Experience working with both on and offshore teams a plus
  • Knowledge of cloud architecture, AWS, Azure, or Linux / Hadoop a plus
  • Familiar with data standards/procedures and data governance and how the governance and data quality policies can be implemented in data integration projects
  • Ability to problem solve, multitask and communicate at all levels of the organization.

Database Administrator II

Intermediate professional level role. Supports multiple services and multiple databases of medium to high complexity (complexity defined by database size, technology used, systems feeds and interfaces) with multiple concurrent users, ensuring control, integrity and accessibility of data. Works on multiple projects as a project leader or sometimes as a project advisor. May coach more junior technical staff. Typically requires four

(4) or more years of experience working with various database management systems in database design, testing, implementation, maintenance and administration in a multiple platform environment.

Black Knight is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, disability, age, and protected veteran or military family status. Our employees diversity is our strength, and when we embrace our differences, it makes us better and brighter. Black Knights commitment to inclusion is at the core of who we are, and motivates us in how we do business each and every day.

Location: Glendale, CA Time Type: Full timePosted 6 Days AgoFull time19-1344 The Industrys Leading Provider of Technology, and Data and Analytics Solutions

Black Knight is a mortgage and finance industries leading provider of integrated technology, data and analytics solutions that facilitate and automate many of the business processes across the entire loan lifecycle. Black Knight is the provider lenders and servicers rely on to support their strategic goals and better serve their customers by delivering best-in-class technology, services and insight with a relentless commitment to excellence, innovation, integrity and leadership. 

Black Knight's offerings include:  

  • Leading origination, servicing and default technologies for lenders and servicers 
  • Data and analytics solutions to help improve performance, reduce risk, identify opportunities and make more informed decisions 
  • Information solutions that facilitate and automate many of the business processes across the loan lifecycle, including workflow solutions, invoice management technology, business intelligence and mobile applications
  • Consulting services to help develop strategies that will drive transformative change aimed at improving organizational efficiency, reducing overall costs and increasing customer service and competitiveness
Close
Loading...