Department

SQL Database Developer

Information Technology
Posted: 12/05/2019
Full Time
Los Angeles, CA
CIM Group is looking for a database Developer to join their ranks! This position is part of CIM’s development and application support team and will be responsible for providing BI best practices and developing Enterprise Data Warehouse that will directly impact budgeting, reforecasting and overall business reporting and performance.  
ESSENTIAL FUNCTIONS
  • Develop robust ETL packages and support finance budget / reforecasting processes. Ensure data integrity, validity, accuracy, completeness and quality through data acquisition process design and process monitoring capabilities
  • Identify opportunities for usability improvements, simplification and standardization across ETL package and process
  • Responsible for the company’s enterprise data warehouse design, development, operations and maintenance
  • Design, develop, and operationalize complex logical and physical data models that meet complex business analytical needs
  • Maintain the integrity and performance of company databases
  • Manage quality aspects of offshore and outsourced development initiatives
  • Support ad hoc business data requests by understanding requirements and developing queries/SSRS reporting to present necessary data
  • Must have excellent analytical capability and comprehension of business challenges and address them during technical design
  • Responsible for effective communication and interaction with business users and documenting
  • NON-ESSENTIAL FUNCTIONS
  • Assist in supporting the user community with general I.T. issues
  • Collaborate with the general I.T. team to suggest general environment enhancements
  • Collaborate with the general I.T. team to suggest general I.T. operational process enhancements
  • Share knowledge and ask questions
  • EDUCATION/EXPERIENCE REQUIREMENTS (including certifications, licenses, etc)
  • 3+ years of hands-on experience on developing and supporting data warehouses (ETL) in an enterprise environment, supporting Windows SQL Server with large data volumes and complex data processes
  • 3+ years hands-on experience in data modeling (conceptual, logical, and physical) across various business subject areas.  Data models presented in an enterprise business intelligence suite
  • 3+ years of experience in writing SQL queries and database and SSRS report
  • B.S. degree in Computer Science
  • Experience with ETL processing using SSIS
  • Experience with Modeling using SSAS
  • Experience with Reporting using SSRS
  • Be adept to documenting as part of communication, such as ER diagramming, architecture visualizations, data process flows, etc.
  • Must possess SQL programming and SQL tuning skills
  • Experience writing and tuning stored procedures
  • Expert knowledge of Relational databases such as SQL Server
  • Experience in an Agile based delivery environment
  • CIM does not accept unsolicited resumes from Agencies.  Any unsolicited resumes received from Agencies will be considered property of CIM and no fees will be due or paid.  If you wish to become an approved Agency with CIM or any of its Affiliates, please contact a member of the CIM Talent Acquisition Team.