Overview
The Data Engineer will assist in building, managing, and optimizing data pipelines, ensuring the smooth and secure movement of data across multiple platforms. You will work closely with data scientists, analysts, and senior engineers to help manage data infrastructure and support data-driven decision-making for OnPoint’s data program. This includes migrating from an on-prem data warehouse to Azure and modernizing analytics capabilities using Power BI and Databricks.
Responsibilities
- Translate business stakeholder data requirements into actionable visualizations using Power BI, ensuring clarity, accuracy, and alignment with business goals for effective decision-making.
- Supports project teams and operations in extraction, transformation and loading of data into Power BI reporting solutions
- Drive requirements, scope, and technical design of the integration workflows, to make sure the build is conducted accurately and according to spec. Develop and maintain requirements, design documentation and test plans.
- Seek out, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability.
- Build the infrastructure required for optimal ETL/ELT pipelines to ingest data from a wide variety of data sources using Microsoft Azure technologies such as Azure Data Factory, Databricks, and SSIS.
- Develop Power BI datasets to support integration projects. Set up and maintain BI tools, infrastructure, and integration with company data sources.
- Troubleshoot issues helping to drive root-cause analysis, and work with infrastructure teams to resolve incidents and arrive to a permanent resolution.
- Creating and maintaining the Data Platform analytics technical components. This includes relational data modelling, star schemas, reporting views and ETL batch feeds
Knowledge Skills & Abilities
- Prior responsibility for application delivery, as well as successful service level agreement accomplishments in a regulated environment. Experience with Azure, DNA Core, Azure Pipelines, Azure Data Factory, Databricks are a plus.
- Strong interpersonal, written, and oral communication skills, including the ability to present ideas in a user-friendly language.
- Deeply ingrained customer service orientation.
- Ability to prioritize and execute tasks in a high-pressure environment and make sound decisions in emergency situations.
- Proven analytical and problem-solving abilities, with keen attention to detail.
- Knowledge of Medallion Architecture principles for building robust, scalable data solutions in cloud environments, including bronze, silver, and gold layer data management.
- Experience with data replication technologies, such as Fivetran/HVR, database mirroring, and transactional replication, with experience in ensuring seamless data synchronization across environments and maintaining data consistency in real-time.
Qualifications
- Bachelor’s degree in Computer Science or a related field or equivalent work experience required
- Experience in design and implementation of data warehouse architecture
- Experience or internship in data engineering
- Knowledge of Microsoft Power BI or exposure to data visualization tools and practices.
At OnPoint, we believe a workplace that reflects the richness of the world fosters a welcoming and empowering environment for everyone. We're committed to equity and inclusion, and consider all qualified applicants embracing every race, religion, color, sex, national origin, age, sexual orientation, gender identity, disability or veteran status, and your unique background.
We encourage you to apply if you're passionate about this opportunity and have the core qualifications. Your unique experiences and skills are what make you a strong candidate. Don’t let imposter syndrome hold you back! Our recruitment process is designed to be inclusive and accessible to all. If you need any accommodations during the application or interview stage, please let us know. We're dedicated to providing what's necessary to ensure a fair and inclusive experience.
