Job description

ServiceChannel is the leading cloud-based service automation platform for facility management. We offer a single platform to source, procure, manage and pay for repair and maintenance services from commercial contractors. ServiceChannel is well established, but even after almost 20 years we still retain the spirit of a startup. We are primed for success and we are currently on a high growth trajectory. We are committed to creating a great product for our customers and a great work environment for our employees to succeed professionally and personally.

ServiceChannel Data Engineers are responsible for the design and implementation of enterprise data solutions across the organization using proven database architecture, modeling, engineering techniques and sound database principles. Prospective candidates must have extensive experience in developing data integration processes for enterprise data enablement and management systems. They must understand information and system development lifecycles. Deep knowledge of database, data warehouse, and various data management focus areas as specified in DMBOK (refer to DAMA – Data Management Association) Framework (or equivalent disciplines) are required. The candidate will work on enterprise data analytics, data mining and data science initiatives and other integration projects driving ServiceChannel’s analytics strategy and implementation roadmap.

Key Responsibilities:
Data Discovery - analyzing data values and data patterns to identify the relationships that link disparate data elements into logical units of information, or “business objects” (such as customer (subscriber), service provider, work requests, etc.). Identify the transformation rules that have been applied to a source system to populate a target such as transactional entities, operational data store or data warehouse. Create and maintain user documentation

Data Architecture and Modeling - Create conceptual, logical and physical data models. Define data attributes, including domain constraints and privacy attributes. Discover, explore, and visualize the structure of data sources. Discover or identify relationships between disparate data sources. Compare and normalize the structures of various data sources to address data analytics, data mining, data warehouse and reporting requirements. Perform peer code review when assigned

Data Engineering and Data Warehouse – Build extensible data acquisition and integration solutions to meet the functional and non-functional requirements of the business. Implement processes and logic to extract, transform, and distribute data across one or more data stores from a wide variety of sources. Optimize data integration platform to provide optimal performance under increasing data volumes. Participate in research and development of recommendations regarding database components, including hardware, database systems, ETL software, metadata management tools and database design solutions.

Data Governance/Stewardship – Ensures the quality, completeness and accuracy of data definitions within developed codes. Identifies and lead the resolution of data quality and data security issues, such as uniqueness, integrity, accuracy, consistency, privacy and completeness in a cost-effective and timely fashion. Identify procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.

Data Quality - Ensure the stability, integrity and efficiency of data access and data quality via ongoing database support and maintenance. Ensure data reconciliation unit testing procedures that will prove accuracy and correctness of data being processed.

Database Architecture, Administration and Development- Work with database development staff and DBAs to develop database architectures, coding standards, and quality assurance policies and procedures. Participate in testing and implementing database design and functionality, and tuning for performance.

Metadata - support information governance by providing reporting and traceability on data movement, modeling and business intelligence applications, as required by regulatory requirements. Analyze and view the impact of changes to the current information model, avoiding potentially problematic modifications to existing processes.

Customer Implementation and Production Support – Assist Implementation and Customer Success teams as Data SME during solving issues.

