Data Engineer

Our client is currently seeking a Data Engineer

This role is hybrid in Bloomington, MN

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 :

• Associate or bachelor’s degree in computer science, software engineering or 5+ years equivalent related IT experience.
• 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.
30+ days ago