Data Insights Engineer
-
Illinois
-
Other
Job Description
Job
Description: Database Engineer/Database Developer
A Database Engineer must be able
to conceptualize and design DB solutions and manage processes with a team of
developers. This sample job description will help you evaluate candidates for
this critical hire.
The Database Engineer is
responsible for all aspects of the design, development and delivery of data and
database solutions.
Responsibilities include:
Design,
develop and deliver / implement data solutions to include: architecture design,
prototyping of concepts to proof of concept, development of standards, design
and development of test plans, code and module design, development and testing,
data solution debugging, design and implementation of a solution that follows
efficient design techniques and development that meets and exceeds the intent
of the design of the data solution.
Effectively
manage day-to-day tasks / activities in coordination with a team of developers
to effectively meet the deliverables and schedule of a data solution component
within a larger application project.
Lend
support to various business and technology teams as necessary during design,
development and delivery to ensure solid, scalable, robust solutions.
Support and maintain data and database systems to meet
business delivery specifications and needs.
Define
and create data structures for schemas including tables, views, indexes etc.
Improve upon (refactor) existing SQL and PL/SQL code.
Unit
test code, identify and fix bugs.
Assist
in developing deployment scripts for releases.
Draft
technical documentation.
Experience Needed
Experience in developing/maintaining databases
in MySQL, SQL Server, NoSQL database such as MongoDB, CouchDB
Reporting and business intelligence tools like Cognos,
Microsoft SQL Server Reporting Services, Tableau and SAP Crystal Reports
Big data technologies like Hadoop and Spark
Developing and maintaining ETL process using
various tools like SSIS, etc..
Maintaining databases in the cloud specifically
AWS RDS
The ideal candidate will have:
• 4-yr degree in computer/information science or related
years of experience
• Excellent written and verbal communication skills
Writing
queries and designing tables, stored procedures and other database objects
using T-SQL, index-tuning
• Strong analytical abilities
• Strong attention to details
• 3-4 years of professional experience in the following:
o
Visual Studio 2013 or later
MySQL, PostGre, MariaDB, SQL Server
Additional experience in the following applications is
useful:
Java, Javascript, C#, VB.NET and SSRS Expressions
Description: Database Engineer/Database Developer
A Database Engineer must be able
to conceptualize and design DB solutions and manage processes with a team of
developers. This sample job description will help you evaluate candidates for
this critical hire.
The Database Engineer is
responsible for all aspects of the design, development and delivery of data and
database solutions.
Responsibilities include:
Design,
develop and deliver / implement data solutions to include: architecture design,
prototyping of concepts to proof of concept, development of standards, design
and development of test plans, code and module design, development and testing,
data solution debugging, design and implementation of a solution that follows
efficient design techniques and development that meets and exceeds the intent
of the design of the data solution.
Effectively
manage day-to-day tasks / activities in coordination with a team of developers
to effectively meet the deliverables and schedule of a data solution component
within a larger application project.
Lend
support to various business and technology teams as necessary during design,
development and delivery to ensure solid, scalable, robust solutions.
Support and maintain data and database systems to meet
business delivery specifications and needs.
Define
and create data structures for schemas including tables, views, indexes etc.
Improve upon (refactor) existing SQL and PL/SQL code.
Unit
test code, identify and fix bugs.
Assist
in developing deployment scripts for releases.
Draft
technical documentation.
Experience Needed
Experience in developing/maintaining databases
in MySQL, SQL Server, NoSQL database such as MongoDB, CouchDB
Reporting and business intelligence tools like Cognos,
Microsoft SQL Server Reporting Services, Tableau and SAP Crystal Reports
Big data technologies like Hadoop and Spark
Developing and maintaining ETL process using
various tools like SSIS, etc..
Maintaining databases in the cloud specifically
AWS RDS
The ideal candidate will have:
• 4-yr degree in computer/information science or related
years of experience
• Excellent written and verbal communication skills
Writing
queries and designing tables, stored procedures and other database objects
using T-SQL, index-tuning
• Strong analytical abilities
• Strong attention to details
• 3-4 years of professional experience in the following:
o
Visual Studio 2013 or later
MySQL, PostGre, MariaDB, SQL Server
Additional experience in the following applications is
useful:
Java, Javascript, C#, VB.NET and SSRS Expressions