SQL-ETL Database Developer

Posted:
9/13/2024, 9:10:10 AM

Location(s):
Ontario, Canada ⋅ Toronto, Ontario, Canada

Experience Level(s):
Mid Level ⋅ Senior

Field(s):
Data & Analytics ⋅ IT & Security

At CoreLogic, we are driven by a single mission—to make the property industry faster, smarter, and more people-centric. CoreLogic is the trusted source for property intelligence, with unmatched precision, depth, breadth, and insights across the entire ecosystem. Our talented team of 5,000 employees globally uses our network, scale, connectivity and technology to drive the largest asset class in the world. Join us as we work toward our vision of fueling a thriving global property ecosystem and a more resilient society.

CoreLogic is committed to cultivating a diverse and inclusive work culture that inspires innovation and bold thinking; it's a place where you can collaborate, feel valued, develop skills and directly impact the real estate economy. We know our people are our greatest asset. At CoreLogic, you can be yourself, lift people up and make an impact. By putting clients first and continuously innovating, we're working together to set the pace for unlocking new possibilities that better serve the property industry.

Job Description:

  • Primarily responsible for creating database tables, structures, views, functions, stored procedures, schemas and dictionaries to facilitate the ETL of data within Microsoft SQL Server. 
  • Responsible for developing and maintaining Microsoft SQL Server databases whilst also ensuring their performance and stability.
  • Create and implement changes to databases based on the requirements of the end user
  • Ensure data quality and integrity. 
  • Works on problems of complex scope where analysis of situations or data requires a review of a variety of factors.

Job Qualifications:

  • Bachelor's degree in Computer Science, or IT related field, or equivalent work experience
  • 3–5 years of directly related experience
  • Experience working with  Microsoft SQL Server (2012+ )
  • Solid coding techniques to develop complex views, stored procedures and functions using T-SQL
  • Experience importing data from text file formats, linked server connections, APIs and web services,
  • Experience creating mapping document/s between source and target data structures.
  • Excellent knowledge of data transformations of all types including calling custom scripts, applying complex logic etc.
  • Solid knowledge of database design to produce sound logical and physical data models
  • Ability to understand and analyze system interdependencies, data structures, and data models
  • Experience with varied forms of data design, such as online transaction processing, online analytical processing, data warehousing, operational data stores, and decision support systems.
  • Knowledge of one or more database management systems to install, upgrade, configure, design, develop, implement, secure, tune, monitor and maintain required database objects
  • Experience in troubleshooting all types of ETL issues
  • Ability to write custom scripts using shell scripts such as PowerShell
  • Good verbal and written communication skills are a must
  • Analytical and problem management skills and the ability to resolve complex data issues
  • Ability to immediately adapt to changing requirements and conditions
  • Ability to work in fast paced environment essential
  • Familiarity with real estate concepts a plus

CoreLogic's Diversity Commitment:

CoreLogic is fully committed to employing a diverse workforce and creating an inclusive work environment that embraces everyone’s unique contributions, experiences and values. We offer an empowered work environment that encourages creativity, initiative and professional growth and provides a competitive salary and benefits package.  We are better together when we support and recognize our differences. 

Equal Opportunity Employer Statement:

CoreLogic is an Equal Opportunity employer committed to attracting and retaining the best-qualified people available, without regard to race, ancestry, place of origin, colour, ethnic origin, citizenship, creed, sex, sexual orientation, record of offences, age, marital status, family status or disability. CoreLogic maintains a Drug-Free Workplace. ​

Please apply on our website for consideration.

Privacy Policy - http://www.corelogic.com/privacy.aspx

By providing your telephone number, you agree to receive automated (SMS) text messages at that number from CoreLogic regarding all matters related to your application and, if you are hired, your employment and company business. Message & data rates may apply. You can opt out at any time by responding STOP or UNSUBSCRIBING and will automatically be opted out company-wide.

Connect with us on social media!  Click on the quicklinks below to find out more about our company and associates.

CoreLogic

Website: https://corelogic.com/

Headquarter Location: Irvine, California, United States

Employee Count: 10001+

Year Founded: 1991

IPO Status: Delisted

Last Funding Type: Private Equity

Industries: Analytics ⋅ Government ⋅ Property Management ⋅ Risk Management ⋅ Software