Acquiring, curating, and publishing data for analytical or operational uses, including the creation of BI reports to support business decision-making. Preparing data for use by data scientists, business users, and technology platforms by creating a single version of the truth for all data consumers.
Requirements
- 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).
- At least 3 years’ experience in data warehousing, queries, and designing AI/ML-ready data structures.
- 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.
Responsibilities
- Acquiring, curating, and publishing data for analytical or operational uses, including the creation of BI reports to support business decision-making.
- Prepare data for use by data scientists, business users, and technology platforms by creating a single version of the truth for all data consumers.
- 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.
- Design, build, and maintain reliable data pipelines and ETL processes to feed databases and data warehouses using a variety of tools and techniques.
- 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, including AI/ML-driven solutions and virtual agent integrations.
- 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.
Other
- Is a Lifelong Learner and Passionate about Technology
- Derives joy from tackling complex problems and working through solution tradeoffs
- Can learn on the fly and fill knowledge gaps on demand
- Can work with a variety of people at various levels
- Has excellent communication ability