Required Qualifications:
Bachelor’s Degree in Computer Science, related field or equivalent experience (including completed courses in relevant areas such as computer science, computer languages, etc.

Solid understanding of database structures, theories, principles and practices, and hands-on experience with business requirements gathering, data analysis and data modeling

Good experience running/maintaining database schema in source code control

Demonstrated ability related work experience which deals with following data domain - customer, service provider, service orders, invoices and other related attributes.

Demonstrated ability in analyzing and developing data requirements and data specifications; hands-on experience in documenting understanding and analysis of databases and data models.

3+ years of experience in creating, mapping and documenting data within organization (source, targets, transformation rules, etc.); Experience with any off the shelf ETL technology to build mappings to extract and transform data. Understanding of ETL technology architecture; Understanding of ETL Repository. Worked on transformations to cleanse, format, join, aggregate and route data to appropriate targets. Perform error handling/trapping using ETL mappings or corresponding techniques. Experience using Workflow management to build and run workflows; Experience with performance tuning ETL mappings and workflow; Designed error handling strategies for use in a workflow. Worked with ETL logs and debugger for troubleshooting

4+ years of hands-on experience in writing SQL for querying databases. Ability to extract information from databases using sophisticated query statements and advanced database tools.

Ability to work independently while working on multiple projects

Strong problem-solving and communication skills

Strong analytical, prioritizing, interpersonal, problem-solving, presentation, project management (from conception to completion) & planning skills

Demonstrated collaborative skills and ability to work well within a team

Ability to work in a fast-paced environment

Self-motivated with critical attention to detail, deadlines and reporting. Able to successfully work on problems of limited to diverse scope involving task specific or multi-functional teams.

Ability to analyze business processes, data lifecycles, and standard operating procedures Preferred Qualifications:

Facility management data domain knowledge/experience

Experience in cloud ETL and near-time data integration technology

Good background in logical data modeling

2+ years hands-on technical experience with designing, building, installing, configuring and supporting database servers including database tuning and troubleshooting experience

Advanced ETL techniques: Understanding structure and use of parameters. Experience using Lookup transformation. Applied memory optimization techniques

Worked with various relational and MPP database platforms

Experience with version control tools & release management

Applied experience in secure file transfer protocol (sFTP), web services integrations, Salesforce, and JIRA

Fortive is a diversified industrial growth company, with a $6B portfolio of market-leading brands. We develop and deliver essential technology for the people who create, implement and accelerate progress. And we achieve this through our people. Our globally diverse team of 24,000 employees is united by a common culture rooted in Fortive Business System (FBS). Exceptional people thrive at Fortive because we build extraordinary teams for extraordinary results. We recruit, develop and retain the best talent available. We shape the future. We innovate to fuel our customers’ success, building better businesses and propelling progress. We are driven to do better. We emphasize continuous improvement and nonstop learning. We are team-oriented. We work together, and we win together. We create an environment based on integrity and action, not politics and bureaucracy.

At Fortive, you can build a career in a way no other company can duplicate. Our brands allow us to offer dynamic careers across multiple industries. We need the most talented people to keep progressing. Here you’ll learn how FBS is used to shape strategy, focus execution, align our people, and create value for customers and shareholders. Come join our winning team.

#LI-Remote
Our work environment is dynamic, collaborative, and entrepreneurial - We are firm believers in working to live and not living to work. Don’t get us wrong, we work hard and do what it takes to get the job done, but we value a healthy work/life balance and have a lot of fun along the way. Our company is filled with foodies, music lovers, travelers and sports nuts.

We are looking for energetic, positive, creative problem solvers who don’t mind digging in and getting their proverbial hands dirty. In addition to striving to create the best possible environment for our ServiceChannel team members, we also support them outside of work as well through generous medical, dental, and vision insurance, life insurance, 401k with match, a flexible time-off policy, and paid parental leave. Our greatest benefit, however, is our amazing ServiceChannel team!

In 2021, ServiceChannel joined the Fortive group of leading technology companies, united by a common purpose to make the world stronger, safer, and smarter. Fortive accelerates ServiceChannel’s growth through extraordinary business systems, cross-industry expertise, and employee development resources

We offer an excellent benefits package including medical, dental, vision, life and LTD insurance, HSA, and a 401(k) retirement plan. ServiceChannel’s commitment to the professional and personal success of our employees has landed us on Wealthfront’s Career-Launching Companies List for three years in a row.
We Are an Equal Opportunity Employer
Fortive Corporation and all Fortive Companies are proud to be equal opportunity employers. We value and encourage diversity and solicit applications from all qualified applicants without regard to race, color, national origin, religion, sex, age, marital status, disability, veteran status, sexual orientation, gender identity or expression, or other characteristics protected by law. Fortive and all Fortive Companies are also committed to providing reasonable accommodations for applicants with disabilities. Individuals who need a reasonable accommodation because of a disability for any part of the employment process should ask to speak with a Human Resources representative to request an accommodation.

National: The salary range for this position is $98,000- $182,000

Base pay offered may vary depending on various factors, including, but not limited to: job-related knowledge; skills; experience; and other eligibility factors such as geographic location. The Total Rewards package includes competitive base pay and an opportunity to enroll in a variety of benefit programs, generally including health insurance, flexible spending accounts, health savings accounts, retirement savings plans, life and disability insurance programs, and several programs that provide for both paid and unpaid time away from work.

colinoncars.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, colinoncars.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, colinoncars.com is the ideal place to find your next job.