Cardinal is looking to solve its end-to-end BI and Analytics ecosystem problems by designing, developing, and implementing BI solutions
Requirements
- Intermediate proficiency in SQL development, including table definitions, procedure, function development, and view definitions
- Demonstrated experience applying database modeling patterns (First, Second, and Third Normal Form, Dimensional Modeling, or Data Vault)
- Experience in public cloud environments, such as Amazon Web Services, Google Cloud Platform, or Microsoft Azure
- Proficiency with open-source database management systems such as PostgreSQL
- Expertise in designing and implementing ETL/ELT solutions
- Intermediate-level experience in SQL Development and all aspects of SDLC with Source Code Control, GitHub, and Code Reviews
- Proven ability to develop, debug, and optimize complex SQL queries, Stored Procedures, and Functions, particularly in cloud data warehouses, such as BigQuery, Snowflake, or Redshift
Responsibilities
- Design, build, and optimize technical solutions that meet business needs by delivering data in an efficient, scalable, and durable manner within Cardinal’s EDW
- Lead data modeling efforts through requirements gathering, process documentation, and data discovery efforts
- Design and implement advanced data models in SQL, including table definitions, complex procedure builds, advanced function development, and optimized view definitions
- Perform and present complex ad-hoc analyses of relevant business processes
- Provide front-end support in our Business Intelligence tool, including dashboard maintenance, managing ETL data flows, and occasionally designing and building new reports
- Proactively diagnose, debug, and resolve inaccuracies and inconsistencies within deployed database objects
- Establish, document, and champion standard operating procedures and warehousing standards
Other
- 3-5 years of relevant data experience
- Bachelor’s Degree in relevant areas of study or equivalent professional experience
- Strong project management skills with the ability to manage daily tasks against established priorities to meet commitments
- Strong attention to detail in ensuring data quality
- Excellent communication (oral and written) and interpersonal skills required to interact with colleagues, clients, and senior leadership
