GMR Marketing

Returning Candidate?

Lead Business Intelligence Engineer

Lead Business Intelligence Engineer

Job ID 
# of Openings 
Job Locations 
US-WI-New Berlin
Posted Date 
Digital Solutions / IT

More information about this job


As the primary data warehouse and business intelligence architect you will have the opportunity to have a great impact as you continue to build and improve our data warehouse and business intelligence infrastructure.  Working with multiple brands and clients, you will have the exciting challenge of understanding varied data needs and designing and implementing solutions to improve access to information. We are looking for someone with technical aptitude, creativity, strong communication skills, and the flexibility to grow and learn quickly as technology advances. This role will be responsible for ensuring that the data assets of the organization are supported by an architecture that results in the organization achieving its strategic goals. 



Analysis, design and creation of additional data warehouse infrastructure
Develop star-schema structures and ETL for new data warehouse initiatives
Support and maintenance of data warehouse, including ETL functions and data integration
Design SSAS cubes
Design database applications, such as interfaces, data transfer mechanisms, global temporary tables, data partitions, and function-based indexes to enable efficient access of the generic database structure
Design databases to support business applications, ensuring system scalability, security, performance and reliability
Develop data models for applications, metadata tables, views or related database structures
Develop load-balancing processes to eliminate down time for backup processes
Develop or maintain archived procedures, procedural codes, or queries for applications
Develop and document database architectures
Develop database architectural strategies at the modeling, design and implementation stages to address business requirements
Gather reporting and analysis requirements and translate into reporting structure data models
Conceptualizing complex requirements and translating them into a functional data model
Provide day-to-day support and mentoring to users who are interacting with the data


3+ years of experience in a dedicated data warehouse or business intelligence development role
A Bachelor’s degree in Computer Science or equivalent experience
Strong communication skills
Strong time management skills and the ability to work under and meet deadlines
A strong work ethic and customer service orientation

Preferred Knowledge, Skills and Abilities
Experience working with reporting and BI tools such as Tableau
Experience merging disparate data sources
Exposure to dealing with unstructured or semi-structured data


Connect With Us!

If you don’t see an opening that fits your unique career needs, be sure to connect with us! In doing so, you’ll be able to opt into the specific areas of interest and receive periodic updates on open positions and GMR Marketing news.