Database Developer

SDH Systems LLC

Posted 5 years ago

Job Title: Database Developer
Job Location: Chicago, IL 60601
Duration: 3 Years
Job Type: Full time
Salary: $81,931.00/Annum + Company Standard Benefits
Job Duties:

  • Coordinate with Business Analysts and customers to develop business requirements and specifications documents.
  • Ensure to generate and deliver quality reports to customers in timely and accurate manner.
  • Develop VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries and linked the based module to enable automatic updates for excel workbooks.
  • Identify and resolve data reporting issues in a timely fashion.
  • Create Macros for Excel reports.
  • Implement pivot tables and charts in Excel for summarizing data.
  • Build optimized SQL tables for data ingestion projects using Microsoft SQL server 2012.
  • Experience in Performance Tuning and Query Optimization.
  • Conduct analyses of alternatives for different technical solutions and be able to communicate the strengths and weaknesses of each ETL solution.
  • Perform ETL failure recovery when needed. Daily notifications on ETL workflow status.
  • Design the incremental and historical load strategy.
  • Responsible for aggregating data from multiple sources like HIVE Data Lake, Teradata, Excel, CSV, Flat files, XML etc., in an efficient data warehouse and designing enterprise- level solutions for very large multidimensional databases.
  • Experience in Design, Develop and Automate SSIS Packages using Microsoft Visual Studio 2010.
  • Builds SSIS packages to automate reports.
  • Analyze and create complex SQL Queries, database scripts, stored procedures, triggers Views and Temporary Tables etc., as per the requirement. as well as troubleshooting and optimizing, Writing relational and multidimensional database queries. Develop and update technical documentation.

Job Requirements:

  • Experience utilizing SQL, SAS, Teradata, SSIS or other reporting tools / languages.
  • Communicate technical concepts to non-technical audiences both in written and verbal form. Lead projects and junior analyst.
  • Initiative to solve complex problems; takes an “outside –in” perspective to identify innovative solutions.
  • May lead functional teams or projects or decisions to support business needs for reporting and insights.
  • Work with both internal and external data.
  • Verify accuracy of reports and provide insights.
  • Work independently, with guidance in only the most complex situations. Preference : Hadoop, Tableau, Datameer

Minimum Qualification:

  • Bachelor’s degree in computer science, computer information systems, information technology, or a combination of education and experience equating to the U.S. equivalent of a Bachelor’s degree in one of the aforementioned subjects.

Apply Online