Senior Software Engineer

As a Senior Software Engineer for the Information Technology organization, you’ll be responsible for acquiring, curating, and publishing data for analytical or operational uses, including the creation of BI reports to support business decision-making. You will prepare data for use by data scientists, business users, and technology platforms by creating a single version of the truth for all data consumers. You will work with streaming and batch-loading data sources from technical systems and solutions across the enterprise, with a strong emphasis on API integrations (using tools like PowerShell, Python, SQL, and others) and ServiceNow platform integrations. Successful engineers have the skills to design, build, and maintain reliable data pipelines and ETL processes to feed databases and data warehouses using a variety of tools and techniques. You will have the opportunity to work with various programming languages, technologies (front-end development experience with .Net or Java is a strong plus), and both structured and unstructured data.

A Qualified Candidate

• Is a Lifelong Learner and Passionate about Technology
• Is knowledgeable of emerging BI tools, API frameworks, and cloud-native solutions
• Derives joy from tackling complex problems and working through solution tradeoffs
• Has experience implementing integrations across diverse systems (e.g., API-driven workflows, ServiceNow platforms)
• Can learn on the fly and fill knowledge gaps on demand
• Has hands-on experience with front-end development frameworks (e.g., .Net, Java) for building data-driven applications
• Can work with a variety of people at various levels
• Has excellent data management and QA skills – Process Oriented, with a focus on validating BI report accuracy and API/data pipeline reliability
• Can debug problems to their root cause, especially when the path leads through multiple systems or environments
• Has interest in working with data at the protocol level
• Has experience applying machine learning algorithms, AI tools (e.g., TensorFlow, PyTorch), and developing AI-driven solutions such as virtual agents, particularly within the ServiceNow ecosystem
• Has aptitude for data presentation and ability to transform raw data into meaningful, actionable reports, including advanced BI dashboards and stakeholder-ready visualizations
• Has significant experience creating data pipelines and ETL processes with both batch and real-time API data sources
• Is experienced with Google Cloud Composer / Apache Airflow or similar data orchestration services
• Is experienced with BigQuery or other data warehouse products
• Has excellent communication ability

Essential Functions

• Consults on complex data product projects by analyzing moderate to complex end to end data product requirements and existing business processes to lead in the design, development and implementation of data products.
• Builds data cleansing, imputation, and common data meaning and standardization routines from source systems by understanding business and source system data practices and by using data profiling and source data change monitoring, extraction, ingestion, and curation of data flows.
• Responsible for producing data views and data flows for varying client demands such as dimensional data, standard and ad hoc reporting, data feeds, dashboard reporting, and data science research & exploration.
• Collaborate with data scientists to integrate machine learning models and AI tools (e.g., TensorFlow, PyTorch) into production workflows.
• Translates business data stories into a technical story breakdown structure and work estimate so value and fit for a schedule or sprint.
• Creates business user access methods to structured and unstructured data by such techniques as mapping data to a common data model, transforming data as necessary to satisfy business rules and validation of data content.
• Collaborates with enterprise teams and other internal organizations on CI/CD best practices experience using Google Tables, JIRA, Jenkins, Confluence etc.
• Implements production processes and systems to monitor data quality, ensuring production data is always accurate and available for key stakeholders and business processes that depend on it.
• Develops and maintains scalable data pipelines for both streaming and batch requirements and builds out new API integrations to support continuing increases in data volume and complexity
• Writes and performs data unit/integration tests for data quality with input from a business requirements/story, creates and executes testing data and scripts to validate that quality and completeness criteria are satisfied. Can create automated testing programs and data that are reusable for future code changes.
• Practices code management and integration with engineering Git principle and practice repositories.
• Participates as an expert and learner in team tasks for data analysis, architecture, application design, coding, and testing practices.

Qualifications

• Required Education: Bachelor's Degree in computer science, management information systems, business, statistics, math, a related field or comparable experience and education

Required Experience

• 3 - 5 years of relevant experience with data quality rules, data management organization/standards and practices, and API integrations (e.g., RESTful services, PowerShell, Python, SQL).
• 3 years experience in data warehousing, queries, and designing AI/ML-ready data structures.
• Strong problem-solving, oral, and written communication skills.
• Ability to influence, build relationships, negotiate, and present to senior leaders.
• Experience manipulating, processing, and extracting value from large, disconnected datasets, including feature engineering for AI/ML models.
• Advanced query authoring (SQL).
• Advanced Python scripting with a focus on API integrations.
• Advanced working knowledge of a variety of databases.
• Working experience with Git, and GitHub or GitLab.
• Hands-on experience with front-end development (e.g., .Net, Java) for data visualization tools or custom dashboards.
• Data application and practice knowledge, including machine learning frameworks (e.g., TensorFlow, PyTorch)

Preferred Experience

• Healthcare/Insurance/financial services industry knowledge
• Experience with Google Dataflow
• Experienced handling and working with sensitive data
• Experience with Google Cloud Platform (GCP), including AI/ML services (e.g., GCP AI Platform).
• Familiarity with ServiceNow AI/ML tools (e.g., Predictive Intelligence, Virtual Agent, Now Intelligence) is a strong plus.