Job Description :
Summary:
You will join a team of analysts and developers whose goal is to support decision making at all levels, solve business problems, and deliver insight throughout the organization.
In this role you will work to design, implement, and maintain data warehousing and data management solutions to support business reporting and analytical requirements. This includes researching and defining the source system data, designing the data ware house data model, building source system data ETL processes, verifying data accuracy, and designing complex interactions between data sources. Additionally, the Data Engineer designs, develops, and automates reports and dashboards that communicate performance, strategic planning, market analysis, financial analysis, operational analysis, and a variety of other business needs.
You will be given autonomy to conduct ad-hoc research and routine projects, while given complete support of your peers, database experts, and management. You will be looked to:
Stay abreast of evolving business intelligence technology, trends, and best practices
Research new data sources and analytical tools to help visualize key performance indicators
Collaborate in planning, design, development, and deployment of new business intelligence tools
Recommend supplemental enhancements to existing applications
Candidates should have worked in a cross-domain environment (example: finance, marketing, etc They are truly wanting a Data Engineer who has worked with MS and Oracle databases. Ideally 50% between MS/Oracle, but if we find candidates stronger in one – MS would be the better. They can have experience with any BI tools. Must be an excellent communicator (will be working with C-level folks from time to time. They would like to have someone with expert data modeling experience.
Responsibilities:
Working within Data System Development domains you:
o Designing, building, monitoring, and maintaining ETL feeds for new and existing data sources
o Structuring data in a way that is easy to understand, query, and display.
o Documenting all metadata regarding data source, field type, definition, etc. for each field and table created
o Serving as a subject matter expert on data sources, structure, or definitions
o Working with various stakeholders to optimize data and the use of information
o Collecting, organizing, analyzing, and disseminating significant amounts of information with attention to detail and accuracy
o Developing, designing, and automating regular reports accurately and on a timely basis
Supporting analytics by:
o Designing and building ad-hoc reports that provide actionable and meaningful information
o Responding to analytics inquiries from various departments by identifying data that will provide appropriate and actionable answers
o Identifying, analyzing, and interpreting trends or patterns in complex data sets, and connecting those trends to actionable insights and business needs.
o Interpreting reports or contractual language to analyze the impact on the port’s overall operations, customers and finances.
Researching new data management techniques or best practices
Actively promoting and supporting a culture of data-driven decision making within various departments with use of innovative data visualization and data science methodologies
Represent Business Intelligence and Innovation to internal departments
Mentor less experienced technical
All other duties as assigned
Required Knowledge, Skills and Abilities
PL and T- SQL (we have both MS and Oracle based SQL Servers)
In-depth technical expertise regarding data models, data analysis and design, programming, master data management, metadata management, data warehousing, business intelligence, and data quality improvement
Ability to research and implement best-practice database management techniques
Ability to work effectively in a team environment
Well-developed communication skills, both written and verbal
Strong skills in organization and time management
Minimum Qualifications:
Bachelor''s Degree in a Computer Science, Information Systems, Data Analytics, Database Management, or Operations Research - will consider experience in lieu of education
Experience using data visualization and business intelligence tools, such as Tableau, Birst, Power BI, Business Objects, SQL Server, etc.
Displays a high degree of integrity, professionalism, and strong business ethic
Ability to use MS Office applications
Preferred Qualifications:
Master’s degree in information systems, computer science, business, finance, economics, or other analytical field
Experience in the maritime industry, warehousing, logistics, intermodal, rail, or trucking
Experience applying qualitative and statistical methods, conducting independent research projects, and preparing research reports