Join Verinext, a technology company that's not just keeping up with the future, but actively shaping it. At Verinext, we firmly believe that work should be as enjoyable as it is rewarding. As a Database Engineer, you'll be stepping into an environment that thrives on innovation and fun. Our team-oriented culture isn't just a buzzword; it's a cornerstone of our success. We're incredibly proud to have been recognized as a "Best Place to Work" by the Philadelphia Business Journal for 10 consecutive years.
We are recruiting for a Database Engineer that will oversee the IT department’s IT and Business needs using Azure Data Lake and, Local SQL Databases to integrate application data for all business units. They will also be responsible for identifying what platforms and software is best for Client's data/business specific needs and work with the Sr. IT Leadership to determine and acquire software to facilitate implementation. This role will be the primary lead on all MS SQL databases and integrations.
Other responsibilities will include IT project oversight, process improvements, and cross-functional system integration.RESPONSIBILITIES
- Collaborate with stakeholders to understand data requirements and Translate them into data architecture solutions.
- Design and engineer efficient data pipelines to extract, transform, and load data from various sources into the data lake.
- Develop and maintain SQL scripts, stored procedures, views, and ETL processes. To support data integration and transformation.
- Perform data modeling to ensure data is structured and optimized for reporting and analysis.
- Work with existing data architectures and propose enhancements or new architectures as needed to meet evolving data needs.
- Implement data quality checks and monitoring processes to ensure data integrity.
- Troubleshoot and resolve issues with data pipelines, ensuring smooth and reliable data flow.
- Collaborate closely with report writers and BI analysts to provide them with the required data in the data lake.
- Stay current with the latest trends and best practices in data engineering and Azure technologies.
- Provide technical guidance and mentorship to team members as needed.
QUALIFICATIONS
- Knowledge of system design, development, implementation, and user support principles and practices.
- Experience with database management
- Experience with project management principals
- Familiarity with information systems troubleshooting
- Ability to communicate technical information to a non-technical audience.
EXPERIENCE AND EDUCATION
- 6+ years of experience in data engineering, data architecture, or a related field in manufacturing or distribution industries.
- Strong Proficiency in SQL and Azure SQL Server, with hands-on experience in data modeling and schema design.
- Extensive experience with Azure Big Data technologies, including Azure Data Factory (ADF) and Azure Data Lake.
- Proven ability to design and implement robust data pipelines, ETL processes, and data architectures.
- Experience with data modeling and data quality assurance best practices.
- Experience delivering data mapping and accompanying documentation
- Familiarity with SSRS and Power BI, Python, R is a plus.
- Strong problem-solving, analytical, and troubleshooting skills.
- Excellent communication and collaboration abilities, with the ability to work with cross-functional teams.
- Bachelor’s degree in computer science, Information Technology, or a related field.
- SQL or Azure certifications are desirable but not required if the experience is evident.
COMPETENCIES
- Analytical — the individual synthesizes complex or diverse information.
- Problem solving — the individual identifies and resolves problems in a timely manner and gathers and analyzes information skillfully.
- Oral communication—the individual speaks clearly and persuasively in positive or negative situations, demonstrates group presentation skills and conducts meetings.
- Quality management—the individual looks for ways to improve and promote quality and demonstrates accuracy and thoroughness.
- Judgment—the individual displays willingness to make decisions, exhibits sound and accurate judgment and makes timely decisions.
- Planning/organizing—the individual prioritizes and plans work activities, uses time efficiently and develops realistic action plans.
- Safety and security—the individual actively promotes and personally observes safety and security procedures and uses equipment and materials properly.
COMPUTER SKILLS
To perform this job successfully, an individual should have knowledge of Microsoft Word, Excel, PowerPoint, and other report writing and project planning software. Experience working in an ERP environment is desirable.
