Sr. BI Data Warehouse Developer

| Waltham
Strong data oriented person with experience in building data warehouse solutions. Identify projects, manage requests, and resolve issues to ensure the timely & accurate delivery of data to support Business Intelligence reports, analytics, ad-hoc reporting. Establish data controls with emphasis on data quality and process automation. A deep understanding of SQL and ability to model data based on usage, volume, performance and value. Cloud based DW implementation a must. 

Key Responsibilities:

  • Participate in discussions with business/IT stake holders on key reporting needs and provide architecture options and recommendations
  • Design and implement complex reporting required by the business
  • Design and implement Power BI Reports and Dashboards
  • Create complex calculations using DAX/MDX language
  • Functional domain knowledge of Sales, Marketing and Finance
  • Experience in creating prototypes to demo design and create requirements
  • Enhance BI environment through continuous improvement following standards and best practices.
  • Works with other teams to maintain an optimal BI environment.
  • Assists users with use of BI applications to drive business value
  • Document process / workflow and ability to evaluate business processes and identify opportunities for improvement
  • Monitors and maintains system performance and provides statistical reporting
  • Participate in requirement gathering, resolving ambiguity and conflicts, ensuring accuracy.
  • Assist with BI test executions and implement performance tuning as required
  • Performs systems/database modification impact analysis
  • Communicate effectively in verbal and written English.
  • Demonstrate ability to work in team environment and help resolve issues
  • Communicate status / risks to manager regarding delivering solution on time
  • Participates in on-call schedule; off-hours support as required

Experience/Education:

  • Bachelor’s degree in a technical development discipline, computer science, or other relevant discipline required.
  • 10+ years of building dimensional models, implementation of SCD and point-in-time data storage
  • 10+ years of database and data warehouse development knowledge (SQL Server/MySQL/Oracle/Postgres)
  • 5-8+ Cloud DB development experience
  • 10+ years Knowledge and experience with ETL tools: SSIS, ADF, SQL Stored Procedures
  • Knowledge of row-level security implementation and access-control-lists on databases to secure data
  • Strong conceptual, analytical, and problem-solving abilities
  • Well-organized and able to prioritize and coordinate simultaneous tasks and projects while addressing customer needs
  • Strong interpersonal and oral and written communication skills
  • Knowledge of Heroku Postgres, Heroku Connect and Salesforce highly preferred. 

Dynatrace provides software intelligence to simplify enterprise cloud complexity and accelerate digital transformation. With AI and complete automation, our all-in-one platform provides answers, not just data, about the performance of applications, the underlying infrastructure and the experience of all users. That’s why many of the world’s largest enterprises trust Dynatrace to modernize and automate enterprise cloud operations, release better software faster, and deliver unrivaled digital experiences.
 
We offer competitive compensation, company-sponsored premium benefits, medical, dental, vacation/holidays, company matching 401(k) Plan, etc. Dynatrace is an equal opportunity employer and VEVRAA Federal Contractor. We consider all qualified applicants of diverse background and hire without regard to race, color, gender identity, religion, national origin, ancestry, citizenship, physical abilities, age, sexual orientation, veteran status, or any other characteristic protected by law. If your disability makes it difficult for you to use this site, please contact [email protected] Dynatrace participates in E-Verify, participant information in English and Spanish. Right to work information in English and Spanish. EEO is the Law/EEO is the Law Supplement.
Note to Recruiters and Placement Agencies: Dynatrace LLC (Dynatrace) does not accept unsolicited agency resumes. Please do not forward unsolicited agency resumes to our website or to any Dynatrace employee. Dynatrace will not pay fees to any third party agency or firm and will not be responsible for any agency fees associated with unsolicited resumes. Unsolicited resumes received will be considered property of Dynatrace.

Read Full Job Description
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
  • Product
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • ScalaLanguages
    • AWSLanguages
    • Node.jsFrameworks
    • TensorFlowFrameworks
    • AngularFrameworks
    • DB2Databases
    • Microsoft SQL ServerDatabases
    • MySQLDatabases
    • PostgreSQLDatabases
    • DynatraceAnalytics
    • IllustratorDesign
    • InVisionDesign
    • PhotoshopDesign
    • SketchDesign
    • ConfluenceManagement
    • JIRAManagement
    • Microsoft ProjectManagement

Location

