Hps Software Solutions - Memphis, TN

posted 3 months ago

Full-time - Mid Level
Memphis, TN
Professional, Scientific, and Technical Services

About the position

The Data Integration Developer position is focused on implementing ETL (Extract, Transform, Load) and reporting solutions for various disparate systems that handle challenging data types. The ideal candidate will possess advanced knowledge of SQL Server and other databases, along with experience in data modeling, data warehousing, and data exchange. This role requires strong analytical and problem-solving skills, as well as a solid understanding of business intelligence (BI) tools and technologies. The candidate will be responsible for direct communication with both requestors and technical personnel, ensuring that data integration solutions meet the needs of the organization. In this role, the Data Integration Developer will work extensively with Azure tools, including Azure Data Factory, Azure Synapse, and other Azure services. The candidate will also utilize reporting tools such as Power BI and Cognos to create insightful reports and dashboards. A strong background in writing SQL and T-SQL queries, as well as experience with No-SQL databases like Cosmos and MongoDB, will be beneficial. The position requires the ability to manage detail-oriented work while adhering to schedules and deadlines, and the candidate should be comfortable with ad-hoc reporting and requirements analysis. The successful candidate will have a Bachelor’s degree and 7-10 years of relevant experience in the data engineering field. They should be well-versed in database architecture and design, data extraction, data modeling, and analysis. Effective communication skills, both verbal and written, are essential for conveying technical information to non-technical users and collaborating with team members.

Responsibilities

  • Implement ETL and reporting solutions for disparate systems.
  • Utilize Azure Data Factory, MS SQL, Azure Synapse, SSIS, Power BI, SSRS, SQL Query Analyzer, Cognos, and Excel for data integration tasks.
  • Write SQL and T-SQL queries and stored procedures for data manipulation.
  • Work with No-SQL databases like Cosmos and MongoDB as needed.
  • Communicate effectively with both technical and non-technical users.
  • Conduct ad-hoc reporting and requirements analysis.
  • Manage database architecture and design, data warehousing, and data modeling activities.

Requirements

  • Bachelor's degree in a relevant field.
  • 7-10 years of experience in data engineering.
  • Advanced knowledge of SQL Server and other databases.
  • Experience with data modeling, data warehousing, and data exchange.
  • Strong analytical and problem-solving skills.
  • Proficiency in Azure tools and services, including Azure Data Factory and Azure Synapse.
  • Experience with reporting tools such as Power BI and Cognos.
  • Ability to communicate effectively with technical and non-technical personnel.

Nice-to-haves

  • Experience with No-SQL databases like Cosmos and MongoDB.
  • Familiarity with Azure Logic Apps, Functions Apps, Power Automate/Apps, and Azure Storage.
  • Knowledge of business intelligence tools and technologies.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service