Senior Data Engineer | 782800

Revel IT

Apply Now

Columbus, Ohio client has a direct hire opportunity for a Senior Data Engineer that will assist with moving forward the strategy around the integration, aggregation, and warehousing of the company’s data making it available for consumption through business intelligence and data analytics/science solutions. The role will collaborate with product owners, data governance, data analytics, software architects, QA, and other functional leaders to deliver innovative data solutions.

Requirements:

  • 5 to 7 years of experience with database management, data centric applications.
  • Experience with the property and casualty insurance industry. Strong understanding of insurance business and data models.
  • Experience developing conceptual, logical, and physical data models, including 3NF (3rd Normalized Form), Dimensional Modeling, Data Vault Modeling, and Bi-Temporal Modeling.
  • Strong experience with Data Warehouse Architecture (Inmon versus Kimball vs. Data Vault)
  • Hands-on experience with Microsoft SQL Server 2016 and higher.
  • Experience with SQL server analysis services, Metadata management, data governance, and data lineage.
  • Experience with data quality management and data profiling.
  • Experience with DevOps, including Agile, Continuous Integration / Continuous Delivery.

Responsibilities:

  • Work with Microsoft Azure Data Platform, including Azure SQL, Azure Data Factory, Azure SQL Data Warehouse (Synapse Analytics), Azure Data Lake Storage, etc. In- depth knowledge of Azure data component use cases and patterns.
  • Design and develop robust ETL processes specifically in Microsoft Azure environments using Azure data factory pipelines, stored procedures, Azure functions, SSIS, SQL, APIs, etc.
  • Develop conceptual, logical, and physical data models, including 3NF (3rd Normalized Form), Dimensional Modeling, Data Vault Modeling, and Bi-Temporal Modeling.
  • Perform SQL Server performance tuning, including identifying which queries are experiencing slowdowns and optimizing them for maximum efficiency.
  • Design and develop SQL server analysis services cubes, Metadata management, data governance, and data lineage.

Nice to have:

  • Experience with DB2 database.
  • Experience with AWS / Google Cloud Data Technologies
  • Managing Azure infrastructure, SQL Server Database Administration (DBA skills), and database replication techniques.
  • Dashboard development using Power BI.
  • NoSQL techniques and databases (including graph databases)
  • Experience with neural networks, machine learning, deep learning, Azure DataBricks, Spark, Python, data mining techniques, and data science libraries like NumPy, TensorFlow, Keras, Scikit-learn, etc.

Reference: 782800
  

Revel IT is an Equal Opportunity Employer. Revel IT does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.

#gdr4900

Apply Now

  • Hidden
  • Max. file size: 128 MB.
  Apply with Google   Apply with Twitter
  Apply with Github   Apply with Linkedin   Apply with Indeed
  Stack Overflow