Data Engineer

Summary:

Purpose: The Data Engineer will be responsible to 1) collaborate with business leaders to define data storage and tracking needs; 2) define and implement data modeling, scripting, and manipulations to support business reporting and analytics; and 3) provide oversight on the administration and maintenance of database systems and platforms.

This position will work with the CTO to ensure projects are implemented in alignment with defined data architecture and governance principles.

This is a hands-on leadership position in the organization. The successful candidate will be able to visualize, execute, and implement projects as an individual and part of a team. This person will be able to facilitate decisions between departments and to design effective solutions built off strong data management principles.

Reports To: Chief Technology Officer

Responsibilities:

• Collaborate with business leaders to understand business processes and reporting and analysis needs. Make recommendations and design solutions to ensure data is entered, stored, and managed in accordance with defined data architecture principles to ensure high data quality results.
• Design, build, and maintain a data warehouse and coordinate and schedule data refresh activities.
• Design, build, and maintain data modeling and manipulation programs and scripts that support data reporting and analysis initiatives.
• Perform data management tasks, such as data cleansing, manipulations, and transformations.
• Create and manage database reports; assist with dashboard visualizations and designs.
• Manage and maintain the performance, recoverability, versioning, and security of all corporate database systems. Ensure database backups and replications are set up to mitigate the impact of a data breach.
• Diagnose and troubleshoot database errors and data quality concerns.
• Participate in M&A activities to effectively merge data sets for consolidated reporting and analytics.
• Proactively seek out and implement improvements to data quality.
• Be aware of and understand current and evolving data trends and technologies.
• Create and maintain documentation on all responsibilities.

Required Qualifications:

• Bachelor’s degree in computer science or a related field.
• 5 years of direct experience in data architecture, modeling, scripting, or reporting.
• Understanding of relational and dimensional data modeling.
• Understanding of data management concepts and practices.
• Experience with SQL and other scripting languages.
• Experience with data reporting and analytical tools. Direct experience with SSRS and PowerBI is preferred.
• Experience with Windows SQL Server environments and administration tools.
• Advanced knowledge of database security, backup and recovery, and performance monitoring standards
• Excellent written and verbal communication skills
• Impeccable attention to detail
• Strong analytical, communication, and problem-solving skills.
• Independent sense of urgency to task and project completion.
• Ability to work well with a variety of personality types.