About Core Education
Core Education is a dynamic organization dedicated to transforming the business model of higher education through in
innovative programs and partnerships. We work collaboratively with colleges and universities to enhance learning experiences, promote student success, and drive positive outcomes.
About the role
We are looking for a talented and experienced Software Engineer with a focus on Database, API, and BI Development, who possesses a strong background in back-end database querying and data integration. The ideal candidate will have a proven ability to create and manage data lakes using APIs, be proficient in SSIS, and have a deep understanding of ETL tools for building data warehouses from various data sources. Experience with CRM platform integration is highly desirable.
What you'll do
- BI Development:
- Design, develop, and maintain comprehensive reports and dashboards using Power BI and other BI tools.
- Collaborate with business stakeholders to gather and understand reporting requirements.
- Ensure effective data visualization and delivery of insights to drive business decisions.
- Back-End Database Querying:
- Write and optimize complex SQL queries for data extraction, transformation, and loading.
- Troubleshoot and enhance database performance.
- Work with multiple database systems for efficient data retrieval and manipulation.
- SSIS Integration:
- Develop, deploy, and maintain SSIS packages for seamless data integration and transformation.
- Ensure reliable and secure data flow between various systems using SSIS.
- ETL Development:
- Utilize a range of ETL tools to extract, transform, and load data from multiple data sources.
- Implement scalable and efficient ETL processes to support data integration and warehousing.
- Data Warehouse Creation:
- Design and build data warehouses from diverse data sources.
- Maintain data integrity and consistency within data warehouse structures.
- CRM Platform Integration:
- Develop solutions that integrate various CRM platforms with data systems, ensuring smooth data flow and synchronization.
- Collaborate with stakeholders to design workflows and processes that enhance CRM data utilization and reporting.
- Scripting and Automation:
- Proficiency in scripting languages such as PowerShell, TypeScript, and/or Python.
- Experience in developing automation scripts to streamline data processes.
- Familiarity with Linux-based server administration via command line
- Familiarity with containerization technology, particularly Docker
- Ability to collaborate effectively with cross-functional teams to integrate scripting solutions into the data infrastructure.
Qualifications
- 5+ years of relevant experience in BI development, database management, API integration, and CRM platform integration.
- Strong proficiency in writing and optimizing SQL queries with relational databases.
- Proven experience in creating and maintaining data lakes using APIs.
- Expertise in SSIS for data transformation and integration.
- Familiarity with various ETL tools and best practices for data processing.
- Demonstrated ability to design and manage data warehouses efficiently.
- Experience in integrating and managing data within CRM platforms.
- Strong problem-solving and data troubleshooting skills.
Education:
- Bachelor's degree in computer science, Information Technology, or a related field.
What We Offer:
- An opportunity to work on impactful data solutions and contribute to strategic data-driven initiatives.
- A collaborative and dynamic work environment with opportunities for professional growth and development.
If you are passionate about leveraging data to support decision-making and are eager to contribute your expertise in database, API, BI development, and CRM platform integration, we encourage you to apply for this exciting role.