Cardinal Group Companies · 3 weeks ago
Business Intelligence Developer II
Denver, CO
Full-time
Onsite
Mid Level
$95K/yr - $105K/yr
3+ years expCardinal Group Companies is seeking a Business Intelligence Developer II who will be responsible for designing, developing, and implementing BI solutions that support the company's analytics ecosystem. The role involves partnering with the BI Architect and stakeholders to optimize data models and reporting structures.
LeasingProperty ManagementReal EstateReal Estate Investment
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, 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
Own and maintain data dictionaries and metadata repositories
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
Mentor Junior Developers through code reviews, technical guidance, and best-practice enforcement
Qualification
Required
3-5 years of relevant data experience
Bachelor's Degree in relevant areas of study or equivalent professional experience
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
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 continue to learn, build skills, and mentor others
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
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
Proficiency in relational database engines, such as PostgreSQL or SQL Server
Proficient experience building and maintaining data visualizations and data models in Business Intelligence Tools, such as Domo, Tableau, or Looker
Experience with modern data lake architectures and technologies, such as Delta Lake or Apache Iceberg
Proficient with data structures such as JSON, Parquet, CSV, etc
Benefits
Health, vision, dental, and pet insurance
401(k) retirement plan
Student loan assistance
Licensing and continuing education reimbursement
Parental leave
Housing allowances or gifts
Company
Cardinal Group Companies
The strength of Cardinal is rooted in our identity.
1001-5000 employees
H1B Sponsorship
Cardinal Group Companies has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2022 (1)
Funding
Current Stage
Late StageLeadership Team
Gabriella Azmoudeh, PHR
Associate HR Business Partner
John O'Brien
Chief Administrative Officer (CAO)
Recent News
2026-01-06
Company data provided by crunchbase