Data Warehouse Architect in Charlotte, North Carolina at AccruePartners

Date Posted: 9/8/2020

Job Snapshot

Job Description

WHO OUR CLIENT IS:

  • Privately-held manufacturing and sales and service organization experiencing high growth
  • Financially healthy, solid company and very well established
  • Locations throughout the Southeast US
  • Highly diversified divisions
  • Top notch leadership and vision with outstanding reputation in Charlotte and in their industry

WHY YOU SHOULD CONSIDER THIS OPPORTUNITY:

  • Complete ownership of technical direction and solution strategy 
  • Partner to the Head of BI and Advanced Analytics 
  • An Executive Leadership team that advocates, supports and backs their desire to build out an advanced analytics environment as the company's main initiative. 
  • Opportunity to really build from the ground up, grow as the company grows and see your vision come to fruition 
  • Professional development as it aligns to your personal career goals and expectations for yourself personally
  • Friendly place to work, as evidenced by the number of long-term employees
  • From the CEO down, everyone is on a first-name basis
  • Dress is business casual and there is genuine respect for employees at every level
  • Various company functions and family events
  • Company leadership works hard to ensure two-way communications via an open-door policy, newsletters, lunchbox meetings, open forums, and more

WHAT YOU WILL DO:

  • Lead the architecture and development of ETL / data pipelines which bring source system data into a cloud environment for use in business intelligence applications or analytics development and deployment.
  • Lead the design and development of data architecture for the BI & Analytics ecosystem, and through expert knowledge translate high-level business requirements into data models and appropriate metadata, test data, and data quality standards
  • Lead the process to deploy content through standard BI tools or custom data services.
  • Work as part of the program management team on large programs, governing and shaping the delivery of data integration / ETL components of the projects. Work closely with external suppliers to ensure solution makes best use of technology and meets requirements
  • Simplify the existing data architecture, delivering reusable services and cost saving opportunities in line with the policies and standards of the group
  • Ensure that all solutions are complete, operable, conform to business processes, and meet the business needs with the agreed quality of service
  • Responsible throughout the entire project life-cycle for the end-to-end compliance with enterprise data model and logical data groups
  • Provide mentoring and coaching for data developers and ETL analysts engaged on initiatives
  • Ensure the end-to-end solution is fit for purpose, meet the needs of business, the agreed requirements, and are both pragmatic and supportive of the strategic architecture direction
  • Lead and participate in the peer review and quality assurance of project architectural artifacts.
  • Participate from time to time in the supplier selection process, evaluating usefulness and cost of products and making appropriate recommendations
  • Drive project knowledge back to the enterprise data model and ensure that it evolves correctly
  • Develop conceptual, logical and physical data models to support data analysis and business intelligence
  • Create and maintain current- and target-state data architectures
  • Ensure technology solutions are in alignment with data architecture principles and target state
  • Oversee end-to-end data life cycle management activities
  • Evaluate and recommend emerging technologies for data management, storage and analytics

HOW YOU ARE QUALIFIED:

  • Bachelor’s degree with an emphasis on technical, analytical, and problem solving skills.
  • 8+ years in the information technology field, with architectural background and experience
  • 5+ years as a DBA, Data Systems Analyst or Business Intelligence Developer
  • Experience working in or developing a DataOps culture; familiar with automated testing systems, continuous integration / continuous delivery approaches and building data quality into data pipelines
  • Strong experience in data warehousing, data modeling and/or data analysis
  • Proven experience with entity relationship modeling, metadata systems, data quality tools and techniques
  • Ability to relate architectural decisions and recommendations to business needs
  • Experience with cloud-based database technologies (e.g., Snowflake, AWS, SQL, Hadoop)
  • Experience with enterprise ETL tools (e.g. Talend, Informatica)
  • Experience with enterprise business intelligence tools (e.g. Microstrategy, Tableau, Power BI)
  • Ability to regularly learn and adopt new technology
  • Experience developing reference architecture, principles and standards
  • Strong analytical and problem-solving skills
  • Ability to communicate across all levels of the organization and work with diverse project teams