BoulderRecruiter Since 2001
the smart solution for Boulder jobs

Engineer

Company: Flexential
Location: Boulder
Posted on: May 3, 2021

Job Description:

Job Description:

General Description

The Data Warehouse Engineer will work closely with the Data Services team and with the direction of the Enterprise Data Architect to support and enable client success by promoting clear dialog and common understanding through secure, optimized, and trusted data products. The Data Warehouse Engineer will be responsible for the creation & ongoing maintenance of custom data warehousing, reporting, and data-delivery solutions to support strategic and analytical data uses as well as supporting system integration needs that rely on data manipulation to make analysis and visualization possible. The Data Warehouse Engineer will also be responsible for working directly with business teams and internal customers to analyze & understand business needs in support of the Enterprise Data Strategy. Database and Data Warehousing solutions will need to be capable of tracking histories efficiently, handling complex data structures, and medium to high data volumes. These solutions will also need to integrate with and consume data provided by custom ETL's. The Data Warehouse Engineer will also provide subject matter expertise pertaining to data structure, storage and analysis paradigms, and related solution designs to the Enterprise Data Architect in support of overall data strategy development & execution.

Key Responsibilities and Essential Job Functions

+ Administer, maintain, document, deploy & grow the EDW SQL codebase, schema structure, and data driven processes within the guidelines provided by ITIL & Agile methodologies

+ Work as a collaborative component of an Agile-driven team

+ Maintain code base in GIT

+ Leverage ITIL best practices for service management

+ Collaborate with the Enterprise Data Architect to create secure, scalable, reliable, auditable data processing, aggregation and reporting preparations within the EDW for consumption by downstream processes, visualization tools, and analysts in the data community at Flexential

+ As directed by the Enterprise Data Architect, work directly with business project owners to determine and help create business requirements for data projects by providing technically focused consultative support

+ Collaborate with Enterprise Data Architect & Data Services Team to:

+ design data aggregation logical flows

+ select & craft database structure and relationships within the EDW

+ document code bases

+ Collaborate with Data Integration Architect to maintain and create transformation logic and data pipelines

+ Independently author T-SQL based stored procedures, queries, aggregations and other logical operations to deliver consistently accurate data

+ Create and maintain process and code documentation for existing and new solutions in the EDW and related database spaces

Required Qualifications

+ 5+ years of experience:

+ Creating custom SQL driven database / data warehouse solutions

+ Collaborating with technical counterparts to deliver cross functional solutions

+ Intimately familiar with database development within the Microsoft SQL Server toolset including T-SQL, complex SQL with subqueries, triggers, temp table management, mathematical and aggregate functions as well as ability to leverage cursors, embedded code, and knowledge of query tuning to improve work quality

+ Capable of performing business analysis tasks to meet highly technical needs that business functions may not be fully capable of expressing

+ For example, decoding the data architecture within a net new platform to the organization to allow for analysis of key data and enable organization-wide usage of data that would otherwise be unavailable outside of the source system

+ Capable of independently:

+ Coordinating complex project work across multiple teams to effectively craft data-centric solutions

+ Discuss impacts of technical decisions with the Enterprise Data Architect to ensure sound data strategy

+ Building fully scalable solutions that do more than just 'work' but are robust, traceable, optimized and follow ITIL recommendations

+ Trouble shooting and remedying various technical failures or performance maladies related to internal data operations (SPROC's Joins, and general trouble shooting and data tracing)

+ Expertise in:

+ T-SQL

+ Microsoft SQL Server

+ Kimball-style Data Warehousing

+ RDBMS Normal Forms and Database Theory

+ Experienced in SQL Development, Data Warehouse design, Business Analytics, and subject matter expertise that supports scalability and traceability

Preferred Qualifications (Not Required)

+ Experience with Red Gate

+ Python development for data manipulation & analysis

+ Experience with GIT

+ Experience with AWS data systems / Object Storage

+ Experience with Tableau & Qlik Sense

+ Experience with SNOW data

+ Experience with NetSuite Data

+ Bachelors of Computer Science or related field, or equivalent experience

Base Pay Range: Annualized salary range offered for this position is estimated to be$105,000-$130,000, however, the actual pay range depends each candidate's experience and qualifications.

Variable Pay: Discretionary annual bonus, based on personal and company performance.

Benefits of working at Flexential:

+ Medical, Telehealth, Dental and Vision

+ 401(k)

+ Health Savings Accounts (HAS) and Flexible Spending Accounts (FSA)

+ Life and AD&D

+ Short Term and Long Term disability

+ Unlimited Paid Time Off (PTO)

+ Leave of Absence

+ Employee Assistance Program

+ Wellness Program

+ Rewards and Recognition Program

Benefits are subject to change at the Company's discretion

Flexential offers flexible and essential services that help organizations optimize their journey of IT transformation while simultaneously balancing cost, scalability, compliance and security. The company, co-headquartered in Charlotte and Denver, is committed to building trusted relationships and delivering tailored solutions that suit the individual needs of its customers. Flexential is deeply invested in the success of its customers, who trust it to deliver core data center solutions of colocation and connectivity, as well as, cloud, managed solutions and professional services. Flexential's robust suite of assets spans 21 markets and comprises 40 highly redundant and connectivity-rich data centers. For more information on Flexential, please visit www.flexential.com. Flexential is a registered trademark of the Flexential Corp.

Follow Flexential on LinkedIn (http://www.linkedin.com/company/flexential) , Twitter (https://twitter.com/flexential) , Facebook (https://www.facebook.com/flexential/) and YouTube (https://www.youtube.com/c/Flexential) .

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status.

Keywords: Flexential, Boulder , Engineer, Other , Boulder, Colorado

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Log In or Create An Account

Get the latest Colorado jobs by following @recnetCO on Twitter!

Boulder RSS job feeds