Home > Minneapolis / St. Paul jobs > Minneapolis / St. Paul computer/technical

Posted: Monday, January 15, 2018 11:37 PM

Job Description:/h3:
Position Overview:
We are looking for an experienced Sr Data Warehouse Modeler and Developer to join our Enterprise Business Intelligence (EBI) team within the Global Technology Services (GTS) organization at Proto Labs. This position will play a key role working hands:on with team on the Companys exciting Business Systems and BI Re:engineering initiatives. Together, we look forward to advancing tomorrows modern Data Warehousing and BI solutions to meet the Companys growing and dynamic business needs.

Specific Duties:
As a Sr BI Data Warehouse Modeler and Developer, you will work on the following:
:Develop a strong understanding of Companys existing and projected data organizational structures and usage requirements
:Partner closely with business stakeholders, business analysts, end users and developers to refine business and data capability requirements
:Lead efforts to map requirements into extensible data warehousing structures using conceptual, logical, and physical data models with robust methodologies for data integration
:Provide hands:on technical development of new data warehousing solutions.
:Implement Extract, Transform, Load (ETL) processes integrating data from a variety of transactional data sources into staging, relational and dimensional databases and data cubes using MS SQL Server 2012/2016 SSIS/SSAS and related tools
:Optimize data management processes involving large complex data sets, multi:dimensional and tabular analysis cubes in support of user:exploratory
analyses/reportings in Excel, Power Pivot, Power BI, SSRS reports and more
:Lead data development and change management on the data warehouse, ensuring overall integrity of data models and configurations
:Develop appropriate logs, monitoring methods, and audits to ensure high availability, quality, security, scalability and performance of solutions
:Collaborate closely with concerned parties to ensure timely resolution of data issues
:Maintain accurate documentation of work, including data models, data dictionaries and other artifacts in currency with corporate standards, data governance and architectures
:Recommend technical resources and best practices on BI and enterprise data management.

Minimum Qualifications:
Effective communicator with excellent analytical and problem solving skills
9+ years of direct development and administrative experience with data warehouses
Proven skills in developing robust, extensible, scalable Data Warehousing relational and dimensional data models
Solid understanding of ETL and Data Integration methodologies
Solid development experience with erwin EA, MS SQL Server 2012/2014/2016, SQL Server Agent, T:SQL, SSIS, SSAS
Experience with
developing/optimizing complex queries and interpreting execution plans
Experience with SSAS DAX scripting for tabular data cube management
Experience with preparing and publishing Meta Data and Data Dictionaries in support of Corporate Data Governance
Understanding of solution delivery methods via Modern BI Tools including Power BI, SSRS, Power Pivot, Excel automations

Desired Qualifications:
Understanding or experience with:
MS Dynamics AX 2012 R3 ERP data models, particularly on order:to:cash processes
Distributed communication protocols (e.g. HTTP, JSON, XML, SOAP, REST or related web services and messaging formats)
MS SQL Server, PostgreSQL, Azure Cloud SQL Database services
Various data warehousing approaches (e.g.
OLTP/OLAP/NoSQL/Big Data/Hadoop)
Various data integration methods across mixes of transactional, distributed, on:premise, cloud:based, structured and unstructured data sources
Agile development methodologies (Kanban/Scrum/...)
Power Shell and shell scripting, R, Python, JavaScript, HTML, .NET programming

Other qualifications important to this position:
Ability to mentor and participate in code and design reviews with software team members


• Location: maple plain, Minneapolis / St. paul

• Post ID: 28623047 minneapolis is an interactive computer service that enables access by multiple users and should not be treated as the publisher or speaker of any information provided by another information content provider. © 2018