Sr. Data Warehouse Architect (Remote in US)

Company Description

Resultant is a modern consulting firm with a radically different approach to solving problems.

We don’t solve problems for our clients. We solve problems with them.

Through outcomes driven by data analytics, technology solutions, digital transformation, and beyond, our team works with clients in both the public and private sectors to solve their most complex challenges. We start by learning as much as we can about who they are, how they work, and what they’re striving for so we can feel their problems as our own. Partnering with our clients means their desired outcomes are always top of mind, their challenges and strengths guiding our efforts. We build client-focused relationships before we build unique solutions that blaze past expectations.

Originally founded in Indianapolis in 2008, Resultant now employs more than 400 team members who operate from offices around the United States including Indianapolis and Fort Wayne, Indiana; Columbus, Ohio; Lansing, Michigan; Denver, Colorado; Dallas, Texas and Atlanta, Georgia.

We’re Resultant. Clients partner with us to see a difference. People join us to make one.

Job Description

Resultant is seeking team members to join our consulting group to work with clients and deliver data solutions of all kinds. Particularly, we are seeking architects and consultants with experience delivering data warehouse solutions who desire to participate in all aspects of the project (planning, requirements, architecture, design, development, testing, and deployment) while using modern tools and technologies.
 

Your day-to-day responsibilities in this role:

• Consult with clients to identify, assess, and solve complex business problems.
• Own and drive complex technical solutions to enable our clients to maximize the value of their data.
• Use best of breed modern data warehouse tools across traditional data warehouses and modern big data solutions. Key tools and platforms:
  • WhereScape (preference will be given to candidates with WhereScape experience)
  • Snowflake
  • AWS
  • Azure
  • Other Cloud ETL tools (Matilion, FiveTran, Informatica, etc.)
• Participate in integrated projects that include modern BI solutions such as Tableau, PowerBI, and Alteryx.
• Continuously learn about data analytics business and technology trends, and effectively communicating/sharing information with colleagues.
• Mentor technical employees and contributing to their individual development and lead performance management processes for technical delivery teams.

Qualifications

We are seeking individuals with the following experience:

• Minimum 10 years of recent, progressive experience and demonstrable technical expertise in enterprise-class data analytics solutions and services. Including advanced skills in areas such as Data Modeling, Integration, Storage, Indexing, Security, Logging, Data Quality, Master Data Management and Archiving.
• Minimum 2 years architect and hand on experience with modern data analytics solutions (Snowflake, RedShift, AzureDW, Hadoop, cloud data lake strategies, etc.)
• Minimum 2 years of recent, progressive experience in technical consulting leadership roles
• Minimum 2 years of recent leadership experience in enterprise-class data analytics architecture, including enterprise and solution architecture assessment/definition, and significant depth in two or more data analytics solution architecture components (i.e., data management, data integration, information delivery, and/or advanced analytics)
• Experience with Architecture and applications on or incorporating cloud infrastructure-, platform-, and/or software as a service (particularly data analytic solutions on Amazon AWS, Microsoft Azure, or other cloud platforms and service providers)
• Experience in core business system (e.g. customer, call center, billing, etc.) transformation programs, with a focus on related changes in data analytics architecture, engineering, and business capabilities
• B.S. in Computer Science or equivalent degree or 5-7 years of professional work experience is required.

 Technical Skills:

• Required
  • Strong database skills
  • Strong Data Modeling skills (dimensional modeling, data vault, 3NF, etc.)
  • Strong ETL Architecture and Tool Skills (Informatica, DataStage, SSIS)
• Preferred
  • Cloud Architecture skills
  • BI Tool experience (Tableau, PowerBI, Looker)
• Bonus
  • WhereScape RED and 3D experience
  • Snowflake experience

Additional Information

What you should know about us: 

• We are humble,