Junior Data Architect
Featured

Other jobs >> General

Negotiable

Permanent

Description

Blue Margin, Inc. helps companies improve their businessperformance using Microsoft’s Business Intelligence stack (including Power BIand SQL Server) and Cloud Computing software and services (Azure and Office365). We believe in working hard, volunteering in our community, and enjoyinglife along the way.

Why are we looking?

We are expanding our Microsoft Power BI team, and arelooking for clever, creative, data-savvy people who are flexible and capable ofputting themselves in the shoes of the client. Our growth means we are lookingfor 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 Database Architect’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.

Responsibilities:

·       Maintain data warehouses

·       Designand 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 one year of development expertise in 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

·       Abroad understanding of data visualization methods and techniques

·       PowerQuery ("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:

·       CompanyCore 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- weve 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.

Job Type: Full-time

 

  • 1
  • Negotiable
  • None
  • None
  • Hi-206785
  • Permanent
  • 30

How to Apply: Please click here to create a free Pure-jobs.com account and post your resume. Only logged in job seekers can apply for a job.

Find us at:

Never provide bank account, credit card details or any other financial information, or make any form of payment, when applying for a job. If you are ever asked to do this by a recruiter on Pure Jobs please click the Report button or contact us with the advertiser's company name and the title of the job vacancy. You should not send any money to anyone. A genuine employer with a job offer would never ask you to do this.

Report this job
x

Report a job

If you're concerned about a job advert, let us know and our quality team will investigate.

Your name(*)
Invalid Input

Your email address(*)
Invalid Input

Please select you reason(*)

Additional information(*)
Invalid Input

Invalid Input

Get new jobs for this search by email.

Also get an email with jobs recommended just for me.

Create Alert

Subscribe to updates from our blog

PLEASE NOTE! WE USE COOKIES AND SIMILAR TECHNOLOGIES FOR THE BEST USER EXPERIENCES

However, by continuing to use the site without changing settings, you are agreeing to our use of cookies.