Database Engineer

Job Description

Our client is looking for a passionate engineer who loves data and database technologies and has experience bringing new analytics solutions from concept to market. They are building a new series of Products and Services based on Software as a Service (SaaS) model on AWS. Analytics will be their first service offering in that series. You will have the opportunity to influence the design and implementation. You must have deep knowledge of Microsoft SQL Server and data warehouse technologies (e.g. AWS Redshift) and be self-driven and highly motivated.

The Data Engineer is a critical member of the Software Development and Analytics team. You will help in sustaining and improving our current software solutions, as well as help steer new analytics offerings and establish our next generation data ingestion, transformation, and analytics capabilities.

Responsibilities:

  • Design the organization of data for data warehousing using the star schema and/or snowflake schema
  • Design and implement complex queries utilizing SQL Commands, Views, Stored Procedures
  • Write programming scripts to provide data to end users to make business decisions
  • Develop Data Warehousing solutions in the cloud, namely AWS and Azure; Design and implement the required ETL
  • Create functions to provide custom functionality per the requirements
  • Develop reports in SQL Server Reporting Services/ Tableau/Qlik View/Power BI
  • Produce ad-hoc queries/reports to meet ADPIs initiatives
  • Design, Develop and Deploy SSIS Packages
  • Participate in discussions involving the application creation and understand the requirements and provide the back-end functionality for the applications
  • Assist with critical analysis of test results and deliver solutions to problem areas
  • Identify and research data issues; work with teams to correct or improve issues
  • Analyze user problems and make suggestions for the prevention of future problems

Requirements:

  • Proven experience in bringing an analytics solution from concept to market
  • 10+ Years of experience in Microsoft SQL Server and database technologies
  • Experience with reporting and analysis tools such as SSRS, Crystal Reports, and Tableau
  • Extensive Experience building Clusters and Data Servers using tools such as Amazon Redshift
  • Migration Experience with moving Data in/out from Amazon Redshift and other similar technologies
  • Experience using scripting languages such as Python and Powershell to source API data
  • Strong preference for Agile/Scrum experience
  • Strong work ethic, loyal, achievement oriented, and ethical
  • Excellent interpersonal and communications skills (both verbally and written)
  • Possess a high level of professionalism and have excellent follow-through skills
  • Highly analytical and organized, with a strong attention to detail
  • Bachelor Degree in Science, Math or Engineering

Desired:

  • Experience in the Healthcare industry a plus
  • Experience with C# and R