Just 11 miles west of Boston, you'll find the Dynatrace headquarters, placed outside the bustle of the city in the tech-hub of Waltham.

An Insider's view of Dynatrace

How would you describe the company’s work-life balance?

Dynatrace has provided me with the tools and flexibility to work remotely (when needed) which has allowed me opportunities to be an involved, present parent and have the option to travel while still fulfilling the obligations to the organization I support.

Joe Callina

Lead Sales Recruiter

What does your typical day look like?

I start going through my Salesforce tasks and running through my Cadences in SalesLoft -- this consists of sending targeted emails, executing campaigns, and cold calling. Throughout the day I'm always on LinkedIn where I read any posting from my Named Accounts, read through profiles and network. I then communicate these findings with my Reps.

Kristen Armata

Sales Development Representatives NORAM

How does the company support your career growth?

Dynatrace has a fantastic training program in place to support new hires! The SDR team continues that training with weekly, monthly, and quarterly enrichment to help new employees gain the skills needed to be successful!

Jamie Mallett

Partner Program Manager NORAM

How do you make yourself accessible to the rest of the team?

From the time the new employees attend boot camp to their time in the field around the world, I make myself available to every rep, manager, SE...the entire organization for sales calls, employee meetings, partner calls, events, etc. I have direct communication with team members daily and I give everyone my number and they know they can call me.

Steve Pace

SVP, Global Sales

How has your career grown since starting at the company?

I’ve been with Dynatrace for 2+ years now and it’s incredible to look back and see how I’ve grown professionally over that time. From launching a company-wide employee advocacy program to having the opportunity to teach incoming “Dynatracers” about the benefits of social media.

John Rocker

Social Media Manager

What are Dynatrace Perks + Benefits

Dynatrace Benefits Overview

Being a leader in the market doesn’t mean it’s all work and no play. At Dynatrace, our employees take their jobs seriously but also like to have fun. While at work, we encourage you to take a break and enjoy a game of ping-pong, have a cup of coffee. Work flexibility is important at Dynatrace, we are investing in your growth and happiness! Dynatrace provides a comprehensive benefit plan that allows employees to select benefits that fit their personal needs and stay competitive in the market place.

Culture
Volunteer in local community
Greater Boston Food Bank. Cradles 2 Crayons.
Friends outside of work
Eat lunch together
Intracompany committees
Open door policy
Group brainstorming sessions
Open office floor plan
Diversity
Unconscious bias training
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Disability insurance covers 100% of annual salary with no maximum.
Dental Benefits
Our dental plan covers $2500 of expenses.
Vision Benefits
Annual eye exams are $10 co-pay with $140 for glasses and contact lenses.
Health Insurance Benefits
Life Insurance
Pet Insurance
Onsite Gym
Retirement & Stock Options Benefits
401(K)
Dynatrace, Inc. 401(k) retirement plan offers pre-tax and after-tax contributions, a wide spectrum of investment options, loans and a year-end True-up.
401(K) Matching
Dynatrace, Inc. provides employees with a 401(k) matching plan managed by Fidelity. We match 6% of contributions up to 3% of an employee's annual gross pay.
Employee Stock Purchase Plan
Dynatrace, Inc. offers qualified employees to purchase company shares at a 15% discount.
Child Care & Parental Leave Benefits
Family Medical Leave
Adoption Assistance
Vacation & Time Off Benefits
Generous PTO
Paid Volunteer Time
Paid Holidays
Paid Sick Days
Employees have unlimited Sick days.
Perks & Discounts
Beer on Tap
Casual Dress
Commuter Benefits
Dynatrace, Inc. offers pre-tax commuter benefits for all employees.
Game Room
Stocked Kitchen
Dynatrace, Inc. has a fully stocked kitchen including unlimited snacks, coffee, tea.
Professional Development Benefits
Promote from within
Online course subscriptions available
More Jobs at Dynatrace28 open jobs
All Jobs
Finance
Data + Analytics
Dev + Engineer
Legal
Marketing
Operations
Product
Project Mgmt
Sales
Content
Sales
new
Waltham
Operations
new
Waltham
Developer
new
Waltham
Sales
new
Waltham
Marketing
new
Waltham
Product
new
Remote
Sales
new
Waltham
Project Mgmt
new
Waltham
Marketing
new
Waltham
Project Mgmt
new
Waltham
Data + Analytics
new
Waltham