What are the responsibilities and job description for the BI Database Developer position at Cypress HCM?
BI Developer
- Primary focus is on data infrastructure and development. Less on creating reports, and more on building & supporting the systems we implement for reporting.
- Strong SQL and SSIS/ETL skills. This should be considered the foundation of a candidate’s skillset, with solid BI skills being built upon that.
- Experience designing, developing, and optimizing data pipelines and analytics solutions using Azure Databricks. Ability to leverage Databricks for big data processing, advanced analytics, and integration with other Azure data services.
- Experience in designing, orchestrating, and managing data pipelines using Azure Data Factory. Ability to integrate ADF with other Azure services, automate ETL processes, and optimize data workflows for scalability and reliability.
- Background in database, data warehouse, and data model design, including examples of their successful implementations. This is critical.
- Strong integration skills. Able to conceptualize how disparate data from different sources would be able to be programmatically merged or appended, and the ability to choose the right place & the right tool to put that vision into practice.
- Needs to be able to identify areas to implement data quality, integrity, and consistency throughout the design process of new solutions and during observation of existing solutions.
- Good understanding and the ability to communicate data warehousing concepts and database management.
- Strong reconciliation skills. The ability to analyze data and datasets from different sources to find discrepancies or provide verification.
- Takes open-ended approaches to optimization, troubleshooting, and performance.
- Consideration of potential points of error or opportunities for future-proofing the product throughout the development process.
- Ability to fail early and try new approaches by switching gears and tackling a problem from different approach.
- Able to determine the goal of a solution prior to implementation. Once a goal is determined, should provide an outline of a solution. Once solution is outlined, should be able to coordinate its goal from start to finish to delivery.
- Can ensure data is accessible, reliable, and efficiently processed for other developers & analysts, and for downstream customers.
- Languages
- SQL
- DAX
- M/Power Query
- Python (within Databricks)
- Programs
- SSMS
- Power BI Desktop
- SSIS
- DAX Studio
- Report Builder
- Azure Data Factory
- Azure Databricks
- GIT