Software Engineer II

POSITION OVERVIEW

NBME® is looking for a Data Engineer to join a highly skilled and growing team of data engineers and BI developers. In this role you will be using your data engineering skills and problem-solving skills to deliver meaningful insights to Internal and external customers. The Data Engineer will be responsible for modernizing, expanding, and optimizing NMBE data warehouse by building data integrations, supporting reporting and data visualization for internal and external customers, as well as optimizing new/existing data flows.

Diversity, Equity, and Inclusion Statement

At NBME, we continue to innovate and improve how we fulfill the evolving needs of the health care community. This commitment starts and ends with the people at NBME. By recruiting and empowering talented individuals from various disciplines and backgrounds, which includes professionals with diverse life experiences, abilities, and perspectives, NBME can take a well-informed, robust approach to advancing medical education and assessment for years to come. We also continue to focus on ensuring that our DEI work is impactful and ingrained in everything we do, including with our staff, workplace culture, products and services, the Philadelphia community and the broader medical education.

RESPONSIBILITIES

• Participates in requirements gathering, analyzes and architects project and/or system data architectures. In collaboration with subject matter experts, data analysts, solutions and enterprise architects, ensures designs are consistent and coherent to the enterprise architecture standards and existing environment.
• Be a critical part of a scrum team in an agile environment, ensuring the team successfully meets its deliverables each sprint.
• Trains and mentors team members
• Work independently and effectively to manage one's time across multiple priorities and projects.
• Assures the integrity and accuracy of the corporate data, with particular attention to data security.
• Responsible to ensure high data quality for Data Services, Analytics and Master Data Management.
• Perform Logical and Physical data modeling with an agile mindset
• Build automated, scalable, test-driven data pipelines.
• Utilize software development practices such as version control via Git, CI/CD, and release management.
• Build data products using various visualization, BI tools and data science tools.
• Collaborate with Data Engineers, DevOps engineers and architects on improvement opportunities for DataOps tools and frameworks.
• Be a trusted partner by providing agile capabilities and outstanding services through digital transformation

QUALIFICATIONS

Skills and Abilities

• Expert in data modeling, database management and data profiling techniques, particularly in Data Warehouse, Master Data Management (MDM), and in the design and delivery of Business Intelligence solutions.
• Deep understanding of industry standards and best practices
• Strong analytic skills related to working with structured and unstructured datasets.
• Critical thinker and creative problem-solving skills along with the ability to communicate well with stakeholders throughout the organization.
• Highly proficient in PL/SQL
• Experience with relational SQL and NoSQL databases, including Oracle, MS SQL Server and HBase.
• Experience with data integration tools: Informatica, Boomi, Fivetran, MS Integration Services, Sqoop, etc.
• Experience with one of the cloud vendors and services: AWS, Google, Microsoft, Snowflake
• Experience consuming and building APIs
• Experience with object-oriented/object function programming languages: Python, Java, C++, Scala, etc.
• Experience with visual analytics tools: QlikView, Tableau, Power BI, Micro strategy etc.
• Experience utilizing Agile methodology for development.
• Experience with Singer and DBT is a plus

Experience

• Minimum of 3 years of Data Engineering and Data Warehousing experience.
• Minimum of 2 years of experience with python
• Minimum of 2 years of experience with data integration tools like In