Blue Margin

Data Warehouse Engineer - Fort Collins, CO.

Data Warehouse Engineer in Fort Collins, CO

Posted 2019-09-03

Blue Margin, Inc. helps companies improve their business performance using Microsoft’s Business Intelligence stack (including Power BI and SQL Server) and Cloud Computing software and services (Azure and Office 365). We believe in working hard, volunteering in our community, and enjoying life along the way.

Why are we looking?
We are expanding our Microsoft Power BI team, and are looking for clever, creative, data-savvy people who are flexible and capable of putting themselves in the shoes of the client. Our growth means we are looking for people with great attitudes, who are fun to work with. It also means we provide an excellent opportunity for someone who is serious about learning and advancing their career.
The SQL Developer's role is to develop and maintain reporting databases using the Microsoft stack, primarily in Azure, ensuring high levels of data availability. They will also evaluate and advise on database technology components, such as software, hardware, and networking. Finally, the architect will assist in implementing and maintaining reporting dashboards across the organization.

Maintain data warehouses
Design and deploy data table structures, reports, and queries
Diagnose and resolve database access and performance issues
Assure security of data from external parties and for management of row-level-security within the organization
Plan and coordinate backup and disaster recovery setup
Develop, implement, and maintain change control and testing processes for modifications to databases
Develop and maintain database stored procedures, views, and functions that support reporting data models
Develop and maintain ETL processes
Produce ad-hoc queries that develop reports to support business needs
Create reports and data models using Power BI that meet business requirements
Provide data management support to users
Create and maintain technical documentation

Our ideal candidate for this position MUST possess:
At least three-five years or more of experience in development within the Microsoft/SQL stack.
T-SQL expertise
Familiarity with cloud services (AWS, Azure (preferred), Google Cloud)
Experience creating databases from the ground up
In-depth understanding of data management (e.g. permissions, recovery, security, and monitoring)
Comprehensive grasp of data visualization methods and data modeling for effective report creation
Ability to construct and maintain data warehouses
SSMS, SSIS, and SSAS expertise
Experience with SSAS, Tabular-based reporting, and Tabular Data Models
Experience creating charts, graphs, dashboards in one or more of the following programs - Excel, SSRS, Power BI, Tableau, Qlik and/or similar programs
A broad understanding of data visualization methods and techniques
Power Query ("M" language), and DAX language experience
Solid presentation skills and the ability to present to audiences of 10-15 people
Broad business experience with proficient ability to talk to execs in business terms
Excellent verbal and written communication skills
Willing to creatively engage with customers to come up with custom solutions
Must possess ability to coordinate and work cohesively with a development team (no ‘code-loners’)
Familiarity with Kimball methodologies of data warehousing
Understanding of the difference between application database design and reporting database design

Our Culture:
Company Core Values: Embrace Transparency, Choose to Be Positive, Be Efficient/Systematize, Pursue Learning, Be Generous.
Weekly personal and professional development programs for all
Teamwork -- we maintain company-wide interaction and communication
Entrepreneurism -- we've been in business 7 years, and want everyone on our team to be eager to adapt and evolve with our advancing business. We are looking for someone who is comfortable wearing more than one hat.

We are seeking a candidate to work full time in our local office in Fort Collins.
NO PHONE CALLS - Please email your resume.
HOURS: Monday-Friday with occasional weekends and evenings. Some occasional travel.

Ready to be Seen?

Apply now to have the opportunity to be considered for similar jobs at leading companies in the Seen network for FREE.

Company summary

Blue Margin is the largest Microsoft Gold Partner dedicated to business intelligence and data warehousing on Power BI and Azure SQL.

We help companies in manufacturing, distribution, professional services, healthcare, and government extract the full value of data using Microsoft’s cloud-based business intelligence tools.

We do this in two ways:

1) Data Management: Blue Margin helps clients gather and control their data with data warehousing on Azure SQL and Azure HDInsight, creating a single source of truth that is secure and scalable.

2) Data Analytics and Dashboards: We use Power BI, to deploy dashboards. Power BI integrates with the most advanced analytical and collaboration tools (R Server, Machine Learning, SharePoint, Microsoft Office, etc.) and connects to any data source, delivering real-time dashboards to any device.

We provide the full spectrum of data services, including Master Data Planning, Data Warehousing, Dashboard Design and Deployment, Training, and Support.

Mission: Blue Margin helps companies use their data to improve operations and profitability.


Equal to the success of our company, we want our employees to succeed both personally and professionally. We believe a great culture is essential to helping our employees succeed, and enables us to deliver the most value to our clients. It motivates us, directs us, and inspires us.

Interested in joining our team? We are always looking for creative, flexible people, with great attitudes.
What We Offer:
- Health, dental, and vision insurance
- Long/short term disability
- Matching 401(k) plan
- Flexible work opportunities
- Casual work environment
- Daily Nerf wars
- "No Drama Zone" office
- Appreciation cards (to Amazon, Best Buy, etc.)
- Paid Volunteer Program - Blue Margin Community Works
- Free Kindle books
- Friday Company Lunches
- Locally brewed beer in the office fridge
- Living in One of America's Top Rated Cities
- And a group of awesome people to work with!

Interview process

You might be curious, so here is how our interview process works:

* Completed initial video interviews are reviewed.
* Selected candidates are invited to interview with a manager via Skype.
* Selected candidates are given a technical skill assessment.
* Technical interviews are scheduled with Blue Margin team members.
* An in-person interview is scheduled with senior executives.

Be Seen in a new Data Warehouse Engineer job

Skip the search

Zero stress and one profile that can connect you directly to 1000s of companies.

Best-fit jobs—for you

We’ll take it from there. After you tell us what you’re looking for, we’ll show you off to matches.

Free Career Coaching

Boost your interview skills, map your tech career and seal the deal with 1:1 career coaching.

You get tech. We get you.

Join now and Be Seen.