Data Warehouse Architect Job at Better Hire in Birmingham

BUSINESS INTELLIGENCE DATA WAREHOUSE DEVELOPER

JOB DESCRIPTION

This role will design, implement, and maintain data warehouses for Alden’s custom-developed software.

Responsibilities include:

• Work with the product and customer teams to create data warehouses that enable data-driven business decisions. Includes data aggregation and OLAP cubes

• Assist/Train internal and external personnel who build Power BI dashboards, in accessing and understanding the available data.

• Work with product and marketing teams to evolve company offerings that make use of the data.

• Analyze data for patterns, trends, knowledge for actionable insights.

• Work with internal teams to create data warehouses for company data.

• Ability to drive discussions with senior personnel regarding trade-offs, best practices, project management and risk mitigation.

Current hands-on implementation experience required:

• Data warehouse architecture and design – including the Kimball method
• Row-level Security and a multi-tenant system.
• SQL and SSIS
• Azure Datawarehouse and SQL OLAP Services
• Azure Data Factory
• Power BI Services

SUMMARY

The focus of this specialized, technically oriented position is on meeting and exceeding high standards of accuracy and quality based on established systems, technologies and guidelines. Strength in technical problem solving based on expertise and experience, and a strong commitment to efficiently achieve high-quality results is required. A thoughtful, persevering, self-disciplined approach to achieving accurate, detailed work is essential. Job responsibilities and expectations are clearly defined, as is the scope of job authority. Expertise and competence is developed through a systematic technical training program, as well as ongoing exposure to and training in new technical systems once they have been adopted and well tested. A key aspect of the job includes the ongoing identification of technical problems and the development of sound, carefully thought-out solutions. Problem-solving is focused on proven systems and technologies and established organizational relationships. Solutions should minimize risk to the organization and utilize existing resources. Because of the expertise developed in this position, it is necessary to regularly initiate and communicate viewpoints on problems and opportunities in a factual, straightforward manner. This job allows for autonomy and independence and is primarily self-reliant. If the job involves managing others, there is a need for someone who will exercise the necessary authority in assuring that subordinates meet or exceed the same technical standards of quality and accuracy. Delegation must be firm, clear and focused on the specific tasks and technical activities of the job. Because of the fast-paced job environment, decisions must be made quickly and firmly, within the defined scope of job authority and based on job expertise. In general, this is a valued expert expected to deliver high quality, accurate results, while efficiently maintaining and enhancing existing

organizational systems and standards.

JOB CHARACTERISTICS

• Varied activities Multiple, simultaneous projects and tasks Continual problem/solution identification Fastpaced environment

• Technical/analytical focus Work within established systems, standards, and procedures Communication based on job knowledge and expertise

• Authoritative, quick decision making within defined span of control Focused on established systems and technologies Fact-based, solution oriented Minimal risk taking

• Focused on job knowledge and expertise Must provide clear, direct, authoritative direction to others Need for collaboration is minimal, when necessary it is task focused, and this person’s role is to provide primarily technical, analytical skills to the team

• Leadership focused on efficient, accurate, quality work output Requires a strong, authoritative leadership style Job requires close control of process, tasks, and results Delegated tasks must be closely measured and monitored