Description

Responsibilities:

  • Coordinate and work with other technical staff to develop database architectures, coding standards, and quality assurance policies and procedures.
  • Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective availability, protection, and integrity of data assets.
  • Plan and implement capacity and resource expansion to ensure data warehouse scalability.
  • Conduct research and make recommendations on data warehouse products, services, protocols, and standards in support of procurement and development efforts.
  • Build relationships with development and infrastructure teams to gain an understanding of data architectures and required functionality.
  • Build relationships with vendors of application software deployed in the organization’s IT environment to learn about and provide feedback on their technical integration capabilities.
  • Evaluate, recommend, and select data warehouse components, including hardware, database management systems, ETL (extract, transform, load) software, data mining tools, and meta data management tools.
  • Orchestrate business intelligence projects and corresponding strategies between business units and development teams.
  • Plan and execute phases of the software development life cycle (SDLC) for a variety of data warehouse projects and business intelligence support activities.
  • In conjunction with Business Systems Analysts, is responsible for data communication with various stakeholders.
  • Facilitate the preparation and documentation of software requirements, functional and technical design specifications.
  • Design, code, test, and document all new or modified BI systems, data pipelines, applications, and programs.
  • Develop the semantic layer, metadata, reports, and report definitions.
  • Produce ETL design guidelines to ensure a manageable ETL infrastructure for the BI system.
  • Identify inefficiencies and gaps in current data warehouses and leverage solutions to ensure data standards.
  • Diagnose and resolve data warehouse access and performance issues.

 

Qualifications:

  • 5+ years working technical experience with designing, building, installing, configuring, and supporting multi-terabyte data warehouses.
  • 3+ years’ experience with database and cloud platforms, SQL Server, SSIS and Azure preferred.
  • 3+ years’ experience with data architecting, data mining, large-scale data modeling, and business requirements gathering/analysis.
  • 3+ years utilizing in-house data-intensive applications for end user reporting and analytics, SSRS, PowerBI, Azure Data Studio and Factory preferred.
  • Familiarity with D365 Financial and Operations, Customer Experience data models
  • Strong understanding of relational database structures, theories, principles, and practices.
  • Experience with data processing flowcharting techniques.
  • Proven project management experience.
  • Good knowledge of applicable data privacy practices and laws.
  • Office type environment, using computer, telephone, other office equipment as needed to perform duties.
  • This position requires the ability to sit for long periods of time, and to work in a fast-paced environment.
  • Position is primarily remote, with the occasional need to come to the office (Bloomington, MN).
  • Position may require some limited travel (locally and throughout United States); Less than 5% annually.


 

Education

Any Graduate