What We Do:
At PESI we reach millions of professionals daily, offering them advanced training so that they can help others to achieve hope and healing. Our work has a deeper purpose; one that contributes to improving the quality of life of others. Our mission is to connect knowledge with need; we help clinicians, in the mental health and healthcare fields, throughout the world expand their knowledge through delivering innovative and cutting-edge training that helps them to improve the outcomes of their clients’ lives. PESI has offices on three continents and is continuing to expand. Join a company with a culture that embraces inquisitiveness, responsibility, collaboration, and continual learning and growth.
How We Do It:
We aim for innovation and creativity: Continuous improvement and falling forward is what facilitates our ability to meet our mission of connecting knowledge with need.
Our people create our success: We listen, we learn, and we strive to meet or exceed the expectations of our customers, associates and vendors.
We go direct and assume competence: We expect open, honest and ethical relationships both internally and externally.
We encourage you to be an entrepreneur: Our associates view their position or area as if it were their own business and make decisions accordingly.
Overview of the Information Technology Team:
The PESI Information Technology Team is responsible for supporting the efforts of all PESI organizations – from business development to fulfillment. From desktop support to building, implementing, and supporting enterprise-scale systems, we work together to change how we reach our customers by developing new and innovative solutions to create efficiencies, expand our capabilities, and provide our customers with a best-in-class experience.
What You Will Be Doing: (responsibilities)
- Collaborating with IT and business teams to develop and execute robust enterprise data strategies, empowering decision-makers across marketing and other business functions.
- Designing and implementing a scalable Azure-based Data Warehouse, enabling seamless access to critical data for informed decision-making.
- Partnering with report writers and analysts to deliver actionable datasets and insightful reports.
- Developing, maintaining, and optimizing ETL processes using modern cloud and on-premises tools.
- Documenting datasets comprehensively to ensure accessibility and ease of use for data warehouse consumers.
- Acting as a trusted technical resource for business and IT teams on data-related challenges and solutions.
- Writing and optimizing complex SQL queries for seamless data retrieval from multiple systems.
What You Bring to the Team: (skills and requirements)
- 2+ years of experience in building ETL processes using tools like SSIS, Azure Synapse Analytics, or Azure Data Factory.
- 1+ years of experience with cloud-hosted databases, preferably in Azure (e.g., Azure Synapse Analytics).
- Strong grasp of ETL principles and best practices for efficient data processing.
- Proficiency in SQL, with the ability to write, debug, and optimize complex queries.
- Familiarity with REST services and other APIs for data integration.
- Exceptional analytical thinking and conceptual problem-solving skills.
- Passion for working with clean, structured, and meaningful data.
- Excellent organizational and time management skills, with attention to detail and the ability to handle multiple tasks.
- Proficient in Microsoft Office Suite for documentation, presentation, and reporting.
- Experience with Power BI or similar reporting tools.
- Knowledge of data warehousing best practices and dimensional modeling.
- Basic understanding of data governance, privacy, and security best practices.
What Would Thrill Us:
- Experience in eCommerce or marketing organizations, working with datasets such as customer, transaction, or product data.
- Hands-on experience with Azure Data Platform technologies, such as Azure Data Lake, Azure CosmosDB, or Azure Fabric.
- Experience with Microsoft Fabric.
- Knowledge of Azure Active Directory (AAD) and Role-Based Access Control (RBAC).
- Familiarity with third-party ETL tools to complement cloud-based solutions.
- Proficiency in scripting languages such as PowerShell or Python.
- Experience in programming with C#.
- Expertise in managing and processing semi-structured data (e.g., JSON, XML).
- Experience with Google Analytics data and working with Google BigQuery.
- Experience with marketing platforms like HubSpot or similar email/campaign systems.
- Experience building data integrations with NetSuite or other financial/accounting systems.
We will consider in-office, hybrid, or fully remote candidates for this role and it does not require regular travel.
What Else You Should Know About Us
We are an organization that loves to play the game of business, and we are unapologetically driven and dedicated to creating world-class educational solutions for our customers. By doing so, we get to help people around the world find comfort and healing.
Candidates must be able to provide proof of eligibility to work in the United States following an offer of employment.
Equal Employment Opportunity
PESI is committed to creating a diverse environment and is proud to be an equal opportunity employer. All employment decisions are based on business needs without regard to race, color, ethnicity, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, veteran status or any other applicable legally protected status. All qualified candidates are encouraged to apply.
Share this job posting with your friends.
https://www.pesi.com/careers/8596/data-engineer