Sr. Integration Engineer

Job Summary
The Sr. Integration Engineer will play a crucial role in facilitating integrations amongst systems and processes across the product security and information technology systems.  The engineer will help transform data into meaningful information that drives decision-making processes across various departments. The ability to effectively communicate findings and collaborate with cross-functional teams will be crucial to their success in this role. 

As a member of the Product Security team, the Senior Integration Engineer is responsible for creating integrations between systems across various aspects of Governance Risk and Compliance.  This will involve the design, development, and management of data sources, dashboards, self-service analytic tools, reports and/or data extracts to meet organization information needs.  The Engineer will gather data from various sources, such as databases, APIs, or files, and build integrations to other systems.  This includes ensuring data quality and completeness, preparing data for analysis by cleaning, filtering, and transforming it into a usable format, ensuring accuracy and consistency, applying statistical and analytical techniques to interpret data, identify trends, patterns, and relationships to uncover insights that can support decision-making and create reports, dashboards, and data visualizations (such as charts, graphs, and plots) to present findings and communicate insights effectively to stakeholders. 

Responsibilities:

• Create integrations between systems across various aspects of IT and Product Governance Risk and Compliance.
• Gather data from various sources, such as databases, APIs, or files, ensuring data quality and completeness.
• Prepare data for analysis by cleaning, filtering, and transforming it into a usable format, ensuring accuracy and consistency.
• Apply statistical and analytical techniques to interpret data, identify trends, patterns, and relationships to uncover insights that can support decision-making.
• Create reports, dashboards, and data visualizations (such as charts, graphs, and plots) to present findings and communicate insights effectively to stakeholders.
• Using data-driven approaches to solve complex business problems, optimize processes, and improve efficiency.
• Interpret data, analyze results using statistical techniques, and provide ongoing reports.
• Develop and implement integrations amongst systems using APIs, databases, data collection systems, data analytics, and other strategies that optimize statistical efficiency and quality.
• Acquire data from primary or secondary data sources and maintain databases/data systems.
• Work closely with management to prioritize business and information needs.
• Locate and define new process improvement opportunities.
• Uses a variety of tools to manipulate, analyze and extract data, including GitLab, SQL, PostgreSQL, Grafana, Prometheus, Pandas, Power BI, Python, PowerShell, and API interaction.
• Presents BI solutions, creates design and standard operating procedure documentation, leads end-user trainings, and facilitates discussions with colleagues from all levels of the organization.
• Act as a centralized resource for data requests by understanding what data is available and how to retrieve it and/or figure out what needs to be done to acquire and deliver the desired data sets.
• Provide structured and high-quality content, summarizing trends and flagging underlying drivers.
• Maintain data analytics platforms.
• Ad hoc querying and data analysis.

Requirements:

• Bachelor's Degree in computer science, data science, information technology or related fields.
• 5+ years of related work experience.
• Experience in development and integrations between systems with a primary focus on Python, SQL, Grafana, Power BI, reporting, and analytics solution development
• Proficiency with SQL and understanding data models (other analytical platforms/languages a plus) and their relationship to reporting.
• Experience with automation, deployment, and scheduling processes.
• Experience working with very large datasets.
• Ability to interact with business users to identify reporting and data analysis needs.
• Unrelenting desire to get to the bottom of the problem and get it right.
• Drive to execute and deliver both independently as well as part of a team.
• Technical Skills: SQL, PostgreSQL, Grafana, Prometheus, Pandas, Power BI, Python, PowerShell, and API interaction.
• Strong consultative skills, with the ability to advise and consult with business and technical professionals.
• Ability to communication highly technical issues to non-technical stakeholders.