Data Warehouse / Information Architect Seattle, WA - (Contract/Remote)
Why clients choose Pivotal Consulting: We are a technology management consulting firm helping Fortune 500 companies improve their performance – we specialize in making People, Process, and Technology work together! Our clients count on us to deliver excellence and seek our guidance on business and technology strategy, technology modernization, and cloud transformation initiatives. Simply put, by listening to our clients closely and focusing on delivering quality, we bring them peace of mind.
After guiding and helping numerous clients from global enterprises to mid-market firms to non-profit organizations – all of them repeat customers – we are starting 2021 with breakthrough growth!
The impact you will have: As a relationship driven and customer focused professional, you will help us continue providing our clients with the quality of work that they have come to know us by.
Our Data Warehouse / Information Architects are responsible for designing and maintaining enterprise data management solutions for our client.
What you will do:
Analyzing data needs, where data currently resides, how data is interconnected, how data flows and comes together.
Define and design a new data architecture framework and recommend options.
Build out a scalable data maturity model and a roadmap to accelerate data journey.
Develop a Data Warehouse architecture, including all stages of data movement (including the 3rd normal form atomic layer and the dimensional models with conformed dimensions).
Work with SQL scripts or ETL tools such as SSIS, Informatica Data Stage, etc.
What makes you a good fit:
Significant experience in enterprise solutions and enterprise data and information architecture.
Data warehouse, BI, and database engineering experience (SQL Server or other RDMS such as Oracle or DB2).
Demonstrated ETL and SQL skills and ability to write SQL as required for purposes of analyzing data and/or evaluating how information needs might be translated into database structures.
Data and information management skills.
Exceptional verbal and written communication skills.
Ability to explain complicated concepts in simple terms.
Excellent attention to detail.
Why our employees love working here: We believe our strength comes from our differences, and as a Certified Minority-Owned Business (MBE) and a majority women-led firm, we are committed to fostering and promoting a culture of diversity and inclusion. We believe our team and our community are our greatest assets and we strive to promote both daily.
From providing our employees the time to pursue company-sponsored certifications, to supporting and partnering with multiple non-profit organizations brought forth by our employees (such as Food Lifeline, United Way, and the Seattle Humane Society), we are proud to support both our fellow Pivotalites and the causes close to their hearts.
As we grow, we are anchored and driven byour Four Core Values:
Be Engaged – We are present, committed, and accountable to our clients and to each other
Consistently Deliver – We are dedicated and reliable by consistently delivering excellence
Always Better – We continuously evolve, inspired to drive beyond the everyday norm
Do Happy – Be passionate and bring fun and creativity into everything you do
Inclusion & Equal opportunity employment: We are an equal opportunity employer committed to Diversity, Inclusion & Belonging. Individuals seeking employment at Pivotal Consulting are considered without regard to any protected category including but not limited to, race, color, religion, national origin, age, sex, marital status, ancestry, disability, veteran status, gender identity or sexual orientation.