Data Modeler

POSITION TITLE: Data Modeler

COMPENSATION: Exempt / Salaried

DIRECT REPORT: Business Intelligence Cloud Architect Data & Analytics

SUMMARY: The Data Modeler is responsible for designing developing and implementing data models that support Cardinals end-to-end Data and Analytics ecosystem. The Data Modeler will partner with the Architect and key business stakeholders to design implement and optimize data models and reporting structures within Cardinals EDW as well as gather and translate business and technical requirements.

RESPONSIBILITIES (Included but not limited to)

1. Design build and optimize technical solutions that meet business needs by delivering data in an efficient scalable and durable manner within Cardinals EDW.
2. Participate in data modeling efforts through requirements gathering process documentation and data discovery efforts.
3. Design and implement advanced data models in SQL including:
1. Table definitions
2. Complex procedure builds
3. Advanced function development
4. Optimized view definitions
4. Perform and present complex ad-hoc analyses of relevant business processes.
5. Provide front-end support in our analytics and reporting tools by creating and maintaining transformations/data flows.
6. Proactively diagnose debug and resolve inaccuracies and inconsistencies within deployed database objects.
7. Optimize and monitor daily database operations including diagnosing and resolving inefficiencies and instabilities.
8. Enforce and improve a governed data environment through the application of warehousing standards best practices and established conventions as defined with the BI Architect.
9. Serve as a key technical liaison to business stakeholders managing support needs and translating feature requests into technical solutions.

QUALIFICATIONS

• 3-5 years of relevant data experience.
• Bachelors Degree in relevant areas of study or equivalent professional experience.
• Advanced-level proficiency in SQL development including table definitions procedure function development and view definitions.
• Demonstrated experience applying database modeling patterns specifically in a dimensional data warehouse.
• 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.
• 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.
• Strong commitment to continuous learning and skill building.
• Excellent communication (oral and written) and interpersonal skills required to interact with colleagues clients and senior leadership.
• Ability to develop productive business relationships with internal team members through cooperation courtesy and professionalism.
• Excellent at troubleshooting complex issues.
• Ability to embody the Cardinal Culture and Cardinals Core Values every day.

TECHNICAL EXPERIENCE

• Advanced-level experience in SQL Development.
• 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.
• Proficiency in relational database engines such as PostgreSQL or SQL Server.

WORK ENVIRONMENT

The work environment characteristics described here are representative of those a Team Member encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Incumbents work in an office environment. This role routinely uses standard office equipment such as computers phones photocopiers filing cabinets and fax machines.

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job the Team Member is regularly required to use hands to finger type handle or feel and talk or hear. The Team Member is frequently required to stand; walk; reach with hands and arms and stoop or squat. The Team Member is often required to sit. The Team Member must be able to push pull lift carry or maneuver office products and supplies of up to twenty (20) pounds. Specific vision abilities required by this job include close vision distance vision color vision peripheral vision depth perception and ability to adjust focus.

The above job description is not intended to be an all-inclusive list of duties and standards of the position. Incumbents will follow any other instructions and perform any other related duties as assigned by their Team Leader.