Job Seekers, Please send resumes to resumes@hireitpeople.com

• Work with business and technology subject matter experts to acquire data from technology production systems and make that data available for operational research, reporting, analysis.
• Help to automate and streamline complex manual or semi-automated reporting processes.
• Work consistently to improve data completeness, accuracy, and actionability.
• Develop efficient ETL (Extract-Transform-Load) routines for loading small-to-large amounts of operational data.
• Ensure appropriate indexing is in place to optimize performance of web-based reporting applications fed from team data repositories.
• Enhance/create automated systems to monitor database server health (including storage space, CPU usage, fragmentation, etc.).
• Identify and remediate performance pain points as needed.
• Help make analysis-ready data available to downstream consumers, analysts, applications, etc. within our Hadoop Data Lake.
• Help improve data documentation and accessibility.
• Learn from senior developers/analysts in the areas of data modeling, ETL design, and query efficiency.
  QUALIFICATIONS
• Analytical and strategic thinking skills.
• Able to quickly learn how to use new software applications.
• Strong organization and communication skills (oral and written)
• Analytical and detail-oriented in all work activities.
• Able to handle and prioritize multiple projects or tasks at a time.
• Able to work cross-functionally and solve complex problems.
• Demonstrated ability to design, develop, and maintain relational databases preferred.
• Demonstrated knowledge writing SQL queries.
• Knowledge of one or more query design tools (i.e., Microsoft SQL Server Management Studio, Teradata SQL Assistant, Oracle SQL Developer, etc.).
• Knowledge of one or more ETL (Extract-Transform-Load) tools a plus (i.e., Microsoft SQL Server Integration Services, Informatica, Ab Initio, Talend, etc.).
• Skills in query tuning and overall efficient use of database resources preferred.
• Experience with Hadoop and other Big Data tools (such as Hive, Spark, SQOOP, etc.) a plus.