Application Programming Interface (API), Business Solutions, Computer Science, Customer Relationship Management (CRM) Systems, Data Management, Data Quality, Database Extract Transform and Load (ETL), Database Optimization, Depth Perception, Identify Issues, Information Technology & Information Systems, Information/Data Security (InfoSec), Microsoft SharePoint, Microsoft Windows Azure, Operational Support, Organizational Skills, Performance Management, Physical Demands, Power BI, Problem Solving Skills, SQL (Structured Query Language), SQL Server Integration Services (SSIS), Salesforce.com, Stored Procedures, Systems Analysis, Systems Engineering, Systems Reliability, Team Player, Time Management, Training Data Sets, Workflow/BPM (Business Process Management) Software
Essential Responsibilities:
- Design, build, and maintain SQL-based data pipelines to support reliable data extraction, transformation, and loading across enterprise systems.
- Develop, update, and optimize database objects (views, stored procedures, functions, indexes) to ensure high performance and data accuracy for reporting and analytics.
- Create and maintain PowerBI datasets, models, and reports, ensuring data is accurate, refreshed appropriately, and presented in a user-friendly manner.
- Build and support data integrations between internal and external systems using APIs, flat files, or integration tools, ensuring secure and timely data exchange.
- Monitor, troubleshoot, and document data workflows to ensure system reliability, resolve data quality issues, and provide ongoing operational support for reporting and analytics environments.
- Effective time management and organization skills to succeed in fast-paced environment
- Works well as a member of a team
- Capable of carrying out a given task with all details necessary to get the task done well
- Consistently introduce new ideas and demonstrate original thinking
- Other duties as assigned
Qualifications:
- Minimum 3 years’ experience as a data engineer, business systems analyst or a similar role (Required)
- BS degree in computer science, information systems, or related field (Required)
- Proficiency in SQL for data querying, transformation, and optimization.
- Experience with ETL tools, preferably SSIS (or equivalent such as Mulesoft or Azure Data Factory).
- Knowledge in SharePoint, Salesforce or similar CRMs, and Workflow software
- Intermediate to expert level Excel skills
Physical Demands:
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job:
While performing the duties of this job, the employee is regularly required to use hands to finger, handle, or feel; reach with hands and arms; and talk or hear. The employee frequently is required to stand; walk; and stoop or kneel. The employee must regularly lift and/or move up to ten pounds, occasionally lift and/or move up to twenty pounds, and rarely lift and/or move more than twenty-five pounds. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception, and ability to adjust focus.
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.