Data Modeler

Cardinal Group Companies • Denver, CO

23d

About The Position

The Data Modeler is responsible for designing, developing, and
implementing data models
that support Cardinal’s 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 Cardinal’s EDW, as well as gather and translate business and
technical requirements.

Requirements

• 3-5 years of relevant data experience.
• Bachelor’s 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 Cardinal’s Core Values every day.
• 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.

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level